Enable remote errors in SQL 2005 Reporting services

Today I had to troubleshoot reports on a SQL 2005 Reporting services installation. All reports ran fine under a administrator account but when users tried to use the reports they where presented with the following error message:
An error has 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.

As I needed to see the actual error message I needed to enable remote errors (or running the reports locally on the reportserver as the user). To do this I created a script for enabling the remote errors and saved it as Enable-SRS-Remote-Errors.rss:
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

I copied the file to the SQL reporting server and ran the following command (from the \90\Tools\binn directory):
rs -i Enable-SRS-Remote-Errors.rss -s http://reportserver/ReportServer

The script writes back:
Remote errors enabled.

No comments: