Enable Remote Errors (Reporting Services)
Applies To: SQL Server 2016
You can set server properties on a Reporting Services report server to return additional information about error conditions that occur on remote servers. If an error message contains the text "For more information about this error, navigate to the report server on the local server machine, or enable remote errors", you can set the EnableRemoteErrors property to access additional information that can help you troubleshoot the problem. For more information, see Report Server System Properties in SQL Server Books Online.
In this topic:
There are two different procedures for enabling remote errors for Reporting Services SharePoint mode. The procedure is different for the two different report server architectures. The newer SharePoint service based architecture that was introduced in the SQL Server 2012 release, utilizes a setting that can be configured for each Reporting Services service application. The older architecture utilizes a single site level setting.
For a SharePoint mode report server installed with SQL Server 2012 or a newer version of Reporting Services, enable the service application setting Enable remote errors. The setting can be configured for each Reporting Services service application.
In SharePoint Central Administration, click Manage service applications in the Application Management group.
Find your Reporting Services service application and click the name of your service application.
Click System Settings.
Click Enable Remote Errors in the Security section.
For a SharePoint mode report server installed with a version of Reporting Services prior to SQL Server 2012, enable the site setting Enable remote errors in local mode.
In Site Actions click Site Settings for the site you want to modify.
Click Reporting Services Site Settings in the Reporting Services group.
Click Enable remote errors in local mode.
Start Management Studio and connect to a report server instance. For more information, see Connect to a Report Server in Management Studio in SQL Server Books Online.
Right-click the report server node, and select Properties.
Click Advanced to open the properties page. For more information, see Server Properties (Advanced Page) - Reporting Servicesin SQL Server Books Online.
In EnableRemoteErrors, select True.
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.
Click Start, point to Run, type cmd, and click OK to open a command prompt window.
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
For more information, see RS.exe Utility (SSRS)
You can edit the ConfigurationInfo table in the report server database to set EnableRemoteErrors to True, but if the report server is actively used, you should use SQL Server Management Studio or script to modify the settings. If you modify the setting in the database, you need to restart the Reporting Services service before the changes take effect.