Enable remote errors (Reporting Services)

Artikel
09/25/2024

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 this article:

Enable remote errors for SharePoint mode
Enable remote errors through SQL Server Management Studio (native mode)
Enable remote errors through script (native mode)
Modify the ConfigurationInfo table (native mode)

Enable remote errors for SharePoint mode

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 (11.x) release, utilizes a setting that can be configured for each Reporting Services service application. The older architecture utilizes a single site level setting.

Enable remote errors for a Reporting Services service application

For a SharePoint mode report server installed with SQL Server 2012 (11.x) 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, select Manage service applications in the Application Management group.
Find your Reporting Services service application and choose the name of your service application.
Select System Settings.
Choose Enable Remote Errors in the Security section.
Select OK.

Enable remote errors for a SharePoint site

For a SharePoint mode report server installed with a version of Reporting Services prior to SQL Server 2012 (11.x), enable the site setting Enable remote errors in local mode.
In Site Actions, choose Site Settings for the site you want to modify.
Select Reporting Services Site Settings in the Reporting Services group.
Choose Enable remote errors in local mode.
Select OK.

Enable remote errors through SQL Server Management Studio (native mode)

Start Management Studio and connect to a report server instance. For more information, see Connect to a report server in Management Studio.
Right-click the report server node, and select Properties.
Select Advanced to open the properties page. For more information, see Server Properties (Advanced Page) - Reporting Services.
In the Security section, for EnableRemoteErrors, select True.
Select OK.

Enable remote errors through script (native mode)

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.
Select Start, point to Run, enter cmd, and select OK to open a command prompt window.
Navigate to the directory that contains the .rss file you created.
Type the following command line, replacing servername with the actual name of your server:
```
rs -i EnableRemoteErrors.rss -s https://servername/ReportServer  
```
For more information, see RS.exe utility (SSRS).

Modify the ConfigurationInfo table (native mode)

Note

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.

Dela via