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.