Prev: Unable to Connect to Remote Server
Next: HELP! Report Manager Error: HTTP status 400: Bad Request
From: Mark on 13 Mar 2006 14:47
I have SQL Server 2005 and Reporting Services installed on my development
machine. I have successfully created and deployed a report using Visual
Studio 2005, and I've viewed it using both URL access and the SOAP web
service. I just tried adding a ReportViewer control to an ASP.NET web form on
the local IIS server, but after I enter the parameters and click the "View
Report" button I get the following message:

Unable to connect to the remote server
The attempted operation is not supported for the type of object referenced

I've gone to the report manager and given all privileges to both the
Administrator accounts and the local ASPNET account (using Windows XP Pro,
btw) and that hasn't worked. There was a new warning entry in the event log
which I believe is from my attempt to access the report, and it mentions a
SocketException. Here's the log entry:

Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 3/13/2006 10:54:22 AM
Event time (UTC): 3/13/2006 4:54:22 PM
Event ID: 66840124693742e68e04b3b6e9bf0b01
Event sequence: 52
Event occurrence: 1
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/1/root/Reports-1-127867381940312500
Trust level: RosettaMgr
Application Virtual Path: /Reports
Application Path: C:\Program Files\Microsoft SQL
Server\MSSQL.3\Reporting Services\ReportManager\
Machine name: MY-COMPUTER

Process information:
Process ID: 2208
Process name: aspnet_wp.exe
Account name: MY-COMPUTER\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://localhost/Reports/Reserved.ReportViewerWebControl.axd?OpType=StyleSheet&Version=2005.090.1399.00
Request path: /Reports/Reserved.ReportViewerWebControl.axd
User host address: 127.0.0.1
User: MY-COMPUTER\mraimondi
Is authenticated: True
Authentication Type: Negotiate
Thread account name: MY-COMPUTER\ASPNET

Thread information:
Thread ID: 8
Thread account name: MY-COMPUTER\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.

So, can anybody think of why I am having this problem and what steps I can
take to resolve it?

Thanks,
Mark
 | 
Pages: 1
Prev: Unable to Connect to Remote Server
Next: HELP! Report Manager Error: HTTP status 400: Bad Request