RSReportServer Configuration File
The RsReportServer.config file stores settings that are used by Report Manager, the Report Server Web service, and background processing. All Reporting Services applications run within a single process that reads configuration settings stored in the RSReportServer.config file. Both Native mode and SharePoint mode report servers use the RSReportServer.config, however the two modes do not use all of the same settings in the configuration file. The SharePoint mode version of the file is smaller as many of the settings for SharePoint mode are stored in SharePoint configuration databases rather than the file. This topic describes the default configuration file that is installed for Native mode and SharePoint mode and some of the important settings and behaviors that are controlled by the configuration file.
In SharePoint mode, the configuration file contains those settings that apply to all service application instances running on that computer. The SharePoint configuration database contains configuration settings that apply to specific service applications. The settings that are stored in the Configuration database and managed through the SharePoint management pages can be different for each Reporting Services service application.
The settings are presented in following content in the order in which they appear in the configuration file that is installed by default. For instructions on how to edit this file, see Modify a Reporting Services Configuration File (RSreportserver.config).
In this topic:
Extensions (RSReportServer.config file) Native Mode
Default Configuration File for a SharePoint Mode Report Server
File Location
The RSReportServer.config is located in the following folders, depending on the report server mode:
Native mode report server:
C:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\ReportServer
SharePoint mode report server:
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\WebServices\Reporting
For more information on editing the file, see Modify a Reporting Services Configuration File (RSreportserver.config).
General Configuration Settings (rsreportserver.config)
The following table provides information about general configuration settings that appear in the first part of the file. Settings are presented in the order in which they appear in the configuration file. The last column of the table indicates if the setting applies to a Native mode report server (N) or a SharePoint mode report server (S) or both.
Note
In this topic, "maximum integer" refers to INT_MAX value of 2147483647. For more information, see Integer Limits (https://msdn.microsoft.com/library/296az74e(v=vs.110).aspx).
Setting | Description | Mode |
---|---|---|
Dsn | Specifies the connection string to the database server that hosts the report server database. This value is encrypted and is added to the configuration file when you create the report server database. For SharePoint, the database connection information is taken from the SharePoint configuration database. | N,S |
ConnectionType | Specifies the type of credentials that the report server uses to connect to the report server database. Valid values are Default and Impersonate . Default is specified if the report server is configured to use a SQL Server login or the service account to connect to the report server database. Impersonate is specified if the report server uses a Windows account to connect to the report server database. |
N |
LogonUser, LogonDomain, LogonCred | Stores the domain, user name, and password of a domain account that is used by a report server to connect to a report server database. Values for LogonUser , LogonDomain , and LogonCred are created when the report server connection is configured to use a domain account. For more information about a report server database connection, see Configure a Report Server Database Connection (SSRS Configuration Manager). |
N |
InstanceID | An identifier for the report server instance. Report server instance names are based on SQL Server instance names. This value specifies a SQL Server instance name. By default, this value is MSRS12 <instancename>. Do not modify this setting. The following is an example of the complete value: <InstanceId>MSRS12.MSSQLSERVER</InstanceId> The following is an example of SharePoint mode: <InstanceId>MSRS12.@Sharepoint</InstanceId> |
N,S |
InstallationID | An identifier for the report server installation that Setup creates. This value is set to a GUID. Do not modify this setting. | N |
SecureConnectionLevel | Specifies the degree to which Web service calls must us Secure Sockets Layer (SSL). This setting is used for both the Report Server Web service and Report Manager. This value is set when you configure a URL to use HTTP or HTTPS in the Reporting Services Configuration tool. Valid values range from 0 through 3, where 0 is least secure. For more information, see Using Secure Web Service Methods and Configure SSL Connections on a Native Mode Report Server. | N,S |
DisableSecureFormsAuthenticationCookie | Default value is False. Specifies whether to disable the forcing of the cookie used for form and custom authentication to be marked secure. Starting with SQL Server 2012, Reporting Services will automatically mark forms authentication cookies used with custom authentication extensions, as a secure cookie when sent to the client. By changing this property, report server administrators and custom security extension authors can revert to the previous behavior which allowed the custom security extension author to determine whether to mark the cookie as a secure cookie. It is recommended that secure cookies are used for forms authentication to help prevent network sniffing and replay attacks. |
N |
CleanupCycleMinutes | Specifies the number of minutes after which old sessions and expired snapshots are removed from the report server databases. Valid values range from 0 to maximum integer. The default is 10. Setting the value to 0 disables the database clean up the process. | N,S |
MaxActiveReqForOneUser | Specifies the maximum number of reports that one user can process at the same time. Once the limit is reached, further report processing requests are denied. Valid values are 1 to a maximum integer. The default is 20. Note that most requests process very quickly so it is unlikely that a single user will have more than 20 open connections at any given time. If users are opening more than 15 process-intensive reports at the same time, you might need to increase this value. This setting is ignored for report servers that run in SharePoint integrated mode. |
N,S |
DatabaseQueryTimeout | Specifies the number of seconds after which a connection to the report server database times out. This value is passed to the System.Data.SQLClient.SQLCommand.CommandTimeout property. Valid values range from 0 to 2147483647. The default is 120. A value of 0 specifies an unlimited wait time and therefore is not recommended. | N |
AlertingCleanupCycleMinutes | The default is 20. Determines how often the clean up of temporary data stored in the Alerting database occurs. |
S |
AlertingDataCleanupMinutes | The default is 360. Determines how long session data used for creating or editing an alert definition is retained within the Alerting database. Default is 6 hours. |
S |
AlertingExecutionLogCleanupMinutes | The default is 10080. Determines how long to keep Alerting execution log values. Default is 7 days. |
S |
AlertingMaxDataRetentionDays | The default is 180. Determines how long to keep alert data required to prevent duplicate alert messages when the data for the alert has not changed. |
S |
RunningRequestsScavengerCycle | Specifies how often orphaned and expired requests are canceled. This value is specified in seconds. Valid values range from 0 to maximum integer. The default is 60. | N,S |
RunningRequestsDbCycle | Specifies how often the report server evaluates running jobs to check whether they have exceeded report execution time outs, and when to present running job information in the Manage Jobs page of Report Manager. This value is specified in seconds. Valid values range from 0 to 2147483647. The default is 60. | N,S |
RunningRequestsAge | Specifies an interval in seconds after which the status of a running job changes from new to running. Valid values range from 0 to 2147483647. The default is 30. | N,S |
MaxScheduleWait | Specifies the number of seconds the Report Server Windows service waits for a schedule to be updated by SQL Server Agent service when Next Run Time is requested. Valid values range from 1 to 60. In the default configuration file, MaxScheduleWait is set to 5. If the report server cannot find or read the configuration file, the server defaults MaxScheduleWait to 1. |
N,S |
DisplayErrorLink | Indicates whether a link to the Microsoft Help and Support site is displayed when errors occur. This link appears in error messages. Users can click the link to open updated error message content on the site. Valid values include True (default) and False . |
N,S |
WebServiceuseFileShareStorage | Specifies whether to store cached reports and temporary snapshots (created by the Report Server Web service for the duration of a user session) on the file system. Valid values are True and False (default). If the value is set to false, temporary data is stored in the reportservertempdb database. |
N,S |
WatsonFlags | Specifies how much information is logged for error conditions that are reported to Microsoft. 0x0430 = a full dump 0x0428 =a minidump 0x0002 = no dump |
N,S |
WatsonDumpOnExceptions | Specifies a list of exceptions that you want to report in an error log. This is useful when you have a recurring issue and want to create a dump with information to send to Microsoft for analysis. Creating dumps affects performance, so change this setting only when you are diagnosing a problem. | N,S |
WatsonDumpExcludeIfContainsExceptions | Specifies a list of exceptions that you do not want to report in an error log. This is useful when you are diagnosing a problem and do not want the server to create dumps for a specific exception. | N,S |
URLReservations (RSReportServer.config file)
URLReservations
defines HTTP access to the Report Server Web service and Report Manager for the current instance. URLs are reserved and stored in HTTP.SYS when you configure the report server.
Warning
For SharePoint mode, URL reservations are configured in SharePoint Central Administration. For more information, see Configure alternate access mapping (https://technet.microsoft.com/library/cc263208(office.12).aspx).
Do not modify URL reservations in the configuration file directly. Always use the Reporting Services Configuration Manager or the Report Server WMI provider to create or modify URL reservations for a Native mode report server. If you modify the values in the configuration file, you might corrupt the reservation, which will cause server errors at run time or leave orphan reservations in HTTP.SYS that are not removed if you uninstall the software. For more information, see Configure Report Server URLs (SSRS Configuration Manager) and URLs in Configuration Files (SSRS Configuration Manager).
URLReservations
is an optional element. If it is not present in the RSReportServer.config file, the server might not be configured. If it is specified, all child elements except for AccountName
are required.
The last column of the table indicates if the setting applies to a Native mode report server (N) or a SharePoint mode report server (S) or both.
Setting | Description | Mode |
---|---|---|
Application | Contains settings for Reporting Services applications. | N |
Name | Specifies the Reporting Services applications. Valid values are ReportServerWebService or ReportManager. | N |
VirtualDirectory | Specifies the virtual directory name of the application. | N |
URLs, URL | Contains one or more URL reservations for the application. | N |
UrlString | Specifies URL syntax that is valid for HTTP.SYS. For more information about the syntax, see URL Reservation Syntax (SSRS Configuration Manager). | N |
AccountSid |
Specifies the security identifier (SID) of the account for which the URL reservation was created. This should be the account under which the Report Server service runs. If the SID does not match the service account, the report server might not be able to listen for requests on that URL. | N |
AccountName |
Specifies a readable account name that corresponds to the AccountSid . It is not used, but it appears in the file so that you can easily determine the service account for the account that is used for URL reservation. |
N |
Authentication (RSReportServer.config file)
Authentication
specifies one or more authentication types accepted by the report server. The default settings and values are a subset of the settings and values that are possible for this section. Only the default settings are added automatically. To add other settings, you must use a text editor to add the element structure to the RSReportServer.config file and set the values.
Default values include RSWindowsNegotiate
and RSWindowsNTLM
with EnableAuthPersistance
set to True
:
<Authentication>
<AuthenticationTypes>
<RSWindowsNegotiate/>
<RSWindowsNTLM/>
</AuthenticationTypes>
<EnableAuthPersistence>true</EnableAuthPersistence>
</Authentication>
All other values must be added manually. For more information and examples, see Authentication with the Report Server.
The last column of the following table indicates if the setting applies to a Native mode report server (N) or a SharePoint mode report server (S) or both.
Setting | Description | Mode |
---|---|---|
AuthenticationTypes | Specifies one or more authentication types. Valid values are: RSWindowsNegotiate , RSWindowsKerberos , RSWindowsNTLM , RSWindowsBasic , and Custom .RSWindows types and Custom are mutually exclusive.RSWindowsNegotiate , RSWindowsKerberos , RSWindowsNTLM , and RSWindowsBasic are cumulative and can be used together, as illustrated in the default value example earlier in this section.Specifying multiple authentication types is necessary if you expect requests from a variety of client applications or browsers that use different types of authentication. Do not remove RSWindowsNTLM , otherwise you will limit browser support to a portion of the supported browser types. For more information, see Planning for Reporting Services and Power View Browser Support (Reporting Services 2014). |
N |
RSWindowsNegotiate |
The report server accepts either Kerberos or NTLM security tokens. This is the default setting when the report server is running in native mode and the service account is Network Service. This setting is omitted when the report server is running in native mode and the service account is configured as a domain user account. If a domain account is configured for the Report Server Service account and a Service Principle Name (SPN) is not configured for the report server, this setting might prevent users from logging on to the server. |
N |
RSWindowsNTLM |
The server accepts NTLM security tokens. If you remove this setting, browser support will be limited for some of the supported browser types. For more information, see Planning for Reporting Services and Power View Browser Support (Reporting Services 2014). |
N, S |
RSWindowsKerberos |
The server accepts Kerberos security tokens. Use this setting or RSWindowsNegotiate when you use Kerberos authentication in a constrained delegation authentication scheme. |
N |
RSWindowsBasic |
The server accepts Basic credentials and issues a challenge/response when a connection is made without credentials. Basic authentication passes credentials in the HTTP requests in clear text. If you use Basic authentication, use SSL to encrypt network traffic to and from the report server. To view example configuration syntax for Basic authentication in Reporting Services, see Authentication with the Report Server. |
N |
Custom |
Specify this value if you deployed a custom security extension on the report server computer. For more information, see Implementing a Security Extension. | N |
LogonMethod | This value specifies the logon type for RSWindowsBasic . If you specify RSWindowsBasic , this value is required. Valid values are 2 or 3, where each value represents the following:2 = Network logon high performance servers to authenticate plaintext passwords3 = Cleartext logon, which preserves logon credentials in the authentication package that is sent with each HTTP request, allowing the server to impersonate the user when connecting to other servers in the network.Note: Values 0 (for interactive logon) and 1 (for batch logon) are not supported in SQL Server 2014 Reporting Services (SSRS). |
N |
Realm | This value is used for RSWindowsBasic . It specifies a resource partition that includes authorization and authentication features used to control access to protected resources in your organization. |
N |
DefaultDomain | This value is used for RSWindowsBasic . It is used to determine the domain used by the server to authenticate the user. This value is optional, but if you omit it the report server will use the computer name as the domain. If you installed the report server on a domain controller, the domain used is the one controlled by the computer. |
N |
RSWindowsExtendedProtectionLevel | The Default value is off. For more information, see Extended Protection for Authentication with Reporting Services | N |
RSWindowsExtendedProtectionScenario | The default value is Proxy | N |
EnableAuthPersistence | Determines whether authentication is performed on the connection or for every request. Valid values are True (default) or False . If set to True , subsequent requests from the same connection assume the impersonation context of the first request.This value must be set to False if you are using proxy server software (such as ISA Server) to access the report server. Using a proxy server allows a single connection from the proxy server to be used by multiple users. For this scenario, you should disable authentication persistence so that each user request can be authenticated separately. If you do not set EnableAuthPersistence to False , all users will connect using the impersonation context of the first request. |
N,S |
Service (RSReportServer.config file)
Service
specifies the application settings that apply to the service as a whole.
The last column of the following table indicates if the setting applies to a Native mode report server (N) or a SharePoint mode report server (S) or both.
Setting | Description | Mode |
---|---|---|
IsSchedulingService | Specifies whether the report server maintains a set of SQL Server Agent jobs that correspond to schedules and subscriptions created by Reporting Services users. Valid values include True (default) and False .This setting is affected when you enable or disable Reporting Services features using the Surface Area Configuration for Reporting Services facet of Policy-Based Management. For more information, see Start and Stop the Report Server Service. |
N,S |
IsNotificationService | Specifies whether the report server processing notifications and deliveries. Valid values include True (default) and False . When the value is False , subscriptions are not delivered.This setting is affected when you enable or disable Reporting Services features using the Surface Area Configuration for Reporting Services facet of Policy-Based Management. For more information, see Start and Stop the Report Server Service. |
N,S |
IsEventService | Specifies whether service processes events in the event queue. Valid values include True (default) and False . When the value is False , the report server does not perform operations for schedules or subscriptions.This setting is affected when you enable or disable Reporting Services features using the Surface Area Configuration for Reporting Services facet of Policy-Based Management. For more information, see Start and Stop the Report Server Service. |
N,S |
IsAlertingService | The default value is True |
S |
PollingInterval | Specifies the interval, in seconds, between polls of the event table by the report server. Valid values range from 0 to maximum integer. The default is 10. | N,S |
WindowsServiceUseFileShareStorage | Specifies whether to store cached reports and temporary snapshots (created by the Report Server service for the duration of a user session) on the file system. Valid values are True and False (default). |
N,S |
MemorySafetyMargin |
Specifies a percentage of WorkingSetMaximum that defines the boundary between medium and low pressure scenarios. The default value is 80. For more information about WorkingSetMaximum and configuring available memory, see Configure Available Memory for Report Server Applications. |
N,S |
MemoryThreshold | Specifies a percentage of WorkingSetMaximum that defines the boundary between high and medium pressure scenarios. The default value is 90. This value should be greater than the value set for MemorySafetyMargin . For more information, see Configure Available Memory for Report Server Applications. |
N,S |
RecycleTime | Specifies a recycle time for the application domain, measured in minutes. Valid values range from 0 to maximum integer. The default is 720. | N,S |
MaxAppDomainUnloadTime | Specifies an interval during which the application domain is allowed to unload during a recycle operation. If recycling does not complete during this time period, all processing in the application domain is stopped. For more information, see Application Domains for Report Server Applications. This value is specified in minutes. Valid values range from 0 to maximum integer. The default is 30. |
N,S |
MaxQueueThreads | Specifies the number of threads used by the Report Server Windows service for concurrent processing of subscriptions and notifications. Valid values range from 0 to maximum integer. The default is 0. If you choose 0, the report server determines the maximum number of threads. If you specify an integer, the value you specify sets the upper limit on threads that can be created at one time. For more information about how the Report Server Windows service manages memory for running processes, see Configure Available Memory for Report Server Applications. | N,S |
UrlRoot | Used by the report server delivery extensions to compose URLs that are used by reports delivered in e-mail and file share subscriptions. The value must be a valid URL address to the report server from which the published report is accessed. Used by the report server to generate URLs for offline or unattended access. These URLs are used in exported reports, and by delivery extensions to compose a URL that is included in delivery messages such as links in e-mails. The report server determines URLs in reports based on the following behavior: When UrlRoot is blank (the default value) and there are URL reservations, the report server automatically determines URLs the same way that URLs are generated for the ListReportServerUrls method. The first URL returned by the ListReportServerUrls method is used. Or, if SecureConnectionLevel is greater than zero (0), the first SSL URL is used. When UrlRoot is set to a specific value, the explicit value is used. When UrlRoot is blank and there are no URL reservations configured, the URLs in rendered reports and in e-mail links are incorrect. |
N,S |
UnattendedExecutionAccount | Specifies a user name, password, and domain used by the report server to run a reports. These values are encrypted. Use the Reporting Services Configuration tool or the rsconfig utility to set these values. For more information, see Configure the Unattended Execution Account (SSRS Configuration Manager). For SharePoint mode, you set the execution account for a Reporting Services service application using SharePoint Central Administration. For more information, see Manage a Reporting Services SharePoint Service Application |
N |
PolicyLevel | Specifies the security policy configuration file. The valid value is Rssrvrpolicy.config. For more information, see Using Reporting Services Security Policy Files. | N,S |
IsWebServiceEnabled | Specifies whether the Report Server Web service responds to SOAP and URL access requests. This value is set when you enable or disable service using the Surface Area Configuration for Reporting Services facet of Policy-Based Management. | N,S |
IsReportManagerEnabled | Specifies whether the Report Manager application is available on the report server. Valid values are True (default) and False . If the value is set to True , Report Manager is available. Note that you must still configure a URL reservation for Report Manager before you can use it. |
N |
FileShareStorageLocation | Specifies a single folder on the file system for storing temporary snapshots. Although you can specify the folder path as a UNC path, doing so is not recommended. The default value is empty.<FileShareStorageLocation> <Path> </Path> </FileShareStorageLocation> |
N,S |
IsRdceEnabled | Specifies whether Report Definition Customization Extension (RDCE) is enabled. Valid values are True and False . |
N,S |
UI (RSReportServer.config file)
UI
specifies configuration settings that apply to the Report Manager application.
The last column of the following table indicates if the setting applies to a Native mode report server (N) or a SharePoint mode report server (S) or both.
Setting | Description | Mode |
---|---|---|
ReportServerUrl | Specifies the URL of the report server that Report Manager connects to. Only modify this value if you are configuring Report Manager to connect to a report server in another instance or on a remote computer. For more information, see Configure Report Manager (Native Mode). | N,S |
ReportBuilderTrustLevel | Do not modify this value; it is not configurable. In SQL Server 2008 Reporting Services and later versions, Report Builder runs only in FullTrust . For more information, see Configure Report Builder Access . For more information about discontinuing partial trust mode, see Discontinued Functionality to SQL Server Reporting Services in SQL Server 2014. |
N,S |
PageCountMode |
For Report Manager only, this setting specifies whether the report server calculates a page count value before the report is rendered, or as the report is viewed. Valid values are Estimate (default) and Actual . Use Estimate to calculate page count information as the user views the report. Initially, the page count is set to 2 (for the current page plus one additional page), but adjusts upwards as the user pages through the report. Use Actual if you want to calculate page count in advance before the report is displayed. Actual is provided for backward compatibility. Note that if you set PageCountMode to Actual , the entire report must be processed to get a valid page count, increasing wait time before the report is displayed. |
N,S |
Extensions (RSReportServer.config file) Native Mode
The Extensions section appears in the rsreportserver.config file only for native mode report servers. Extension information for SharePoint mode report servers is stored in the SharePoint configuration database and is configured per Reporting Services service application.
Extensions
specifies configuration settings for the following extensible modules of a Reporting Services installation:
Delivery extensions
DeliveryUI extensions
Rendering extensions
Data processing extensions
Semantic query extensions (internal only)
Model generation extensions (internal only)
Security extensions
Authentication extensions
Event processing extensions (internal only)
Report definition customization extensions
Some of these extensions are strictly for internal use by the report server. Configuration settings for internal-use-only extensions are not documented. The following sections describe configuration settings for the default extensions. If you are using report server that has custom extensions, your configuration files might contain settings that are not described here. This section lists the extensions in the order in which they appear. Settings that occur repeatedly for multiple instances of the same kind of extension are described once.
Delivery Extension(s) General configuration
Specifies default (and possibly custom) delivery extensions used to deliver reports through subscriptions. The RSReportServer.config file includes application settings for four delivery extensions:
Report server e-mail
File share delivery.
Report server document library used for a report server that runs in SharePoint integrated mode.
Null delivery provider used to preload the report cache.
For more information about delivery extensions, see Subscriptions and Delivery (Reporting Services)
All delivery extensions have Extension Name, MaxRetries, SecondsBeforeRetry, and Configuration. These shared settings are documented first. Descriptions of extension-specific settings follow in a second table.
Setting | Description |
---|---|
Extension Name | Specifies a friendly name and assembly of the delivery extension. Do not modify this value. |
MaxRetries | Specifies the number of times a report server will retry a delivery if the first attempt does not succeed. The default value is 3. |
SecondsBeforeRetry | Specifies the interval of time (in seconds) between each retry attempt. The default value is 900. |
Configuration | Contains the configuration settings that are specific to each delivery extension. |
File Share Delivery Extension Configuration Settings
File Share delivery sends a report that has been exported to an application file format to a shared folder on the network. For more information, see File Share Delivery in Reporting Services.
Setting | Description |
---|---|
ExcludedRenderFormats, RenderingExtension | These settings are used to intentionally exclude export formats that do not work well with file share delivery. These formats are typically used for interactive reporting, preview, or to preload the report cache. They do not produce application files that can be easily viewed from a desktop application. Valid values are: HTMLOWC RGDI Null |
Report Server E-mail Extension Configuration Settings
Report Server Email uses an SMTP network device to send reports to e-mail addresses. This delivery extension must be configured before it can be used. For more information, see Configure a Report Server for E-Mail Delivery (SSRS Configuration Manager) and E-Mail Delivery in Reporting Services.
Setting | Description |
---|---|
SMTPServer | Specifies a string value indicating the address of a remote SMTP server or forwarder. This value is required for remote SMTP service. It can be an IP address, a UNC name of a computer on your corporate intranet, or a fully qualified domain name. |
SMTPServerPort | Specifies an integer value indicating the port on which the SMTP service uses to send outgoing mail. Port 25 is typically used to send e-mail. |
SMTPAccountName | Contains a string value that assigns Microsoft Outlook Express account name. You can set this value if your SMTP server is configured to use it in some way; otherwise you can leave it blank. Use From to specify an e-mail account used to send reports. |
SMTPConnectionTimeout | Specifies an integer value indicating the number of seconds to wait for a valid socket connection with the SMTP service before timing out. The default is 30 seconds, but this value is ignored if SendUsing is set to 2. |
SMTPServerPickupDirectory | Specifies a string value indicating the pickup directory for the local SMTP service. This value must be a fully qualified local folder path (for example, d:\rs-emails). |
SMTPUseSSL | Specifies a Boolean value that can be set to use Secure Sockets Layer (SSL) when sending an SMTP message over the network. The default value is 0 (or false). This setting can be used when the SendUsing element is set to 2. |
SendUsing | Specifies which method to use for sending messages. Valid values are: 1=Sends a message from the local SMTP service pickup directory. 2=Sends the message from the network SMTP service. |
SMTPAuthenticate | Specifies an integer value that indicates the kind of authentication to use when sending messages to an SMTP service over a TCP/IP connection. Valid values are: 0=No authentication. 1= (not supported). 2= NTLM (NT LanMan) authentication. The security context of the Report Server Windows service is used to connect to the network SMTP server. |
From | Specifies an e-mail address from which reports are sent in the format abc@host.xyz. The address appears on the From line of an outgoing e-mail message. This value is required if you are using a remote SMTP server. It should be a valid e-mail account that has permission to send mail. |
EmbeddedRenderFormats, RenderingExtension | Specifies the rendering format used to encapsulate a report within the body of an e-mail message. Images within the report are subsequently embedded within the report. Valid values are MHTML and HTML4.0. |
PrivilegedUserRenderFormats | Specifies rendering formats that a user can select from for a report subscription when subscribing is enabled through the "Manage all subscriptions" task. If this value is not set, all render formats that are not intentionally excluded are available to use. |
ExcludedRenderFormats, RenderingExtension | Purposely excludes formats that do not work well with a given delivery extension. You cannot exclude multiple instances of the same rendering extension. Excluding multiple instances will result in an error when the report server reads the configuration file. By default, the following extensions are excluded for e-mail delivery: HTMLOWC Null RGDI |
SendEmailToUserAlias | This value works with DefaultHostName. When SendEmailToUserAlias is set to True , users who define individual subscriptions are automatically specified as recipients of the report. The To field is hidden. If this value is False , the To field is visible. Set this value to True if you want maximum control over report distribution. Valid values include the following:True =The e-mail address of the user creating the subscription is used. This is the default value.False =Any e-mail address can be specified. |
DefaultHostName | This value works with SendEmailToUserAlias. Specifies a string value indicating the host name to append to the user alias when the SendEmailToUserAlias is set to true. This value can be a Domain Name System (DNS) name or IP address. |
PermittedHosts | Limits report distribution by explicitly specifying which hosts can receive e-mail delivery. Within PermittedHosts, each host is specified as a HostName element, where the value is either an IP address or a DNS name. Only e-mail accounts defined for the host are valid recipients. If you specified DefaultHostName, be sure to include that host as HostName element of PermittedHosts. This value must be one or more DNS names or IP addresses. By default, this value is not set. If the value is not set, there are no restrictions on who can receive e-mailed reports. |
Report Server SharePoint Document Library Extension Configuration
Report Server Document Library sends a report that has been exported to an application file format to a document library. This delivery extension can only be used by a report server that is configured to run in SharePoint integrated mode. For more information, see SharePoint Library Delivery in Reporting Services.
Setting | Description |
---|---|
ExcludedRenderFormats, RenderingExtension | These settings are used to intentionally exclude export formats that do not work well with document library delivery. HTMLOWC, RGDI, and Null delivery extensions are excluded. These formats are typically used for interactive reporting, preview, or to preload the report cache. They do not produce application files that can be easily viewed from a desktop application. |
NULL delivery Extension Configuration
The NULL delivery provider is used to preload the cache with pre-generated reports for individual users. There are no configuration settings for this delivery extension. For more information, see Caching Reports (SSRS).
Delivery UI Extension(s) General Configuration
Specifies delivery extensions that contain a user interface component that appears in the subscription definition pages used when defining individual subscriptions in Report Manager. If you create and deploy a custom delivery extension that has user-defined options and you want to use Report Manager, you must register the delivery extension in this section. By default, there are configuration settings for Report Server E-mail and Report Server File Share. Delivery extensions used only in data-driven subscriptions or in SharePoint application pages do not have settings in this section.
Setting | Description |
---|---|
DefaultDeliveryExtension | This setting determines which delivery extension appears first in the list of delivery types in the subscription definition page. Only one delivery extension can contain this setting. Valid values include True or False . When this value is set to True , that extension is default selection. |
Configuration | Specifies configuration options for a delivery extension. You can set a default rendering format for each delivery extension. Valid values are the rendering extension names noted in the render section of the rsreportserver.config file. |
DefaultRenderingExtension | Specifies whether a delivery extension is the default. Report Server E-Mail is the default delivery extension. Valid values include True or False . If more than one extension contains a value of True , the first extension is considered the default extension. |
Rendering Extensions General Configuration
Specifies default (and possibly custom) rendering extensions used in report presentation.
Do not modify this section unless you are deploying a custom rendering extension. For more information, see Implementing a Rendering Extension.
Default rendering extensions include the following:
XML
Null
CSV
PDF
RGDI
HTML4.0
MHTML
EXCEL
RPL
IMAGE
Starting with the SQL Server 2012 release, the MHTML and HTML 4.0 renders contain by default the following device information setting to control the behavior of sizing data visualizations.
<DeviceInfo><DataVisualizationFitSizing>Approximate</DataVisualizationFitSizing></DeviceInfo>
For more information on DeviceInfo settings, see the following:
[HTML Device Information Settings]../../html-device-information-settings.md)
Device Information Settings for Rendering Extensions (Reporting Services)
For information about the attributes for the child <Extension> element under <Render>, see the following:
Do not modify this section unless you are deploying a custom rendering extension. For more information, see Implementing a Rendering Extension.
Data Extension(s) General Configuration
Specifies default (and possibly custom) data processing extensions used to process queries. Default data processing extensions include the following:
SQL
SQLAZURE
SQLPDW
OLEDB
OLEDB-MD
ORACLE
ODBC
XML
SHAREPOINTLIST
SAPBW
ESSBASE
TERADATA
Do not modify this section unless you are adding custom data processing extensions. For more information, see Implementing a Data Processing Extension.
Semantic Query Extensions General Configuration
Specifies semantic query processing extension used to process report models. The semantic query processing extensions included with Reporting Services provide support for SQL Server relational data, Oracle, and Analysis Services multidimensional data. Do not modify this section. Query processing is not extensible.
Model Generation Configuration
Specifies a model generation extension used to create report models from a shared data source that is already published on a report server. You can generate models for SQL Server relational data, Oracle, and Analysis Services multidimensional data sources. Do not modify this section. Model generation is not extensible.
Security Extension Configuration
Specifies the authorization component used by Reporting Services. This component is used by the authentication extension registered in the Authentication
element of the RSReportServer.config file. Do not modify this section unless you are implementing a custom authentication extension. For more information about adding custom security features, see Implementing a Security Extension. For more information about authorization, see Authorization in Reporting Services.
Authentication Extension Configuration
Specifies the default and custom authentication extensions used by the report server. The default extension is based on Windows Authentication. Do not modify this section unless you are implementing a custom authentication extension. For more information about authentication in Reporting Services, see Authentication in Reporting Services and Authentication with the Report Server. For more information about adding custom security features, see Implementing a Security Extension.
Event Processing
Specifies default event handlers. Do not modify this section. This section is not extensible.
Report Definition Customization
Specifies the name and type of a custom extension that modifies a report definition.
RDLSandboxing
Specifies a Report Definition Language (RDL) mode that enables you to help detect and restrict the use of specific types of report resources by individual tenants in a scenario where multiple tenants share a single Web farm of report servers. For more information, see Enable and Disable RDL Sandboxing.
MapTileServerConfiguration (RSReportServer.config file)
MapTileServerConfiguration
defines configuration settings for Microsoft Bing Maps Web Services that provides a tile background for a map report item in a report that is published on a report server. All child elements are required.
Setting | Description |
---|---|
MaxConnections | Specifies the maximum number of connections to Bing Maps Web Services. |
Timeout | Specifies the timeout in seconds to wait for a response from Bing Maps Web Services. |
AppID | Specifies the application identifier (AppID) to use for Bing Maps Web Services. (Default) specifies the Reporting Services default AppID.For more information about the use of Bing map tiles in your report, see Additional Terms of Use and Privacy Statement. Do not change this value unless you must specify a custom AppID for your own Bing Maps license agreement. When you change the AppID, you do not have to restart Reporting Services for the change to take effect. |
CacheLevel | Specifies a value from the HttpRequestCacheLevel Enumeration of System.Net.Cache. The default value is Default . For more information, see HttpRequestCacheLevel Enumeration. |
Default Configuration File for a Native Mode Report Server
The rsreportserver.config file is installed to the following location by default:
C:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\ReportServer
<Configuration> <Dsn>AQAAANCMnd8BFdERjHoAwE/Cl+sBAAAAoyfT3iJKS0qxG3ibhRCYhAQAAAAiAAAAUgBlAHAAbwByAHQAaQBuAGcAIABTAGUAcgB2AGUAcgAAAANmAADAAAAAEAAAADMnIAaBwxRDy2mu4yg0zKAAAAAABIAAAKAAAAAQAAAAX+0WIyZTGyyEE7R8rtmmZegAAAByz0h1aXSAggJLDnVfd1eyGlLqTln9cCff3DQ25pcNBccP2rsLkwokUrS9kcee4up6UOawgKQuQjqWbLXfpqY9Dp/ueDTcF8h+VlSWNCmcH/OlDo7Pt2S6FestlnrmFrUXImx+XPZoeDYQelDUTgy8cHUAgUlD/wW8beboXXcS04QB0uTy2mwtUl5/xAPOGXFOKkXp6w8wqnxkEdVd60WyyppOu7djRf25OBSZn3I4T5dwaORHqPGVJmVGzcagoG5u0hDqtEf2RD4FnJgcAAIRHcqxj+jqOV+ZCVvmDcdBWCsbg5OdvIBEFAAAABi/yAmdbbA2emMyOAFIQ1k0His4</Dsn> <ConnectionType>Default</ConnectionType> <LogonUser></LogonUser> <LogonDomain></LogonDomain> <LogonCred></LogonCred> <InstanceId>MSRS12.MSSQLSERVER</InstanceId> <InstallationID>{6af9ea4c-2593-4dd8-8e2b-6315014c1a52}</InstallationID> <Add Key="SecureConnectionLevel" Value="0"/> <Add Key="DisableSecureFormsAuthenticationCookie" Value="false"/> <Add Key="CleanupCycleMinutes" Value="10"/> <Add Key="MaxActiveReqForOneUser" Value="20"/> <Add Key="DatabaseQueryTimeout" Value="120"/> <Add Key="RunningRequestsScavengerCycle" Value="60"/> <Add Key="RunningRequestsDbCycle" Value="60"/> <Add Key="RunningRequestsAge" Value="30"/> <Add Key="MaxScheduleWait" Value="5"/> <Add Key="DisplayErrorLink" Value="true"/> <Add Key="WebServiceUseFileShareStorage" Value="false"/> <!-- <Add Key="ProcessTimeout" Value="150" /> --> <!-- <Add Key="ProcessTimeoutGcExtension" Value="30" /> --> <!-- <Add Key="WatsonFlags" Value="0x0430" /> full dump--> <!-- <Add Key="WatsonFlags" Value="0x0428" /> minidump --> <!-- <Add Key="WatsonFlags" Value="0x0002" /> no dump--> <Add Key="WatsonFlags" Value="0x0428"/> <Add Key="WatsonDumpOnExceptions" Value="Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException"/> <Add Key="WatsonDumpExcludeIfContainsExceptions" Value="System.Threading.ThreadAbortException,System.Web.UI.ViewStateException,System.OutOfMemoryException,System.Web.HttpException,System.IO.IOException,System.IO.FileLoadException,Microsoft.SharePoint.SPException,Microsoft.ReportingServices.WmiProvider.WMIProviderException"/> <URLReservations> <Application> <Name>ReportServerWebService</Name> <VirtualDirectory>ReportServer</VirtualDirectory> <URLs> <URL> <UrlString>http://+:80</UrlString> <AccountSid>S-1-5-80-2885764129-887777008-271615777-1616004480-2722851051</AccountSid> <AccountName>NT Service\ReportServer</AccountName> </URL> </URLs> </Application> <Application> <Name>ReportManager</Name> <VirtualDirectory>Reports</VirtualDirectory> <URLs> <URL> <UrlString>http://+:80</UrlString> <AccountSid>S-1-5-80-2885764129-887777008-271615777-1616004480-2722851051</AccountSid> <AccountName>NT Service\ReportServer</AccountName> </URL> </URLs> </Application> </URLReservations> <Authentication> <AuthenticationTypes> <RSWindowsNTLM/> </AuthenticationTypes> <RSWindowsExtendedProtectionLevel>Off</RSWindowsExtendedProtectionLevel> <RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario> <EnableAuthPersistence>true</EnableAuthPersistence> </Authentication> <Service> <IsSchedulingService>True</IsSchedulingService> <IsNotificationService>True</IsNotificationService> <IsEventService>True</IsEventService> <PollingInterval>10</PollingInterval> <WindowsServiceUseFileShareStorage>False</WindowsServiceUseFileShareStorage> <MemorySafetyMargin>80</MemorySafetyMargin> <MemoryThreshold>90</MemoryThreshold> <RecycleTime>720</RecycleTime> <MaxAppDomainUnloadTime>30</MaxAppDomainUnloadTime> <MaxQueueThreads>0</MaxQueueThreads> <UrlRoot> </UrlRoot> <UnattendedExecutionAccount> <UserName></UserName> <Password></Password> <Domain></Domain> </UnattendedExecutionAccount> <PolicyLevel>rssrvpolicy.config</PolicyLevel> <IsWebServiceEnabled>True</IsWebServiceEnabled> <IsReportManagerEnabled>True</IsReportManagerEnabled> <FileShareStorageLocation> <Path> </Path> </FileShareStorageLocation> </Service> <UI> <ReportServerUrl> </ReportServerUrl> <PageCountMode>Estimate</PageCountMode> </UI> <Extensions> <Delivery> <Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider"> <MaxRetries>3</MaxRetries> <SecondsBeforeRetry>900</SecondsBeforeRetry> <Configuration> <FileShareConfiguration> <ExcludedRenderFormats> <RenderingExtension>HTMLOWC</RenderingExtension> <RenderingExtension>NULL</RenderingExtension> <RenderingExtension>RGDI</RenderingExtension> </ExcludedRenderFormats> </FileShareConfiguration> </Configuration> </Extension> <Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider"> <MaxRetries>3</MaxRetries> <SecondsBeforeRetry>900</SecondsBeforeRetry> <Configuration> <RSEmailDPConfiguration> <SMTPServer></SMTPServer> <SMTPServerPort> </SMTPServerPort> <SMTPAccountName> </SMTPAccountName> <SMTPConnectionTimeout> </SMTPConnectionTimeout> <SMTPServerPickupDirectory> </SMTPServerPickupDirectory> <SMTPUseSSL> </SMTPUseSSL> <SendUsing>2</SendUsing> <SMTPAuthenticate> </SMTPAuthenticate> <From></From> <EmbeddedRenderFormats> <RenderingExtension>MHTML</RenderingExtension> </EmbeddedRenderFormats> <PrivilegedUserRenderFormats> </PrivilegedUserRenderFormats> <ExcludedRenderFormats> <RenderingExtension>HTMLOWC</RenderingExtension> <RenderingExtension>NULL</RenderingExtension> <RenderingExtension>RGDI</RenderingExtension> </ExcludedRenderFormats> <SendEmailToUserAlias>True</SendEmailToUserAlias> <DefaultHostName> </DefaultHostName> <PermittedHosts> </PermittedHosts> </RSEmailDPConfiguration> </Configuration> </Extension> <Extension Name="Report Server DocumentLibrary" Type="Microsoft.ReportingServices.SharePoint.SharePointDeliveryExtension.DocumentLibraryProvider,ReportingServicesSharePointDeliveryExtension"> <MaxRetries>3</MaxRetries> <SecondsBeforeRetry>900</SecondsBeforeRetry> <Configuration> <DocumentLibraryConfiguration> <ExcludedRenderFormats> <RenderingExtension>HTMLOWC</RenderingExtension> <RenderingExtension>NULL</RenderingExtension> <RenderingExtension>RGDI</RenderingExtension> </ExcludedRenderFormats> </DocumentLibraryConfiguration> </Configuration> </Extension> <Extension Name="NULL" Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/> </Delivery> <DeliveryUI> <Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl,ReportingServicesEmailDeliveryProvider"> <DefaultDeliveryExtension>True</DefaultDeliveryExtension> <Configuration> <RSEmailDPConfiguration> <DefaultRenderingExtension>MHTML</DefaultRenderingExtension> </RSEmailDPConfiguration> </Configuration> </Extension> <Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIControl,ReportingServicesFileShareDeliveryProvider"/> </DeliveryUI> <Render> <Extension Name="XML" Type="Microsoft.ReportingServices.Rendering.DataRenderer.XmlDataReport,Microsoft.ReportingServices.DataRendering"/> <Extension Name="NULL" Type="Microsoft.ReportingServices.Rendering.NullRenderer.NullReport,Microsoft.ReportingServices.NullRendering" Visible="false"/> <Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering"/> <Extension Name="ATOM" Type="Microsoft.ReportingServices.Rendering.DataRenderer.AtomDataReport,Microsoft.ReportingServices.DataRendering" Visible="false"/> <Extension Name="PDF" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PDFRenderer,Microsoft.ReportingServices.ImageRendering"/> <Extension Name="RGDI" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.RGDIRenderer,Microsoft.ReportingServices.ImageRendering" Visible="false"/> <Extension Name="HTML4.0" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false"> <Configuration> <DeviceInfo> <DataVisualizationFitSizing>Approximate</DataVisualizationFitSizing> </DeviceInfo> </Configuration> </Extension> <Extension Name="MHTML" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.MHtmlRenderingExtension,Microsoft.ReportingServices.HtmlRendering"> <Configuration> <DeviceInfo> <DataVisualizationFitSizing>Approximate</DataVisualizationFitSizing> </DeviceInfo> </Configuration> </Extension> <Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering" Visible="false"/> <Extension Name="EXCELOPENXML" Type="Microsoft.ReportingServices.Rendering.ExcelOpenXmlRenderer.ExcelOpenXmlRenderer,Microsoft.ReportingServices.ExcelRendering"/> <Extension Name="RPL" Type="Microsoft.ReportingServices.Rendering.RPLRendering.RPLRenderer,Microsoft.ReportingServices.RPLRendering" Visible="false" LogAllExecutionRequests="false"/> <Extension Name="IMAGE" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRenderer,Microsoft.ReportingServices.ImageRendering"/> <Extension Name="WORD" Type="Microsoft.ReportingServices.Rendering.WordRenderer.WordDocumentRenderer,Microsoft.ReportingServices.WordRendering" Visible="false"/> <Extension Name="WORDOPENXML" Type="Microsoft.ReportingServices.Rendering.WordRenderer.WordOpenXmlRenderer.WordOpenXmlDocumentRenderer,Microsoft.ReportingServices.WordRendering"/> </Render> <Data> <Extension Name="SQL" Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/> <Extension Name="SQLAZURE" Type="Microsoft.ReportingServices.DataExtensions.SqlAzureConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/> <Extension Name="SQLPDW" Type="Microsoft.ReportingServices.DataExtensions.SqlDwConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/> <Extension Name="OLEDB" Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/> <Extension Name="OLEDB-MD" Type="Microsoft.ReportingServices.DataExtensions.AdoMdConnection,Microsoft.ReportingServices.DataExtensions"/> <Extension Name="ORACLE" Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/> <Extension Name="ODBC" Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/> <Extension Name="XML" Type="Microsoft.ReportingServices.DataExtensions.XmlDPConnection,Microsoft.ReportingServices.DataExtensions"/> <Extension Name="SHAREPOINTLIST" Type="Microsoft.ReportingServices.DataExtensions.SharePointList.SPListConnection,Microsoft.ReportingServices.DataExtensions"/> <Extension Name="SAPBW" Type="Microsoft.ReportingServices.DataExtensions.SapBw.SapBwConnection,Microsoft.ReportingServices.DataExtensions.SapBw"/> <Extension Name="ESSBASE" Type="Microsoft.ReportingServices.DataExtensions.Essbase.EssbaseConnection,Microsoft.ReportingServices.DataExtensions.Essbase"/> <Extension Name="TERADATA" Type="Microsoft.ReportingServices.DataExtensions.TeradataConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/> </Data> <SemanticQuery> <Extension Name="SQL" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQL.MSSqlSQCommand,Microsoft.ReportingServices.SemanticQueryEngine"> <Configuration> <EnableMathOpCasting>False</EnableMathOpCasting> </Configuration> </Extension> <Extension Name="SQLAZURE" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQL.MSSqlSQCommand,Microsoft.ReportingServices.SemanticQueryEngine"> <Configuration> <EnableMathOpCasting>False</EnableMathOpCasting> </Configuration> </Extension> <Extension Name="SQLPDW" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQLADW.MSSqlAdwSQCommand,Microsoft.ReportingServices.SemanticQueryEngine"> <Configuration> <EnableMathOpCasting>False</EnableMathOpCasting> </Configuration> </Extension> <Extension Name="ORACLE" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Oracle.OraSqlSQCommand,Microsoft.ReportingServices.SemanticQueryEngine"> <Configuration> <EnableMathOpCasting>True</EnableMathOpCasting> <DisableNO_MERGEInLeftOuters>False</DisableNO_MERGEInLeftOuters> <EnableUnistr>False</EnableUnistr> <DisableTSTruncation>False</DisableTSTruncation> </Configuration> </Extension> <Extension Name="TERADATA" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Teradata.TdSqlSQCommand,Microsoft.ReportingServices.SemanticQueryEngine"> <Configuration> <EnableMathOpCasting>True</EnableMathOpCasting> <ReplaceFunctionName>oREPLACE</ReplaceFunctionName> </Configuration> </Extension> <Extension Name="OLEDB-MD" Type="Microsoft.AnalysisServices.Modeling.QueryExecution.ASSemanticQueryCommand,Microsoft.AnalysisServices.Modeling"/> </SemanticQuery> <ModelGeneration> <Extension Name="SQL" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQL.MsSqlModelGenerator,Microsoft.ReportingServices.SemanticQueryEngine"/> <Extension Name="SQLAZURE" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQL.MsSqlModelGenerator,Microsoft.ReportingServices.SemanticQueryEngine"/> <Extension Name="ORACLE" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Oracle.OraSqlModelGenerator,Microsoft.ReportingServices.SemanticQueryEngine"/> <Extension Name="TERADATA" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Teradata.TdSqlModelGenerator,Microsoft.ReportingServices.SemanticQueryEngine"/> <Extension Name="OLEDB-MD" Type="Microsoft.AnalysisServices.Modeling.Generation.ModelGeneratorExtention,Microsoft.AnalysisServices.Modeling"/> </ModelGeneration> <Security> <Extension Name="Windows" Type="Microsoft.ReportingServices.Authorization.WindowsAuthorization, Microsoft.ReportingServices.Authorization"/> </Security> <Authentication> <Extension Name="Windows" Type="Microsoft.ReportingServices.Authentication.WindowsAuthentication, Microsoft.ReportingServices.Authorization"/> </Authentication> <EventProcessing> <Extension Name="SnapShot Extension" Type="Microsoft.ReportingServices.Library.HistorySnapShotCreatedHandler,ReportingServicesLibrary"> <Event> <Type>ReportHistorySnapshotCreated</Type> </Event> </Extension> <Extension Name="Timed Subscription Extension" Type="Microsoft.ReportingServices.Library.TimedSubscriptionHandler,ReportingServicesLibrary"> <Event> <Type>TimedSubscription</Type> </Event> </Extension> <Extension Name="Cache Refresh Plan Extension" Type="Microsoft.ReportingServices.Library.CacheRefreshPlanHandler,ReportingServicesLibrary"> <Event> <Type>RefreshCache</Type> </Event> </Extension> <Extension Name="Cache Update Extension" Type="Microsoft.ReportingServices.Library.ReportExecutionSnapshotUpdateEventHandler,ReportingServicesLibrary"> <Event> <Type>SnapshotUpdated</Type> </Event> </Extension> </EventProcessing> </Extensions> <MapTileServerConfiguration> <MaxConnections>2</MaxConnections> <Timeout>10</Timeout> <AppID>(Default)</AppID> <CacheLevel>Default</CacheLevel> </MapTileServerConfiguration></Configuration>
Default Configuration File for a SharePoint Mode Report Server
The rsreportserver.config file is installed to the following location by default:
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\WebServices\Reporting
<Configuration>
<Dsn />
<ConnectionType>Default</ConnectionType>
<LogonUser>
</LogonUser>
<LogonDomain>
</LogonDomain>
<LogonCred>
</LogonCred>
<InstanceId>MSRS12.@Sharepoint</InstanceId>
<Add Key="SecureConnectionLevel" Value="0" />
<Add Key="CleanupCycleMinutes" Value="10" />
<Add Key="MaxActiveReqForOneUser" Value="20" />
<Add Key="AlertingCleanupCycleMinutes" Value="20" />
<Add Key="AlertingDataCleanupMinutes" Value="360" />
<Add Key="AlertingExecutionLogCleanupMinutes" Value="10080" />
<Add Key="AlertingMaxDataRetentionDays" Value="180" />
<Add Key="RunningRequestsScavengerCycle" Value="60" />
<Add Key="RunningRequestsDbCycle" Value="60" />
<Add Key="RunningRequestsAge" Value="30" />
<Add Key="MaxScheduleWait" Value="5" />
<Add Key="DisplayErrorLink" Value="true" />
<Add Key="WebServiceUseFileShareStorage" Value="false" />
<!-- <Add Key="ProcessTimeout" Value="150" /> -->
<!-- <Add Key="ProcessTimeoutGcExtension" Value="30" /> -->
<!-- <Add Key="WatsonFlags" Value="0x0430" /> full dump-->
<!-- <Add Key="WatsonFlags" Value="0x0428" /> minidump -->
<!-- <Add Key="WatsonFlags" Value="0x0002" /> no dump-->
<Add Key="WatsonFlags" Value="0x0428" />
<Add Key="WatsonDumpOnExceptions" Value="Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException" />
<Add Key="WatsonDumpExcludeIfContainsExceptions" Value="System.Threading.ThreadAbortException,System.Web.UI.ViewStateException,System.OutOfMemoryException,System.Web.HttpException,System.IO.IOException,System.IO.FileLoadException,Microsoft.SharePoint.SPException,Microsoft.ReportingServices.WmiProvider.WMIProviderException" />
<RStrace>
<add name="FileName" value="ReportServerService" />
<add name="FileSizeLimitMb" value="32" />
<add name="KeepFilesForDays" value="14" />
<add name="Prefix" value="tid, time" />
<add name="TraceListeners" value="file" />
<add name="TraceFileMode" value="unique" />
<add name="Components" value="all:3" />
</RStrace>
<URLReservations>
<Application>
<Name>ReportServerWebService</Name>
<VirtualDirectory>ReportServer</VirtualDirectory>
<URLs>
<URL>
<UrlString>http://+:80</UrlString>
<AccountSid>
</AccountSid>
<AccountName>
</AccountName>
</URL>
</URLs>
</Application>
<Application>
<Name>ReportManager</Name>
<VirtualDirectory>Reports</VirtualDirectory>
<URLs>
<URL>
<UrlString>http://+:80</UrlString>
<AccountSid>
</AccountSid>
<AccountName>
</AccountName>
</URL>
</URLs>
</Application>
</URLReservations>
<Authentication>
<AuthenticationTypes>
<RSWindowsNTLM />
</AuthenticationTypes>
<EnableAuthPersistence>true</EnableAuthPersistence>
</Authentication>
<Service>
<IsSchedulingService>True</IsSchedulingService>
<IsNotificationService>True</IsNotificationService>
<IsEventService>True</IsEventService>
<IsAlertingService>True</IsAlertingService>
<PollingInterval>10</PollingInterval>
<WindowsServiceUseFileShareStorage>False</WindowsServiceUseFileShareStorage>
<MemorySafetyMargin>80</MemorySafetyMargin>
<MemoryThreshold>90</MemoryThreshold>
<RecycleTime>720</RecycleTime>
<MaxAppDomainUnloadTime>30</MaxAppDomainUnloadTime>
<MaxQueueThreads>0</MaxQueueThreads>
<UrlRoot>
</UrlRoot>
<PolicyLevel>rssrvpolicy.config</PolicyLevel>
<IsWebServiceEnabled>True</IsWebServiceEnabled>
<IsReportManagerEnabled>True</IsReportManagerEnabled>
<FileShareStorageLocation>
<Path>
</Path>
</FileShareStorageLocation>
</Service>
<UI>
<ReportServerUrl>
</ReportServerUrl>
<PageCountMode>Estimate</PageCountMode>
</UI>
<MapTileServerConfiguration>
<MaxConnections>2</MaxConnections>
<Timeout>10</Timeout>
<AppID>(Default)</AppID>
<CacheLevel>Default</CacheLevel>
</MapTileServerConfiguration>
</Configuration>
See Also
Modify a Reporting Services Configuration File (RSreportserver.config)
Configure Available Memory for Report Server Applications
Customize Style Sheets for HTML Viewer and Report Manager
Reporting Services Configuration Files
Initialize a Report Server (SSRS Configuration Manager)
Store Encrypted Report Server Data (SSRS Configuration Manager)
Reporting Services Configuration Manager (Native Mode)