topic Issue with data source error (SQL Server) in Report Server

Issue with data source error (SQL Server)

gautampruthi — Wed, 29 Oct 2025 15:35:46 GMT

Hi,
i am using On-premise gateway to connect to sql server and I am getting this error
DataSource.MissingClientLibrary: Loading assembly file 'System.EnterpriseServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' failed for data source type 'SQL' Details: DataSourceKind=SQL DataSourcePath=gold;sipr

All my exisitng report have stopped refreshing suddenly.

Re: Issue with data source error (SQL Server)

lbendlin — Wed, 29 Oct 2025 16:18:17 GMT

Restart the VMs for all the cluster members of your gateway, one after the other.

Re: Issue with data source error (SQL Server)

LittleMarie_MT — Mon, 01 Dec 2025 09:16:41 GMT

To solve this error, what helped me is to go to the Data source settings, open my sources in Global Permissioons and double check that the connection settings are valid there.

The error happened when I tried to connect to a source with different credentials, and these wrong credentials got fixed in global permissions even when I changed them in the connection settings.