Cannot create a connection to data source (rsErrorOpeningConnection)

Marin Kostadinovic 0 Reputation points
2023-03-14T18:39:08.4233333+00:00
We have two servers with SSRS and SSAS. Both are running 2008R2. On SSRS server there are quite a few data sources using SSAS databases. All reports based on these data sources are working when I connect to Report Manager on SSRS server but when I try to open them on any workstation I am getting:

An error has occurred during report processing. (rsProcessingAborted)
   Cannot create a connection to data source 'XYZ'. (rsErrorOpeningConnection)
      The connection either timed out or was lost.
         Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.
            An existing connection was forcibly closed by the remote host

AD Delegation for Kerberos is turned on on both SSRS and SSAS rervers.

Whenever I try to connect from workstation following error is recorded in SSRS log:
processing!ReportServer_0-24!ec4!03/09/2023-08:05:35:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: , Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'AC360'. ---> Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException: The connection either timed out or was lost. ---> System.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. ---> System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host
   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
   --- End of inner exception stack trace ---
   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
   at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
   at Microsoft.AnalysisServices.AdomdClient.DimeRecord.ForceRead(Stream stream, Byte[] buffer, Int32 length)
   at Microsoft.AnalysisServices.AdomdClient.DimeRecord.ReadHeader()
   at Microsoft.AnalysisServices.AdomdClient.DimeReader.ReadRecord()
   at Microsoft.AnalysisServices.AdomdClient.TcpStream.GetResponseDataType()
   --- End of inner exception stack trace ---
   at Microsoft.AnalysisServices.AdomdClient.XmlaClient.EndRequest()
   at Microsoft.AnalysisServices.AdomdClient.XmlaClient.CreateSession(ListDictionary properties, Boolean sendNamespaceCompatibility)
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.CreateSession(Boolean sendNamespaceCompatibility)
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
   at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
   at Microsoft.ReportingServices.DataExtensions.AdoMdConnection.Open()
   at Microsoft.ReportingServices.Diagnostics.DataExtensionConnectionBase.OpenDataSourceExtensionConnection(IProcessingDataSource dataSourceObj, String connectString, DataSourceInfo dataSourceInfo, String datasetName)
   --- End of inner exception stack trace ---
   at Microsoft.ReportingServices.Diagnostics.DataExtensionConnectionBase.OpenDataSourceExtensionConnection(IProcessingDataSource dataSourceObj, String connectString, DataSourceInfo dataSourceInfo, String datasetName)
   at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSource.OpenConnection(DataSource dataSourceObj, DataSet dataSetObj, OnDemandProcessingContext pc)
   at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSource.ProcessTransactionAndConnection(IJobContext jobContext, Int32 numDataSets, Boolean& concurrentDataSets, IDbConnection& connection, Boolean& closeConnection, TransactionInfo& transInfo, Boolean& isTransactionOwner, Boolean& transactionCanSpanConnections, Boolean& addedTransactionToGlobalDataSourceInfo)
   at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSource.Process()
   at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSource.ProcessConcurrent(Object threadSet)
   --- End of inner exception stack trace ---;
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,854 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,258 questions
{count} votes

1 answer

Sort by: Most helpful
  1. AniyaTang-MSFT 12,341 Reputation points Microsoft Vendor
    2023-03-15T06:19:10.74+00:00

    Hi @Marin Kostadinovic

    What does it mean that you are open on a workstation and is the report being accessed on a different server? Based on your error message, this appears to be a connectivity issue.

    I am not familiar with SSAS, I am responsible for SSRS related issues, I found this link for you, hope it will help you.

    https://social.msdn.microsoft.com/Forums/en-US/18a53350-7694-4283-8416-d41c1c8f30fb/ssas-an-existing-connection-was-forcibly-closed-by-the-remote-host

    Best regards,

    Aniya

    0 comments No comments