Dela via

  • Artikel

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. This topic describes each element in the configuration file. For more information about the context in which the applications run, see Service Architecture (Reporting Services).

Settings are presented in the order in which they appear. For instructions on how to edit this file, see How to: Modify a Reporting Services Configuration File.

Configuration File Structure

The following example illustrates the basic structure of the RSReportServer.config file. The bold elements at the end represent additional sections that are collapsed in this example so that you can view the XML element structure more easily. To go directly to the settings for URLReservations, Authentication, Service, UI, Extensions or MapTileServerConfiguration, click the following links: Authentication, Service, UI, Extensions, URLReservations, and MapTileServerConfiguration.

<Configuration>
    <Dsn></Dsn>
    <ConnectionType>Default</ConnectionType>
    <LogonUser></LogonUser>
    <LogonDomain></LogonDomain>  
    <LogonCred></LogonCred>
    <InstanceId></InstanceId>  
    <InstallationID>{00000000-0000-0000-0000-000000000001}</InstallationID>

    <Add Key="SecureConnectionLevel" Value="0" />
    <Add Key="CleanupCycleMinutes" Value="10" />
    <Add Key="SQLCommandTimeoutSeconds" Value="60" />
    <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="WatsonFlags" Value="0x1400" /> full dump-->
  <!--  <Add Key="WatsonFlags" Value="0x0430" /> all_memory 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" />
    <Add Key="WatsonDumpExcludeIfContainsExceptions" Value="System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException" />
  <URLReservations></URLReservations>
  <Authentication></Authentication>
  <Service>
    <IsSchedulingService>True</IsSchedulingService>
    <IsNotificationService>True</IsNotificationService>
    <IsEventService>True</IsEventService>
    <PollingInterval>10</PollingInterval>
    <WindowsServiceUseFileShareStorage>False</WindowsServiceUseFileShareStorage>
    <MemorySafetyMargin>80</MemorySafetyMargin>
    <MemoryThreshold>90</MemoryThreshold>
    <WorkingSetMaximum>4000000</WorkingSetMaximum>
    <WorkingSetMinimum>2400000</WorkingSetMinimum>
    <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></UI>
  <Extensions></Extensions>
</Configuration>

Configuration Settings

The following table provides information about 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.

Setting

Description

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.

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.

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 Configuring a Report Server Database Connection.

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 MSRS10_5.<instancename>. Do not modify this setting.

InstallationID

An identifier for the report server installation that Setup creates. This value is set to a GUID. Do not modify this setting.

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 Configuring a Report Server for Secure Sockets Layer (SSL) Connections.

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.

SQLCommandTimeoutSeconds

This setting is not used.

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. For more information about server modes, see Planning a Deployment Mode.

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.

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.

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.

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.

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 0 to 2147483647. The default is 5.

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.

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.

WatsonFlags

Specifies how much information is logged for error conditions that are reported to Microsoft.

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.

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.

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.

Do not modify URL reservations in the configuration file directly. Always use the Reporting Services Configuration tool or the Report Server WMI provider to create or modify URL reservations. 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 Configuring Report Server URLs and URLs in Configuration Files (Reporting Services).

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.

Setting

Description

Application

Contains settings for Reporting Services applications.

Name

Specifies the Reporting Services applications. Valid values are ReportServerWebService or ReportManager.

VirtualDirectory

Specifies the virtual directory name of the application.

URLs, URL

Contains one or more URL reservations for the application.

UrlString

Specifies URL syntax that is valid for HTTP.SYS. For more information about the syntax, see URL Reservation Syntax (Reporting Services).

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.

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.

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 Configuring Authentication in Reporting Services.

Setting

Description

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 Browser Support.

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.

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 Browser Support.

RSWindowsKerberos

The server accepts Kerberos security tokens.

Use this setting or RSWindowsNegotiate when you use Kerberos authentication in a constrained delegation authentication scheme.

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 Configuring Authentication in Reporting Services.

Custom

Specify this value if you deployed a custom security extension on the report server computer. For more information, see Implementing a Security Extension.

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 passwords

3 = 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.

NoteNote
Values 0 (for interactive logon) and 1 (for batch logon) are not supported in SQL Server 2008 Reporting Services.

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.

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.

EnableAuthPersistance

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 EnableAuthPersistance to False, all users will connect using the impersonation context of the first request.

Service (RSReportServer.config file)

Service specifies the application settings that apply to the service as a whole. For more information about the internal components of the service, see Service Architecture (Reporting Services).

