Tuesday, March 17, 2009

Check error messages for SQL Server Reporting Services 2008

Enable remote errors for Reporting Services 2008 - Check Reporting Services 2008 Log Files

Introduction

When you are working with Reporting Services 2008 in SharePoint Integrated Mode, you may encounter this error message in a Report Viewer Web Part or the RSViewerPage.aspx.
"For more information about this error, navigate to the report server on the local server machine, or enable remote errors"

If you want to know more about the error, you have 3 solutions:
  • Navigate to the Report Server Web Service on the computer where Reporting Services is installed.
  • Check the Reporting Services Log Files on the computer where Reporting Services is installed.
  • Enable Remote Errors


1 - Navigate to the Report Server Web Service
There is two ways obtaining the Report server URL for Reporting services 2008 in SharePoint Integrated Mode.

In SharePoint Central Administration



In the Reporting Services Configuration Manager.



When you navigate to this URL, you have access to a more explicit error message.



2 - Reporting Services 2008 Log Files location
Depending on the drive you have chosen to install your Reporting Services instance, the physical path to the Log Files where you can search for errors is the following:

C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\LogFiles

You will find errors description with stack traces.



3 - Enable remote errors for Reporting Services 2008

There is no way of enabling Remote Errors modifying the Reporting Services Web.config file
(c:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\Web.config).

In order to enable Remote Errors you have to connect to the Database Engine and update a row in the ConfigurationInfo table of the Report Server database.
You can do it performing a Tansact SQL Request



or by editing the table and make the change manually.





You have to restart Reporting Services Service after that.