THIS TOPIC APPLIES TO: SQL Server Reporting Services (2016 and later) Power 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.
Indicates whether the My Reports feature is enabled. A value of true indicates that the feature is enabled.
The name of the role used when creating security policies on user's My Reports folders. The default value is My Reports Role.
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.
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.
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.
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.
The length of time, in seconds, that a session remains active. The default value is 600.
This is a read-only property that indicates the server mode. If this value is False, the report server runs in native mode.
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.
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.
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.
Indicates whether the report server should use session cookies when communicating with client browsers. The default value is true.
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.
Defines how snapshots are compressed. The default value is SQL. The valid values are as follows:
|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.|
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.
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.
Determines whether Windows integrated security is supported for report data source connections. The default is True. The valid values are as follows:
|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.|
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.
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).
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.
Specifies the number of data cache entries that can be active in a report edit session. The default number is 5.
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.
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.
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).
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