Setting

Description

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 Starting and Stopping the Report Server Service.

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 Starting and Stopping the Report Server Service.

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 Starting and Stopping the Report Server Service.

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.

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).

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 Configuring Available Memory for Report Server Applications.

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 Configuring Available Memory for Report Server Applications.

WorkingSetMaximum

Specifies a memory threshold after which no new memory allocations requests are granted to report server applications.

By default, the report server sets WorkingSetMaximum to the amount of available memory on the computer. This value is detected when the service starts.

This setting does not appear in the RSReportServer.config file unless you add it manually. If you want the report server to use less memory, you can modify the RSReportServer.config file and add the element and value. Valid values range from 0 to maximum integer. This value is expressed in kilobytes. For more information, see Configuring Available Memory for Report Server Applications.

WorkingSetMinimum

Specifies a lower limit for resource consumption; the report server will not release memory if overall memory use is below this limit. By default, the value is calculated at service startup. The calculation is that the initial memory allocation request is for 60 percent of

WorkingSetMaximum.This setting does not appear in the RSReportServer.config file unless you add it manually. If you want to customize this value, you must add the WorkingSetMinimum element to the RSReportServer.config file. Valid values range from 0 to maximum integer. This value is expressed in kilobytes.

For more information, see Configuring Available Memory for Report Server Applications.

RecycleTime

Specifies a recycle time for the application domain, measured in minutes. Valid values range from 0 to maximum integer. The default is 720.

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.

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 Configuring Available Memory for Report Server Applications.

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.

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 Configuring the Unattended Execution Account.

PolicyLevel

Specifies the security policy configuration file. The valid value is Rssrvrpolicy.config. For more information, see Using Reporting Services Security Policy Files.

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.

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.

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 c:\program files\Microsoft SQL Server\ MSRS10_5.<instance_name>\Reporting Services\RSTempFiles.

IsRdceEnabled

Specifies whether Report Definition Customization Extension (RDCE) is enabled. Valid values are True and False.

UI (RSReportServer.config file)

UI specifies configuration settings that apply to the Report Manager application.

Setting

Description

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 How to: Configure Report Manager.

ReportBuilderTrustLevel

Do not modify this value; it is not configurable. In SQL Server 2008 and SQL Server 2008 R2 Reporting Services, Report Builder runs only in FullTrust. For more information, see How to: Configure Report Builder Access . For more information about discontinuing partial trust mode, see Discontinued Functionality in SQL Server Reporting Services.

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.

Extensions (RSReportServer.config file)

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

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, and the null delivery provider used to preload the report cache. For more information about delivery extensions, see Subscription 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 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. 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.

Report Server E-mail 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 Configuring a Report Server for E-Mail Delivery 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. By default, HTMLOWC, RGDI, and Null delivery extensions are excluded for e-mail delivery and file share delivery. 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.

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 Document Library

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

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).

DeliveryUI

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.

Render

Specifies default (and possibly custom) rendering extensions used in report presentation. Default rendering extensions include XML, NULL, CSV, PDF, RGDI, HTML4.0, MHTML, EXCEL, RPL, and IMAGE. For information about the attributes for the child <Extension> element under <Render>, see Deploying a Rendering Extension. Do not modify this section unless you are deploying a custom rendering extension. For more information, see Implementing a Rendering Extension.

Data

Specifies default (and possibly custom) data processing extensions used to process queries. Default data processing extensions include SQL, OLEDB, OLEDB-MD, ORACLE, ODBC, XML, SAPBW, ESSBASE, SSIS, and SAP. Do not modify this section unless you are adding custom data processing extensions. For more information, see Implementing a Data Processing Extension.

Semantic Query

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.

ModelGeneration

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

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

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 Configuring Authentication in Reporting Services. For more information about adding custom security features, see Implementing a Security Extension.

EventProcessing

Specifies default event handlers. Do not modify this section. This section is not extensible.

ReportDefinitionCustomization

Specifies the name and type of a custom extension that modifies a report definition. For more information about Report Definition Customization Extension (RDCE), see What's New in Report Server Programmability.

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 Enabling and Disabling 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.

Change History

Updated content

Added description of WorkingSetMaximum and WorkingSetMinimum. Also added the ‘Service’ section to the example of the configuration file. The Service section is where the ‘WorkingSet’ options should be.

Updated minimum value for MaxActiveReqForOneUser from 0 to 1.