How to Enable Remote Errors in SQL Reporting Services?

Error:    

An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'xxx'. (rsErrorOpeningConnection) For more information about this error navigate to the report server on the local server machine, or enable remote errors  

Solution:

If you happen to get the above Error while using Reporting Services, do the following to get a more detailed Error Description.

Note: Option 1 and 2 works for both SQL server 2005 and 2008, but option 3 is only for SQL Server 2008
 

Option 1: Make changes to the ConfigurationInfo Table

You need to edit the ConfigurationInfo table in the ReportServer Database. This table contains the Configuration parameters for the Report Server. Set the EnableRemoteErrors to True, by default it is set to false.

You can Set it to True either by Opening the Table and manually editing the value to True or you can use an Update Statement to Set the value to True.

Note: If your Report Server is actively used, the changes you make to the table will not take effect on the Reports displayed immediately. In that case you need to use Option 2, ie. Enabling Remote errors through a Script.

Option 2: Enable Remote Errors through a Script

1.      Copy the following Script and paste it in Notepad

 

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

 

2.      Save the File as EnableRemoteErrors.rss

3.      Open the Command Prompt (StartàRunàtype cmd and click OK

4.      Navigate to the directory where you saved the .rss file you created

5.      Type the following command. Replace the servername with your Servername.

rs -i EnableRemoteErrors.rss -s http://servername/ReportServer

 

Option 3: Only for SQL Server 2008

 In SQL Server 2008 in addition to the above two options you have a third option to make this settings through SQL Server Management Studio.

1.Start Management Studio and connect to Report Server Instance.

2.Right click on the ReportServer database and Select Properties

3.Click Advanced

4.In EnableRemoteErrors, select True.

5.Click OK.