When encountering errors with reports on Microsoft SQL Server Reporting Services (SSRS) 2008 and 2008 R2 the generic error message isn’t very meaningful:
[shell]Error: For more information about this error navigate to the report server on the local server machine, or enable remote errors[/shell]
Thanks to this blog post we have a couple of ways to turn on SSRS Remote Errors.
Method 1 – Enable Remote Errors Via SQL Query
-
Connect to the ReportServer database in SQL Server Management Studio
-
Using the ReportServer database, execute the following query to enable the remote errors:
[sql]USE ReportServer
GO
UPDATE ConfigurationInfo
SET Value = ‘True’
WHERE Name = ‘EnableRemoteErrors'[/sql]
Method 2 – Enable Remote Errors Via SSMS GUI
-
Connect to the Reporting Services instance in SQL Server Management Studio
-
Right-click the report server in the Object Explorer
-
Select Properties
-
On the Advanced Page, change EnableRemoteErrors to True under Security
-
Select OK
That’s it.
[Source]