Export (0) Print
Expand All

RSReportServer Configuration File

SQL Server 2000

RSReportServer Configuration File

RSReportServer.config stores settings that are used for report server connections, multi-instance or Web farm configurations, session and cache management, services, subscription and delivery, and report execution (rendering, data processing, and event processing).

File Location

This file is located in the \Reporting Services\ReportServer folder.

Editing Guidelines

You can use the rsconfig utility to modify encrypted connection and user account values. You can use a text editor to modify the security level, the number of open connections per user, and e-mail delivery settings.

Configuration Settings

The following table provides information about specific settings. Settings are presented in the order in which they appear in the configuration file.

Setting Description Values
Dsn, ConnectionType, LogonUser, LogonDomain, LogonCred Specifies encrypted values used by a report server to connect to a report server database. For more information, see Configuring a Report Server Connection <encrypted>
InstanceID An identifier for the SQL Server instance hosting the report server database. <SQL Server instance name>
InstallationID An identifier for the report server installation. <GUID>
SecureConnectionLevel Specifies the degree of security of the Web service connection. For more information, see Using Secure Web Service Methods. 0 through 3, where 0 is least secure.
InstanceName Specifies the name of a component instance. Do not modify this setting. Microsoft.Reports
ProcessRecycleOptions Specifies whether the ASP.NET worker process is recycled when severe errors occur. Specify 0 to allow recycling. 0 (default)

1

CleanupCycleMinutes Specifies the number of minutes after which old sessions and expired snapshots are removed from the report server databases. 0 to max integer.

The default is 10.

SQLCommandTimeoutSeconds This configuration setting is not documented in this release. 0 to max integer.

The default is 60.

MaxActiveReqForOneUser Specifies the maximum number of simultaneous connections that a single user can open to the report server. Once the limit is reached, further connection requests from the user are denied. For more information, see Limiting the Number of Open Connections. 0 to max integer.

0 indicates no limit on the number of connections.

The default is 20.

DatabaseQueryTimeout Specifies the number of seconds after which a connection to the report server database times out. 0 to max integer.

The default is 120.

RunningRequestsScavengerCycle Specifies how often orphaned and expired requests are canceled. This value is specified in seconds. 0 to max 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 to present running job information in the Manage Jobs page of Report Manager. This value is specified in seconds. 0 to max integer.

The default is 60.

RunningRequestsAge Specifies an interval in seconds after which the status of a running job changes from new to running. A running job is stored in the report server temporary database. 0 to max integer.

The default is 30.

MaxScheduleWait Specifies the number of seconds the Report Server service waits for a schedule to be updated by SQL Server Agent service when Next Run Time is requested. 0 to max integer.

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 link to the site to view updated error message content. True (default)

False

IsSchedulingService Specifies whether a thread is dedicated to ensuring that schedules in the report server database match those in the SQL Server Agent database. True (default)

False

IsNotificationService Specifies whether the report server dedicates a thread to polling the notification table in the report server database to determine if there are pending notifications. True (default)

False

IsEventService Specifies whether service processes events in the event queue. True (default)

False

PollingInterval Specifies the interval, in seconds, between polls of the event table by the report server. 0 to max integer.

The default is 10.

MemoryLimit Specifies that the Worker App domain should be recycled when the worker process consumes a certain percentage of the available memory. When this value is reached, the part of the service that polls events and renders reports is recycled. 0 to max integer.

The default is 60.

RecycleTime Specifies a recycle time for the Worker App domain, measured in minutes. 0 to max integer.

The default is 720.

MaxAppDomainUnloadTime Specifies a wait time during which the Worker App domain is allowed to unload. If the unload does not occur during this time period, the process is stopped. This value is specified in minutes. 0 to max integer.

The default is 30.

MaxQueueThreads Specifies the maximum number of threads dedicated to polling the event table in the report server database. 0 to max integer.

The default is 0.

UrlRoot Used by delivery extensions to complete the URL for items stored on the report server. It is also used by the rsactivate utility when activating a report server. This value is specified during Setup. A valid URL
UnattendedExecutionAccount Specifies a user name, password, and domain used by the report server to run a report in unattended mode. These values are encrypted. Use the rsconfig utility to set these values. For more information, see Configuring an Account for Unattended Report Processing. <encrypted>
PolicyLevel Specifies the security policy configuration file. For more information, see Using Reporting Services Security Policy Files Rssrvrpolicy.config
Delivery Specifies default and (possibly custom) delivery extensions used to distribute reports through subscriptions. For more information, see Delivery Extensions.  
Render Specifies default and (possibly custom) rendering extensions used in report presentation. For more information, see Rendering Extensions.  
Data Specifies default and (possibly custom) data processing extensions used to process queries. For more information, see Data Processing Extensions.  
Security Specifies default and custom security extensions used to support authentication. For more information, see Implementing a Security Extension.  
EventProcessing Specifies default event handlers. You cannot create custom event handlers in this release.  

See Also

Reporting Services Configuration Files

rsconfig Utility

Activating a Report Server

Show:
© 2014 Microsoft