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:
occurred during report processing.
Cannot create a connection to data source ‘AdventureWorks’.
For more information about this error navigate to the report server
on the local server machine, or enable remote errors.
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.