SQL Server 2008 R2
Welcome to SQL Server Reporting Services week at SQL University. This is a great blog project put together by Jorge Segarra (Twitter | Blog), and contributed to by many SQL professionals. If you aren’t a student yet, head over to the website and get started!
This semester, Professor Jes will be guiding you through Reporting Services administration. Let’s get started!
SQL Server Reporting Services Configuration Files
When you install SQL Server Reporting Services, you will be able to access the most important and most common settings through the Configuration Manager.
All of these settings, and many more, are stored in a series of XML configuration files. Understanding what is in these files can help you understand the SSRS architecture better, troubleshoot problems more in-depth, and customize your installations.
Let’s take a look at what these files are.
Where ARE They?
I see this question posted on forums a lot: where are the configuration files hiding? The default path to these files is C:Program FilesMicrosoft SQL ServerMSRS10_50.MSSQLSERVERReporting Services. There are several folders here, and different config files are in each.
RSReportServer
Located in the ReportServer folder, this is the meat-and-potatoes of the SSRS files. The settings here are used by Report Manager, the Report Server web service, and background processes.
Some of the settings you’ll find here include:
- Logon credentials
- Timeout information
- Authentication methods
- Email configuration
- Report rendering and delivery extensions
My next SQL University post will go more in-depth on the settings on this file.
ReportingServicesService
This file is located in the ReportServerbin folder.
Reporting Services has log files, separate from the SQL Server error log files. These are stored at C:Program FilesMicrosoft SQL ServerMSRS10_50.MSSQLSERVERReporting ServicesLogFiles. In this config file, you can edit settings related to these.
Some of the settings you’ll find here include:
• What level of logging you want on your log files.
• The name of your log files.
• The maximum size of log files.
• How log to retain log files.
This is a great place to show an example of how to modify the config files. Let’s use FileName. By default, it’s ReportServerService_.
My log file folder looks like this:
I change the name, save the file, and start the SSRS service:
And my log files are now named differently:
RSSrvPolicy , RSMgrPolicy , and RSPreviewPolicy
These three configuration files store security settings for various components. It isn’t recommended that you edit these files, but it’s helpful to know what they correspond to.
RSSrvPolicy – Report Server. Located at C:Program FilesMicrosoft SQL ServerMSRS10_50.MSSQLSERVERReporting ServicesReportServer
RSMgrPolicy – Report Manager.Located at C:Program FilesMicrosoft SQL ServerMSRS10_50.MSSQLSERVERReporting ServicesReportManager
RSPreviewPolicy – Report Designer. Note that this is in a different location, as Report Designer is part of Visual Studio (Business Intelligence Development Studio). C:Program Files (x86)Microsoft Visual Studio 9.0Common7IDEPrivateAssemblies
RSReportDesigner
This file holds settings for rendering formats and data extensions in the Report Designer. Because it relates to Report Designer, it too is located at C:Program Files (x86)Microsoft Visual Studio 9.0Common7IDEPrivateAssemblies . Microsoft recommends you only modify this file if adding custom extensions.
A Word of Caution
As with any changes to a system, make sure you back up your files before making changes. Also, be aware that some settings can only be changed from the Configuration Manager, and some are internal and can’t be changed at all.
My next post will explore ReportingServicesService, giving you information to make your SSRS installations more customized and powerful.
Jes Borland is a Premier Field Engineer - SQL Server for Microsoft, where she is a trusted technical adviser, deep technical support, and teacher for her customers. Her experience as a DBA, consultant, and 5-time Data Platform MVP allow her to help the business and the IT teams reach their goals. She has worked with SQL Server as a developer, report writer, DBA, and consultant. Her favorite topics are administration, automation, and performance. She frequently presents at user groups, SQL Saturdays, and other community events. She is also an avid runner and chef.
