Turn on Server Remote
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:
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 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 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.
- Click 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, 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.
- Click OK
Enable remote errors through SQL Server Management Studio (Native Mode)
- 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.
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.
- 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