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:

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]


Pin It on Pinterest

Share This
%d bloggers like this: