Error "unable to connect to the remote server "
-
Hi all,
had a strange error yesterday with SSRS 2005.
When I attempted to open a report through the Report Manager (i.e. http://MYSERVER/reports) I got the following error
unable to connect to the remote server
the attempted operation is not supported for the type of object referenced
on screen, and the following in the Application event log
Event Type:Warning
Event Source:ASP.NET 2.0.50727.0
Event Category:Web Event
Event ID:1309
Date:13/05/2008
Time:16:41:01
User:N/A
Computer:MYSERVER
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 13/05/2008 16:41:01
Event time (UTC): 13/05/2008 15:41:01
Event ID: 480ed4ef8ca044f8a36940d00379d263
Event sequence: 12
Event occurrence: 1
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/root/Reports-1-128551667463050939
Trust level: RosettaMgr
Application Virtual Path: /Reports
Application Path: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportManager\
Machine name: MYSERVER
Process information:
Process ID: 1936
Process name: aspnet_wp.exe
Account name: MYSERVER\ASPNET
Exception information:
Exception type: SocketException
Exception message: The attempted operation is not supported for the type of object referenced
Request information:
Request URL: http://MYSERVER/Reports/Reserved.ReportViewerWebControl.axd?OpType=StyleSheet&Version=2005.090.3042.00
Request path: /Reports/Reserved.ReportViewerWebControl.axd
User host address: 10.2.2.1
User: MYDOMAIN\my.name
Is authenticated: True
Authentication Type: Negotiate
Thread account name: MYSERVER\ASPNET
Thread information:
Thread ID: 8
Thread account name: MYSERVER\ASPNET
Is impersonating: False
Stack trace: at System.Net.Sockets.Socket.get_ConnectEx()
at System.Net.Sockets.Socket.BeginConnectEx(EndPoint remoteEP, Boolean flowContext, AsyncCallback callback, Object state)
at System.Net.Sockets.Socket.UnsafeBeginConnect(EndPoint remoteEP, AsyncCallback callback, Object state)
at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)
Custom event details:
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
however when I browsed to the report through the Report Server (i.e. http://MYSERVER/reportserver) it worked fine!
After many hours of messing around, redeploying the reports, changing the report path, using System Restore to get back to a point when i remeber it worked, etc - all to no avail, I found this link
http://support.microsoft.com/?kbid=896861
and followed the resolution of Method 1: Disable the loopback check
and now everything works again.
No idea what happened to stop it working in the first place, or how this resolution pertains to SSRS (I am in no way a web/ASP/.net developer - just a straight up and down SQL guy!!)
Hope this helps someone else with the same issue.
Kev
-
kevriley (5/14/2008)
Hi all,had a strange error yesterday with SSRS 2005.
When I attempted to open a report through the Report Manager (i.e. http://MYSERVER/reports) I got the following error
unable to connect to the remote server
the attempted operation is not supported for the type of object referenced
on screen, and the following in the Application event log
Event Type:Warning
Event Source:ASP.NET 2.0.50727.0
Event Category:Web Event
Event ID:1309
Date:13/05/2008
Time:16:41:01
User:N/A
Computer:MYSERVER
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 13/05/2008 16:41:01
Event time (UTC): 13/05/2008 15:41:01
Event ID: 480ed4ef8ca044f8a36940d00379d263
Event sequence: 12
Event occurrence: 1
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/root/Reports-1-128551667463050939
Trust level: RosettaMgr
Application Virtual Path: /Reports
Application Path: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportManager\
Machine name: MYSERVER
Process information:
Process ID: 1936
Process name: aspnet_wp.exe
Account name: MYSERVER\ASPNET
Exception information:
Exception type: SocketException
Exception message: The attempted operation is not supported for the type of object referenced
Request information:
Request URL: http://MYSERVER/Reports/Reserved.ReportViewerWebControl.axd?OpType=StyleSheet&Version=2005.090.3042.00
Request path: /Reports/Reserved.ReportViewerWebControl.axd
User host address: 10.2.2.1
User: MYDOMAIN\my.name
Is authenticated: True
Authentication Type: Negotiate
Thread account name: MYSERVER\ASPNET
Thread information:
Thread ID: 8
Thread account name: MYSERVER\ASPNET
Is impersonating: False
Stack trace: at System.Net.Sockets.Socket.get_ConnectEx()
at System.Net.Sockets.Socket.BeginConnectEx(EndPoint remoteEP, Boolean flowContext, AsyncCallback callback, Object state)
at System.Net.Sockets.Socket.UnsafeBeginConnect(EndPoint remoteEP, AsyncCallback callback, Object state)
at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)
Custom event details:
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
however when I browsed to the report through the Report Server (i.e. http://MYSERVER/reportserver) it worked fine!
After many hours of messing around, redeploying the reports, changing the report path, using System Restore to get back to a point when i remeber it worked, etc - all to no avail, I found this link
http://support.microsoft.com/?kbid=896861
and followed the resolution of Method 1: Disable the loopback check
and now everything works again.
No idea what happened to stop it working in the first place, or how this resolution pertains to SSRS (I am in no way a web/ASP/.net developer - just a straight up and down SQL guy!!)
Hope this helps someone else with the same issue.
Kev
It helped me...Thank you very much. =)
Christopher Ford
-
Christopher Ford (5/19/2008)
It helped me...Thank you very much. =)
Glad to help - do you have any idea what caused it to break in the first place???
Kev
-
I'm having a similar issue. I noticed that the App Pool that I'm using for both the Report Server and Report Manager Sites uses the .NET Framework v2.0.50727 and I recently installed the .Net Framework v 3.5 (could this be the reason?)
Unfortunately it's been a long time since the last time I used this report server and I don't remember whether or not it was working before installing the aforementioned version of .Net Framework.
I'm trying to disable the loopback check via regedit and at this very moment I'm about to restart the system. I just hope the problem will be solved when it re-boots
-
Aaron - did it work?
-
I'm sorry I didn't update this one. Nope, it didn't work. My next suspect is the .net framework 3.5, but I'm working on another tasks right now. Maybe in a couple of weeks I'll have to try to configure the report server again.
-
I'm having the same problem.
I'm installing Team Foundation Server 2008 with SSL
Default website (SSL) : SSL Port : 2444
Sharepoint (SSL) : SSL Port : 2445
Team Foundation (SSL) : SSL Port : 2443
Everything works fine except on the Reports.
https://localhost:2444/reports
https://localhost:2444/reportserver
both works
under the https://localhost:2444/reports
1) i can list all the reports
2) if clicking the reports, it says
The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.
The remote certificate is invalid according to the validation procedure.
But i can view the reports in Team Explorer as well as on the sharepoint portal link. But it throws an error if i manually go into the
https://localhost:1444/Reports/Pages/Report.aspx?ItemPath=MyOwnReports (example)
It has to do with the SSL but i'm not sure where else to look. I've hacked into the SQL database, Regedit, RSWebApplication.config (in ReportManager folder), RSReportServer.config (in ReportServer folder), Web.Config (in TFS Web Services folder).
Any other places to check? i'm stuck
-
Have you found any solution? I have the same problem.
-
no i haven't, i'm still searching in and out, still no luck. Right now i'm trying to build another server just for SQL 2005 Reporting Services and throw in some SSL at it. Trying to see if the same error will show up.
BTW, Where does the reports are stored in?
-
i've read somewhere it says the problem could be with ASP.Net 2.0, trying to get back that link.. :ermm:
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply