Reporting Services configuration files
Reporting Services stores component information in the registry and in configuration files that are copied to the file system during setup. Configuration files contain a combination of internal-use-only and user-defined values. User-defined values are specified through Setup, the configuration tools, the command line utilities, and by manually editing the configuration files.
Modifying the configuration files is only necessary if you're adding or configuring advanced settings. Configuration settings are specified as either XML elements or attributes. If you understand XML and configuration files, you can use a text or code editor to modify user-definable settings. For more information about how to modify a configuration file or to learn more about how the report server reads new and updated configuration settings, see Modify a Reporting Services configuration file (RSreportserver.config).
Note
In previous releases, Report Manager had its own configuration file named RSWebApplication.config
. That file is now obsolete. If you upgraded from a previous installation, the file isn't deleted but the report server doesn't read any settings from it. If the file exists on your computer, you should delete it. In SQL Server 2008 (10.0.x) and later versions, all Report Manager and web portal configuration settings are stored in and read from the RSReportServer.config
file. To review a list of which settings were deleted or moved, see Breaking changes in SQL Server Reporting Services in SQL Server 2016.
In this article:
Summary of configuration files (native mode)
The following table provides a description of where configuration settings are stored. Most configuration settings are stored in configuration files that are included with Reporting Services. By default, the installation directory is:
Install Paths
C:\Program Files\Microsoft SQL Server\MSRSxx.MSSQLSERVER (where xx is the MS SQL version number)
or
C:\Program Files\Microsoft SQL Server Reporting Services\SSRS
depending on the SSRS version
Stored in: | Description | Location |
---|---|---|
RSReportServer.config |
Stores configuration settings for feature areas of the Report Server service: Report Manager or the web portal, the Report Server Web service, and background processing. For more information about each setting, see RsReportServer.config configuration file. | <Installation directory>\Reporting Services\ReportServer |
RSSrvPolicy.config |
Stores the code access security policies for the server extensions. For more information about this file, see Use Reporting Services security policy files. | <Installation directory>\Reporting Services\ReportServer |
RSMgrPolicy.config |
Stores the code access security policies for the web portal. For more information about this file, see Use Reporting Services security policy files. | <Installation directory>\Reporting Services\ReportManager |
Web.config for the Report Server Web service |
Includes only those settings that are required for ASP.NET. | <Installation directory>\Reporting Services\ReportServer |
Web.config for Report Manager |
Includes only those settings that are required for ASP.NET if applicable for the SSRS version. | <Installation directory>\Reporting Services\ReportManager |
ReportingServicesService.exe.config |
Stores configuration settings that specify the trace levels and logging options for the Report Server service. For more information about the elements in this file, see ReportingServicesService configuration file. | <Installation directory>\Reporting Services\ReportServer\Bin |
Registry settings | Stores configuration state and other settings used to uninstall Reporting Services. If you're troubleshooting an installation or configuration problem, you can view these settings to get information about how the report server is configured. Don't modify these settings directly as this change can invalidate your installation. |
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<InstanceID>\Setup - And - HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Services\ReportServer |
RSReportDesigner.config |
Stores configuration settings for Report Designer. For more information, see RSReportDesigner configuration file. | <drive>:\Program Files\Microsoft Visual Studio 10\Common7\IDE\PrivateAssemblies . |
RSPreviewPolicy.config |
Stores the code access security policies for the server extensions used during report preview. For more information about this file, see Use Reporting Services security policy files. | C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssembliesr |
Summary of configuration files (SharePoint mode)
The following table provides a description of configuration files used for a SharePoint mode report server. Most configuration settings are stored in SharePoint service application databases. For more information, see Reporting Services SharePoint service and service applications.
By default, the installation directory for SharePoint mode is:
Install path
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\WebServices\Reporting
Stored in: | Description | Location |
---|---|---|
RSReportServer.config |
Stores configuration settings for feature areas of the Report Server service: Report Manager or the web portal, the Report Server Web service, and background processing. For more information about each setting, see RsReportServer.config configuration file. | <Installation directory>\Reporting Services\ReportServer |
RSSrvPolicy.config |
Stores the code access security policies for the server extensions. For more information about this file, see Use Reporting Services security policy files. | <Installation directory>\Reporting Services\ReportServer |
Web.config for the Report Server Web service |
Includes only those settings that are required for ASP.NET if applicable for the SSRS version. | <Installation directory>\Reporting Services\ReportServer |
Registry settings | Stores configuration state and other settings used to uninstall Reporting Services. Also stores information about each Reporting Services service application. Don't modify these settings directly as this change can invalidate your installation. |
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft \Microsoft SQL Server\<InstanceID>\Setup Example instance ID: MSSQL13.MSSQLSERVER - And - HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Reporting Services\Service Applications |
RSReportDesigner.config |
Stores configuration settings for Report Designer. For more information, see RSReportDesigner configuration file. | <drive>:\Program Files\Microsoft Visual Studio 10\Common7\IDE\PrivateAssemblies . |