Server Properties (Advanced Page) - Reporting Services

THIS TOPIC APPLIES TO: yesSQL Server Reporting Services (2016 and later) yesPower BI Report Server

Use this page to set system properties on the report server. There are a number of ways to set system properties. This tool provides a graphical user interface so that you can set properties without having to write code.

To open this page, start SQL Server Management Studio, connect to a report server instance, right-click the report server name, and select Properties. Select Advanced to open this page.

Options

EnableMyReports
Indicates whether the My Reports feature is enabled. A value of true indicates that the feature is enabled.

MyReportsRole
The name of the role used when creating security policies on user's My Reports folders. The default value is My Reports Role.

EnableClientPrinting
Determines whether the RSClientPrint ActiveX control is available for download from the report server. The valid values are true and false. The default value is true. For more information about additional settings that are required for this control, see Enable and Disable Client-Side Printing for Reporting Services.

EnableExecutionLogging
Indicates whether report execution logging is enabled. The default value is true. For more information about the report server execution log, see Report Server ExecutionLog and the ExecutionLog3 View.

ExecutionLogDaysKept
The number of days to keep report execution information in the execution log. Valid values for this property include -1 through 2,147,483,647. If the value is -1 entries are not deleted from the Execution Log table. The default value is 60.

Note

Setting a value of 0 will delete all entries from the execution log. A value of -1 will keep the entries of the execution log and will not be deleted.

SessionTimeout
The length of time, in seconds, that a session remains active. The default value is 600.

SharePointIntegratedMode
This is a read-only property that indicates the server mode. If this value is False, the report server runs in native mode.

SiteName
The name of the report server site displayed in the page title of the web portal. The default value is SQL Server Reporting Services. This property can be an empty string. The maximum length is 8,000 characters.

StoredParametersLifetime
Specifies the maximum number of days that a stored parameter can be stored. Valid values are -1, +1 through 2,147,483,647. The default value is 180 days.

StoredParametersThreshold
Specifies the maximum number of parameter values that that can be stored by the report server. Valid values are -1, +1 through 2,147,483,647. The default value is 1500.

UseSessionCookies
Indicates whether the report server should use session cookies when communicating with client browsers. The default value is true.

ExternalImagesTimeout
Determines the length of time within which an external image file must be retrieved before the connection is timed out. The default is 600 seconds.

SnapshotCompression
Defines how snapshots are compressed. The default value is SQL. The valid values are as follows:

Values Description
SQL Snapshots are compressed when stored in the report server database. This is the current behavior.
None Snapshots are not compressed.
All Snapshots are compressed for all storage options, which include the report server database or the file system.

SystemReportTimeout
The default report processing timeout value, in seconds, for all reports managed in the report server namespace. This value can be overridden at the report level. If this property is set, the report server attempts to stop the processing of a report when the specified time has expired. Valid values are -1 through 2,147,483,647. If the value is -1, reports in the namespace do not time out during processing. The default value is 1800.

SystemSnapshotLimit
The maximum number of snapshots that are stored for a report. Valid values are -1 through 2,147,483,647. If the value is -1, there is no snapshot limit.

EnableIntegratedSecurity
Determines whether Windows integrated security is supported for report data source connections. The default is True. The valid values are as follows:

Values Description
True Windows integrated security is enabled.
False Windows integrated security is not enabled. Report data sources that are configured to use Windows integrated security will not run.

EnableLoadReportDefinition
Select this option to specify whether users can perform ad hoc report execution from a Report Builder report. Setting this option determines the value of the EnableLoadReportDefinition property on the report server.

If you clear this option, the property will be set to False and report server will not generate clickthrough reports for reports that use a report model as a data source. Any calls to the LoadReportDefinition method will be blocked.

Turning off this option mitigates a threat whereby a malicious user launches a denial of service attack by overloading the report server with LoadReportDefinition requests.

EnableRemoteErrors
Includes external error information (for example, error information about report data sources) with the error messages that are returned for users who request reports from remote computers. Valid values are true and false. The default value is false. For more information, see Enable Remote Errors (Reporting Services).

EnableReportDesignClientDownload
Specifies whether Report Builder installation package can be downloaded from the report server. If you clear this setting, the URL to Report Builder will not work. For more information, see Configure Report Builder Access.

EditSessionCacheLimit
Specifies the number of data cache entries that can be active in a report edit session. The default number is 5.

EditSessionTimeout
Specifies the number of seconds until a report edit session times out. The default value is 7200 seconds (2 hours).

EnableCustomVisuals (Power BI Report Server only)
Should PowerBI ReportServer enable the display of PowerBI custom visuals. Values are True, False. Default is True.

EnablePowerBIReportExportData (Power BI Report Server only)
Should PowerBI ReportServer enable the export of data from PowerBI visuals. Values are True, False. Default is True.

EnableTestConnectionDetailedErrors
Indicates whether detailed error messages are sent to the client computer when users test data source connections using the report server. The default value is true. If the option is set to false, only generic error messages are sent.

AccessControlAllowCredentials
Indicates whether the response to the client request can be exposed when the 'credentials' flag is set to true. The default value is false.

AccessControlAllowHeaders A comma seperated list of headers that the server will allow when a client makes a request. This property can be an empty string, specifying * will allow all headers.

AccessControlAllowMethods A comma seperated list of HTTP methods that the server will allow when a client makes a request. The default values are (GET, PUT, POST, PATCH, DELETE), specifying * will allow all methods.

AccessControlAllowOrigin A comma seperated list of origins that the server will allow when a client makes a request. The default value is blank which prevents all requests, specifying * will allow all origins when credentials are not set; if credentials are specified an explicit list of origins must be specified.

AccessControlExposeHeaders A comma seperated list of headers that the server will expose to clients. The default value is blank.

AccessControlMaxAge Specifies the number of seconds the results of the preflight request can be cached. The default value is 600 (10 minutes).

See Also

Set Report Server Properties (Management Studio)
Connect to a Report Server in Management Studio
Reporting Services Properties
Report Server in Management Studio F1 Help
Report Server System Properties
Script Deployment and Administrative Tasks
Enable and Disable My Reports

More questions? Try asking the Reporting Services forum