Hi,
I have a local installation of SQL Server 2005 (Developer Edition) on XP Professional SP2, with Reporting Services, Integration Services, and Analysis Server installed.
I can connect to Integration Services and Analysis Server via the SQL Server Management Studio, but not to the Report Server. I can access and use the Report Server installation via http://localhost/Reports and http://localhost/ReportServer, and everything checks out on the Reporting Services Configuration tool, so the server appears to be working fine.
I've uninstalled/re-formatted/reinstalled the services (with all default options, and services running as "Local Service"), but always end up with the following error when connecting to Report Server via Management Studio:
The request failed with HTTP status 503: Service Unavailable. (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.ConnectionDlg.Connector.ConnectionThreadUser()
Any hints would be appreciated...
Thanks,
/vijayan
Can't connect to Report Server via Management Studio
Sean Riddle
Do you know if you installed .Net Framework v2 before you had IIS installed If you did or if the following registry key is not present, you'll need to register ASP.NET.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ASP.NET\2.0.50727.0
If it does not exist, run the command:
aspnet_regiis.exe -i
from the folder:
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\
You may want to run it regardless just to ensure ASP.NET is registered correctly on your computer. Note this does have consequences for encryption keys for the ASP.NET account (and consequently the RS 2000). Before running the command back up your symmetric key for the RS2K server using:
rskeymgmt.exe
-Lukasz
patmur
Hi Lukas,
Thanks for the reply.
I tried with registering ASP.NET again, but still it's not connecting to Report Server using SQL Mgmt Studio. Also it's not connecting to Report Manager using Internet explorer too. I have created a report server project and deployed a sample report to IIS, it's working and I can view it from the browser.
Thanks,
Roshan.
Tim Rupe
Vijayan
Did you manage to solve this problem I am getting the same error message (HTTP Status 503) when connecting to Report Server from Management Studio. Any advice would be appreciated.
Thanks
Brad
Lee Evans
I am also having the same problem. and I have no idea on how to trouble shoot it Can you let us know if you made any progress on the resolution of the issue
Jim
BMcK
vitfrasson
Can you open IIS manager in MMC and tell me what the settings are for the reportserver virtual directory
I firstly, can you provide the directory to which the reportserver virtual directory is pointing
Secondly, what are the script mappings for the virtual directory You can get to this from the properties page for the V-dir and then clicking the 'configuration' button.
Lastly, if there is an ASP.Net tab, what is the value set to
If there isn't a reportserer virtual directory, is there one called reportserver$InstanceName
If there is no virtual directory starting with report server, can you open the reporting services configuration tool from the start menu and create one on the report server virtual directory tab
Thanks!
-Lukasz
Amaltea
Hi Lukasz,
Following are the information requested.
ReportServer virtual directory is pointing to :
C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer
Mappings:
Application extensions: There are no entries
Wildcard application maps:
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll
Options:
Enable session state : Ticked
Enable buffering : Ticked
Default ASP Language : VBScript
There is no ASP.Net tab.
Best Regards,
Roshan.
Rajeevr
Also try using your machine name or IP address to connect rather than localhost.
gmitchell7
I am also having the same problem. Tried everything, no solution yet. My server is having two SQL Server instances SQL 2000 and 2005, will this be a problem. It doesn't connect to IIS.
Roshan.
GordonBeMe
So if you open the report server virtual directory in IE you can browse the report server namespace and execute the report, but if you try to view the report using report manager, it doesn't work
That is really unusual.
When you say you deploy the report to IIS - did you use the Deploy feature of Report Designer
-Lukasz
mpdeglau
You don't have any other version of the .NET Framework on the client machine, do you Maybe uninstalling the SQL tools and the .NET framework and the reinstalling might help. I've never seen this before.
Abdul Hafeez
http://servername/reportserver
or
servername/instance
The second uses WMI to enumerate the instance so you either need to be an administrator or in the DCOM users group on the server machine.
Dale Washlake
Indeed, I can't connect to RS installations on other servers either, while other users are able to. They also connect successfully to my RS instance via SSMS... so it appears to be something completely on my client that I need to fix.
Run out of ideas to try...
/v
VB_Newbie
Can you provide more info on exactly how you reproduce the problem
Can you provide answers to my post above
-Lukasz