July 28, 2008 at 11:08 am
I'm having trouble connecting to a remote Reporting Services server from my machine using SQL Server Management Studio. But, when I open a terminal service session to the Reporting Services server, using the same windows account, and a SQL Server Management Studio connection to the Reporting SErvices server, it works just fine.
In addition, when connecting through the IE browser to the reporting server (http://servername/Reports/Pages/Folder.aspx?ViewMode=List), from my machine, I was able to connect to it just fine.
Below are the errors I receive:
===================================
The underlying connection was closed: An unexpected error occurred on a receive. (Microsoft.SqlServer.Management.UI.RSClient)
------------------------------
Program Location:
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.CreateConnection(String connectionString)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.CreateConnectionObject()
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ConnectToServer(Object connectionInfo, IDbConnection liveConnection, Boolean validateConnection)
===================================
Unable to read data from the transport connection: An established connection was aborted by the software in your host machine. (System)
------------------------------
Program Location:
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
at System.Net.PooledStream.Read(Byte[] buffer, Int32 offset, Int32 size)
at System.Net.Connection.SyncRead(HttpWebRequest request, Boolean userRetrievedStream, Boolean probeRead)
===================================
An established connection was aborted by the software in your host machine (System)
------------------------------
Program Location:
at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
August 11, 2008 at 4:53 am
You can connect to ur SSRS by using
http://localhost/reportserver
instead of
servername\instance
I dont have reason why but it works.
August 11, 2008 at 5:33 am
Also you can try connecting from SMS with the service account that is being used by RS to connect to its database.... Is your RS standalone with remote db or all in one place?
You could also try putting the service account in an AD account group with your login and making sure that has access to the SQL server that the RS db's are attached to.
Adam Zacks-------------------------------------------Be Nice, Or Leave
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply