Dosql

Getting an error message when opening a report from the SSRS web site:

An error has occurred during report processing.
Cannot create a connection to data source ‘TrendDB’.
For more information about this error navigate to the report server on the local server machine, or enable remote errors

So how to enable the remote errors to trouble-shoot the problem?

• You can edit the ConfigurationInfo table in the report server database to set EnableRemoteError to True

Use ReportServer
GO

SELECT Value
FROM [dbo].[ConfigurationInfo]
where name like ‘%EnableRemoteErrors%’
Value
————————————–
False

If the returned value is False, then update the value to True to enable remote error as follow:

update [dbo].[ConfigurationInfo]
set value = ‘True’
where name like ‘%EnableRemoteErrors%’
If you change the configuration like the above, restarting the reporting service is required to make the change in effect. 

• You can also enable remote errors through script

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

Save the file as EnableRemoteErrors.rss.

Open a command prompt window and navigate to the directory that contains the .rss file you just created.

Type the following command line, replacing servername with the actual name of your server:

rs -i EnableRemoteErrors.rss -s http://servername/ReportServer
Here is the sample output:

c:\h4\SQL>rs -i EnableRemoteErrors.rss -s http://winsrvu01/reportserver
Remote errors enabled.
The command completed successfully

 

New Releases: SQL Server 2008 Standard