Check error messages for SQL Server Reporting Services 2008
"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
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.
C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\LogFiles
You will find errors description with stack traces.
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.