[SQL Reporting Services 2008 R2] Enable Remote Errors

When encountering errors with reports on Microsoft SQL Server Reporting Services (SSRS) 2008 and 2008 R2 the generic error message isn’t very meaningful:

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

1. Connect to the ReportServer database in SQL Server Management Studio

2. Using the ReportServer database, execute the following query to enable the remote errors:

   PgSQL

   USE ReportServer GO UPDATE ConfigurationInfo SET Value = 'True' WHERE Name = 'EnableRemoteErrors'

   1 2 3 4 5

   USE ReportServer GO UPDATE ConfigurationInfo SET Value = 'True' WHERE Name = 'EnableRemoteErrors'

Method 2 – Enable Remote Errors Via SSMS GUI

1. Connect to the Reporting Services instance in SQL Server Management Studio

2. Right-click the report server in the Object Explorer

3. Select Properties

4. On the Advanced Page, change EnableRemoteErrors to True under Security

5. Select OK

That’s it.

[Source]