Edit

Troubleshoot a Reporting Services installation

  • Article

If you cannot install Reporting Services because of errors that occur during setup, use the instructions in this article to address the conditions that are most likely to cause installation errors.

For information about other errors and issues related to Reporting Services, see Troubleshoot SSRS issues and errors.

Review the Online release notes in case the issue you encounter is described in the release notes.

Check setup logs

Setup errors are recorded in log files in the C:\Program Files\Microsoft SQL Server\nnn\Setup Bootstrap\Log folder. A subfolder is created each time you run Setup. The subfolder name is the time and date you ran Setup. For instructions on how to view the Setup log files, see View and Read SQL Server Setup Log Files.

  • The log files include a collection of files.

  • Open the *_summary.txt file to view product, component, and instance information.

  • Open the *_errorlog.txt file to view error information generated during Setup.

  • Open the *_RS_*_ComponentUpdateSetup.log to view Reporting Services setup information.

Check prerequisites

Setup checks prerequisites automatically. However, if you are troubleshooting setup problems, it is helpful to know which requirements Setup is checking for.

  • Account requirements for running Setup include membership in the local Administrators group. Setup must have permission to add files, registry settings, create local security groups, and set permissions. If you are installing a default configuration, Setup must have permission to create a report server database on the SQL Server instance on which you are installing.

  • Operating System must support HTTP.SYS 1.1.

  • HTTP service must be enabled and running.

  • Distributed Transaction Coordinator (DTC) must be running if you are also installing SQL Server Agent service.

  • Authz.dll must be present in the System32 folder.

Setup no longer checks for Internet Information Services (IIS) or ASP.NET. Reporting Services requires MDAC 2.0 and the Microsoft .NET Framework version 2.0; Setup will install these, if they are not already installed.

Troubleshoot problems with SharePoint mode installations

Report Server Configuration Manager does not start

Description: This issue is by design in SQL Server 2012 and later. Reporting Services is architected for the SharePoint service architecture. The Configuration Manager is no longer needed to configure and administer Reporting Services in SharePoint mode.

Workaround: Use SharePoint Central Administration to configure a report server in SharePoint mode. For more information, see Manage a Reporting Services SharePoint Service Application

Arrow icon used with Back to Top link Troubleshoot Problems with SharePoint Mode installations

You do not see the SQL Server Reporting Services service in SharePoint Central Administration after installing SQL Server 2016 SSRS in SharePoint mode

Description: If after successfully installing SQL Server 2016 Reporting Services in SharePoint mode and the SQL Server 2016 Reporting Services Add-in for SharePoint 2013/2016, you do not see "SQL Server Reporting Services" in the following two menus, then the Reporting Services service has not been registered:

  • SharePoint 2013/2016 Central Administration -> "Application Management" -> "Manage Services on Server" page

  • SharePoint 2013/2016 Central Administration -> "Application Management" -> "Manage Service Applications" -> "New" menu

Workaround: To register and start the Reporting Services SharePoint Services, complete the following steps:

  1. On the computer that runs SharePoint 2013/2016 Central Administration

    1. Open the SharePoint 2013/2016 Management Shell with administrator privileges. Right-click the icon and click Run As Administrator. Run the following three cmdlets from the shell:

    2. Install-SPRSService  

    3. Install-SPRSServiceProxy  

    4. Get-SPServiceInstance -all |where {$_.TypeName -like "SQL Server Reporting*"} | Start-SPServiceInstance

  2. Verify the Reporting Services Service shows status as "Started" on the page: SharePoint 2013/2016 Central Administration -> "Application Management" -> "Manage Services on Server"

Arrow icon used with Back to Top link Troubleshoot Problems with SharePoint Mode installations

Reporting Services PowerShell cmdlets are not available and commands are not recognized

Description: When you try to run a Reporting Services PowerShell cmdlet, you see an error message similar to this one:

  • The term 'Install-SPRSServiceInstall-SPRSService' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At line:1 char:39+ Install-SPRSServiceInstall-SPRSService <<<< + CategoryInfo : ObjectNotFound: (Install-SPRSServiceInstall-SPRSService:String) [], CommandNotFoundExcep

Workaround: Complete one of the following actions:

  • Run the Reporting Services add-in for SharePoint products. rssharepoint.msi.

  • Install Reporting Services SharePoint mode from the SQL Server installation media.

