Tuesday, March 17, 2009  by Marc Charmois - About Me / Previous Posts / Archives - Home

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.







Labels: , ,

2 Comments:

Blogger Lewis N. Clark said...

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: Senuke Services

March 16, 2014 at 8:12 AM  
Blogger Fiverr Work said...

Likes substantially raise the stage of popularity of your webpage and along with the perfect vary count; plenty of people will most likely be enthusiastic about your account. The firms featuring these merchandise and expert services, buy instagram likes fast will offer you you with non-automated or robot likes and provide you with actual Instagram likes. The good difficulty relating to this would be the actuality they can be immediately shipped on your account as a result you don't have to go to that a great offer. And if you're a organization, increasing your Instagram likes will be worthwhile.

April 14, 2014 at 9:51 AM  

Post a Comment

Subscribe to Post Comments [Atom]

Links to this post:

Create a Link

<< Home