Can't connect to Report Server via Management Studio

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

There are two server addresses you can use in the SSMS connection dialog:

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.|||Thanks for your reply; I tried the 'http://' address, and that fails with exactly the same error. Also, I am an administrator.

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|||This is a bit of a stretch, but you can try www.sysinternals.com filemon utility and look for access denied or buffer overflow messages when connecting. If you can narrow it down to a file permissions problem it may be easier to troubleshoot.
Also try using your machine name or IP address to connect rather than localhost.|||

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.

|||

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

|||Vijayan -

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|||

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.

|||

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

|||

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.

|||

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

|||

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.

|||

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

|||Has anyone found an answer to this issue? I am having the same problem.|||

Can you provide more info on exactly how you reproduce the problem?

Can you provide answers to my post above?

-Lukasz