If the SharePoint 2013/2016 Management Shell is open when you complete one of the workarounds, close and reopen the management shell.

For more information, see the following articles:

Arrow icon used with Back to Top link Troubleshoot Problems with SharePoint Mode installations

You see an error message indicating the URL is not configured

Description: You see an error message similar to this one:

This SQL Server Reporting Services (SSRS) functionality is not supported. Use Central Administration to verify and fix one or more of the following issues:

  • A report server URL is not configured. Use the SSRS Integration page to set it.

  • The SSRS service application proxy is not configured. Use the SSRS service application pages to configure the proxy.

  • The SSRS service application is not mapped to this web application. Use the SSRS service application pages to associate the SSRS service application proxy to the Application Proxy Group for this web application.

Workaround: The error message contains three suggested steps to correct this issue. The first suggestion in the message 'A report server URL is not configured.' is relevant when integrating with report server version previous to SQL Server 2012 (11.x). SharePoint Configuration for the previous report server versions is completed on the General Application Settings page, using the SQL Server Reporting Services (2008 and 2008 R2)..

More Information: You will see this error message when attempting to use any of the Reporting Services functionality that requires a connection to the Reporting Services service. This includes:

  • Opening SQL Server Report Builder from a SharePoint document library.

  • Manage Subscriptions.

  • Manage a service application.

Arrow icon used with Back to Top link Troubleshoot Problems with SharePoint Mode installations

Setup fails on a computer with SharePoint installed but it is not configured

Description: If you select to install Reporting Services SharePoint Mode on a computer that has SharePoint installed but SharePoint is not configured, you will see a message similar to the following and setup will stop:

SQL Server Setup has stopped working

Workaround: Configure SharePoint and then run SQL Server Installation.

More Information: When installing Reporting Services into and existing SharePoint installation, setup attempts to install and start the Reporting Services SharePoint service. If SharePoint is not configured, the service installation fails, causing setup to fail.

Arrow icon used with Back to Top link Troubleshoot Problems with SharePoint Mode installations

SharePoint Central Administration Page is blank

Description: You were able to successfully install SharePoint 2013/2016, with no installation errors. However when you browse to Central Administration, you only see a blank page:

Workaround: This issue is not specific to Reporting Services but is related to the configuration of permissions in your overall SharePoint installation. Here are some suggestions:

  • Review the SharePoint article on development environments. Set up a general development environment for SharePoint

  • The Service account you are using for SharePoint services such as the SharePoint 2013/2016 Central Administration Service, should have administrative privileges in the local operating system.

Arrow icon used with Back to Top link Troubleshoot Problems with SharePoint Mode installations

You see an error Message when you try to create a new Report Builder Report

Description: You see an error message similar to the following when you attempt to create a Report Builder report inside a document library:

This functionality is not supported because a SQL Server Reporting Services service application does not exist or a report server URL has not been configured in Central Administration.

Workaround: Verify you have an Reporting Services service application and it is correctly configured. For more information, see Install the first Report Server in SharePoint mode.

Arrow icon used with Back to Top link Troubleshoot Problems with SharePoint Mode installations

You see an error message that RS_SHP is not supported with PREPAREIMAGE

Description: When you try to run PREPAREIMAGE for Reporting Services you see an error message similar to this one:

"The specified feature 'RS_SHP' is not supported when running the PREPAREIMAGE action, since it does not support SysPrep. Remove the features that are not compatible with SysPrep and run setup again."

Workaround: There is no work-around. Reporting Services does not support SYSPREP (PREPAREIMAGE). Reporting Services Native mode does support SYSPREP.

Arrow icon used with Back to Top link Troubleshoot Problems with SharePoint Mode installations

Troubleshoot problems with the native mode installations

Performance counters are not visible after upgrading to Windows Vista or Windows Server 2008

If you upgrade the operating system to Windows Vista or Windows Server 2008 on a computer that runs Reporting Services, Reporting Services performance counters will not be set after the upgrade.

To reinstate Reporting Services performance counters

  1. Delete the following registry keys:

    • HKLM\SYSTEM\CurrentControlSet\Services\MSRS 2016 Web Service

    • HKLM\SYSTEM\CurrentControlSet\Services\MSRS 2016 Windows Service

  2. Open a command window and type the following command at the prompt:

    • run < .NET 4.0 Framework directory >\InstallUtil.exe < Report Server Bin directory >\ReportingServicesLibrary.dll

      Note

      Replace <.NET 4.0 Framework directory> with the physical path of the .NET Framework 4.0 files and replace <Report Server Bin directory> with the physical path of the report server bin files.

  3. Restart the Reporting Services service.

