• Article

How to: Enable Remote Errors (Reporting Services Configuration)

Updated: September 2011

Note   For SQL Server 2008 R2, there have been no changes to the content that is listed in this topic.

You can set server properties on a report server to return additional information about error conditions that occur on remote servers. If an error message contains the text "For more information about this error, navigate to the report server on the local server machine, or enable remote errors", you can set the EnableRemoteErrors property to access additional information that can help you troubleshoot the problem. For more information, see Report Server System Properties in SQL Server Books Online.

In this Topic:

  • Enable remote errors for SharePoint mode.

  • Enable remote errors through SQL Server Management Studio

  • Enable remote errors through script

  • Enable errors through ConfigurationInfo table

Enable remote errors through SharePoint Central Administration

  1. For a report server in SharePoint mode, enable the site setting Enable remote errors in local mode.

  2. In Site Actions click Site Settings for the site you want to modify.

  3. Click Reporting Services Site Settings in the Reporting Services group.

  4. Click Enable remote errors in local mode.

  5. Click OK

    Arrow icon used with Back to Top linkTop

Enable remote errors through SQL Server Management Studio

  1. Start Management Studio and connect to a report server instance. For more information, see How to: Connect to a Report Server in Management Studio in SQL Server Books Online.

  2. Right-click the report server node, and select Properties.

  3. Click Advanced to open the properties page. For more information, see Server Properties (Advanced Page) - Reporting Servicesin SQL Server Books Online.

  4. In EnableRemoteErrors, select True.

  5. Click OK.

    Arrow icon used with Back to Top linkTop

Enable remote errors through script

  1. Create a text file and copy the following script into the file.

    Public Sub Main()
  Dim P As New [Property]()
  P.Name = "EnableRemoteErrors"
  P.Value = True
  Dim Properties(0) As [Property]
  Properties(0) = P
  Try
    rs.SetSystemProperties(Properties)
    Console.WriteLine("Remote errors enabled.")
  Catch SE As SoapException
    Console.WriteLine(SE.Detail.OuterXml)
  End Try
End Sub

  2. Save the file as EnableRemoteErrors.rss.

  3. Click Start, point to Run, type cmd, and click OK to open a command prompt window.

  4. Navigate to the directory that contains the .rss file you just created.

  5. Type the following command line, replacing servername with the actual name of your server:

    rs -i EnableRemoteErrors.rss -s https://servername/ReportServer

    Arrow icon used with Back to Top linkTop

Enable Remote Errors through ConfigurationInfo table

  • Note

    You can edit the ConfigurationInfo table in the report server database to set EnableRemoteErrors to True, but if the report server is actively used, you should use SQL Server Management Studio or script to modify the settings. If you modify the setting in the database, you need to restart the service before the changes take effect.

    Arrow icon used with Back to Top linkTop

Change History

Date

Change

September 2011

Added a procedure for enabling remote errors from SharePoint site settings.