SQL Server 2005 Reporting Services – Configuration Issues and Fixes

While dealing with a SQL Server 2005 Reporting configuration, faced multiple issues, below is list of issues and applied fixes along with some useful link to redirect in case freshly setting up SSRS.


Main issue which arises is Authentication, SSRS 2005 authentication is handled via IIS manager, and there are multiple options available for e.g. Integrated Windows authentication, Basic authentication, Anonymous Authentication. Based on security requirement one of these can be setup, easiest one is to use anonymous but it opens up security loopholes whereas basic one transmit password over n/w. From setting up first time perspective, enable anonymous and then drill down other options to increase security.

Setting up security:


After security is setup correctly, then you may encounter below issues while trying to access web URL for SSRS, for basic setup with default settings, below URL generally works locally – http://localhost/reports/ and http://localhost/reportserver/



Following is first issue which I encountered,


Error: The remote server returned an error: (400) Bad Request.




To work around this problem, follow these steps:

  1. Open the file RSWebApplication.config file in a text editor. The RSWebApplication.config file is located in the following folder:

    SQLInstall\MSSQL.X\Reporting Services\ReportManager

    Note SQLInstall represents the location where SQL Server 2005 is installed. MSSQL.X represents the instance ID of SQL Server 2005 Report Services.

  2. Delete the entry in the ReportServerVirtualDirectory tag. 

    Note You must not delete the ReportServerVirtualDirectory tag. Only remove the value of theReportServerVirtualDirectory tag.

  3. In the ReportServerUrl tag, type a fully qualified URL to the report server. For example, use the following format:
  4. <ReportServerUrl>http://<FullyQualifiedURL>:<PortNumber>/<VirtualDirectoryOfReportServer></ReportServerUrl>


  5. Save the RSWebApplication.config file, and then close the text editor.




After above is done, below error may be encountered,


Error: The remote server returned an error: (403) Forbidden.



Fix: Apply default settings to Reports and ReportServer in SSRS config manager

Imp Note: Doing above will reset all IIS custom settings done already, so if required, make a note of all custom settings in IIS before apply default settings again to avoid any further issues



After doing above, following error may start,

Error: The report server is not responding. Verify that the report server is running and can be accessed from this computer.




To fix this, you may need to try multiple options, first is to restart services in following manner- Stop SSRS from SQL Config Manager à Restart IIS àStart SSRS from SQL Config Manager


Other option is to grant “Network Service” permission to RSWebApplication.config file on <installdrive>:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\


Other fix is to configure reference of report server from reports as below,

Issue may be how the /Reports application references the services in the /ReportServer application, and it can be fixed by going to IIS and modifying the /ReportServer application configuration to add “ReportService2005.asmx” as a possible default content page under the “Documents” tab of the application’s property page


I fixed by adding domain account on anonymous access section of Directory security in IIS reportserver and reports.




After above is done, face next error as follows,

Error: The attempt to connect to the report server failed.  Check your connection information and that the report server is a compatible version.



Fix: To fix this, updated URL with http://<FQDN>/reportserver/ in RSWebApplication.config and rsreportserver.config





Some useful links related to SSRS configuration and settings:

Enabling Kerberos —

Config Authentication —

Install and Config SSRS2005 on Windows 2008 —

How to troubleshoot IIS configuration issues in SQL Server 2005 Reporting Services –


Download PDF

About the Author: Nitin G

Indian born, trekker, biker, photographer, lover of monsoons. I've been working full time with SQL Server since year 2005 and blogs to post the content aquired during my research on new topics or fixing issues faced by me as a DBA while working in different kind of projects, hope some of my posts may helps others in SQLDBA community. Everything you read on my blog is my own personal opinion and any code is provided "AS-IS" with no warranties!

Leave a comment

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 264 other subscribers

Translate this blog!



January 2021
« Nov    

View Post by Categories

%d bloggers like this: