How to: Enable Remote Errors (Reporting Services Configuration)

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.

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
   

Configuring a Report Server for Remote Administration

Report Server System Properties

Getting SQL Server 2005 Assistance