Skip to content

Latest commit

 

History

History
109 lines (71 loc) · 5.94 KB

enable-remote-errors-reporting-services.md

File metadata and controls

109 lines (71 loc) · 5.94 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic ms.custom helpviewer_keywords
Enable remote errors (Reporting Services)
Learn how to set server properties on a Reporting Services report server to return additional information about error conditions that occur on remote servers.
kfollis
kfollis
09/25/2024
reporting-services
report-server
how-to
updatefrequency5
remote data source [Reporting Services]
EnableRemoteError server property

Enable remote errors (Reporting Services)

You can set server properties on a [!INCLUDEssRSnoversion] 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

There are two different procedures for enabling remote errors for [!INCLUDEssRSnoversion] SharePoint mode. The procedure is different for the two different report server architectures. The newer SharePoint service based architecture that was introduced in the [!INCLUDEssSQL11] release, utilizes a setting that can be configured for each [!INCLUDEssRSnoversion] service application. The older architecture utilizes a single site level setting.

Enable remote errors for a Reporting Services service application

  1. For a SharePoint mode report server installed with [!INCLUDEssSQL11] or a newer version of [!INCLUDEssRSnoversion], enable the service application setting Enable remote errors. The setting can be configured for each [!INCLUDEssRSnoversion] service application.

  2. In SharePoint Central Administration, select Manage service applications in the Application Management group.

  3. Find your [!INCLUDEssRSnoversion] service application and choose the name of your service application.

  4. Select System Settings.

  5. Choose Enable Remote Errors in the Security section.

  6. Select OK.

Enable remote errors for a SharePoint site

  1. For a SharePoint mode report server installed with a version of [!INCLUDEssRSnoversion] prior to [!INCLUDEssSQL11], enable the site setting Enable remote errors in local mode.

  2. In Site Actions, choose Site Settings for the site you want to modify.

  3. Select Reporting Services Site Settings in the Reporting Services group.

  4. Choose Enable remote errors in local mode.

  5. Select OK.

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

  1. Start Management Studio and connect to a report server instance. For more information, see Connect to a report server in Management Studio.

  2. Right-click the report server node, and select Properties.

  3. Select Advanced to open the properties page. For more information, see Server Properties (Advanced Page) - Reporting Services.

  4. In the Security section, for EnableRemoteErrors, select True.

  5. Select OK.

Enable remote errors through script (native mode)

  1. 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

  2. Save the file as EnableRemoteErrors.rss.

  3. Select Start, point to Run, enter cmd, and select OK to open a command prompt window.

  4. Navigate to the directory that contains the .rss file you created.

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

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

  6. 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 [!INCLUDEssRSnoversion] service before the changes take effect.