To verify that the steps worked, open a Web browser and navigate to the web portal URL or the Report Server URL. Then open Performance Monitor to verify that the counters are working.

To add the performance registry keys again by using Registry Editor

  1. Open the Registry Editor:

    1. Click Start, and click Run.

    2. In the Run dialog box, in the Open box, type regedit.

  2. In Registry Editor, select the following registry key: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSRS 2016 Web Service\Performance

  3. Right-click the Performance node, point to New, and click Multi-String Value.

  4. Type Counter Names and then press ENTER.

  5. Repeat to add the Counter Types registry key in this node.

  6. Navigate to the following registry key: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSRS 2016 Web Service\Performance

  7. Right-click the Performance node, point to New, and click Multi-String Value.

  8. Type Counter Names and then press ENTER.

  9. Repeat to add the Counter Types registry key in this node.

After you repair the 64-bit instance or add the registry keys again manually, you can use Performance Monitor to configure the Reporting Services performance objects that you want to monitor.

ReportServerExternalURL and PassThroughCookies configuration properties are not configured after an upgrade from SQL Server 2005

When you upgrade from SQL Server 2005 (9.x) to SQL Server 2016 (13.x) Reporting Services or later (SSRS), the ReportServerExternalURL and PassThroughCookies configuration properties are not configured by the upgrade process. ReportServerExternalURL is an optional property, and it should be set only if you are using SharePoint 2.0 Web Parts and you want users to be able to retrieve a report and open it in a new browser window. For more information about ReportServerExternalURL, see URLs in Configuration Files (Report Server Configuration Manager). PassThroughCookies is required only when using Custom authentication method. For more information about PassThroughCookies, see Configure the Web Portal to Pass Custom Authentication Cookies.

Note

When you use Custom authentication, it is recommended that you migrate your installation rather than performing an upgrade. For more information about migrating Reporting Services, see Migrate a Reporting Services Installation (Native Mode).

By default, these properties do not exist in the SQL Server 2016 (13.x) Reporting Services or later (SSRS) configuration. If you configured these properties in SQL Server 2005 (9.x) and you continue to require the functionality that they provide, you must manually add them to the RSReportServer.config file following the upgrade process. For more information, see Modify a Reporting Services Configuration File (RSreportserver.config).

401-Unauthorized error when using Windows authentication after an upgrade from SQL Server 2005 to SQL Server 2016

If you upgrade from SQL Server 2005 (9.x) Reporting Services to SQL Server 2016 (13.x) Reporting Services or later (SSRS), and you use NTLM authentication with a built-in account for the Report Server service account, you might encounter a 401-Unauthorized error when you access the report server or the web portal after the upgrade.

You see this message because of a change in the default SQL Server 2016 (13.x) Reporting Services or later (SSRS) configuration for Windows authentication. Negotiate is configured when the Report Server service account is either Network Service or Local System. NTLM is configured when the Report Server service account is not one of those built-in accounts. To fix this issue after you upgrade, you can edit the RSReportServer.config file and configure the AuthenticationType to be RSWindowsNTLM. For more information, see Configure Windows Authentication on the Report Server.

Uninstalling 32-bit instance of SQL Server 2016 Reporting Services in side-by-side deployment with a 64-bit instance breaks the 64-bit instance

When you install a 32-bit instance and a 64-bit instance of SQL Server 2016 (13.x) Reporting Services or later (SSRS) side by side on a computer, and you uninstall the 32-bit instance, four Reporting Services registry keys are removed. Removing the keys breaks the 64-bit instance of Reporting Services. The Reporting Services registry keys that are removed when you uninstall the 32-bit instance are:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSRS 2016 Web Service\Performance:Counter Names HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSRS 2016 Windows Service\Performance:Counter Names HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSRS 2016 Web Service\Performance:Counter Types HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSRS 2016 Windows Service\Performance:Counter Types

To fix this issue, you can repair the 64-bit instance. Although it is recommended to use repair, you can add the registry keys again manually by using Registry Editor.

Caution

Incorrectly editing the registry can severely damage your system. Before making changes to the registry, you should back up any valued data on the computer.

Additional resources

The following are additional resources you can review to assist you with troubleshooting issues: