Dec
29
2014

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: http://msdn.microsoft.com/en-ca/library/bb283249(v=sql.90).aspx

 

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.

Ref: http://support.microsoft.com/kb/922656

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/530ed56d-7c84-4d13-8998-80a8bf142197/fix-to-the-attempt-to-connect-to-the-report-server-failed-check-your-connection-information?forum=sqlreportingservices

 

Fix:

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>

    <ReportServerVirtualDirectory></ReportServerVirtualDirectory>

  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.

Ref: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/ef0f1c39-fc92-4cde-9920-597a8d6981f9/403-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.

Ref:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/0008e5fc-397e-42a9-9d73-df1e9e18e3b9/the-report-server-is-not-responding-verify-that-the-report-server-is-running-and-can-be-accessed?forum=sqlreportingservices

http://winterdom.com/2008/06/403forbiddeninreportingservices

 

Fix:

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.

Ref: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/530ed56d-7c84-4d13-8998-80a8bf142197/fix-to-the-attempt-to-connect-to-the-report-server-failed-check-your-connection-information?forum=sqlreportingservices

 

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 — http://blogs.technet.com/b/rob/archive/2011/11/23/enabling-kerberos-authentication-for-reporting-services.aspx

Config Authentication — http://msdn.microsoft.com/en-ca/library/bb283249(v=sql.90).aspx

Install and Config SSRS2005 on Windows 2008 — http://support.microsoft.com/kb/938245

How to troubleshoot IIS configuration issues in SQL Server 2005 Reporting Services – http://support.microsoft.com/kb/958998


 

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 195 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

August 2019
M T W T F S S
« Nov    
 1234
567891011
12131415161718
19202122232425
262728293031  

View Post by Categories

%d bloggers like this: