SQL Server
United States - English
Home
2012
2008 R2
2008
2005
2000
Library
Forums
15 out of 24 rated this helpful - Rate this topic

How to: Enable Remote Errors (Reporting Services Configuration)

SQL Server 2005

New: 17 July 2006

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.

Aa337165.note(en-US,SQL.90).gifNote:
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 script to modify the settings.

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

    Copy 
    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:

    Copy 
    rs -i EnableRemoteErrors.rss -s http://servername/ReportServer
Did you find this helpful?
(1500 characters remaining)
Community Content Add
Annotations FAQ
Use the script
I never been able to enable this via the ConfigurationInfo table, even after restarting the ReportingServices service and restarting the whole server. Using the script works fine though.
History