Export (0) Print
Expand All
Expand Minimize
1 out of 9 rated this helpful - Rate this topic

How to: Enable Remote Errors (Reporting Services Configuration)

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.

NoteNote

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.

Enable remote errors through SQL Server Management Studio

  1. Start Management Studio and connect to a report server instance.

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

  3. Click Advanced to open the properties page.

  4. In EnableRemoteErrors, select True.

  5. Click OK.

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 http://servername/ReportServer
    
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.