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

  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:

    [sql]USE ReportServer
    UPDATE ConfigurationInfo
    SET Value = ‘True’
    WHERE Name = ‘EnableRemoteErrors'[/sql]

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.


Share This
%d bloggers like this: