Site Settings Page (Report Manager)
Applies To: SQL Server 2016
Use the Site Settings page to change the application title, set server-wide defaults for report history limits and report processing timeout values, manage system-level role assignments, and manage shared schedules. You must have Content Manager and System Administrator permissions to view this page.
The following features are not available in every edition of SQL Server: report history, report execution, and shared schedules. For a list of features that are supported by the editions of SQL Server, see Features Supported by the Editions of SQL Server 2016.
Use the following procedure to navigate to this location in the user interface (UI).
Open Report Manager.
At the top of the page, click Site Settings. This opens the General Properties page of the site.
Note: If you do not see the Site Settings option in the menu, you do not have the required permissions, For more information see the “site settings” section of Configure a Native Mode Report Server for Local Administration (SSRS).
Specify the title to use for this instance of SQL Server Report Manager. By default, the title is "SQL Server Reporting Services".
- Select the default settings for report history
Select a default value for the number of copies of report history to retain. The default value provides an initial setting that establishes report history limits. You can vary these settings at the report level. For more information, see Snapshot Options Properties Page (Report Manager).
If you limit report history later, when the existing report history exceeds the limit you specify, the report server reduces the existing report history to the new limit. The oldest report snapshots are deleted first. If report history is empty or below the limit, new report snapshots are added. When the limit is reached, the oldest snapshot is deleted when a new report snapshot is added.
- Report Execution Timeout
Specify whether report processing times out after a certain number of seconds.
This value applies to report processing on a report server. It does not affect data processing on the database server that provides the data for your report.
The report processing timer clock begins when the report is selected and ends when the report opens. When you set this value, specify enough time to complete both data processing and report processing.
- Custom Report Builder launch URL
Specify a custom URL when the report server does not use the default Report Builder URL. This setting is optional. If you do not specify a value, the default URL will be used, which launches Report Builder as a ClickOnce application. The default URL is one of the following:
Native mode report server: In a native mode installation, the default URL will take the form of http://<computername>/reportserver/ReportBuilder/ReportBuilder_3_0_0_0.application.
SharePoint integrated mode: The default URL will take the form of http://<SharePoint_site>/_vti_bin/ReportBuilder/ReportBuilder_3_0_0_0.application.”
Click to save your changes to the report server.
Click this link to open the System Role Assignments page, on which you can assign user and group accounts to predefined system roles.
Click this link to open the Schedules page, on which you can predefine shared schedules that users can select for their reports and subscriptions.