Enable Remote Errors in SQL Server Reporting Services 2005

Enabling remote errors in SQL Server Reporting Services 2005 (SSRS)

By default, reporting services returns the following error message when a report produces an error:

Its inconvenient and sometimes not possible to have to browse the page on the local server. In a development environment it would be better to enable remote errors.

To enable remote errors in SSRS create a .rss script ( a plain text file ) with the following contents:

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

Then run the script using the rs.exe utility that is installed with Reporting Services:

You can download the ssrs2005-enable-remote-errors.rss script here

Thanks to Robert Bruckner for the script.