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
Console.WriteLine("Remote errors enabled.")
Catch SE As SoapException
I copied the file to the SQL reporting server and ran the following command (from the
rs -i Enable-SRS-Remote-Errors.rss -s http://reportserver/ReportServer
The script writes back:
Remote errors enabled.