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


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.


Toàn Cù Huy said...


Yakov Leberman said...

An impressive share, I simply given this onto a colleague who was doing a little bit analysis on this. And he in reality purchased me breakfast as a result of I discovered it for him.. smile. So let me reword that: Thnx for the treat! However yeah Thnkx for spending the time to debate this, I feel strongly about it and love reading extra on this topic. If attainable, as you turn into experience, would you mind updating your blog with extra details? It is extremely useful for me. Massive thumb up for this blog submit! online casino games