Reporting Services in SQL Server Management Studio (SSRS)

Report server administrators can use SQL Server Management Studio to:

Enable features, set server defaults, and manage running jobs.
View custom reports. In Object Explorer, most nodes display a custom reports option. You must have administrator permissions. The schema of a custom report must match the schema of the installed reports. For more information, see Custom reports in Management Studio and Find the report definition schema version (SSRS).

The next section contains links to articles that contain step-by-step instructions for performing various reporting tasks using Management Studio. You can also create and manage shared schedules in the web portal.

In this section

Report Server in Management Studio help

This section includes articles about the dialog boxes in SQL Server Management Studio that you can use to manage report servers.

Cancel report server jobs

Use the Cancel Report Server Jobs dialog box to view or cancel in-progress reports. This dialog box shows all jobs that are currently running on the report server. Although you can't pause or restart jobs that are currently processing, you can cancel all jobs or individual jobs if they're taking too long to complete.

You can cancel user jobs and system jobs.

A user job is any job that an individual user initiates. This job includes running a report on-demand, manually creating a report history snapshot, or manually creating report execution snapshot. An in-progress standard subscription is also a user job.
A system job is one that the report server initiates. System jobs include scheduled report processing.

To open this page, start SQL Server Management Studio, connect to a report server, right-click Jobs, and then select Cancel All Jobs. You can also open Jobs, right-click a job that is running on the report server, and select Cancel Job(s).

Before canceling a job, you can view its properties to determine when the job started. For more information, see Job properties (Management Studio).

Note

This feature is not supported in SQL Server Express with Advanced Services. The page does not appear when you are running SQL Server Express.

Options

Name - Shows the name of the report. You can identify subscriptions by their descriptions.

Type - Valid values are User and System.

Start Time - Shows when the job started.

User Name - For jobs that are initiated by a user, this column shows the name of the user.

Status - Shows the status of the job. Valid values are New and Running. Status is always New when the job begins. After 60 seconds, status changes to Running. You must refresh the page to pick up the change.

OK - Cancel a single job or multiple jobs. The jobs are canceled immediately and can't be resumed. If you mistakenly cancel a job, you must request the report or subscription again to start a new job.

Delete catalog items

Use this page to delete shared schedules and role definitions.

If you delete a shared schedule that is used by multiple reports and subscriptions, the report server creates individual schedules for each report and subscription that previously used the shared schedule. Each new individual schedule contains the date, time, and recurrence pattern that was specified in the shared schedule. Reporting Services doesn't provide central management of individual schedules. If you delete a shared schedule, you now need to maintain the schedule information for each individual item. Before deleting a shared schedule, use the Reports page to determine the reports that currently use the shared schedule.

For role definitions, you can only delete those definitions that aren't actively used in a role assignment. If you try to delete a role that is currently in use, the report server doesn't delete the role and you see an error message to that effect. If this page contains a single role definition that isn't currently in use, you delete it when you select OK. If this page contains multiple roles, you can't select which roles to keep or remove. All unused role definitions are deleted when you select OK.

You can't undo a delete operation. To recover an item that you deleted, you must either recreate it or restore a backup copy of the report server database.

Options

Name - Specifies the name of the item you're deleting.

Type - Shows the type of item you're deleting.

Owner - Shows the name of the owner. In most cases, this name is System.

Status - Shows progress information for a delete operation.

Error - Displays an error code if an error occurs while deleting an item.

Job properties

Use the Job Properties page to view information about an in-progress report or subscription before you cancel it.

To open this page, start SQL Server Management Studio, connect to a report server, and open the Jobs folder. Right-click a job that is running, and then select Properties.

Note

This feature is not supported in SQL Server Express with Advanced Services. The page does not appear when you are running SQL Server Express.

Tasks

Before you can view information about a job, refresh the page to retrieve information about jobs that are currently running on the report server:

Open the report server folder.
Right-click Jobs, and then select Refresh.
If a job is listed, right-click the job, and then select Properties.

Options

Job ID - A GUID that is assigned to a job while it's processing. The value is randomly generated each time a report or subscription runs.

Job Status - Valid values are New and Running. Status is always New when the job begins. After 60 seconds, status changes to Running. You must refresh the page to pick up the change.

Job Type - Valid values are User and System. A user job is any job that an individual user initiates. This job includes running a report on-demand, manually generating a report history snapshot, or manually creating a report execution snapshot. An in-progress standard subscription is also a user job. A system job is a job that the report server initiates. System jobs include report processing that a schedule triggers.

Job Action - For reports, this column shows the report execution processes that are underway. This value is always Render.

Job Description - Reporting Services doesn't provide job descriptions by default.

Server Name - Shows the name of the report server that is processing the job. If you configured a scale-out deployment, this value shows which server is processing the job.

Report Name - Shows the name of the report. You can identify subscriptions by their descriptions.

Report Path - Shows the path of the report in the report server folder hierarchy.

Start Time - Shows when the process started.

User Name - For processes initiated by a user, this column shows the name of the user. For system jobs, the user name is the name of the report server.

New shared schedule

Use this page to create a shared schedule to run published reports and subscriptions. Shared schedules can be used in place of report-specific or subscription-specific schedules. Centralized schedule information and the ability to pause and resume scheduled operations are two key features that distinguish shared schedules from item-specific schedules.

Not all frequency combinations can be supported in a single schedule. For example, if you want to run a report at 12:00 P.M. and 4:00 P.M. every Friday, you must create two daily schedules. These schedules should specify a Friday run date, with one having a start time of 12:00 P.M. and the other with a start time of 4:00 P.M.

Schedule processing is based on the local time of the report server that hosts and processes the schedule.

To open this page, start SQL Server Management Studio, connect to a report server, right-click Shared Schedule, and select New Schedule. To save the schedule, SQL Server Agent service must be running.

Note

This feature is not available in every edition of SQL Server. For a list of features that are supported by the editions of SQL Server, see Features supported by the editions of SQL Server 2012 (https://go.microsoft.com/fwlink/?linkid=232473).

Options

Name - Enter a name for the shared schedule. This name appears in drop-down lists when users select a shared schedule for reports and subscriptions. Be sure to provide a descriptive name that fits easily within a list and that easily distinguishes one shared schedule from another. A name must contain at least one alphanumeric character. It can also include spaces and some symbols. Don't use the following characters when specifying a name:

; ? : \@ & = + , $ / * < > " /

Begin running this schedule on - Specify a start date for this schedule.

Stop this schedule on - Specify an expiration date for this schedule.

Type - Specifies whether the recurrence pattern is based primarily on hours, days, weeks, or months.

Hour (Recurrence Pattern) - Select options to run a scheduled operation in intervals of an hour (for example, to run a report every 6 hours). You can specify the interval in hours and minutes.

Day (Recurrence Pattern) - Select options to run a scheduled operation in intervals of days (for example, to run a report every 2 days). You can specify the interval in days and at the hour and minute you want the schedule to run.

Week (Recurrence Pattern) - Select options to run a scheduled operation in intervals of a week or when the pattern that you want to repeat is based on weeks (for example, to run a report every other week). You can specify a weekly schedule to the day, hour, and minute that you want the schedule to run.

Month (Recurrence Pattern) - Select options to run a scheduled operation in intervals of a month or when the pattern that you want to repeat is based on months. You can specify a monthly schedule to the day, hour, and minute that you want the schedule to run. You can omit specific months from the schedule.

Once - Select this option to create a schedule that runs only once, on a specific date and time.

New system role

Use this page to create a system-level role definition. A system role definition specifies a set of system-level tasks that apply to a report server as whole.

Note

Role definitions are used only on a report server that runs in native mode. If the report server is configured for SharePoint integration, this page is not available.

Options

Name - Enter the name of the role definition. A role definition name must be unique within the report server namespace. A name must contain at least one alphanumeric character. It can also include spaces and some symbols. Don't use the following characters when specifying a name:

; ? : \@ & = + , $ / * < > " /

Description - Provide a description that explains how to use the role and enumerates what the role supports.

Task - Select the system-level tasks that can be performed through this role. You can't create new tasks or modify the existing tasks that Reporting Services supports. You can't choose item-level tasks for a system role definition.

Task Description - Shows a description of the task that enumerates the operations or permissions that the task supports.

New user role

Use this page to create an item-level role definition. An item-level role definition is a named collection of tasks that enumerate the tasks a user can perform in relation to folders, reports, models, resources, and shared data sources. An example of an item-level role definition is the predefined Browser role that identifies the kinds of actions a report end user might require. These actions are for navigating folders and viewing reports.

Role definitions are intended to be few in number. Most organizations only require a few role definitions. However, if the predefined role definitions are insufficient, you can vary them or create new ones.

Note

Role definitions are used only on a report server that runs in native mode. If the report server is configured for SharePoint integration, this page is not available.

Options

; ? : \@ & = + , $ / * < > " /

Description - Enter a description that explains how to use the role and enumerates what the role supports.

Task - Select the tasks that can be performed through this role. You can't create new tasks or modify the existing tasks that Reporting Services supports. Only item-level tasks can be used in an item-level role definition.

Task Description - Shows a description of the task that enumerates the operations or permissions that the task supports.

Schedule properties (General page)

Use the Reporting Services page in SQL Server Management Studio to view or modify a shared schedule. Shared schedules can be used in place of report-specific or subscription-specific schedules. Changes to the schedule are applied after you save the schedule. Editing a schedule has no effect on jobs that are currently in progress. If you edit a schedule while it's being used, all currently processing reports and subscriptions triggered from that schedule are allowed to finish.

Schedule processing is based on the local time of the report server that hosts and processes the schedule.

To open this page:

Start SQL Server Management Studio.
Connect to a report server.
Expand the Shared Schedules folder.
Right-click a shared schedule, and select Properties.

Note

This feature is not available in every edition of SQL Server and this page does not appear when you are running an edition which does not have this feature. For a list of features that are supported by the editions of SQL Server, see Editions and supported features of SQL Server 2022.

Options

Name - Specifies the name for the shared schedule.

Begin running this schedule on - Specifies a start date for this schedule.

Stop this schedule on - Specifies an expiration date for this schedule.

Type - Specifies whether the recurrence pattern is based primarily on hours, days, weeks, months, or only runs once.

Hour (Recurrence Pattern) - Specifies options for running a scheduled operation in intervals of an hour (for example, to run a report every 6 hours). You can specify the interval in hours and minutes.

Day (Recurrence Pattern) - Specifies options for running a scheduled operation in intervals of days (for example, to run a report every 2 days). You can specify the interval in days and at the hour and minute you want the schedule to run.

Week (Recurrence Pattern) - Specifies options for running a scheduled operation in intervals of a week or when the pattern that you want to repeat is based on weeks (for example, to run a report every other week). You can specify a weekly schedule to the day, hour, and minute that you want the schedule to run.

Month (Recurrence Pattern) - Specifies options for running a scheduled operation in intervals of a month or when the pattern that you want to repeat is based on months. You can specify a monthly schedule to the day, hour, and minute that you want the schedule to run. You can omit specific months from the schedule.

Once - Specifies a schedule that runs only once, on a specific date and time.

Schedule properties (Reports page)

Use the Reporting Services schedule properties page in SQL Server Management Studio to view a list of all reports that use the specific shared schedule. Schedules can be used to refresh report snapshots, generate report history, trigger a subscription, or expire a cached copy of the report. To find out how the schedule is used, view the property and subscription information of the report.

Although this page shows each report that uses the shared schedule, it doesn't indicate how many times the shared schedule is used within that single report. For example, suppose 20 different subscribers to the Company Sales report use the same shared schedule to trigger subscription processing. In this case, the Company Sales report appears once in this list, even though the report has 20 references to the shared schedule.

To open the schedule properties page:

Start SQL Server Management Studio.
Connect to a report server.
Open the Shared Schedules folder.
Right-click a shared schedule, select Properties.
Select Reports.

You can also manage shared schedules from the Site Settings of the Reporting Services Web Portal.

Note

This feature is not available in every edition of SQL Server. For a list of features that are supported by the editions of SQL Server, see Editions and supported features of SQL Server 2022.

Options

Folder - Specifies the path of the report.

Report - Specifies the name of the report that uses the schedule.

Server properties (General page)

Use this page to:

View or modify the title used in Report Manager
Enable or disable My Reports
Select a role definition for My Reports security
Enable or disable the client print control

To open this page:

Start SQL Server Management Studio
Connect to a report server instance.
Right-click the report server name, and then select Properties.

The server mode determines which server properties you can set. If you manage a report server that is configured for SharePoint integrated mode, you can't enable My Reports or set the title for the web portal.

Options

Name - Enter a name that appears on top of the web portal. By default, this value is SQL Server Reporting Services. The name that you specify appears only in Report Manager.

Version - This property is read-only. Specifies the version of SQL Server Reporting Services that you're using.

Edition - This property is read-only. Specifies the current report server instance. Report Manager isn't available in every edition of Microsoft SQL Server. For a list of features that the editions of SQL Server support, see Editions and supported features of SQL Server 2022.

Authentication Mode - This property is read-only. It identifies the types of authentication requests accepted by the report server instance. To change the authentication mode, you must edit the RSReportServer.config file. For more information, see Authentication with the report server.

URL - This property is read-only. Specifies the URL to the Report Server Web service. This value is specified in the Reporting Services Configuration tool. For more information, see Configure a URL (Report Server Configuration Manager).

Enable a My Reports folder for each user - Make My Reports available to users. This option is only available for native mode report servers.

Select the role to apply to each My Reports folder - Specify a role definition to use for My Reports security. The role definition identifies the set of tasks that are supported in each My Reports folder.

Server properties (Execution page)

Use this page to set a timeout value for report execution. This value applies to all reports that the current report server instance processes. You can override this value for individual reports. The value you specify must accommodate all report processing that occurs on the report server. It must also accommodate query processing performed on the database server when the report server retrieves data that is used in the report.

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 Execution to open this page.

Options

Do not timeout report execution - Allow a report server unlimited time to complete report processing.

Limit report execution to the following number of seconds - Set a time constraint on report execution. The time period starts when the report is requested. If the time period ends before the report is fully processed, the report server cancels the process and any in-process queries to external data sources.

Server properties (History page)

Use this Reporting Services page in SQL Server Management Studio to set 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 for all reports. You can vary these settings for individual reports.

Report history is a collection of report snapshots that include report data and layout that is current for the report at the time the snapshot is created. You can use report history to keep a copy of a report as it was on a specific date or time. You can create and manage report history for individual reports that run on a native mode report server. Or, you can create and manage report history for a report server that is configured for SharePoint integrated mode.

Report history snapshots are stored in the report server database. If you keep an unlimited number of snapshots, be sure to periodically check the database size to ensure it isn't growing too fast or consuming too much disk space.

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 History to open this page.

Options

Keep an unlimited number of snapshots in report history - Retain all report history snapshots. You must manually delete snapshots to reduce the size of report history.

Limit the copies of report history - Retain a set number of report history snapshots. When the limit is reached, older copies are removed from report history to make room for newer copies.

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.

Server properties (Logging page)

Use this Reporting Services page in SQL Server Management Studio to set limits on the report execution data that the report server collects by a report server. Execution data is stored internally in the report server database. You can track report activity for report server that runs in native mode or SharePoint integrated mode. If the report server is part of a scale-out deployment, the report execution log maintains a record of all report activity for the entire deployment in a single log file.

To open this page:

Start SQL Server Management Studio
Connect to a report server.
Right-click the report server name and select Properties.
Select Logging to open this page.

Options

Enable report execution logging - Select to create and store information about report activity on the server. If this option is enabled, the report server tracks which reports are used. It also tracks the frequency of report processing, the type of report operation that was performed, the output format, and who ran the report. For more information about other data points that are captured in the log, see Report Server ExecutionLog and the ExecutionLog3 View.

Remove log entries older than this number of days - Specify the number of days after which log entries are trimmed from the report execution log. The default value is 60 days.

Server properties (Security page)

Use this Reporting Services page in SQL Server Management Studio to turn off features that can potentially compromise a report server. Turning off these features limits some functionality, but can improve the overall security of the report server by mitigating specific threats.

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 Security to open this page.

Options

Enable Windows-Integrated Security for report data sources - Specify whether a connection to a report data source uses the Windows security token of the user who requested the report.

If you turn off the feature, the Windows-Integrated Security feature in the report data source property pages becomes unavailable. If your report data sources are configured for Windows-integrated security and you turn off this feature, the report server immediately updates all your data source connection properties to prompt for credentials.

Enable unplanned reporting - Specify whether users can perform unplanned queries from a Report Builder report. In this context, new reports are automatically generated when a user chooses data of interest.

Setting this option determines whether the EnableLoadReportDefinition property on the report server is set to True or False. If you clear this option, the property is set to False and report server doesn't generate clickthrough reports that are created during data exploration. All calls to the LoadReportDefinition method are 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.

Server properties (Advanced page)

Use this page to set system properties on the report server. There are many 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

AccessControlAllowCredentials

Power BI Report Server, Reporting Services 2017 and later only

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

Power BI Report Server, Reporting Services 2017 and later only

A comma-separated list of headers that the server allows when a client makes a request. This property can be an empty string, specifying * allows all headers.

AccessControlAllowMethods

Power BI Report Server, Reporting Services 2017 and later only

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

AccessControlAllowOrigin

Power BI Report Server, Reporting Services 2017 and later only

A comma-separated list of origins that the server allows when a client makes a request. The default value is blank, which prevents all requests. Specifying * allows all origins when credentials aren't set. If credentials are specified, an explicit list of origins must be specified.

AccessControlExposeHeaders

Power BI Report Server, Reporting Services 2017 and later only

A comma-separated list of headers that the server exposes to clients. The default value is blank.

AccessControlMaxAge

Power BI Report Server, Reporting Services 2017 and later only

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

AllowedResourceExtensionsForUpload

Power BI Report Server, Reporting Services 2017 and later only

Set extensions of resources that can be uploaded to the report server. Extensions for built-in file types like *.rdl and *.pbix aren't required to be included. Default is &ast;, &ast;.xml, &ast;.xsd, &ast;.xsl, &ast;.png, &ast;.gif, &ast;.jpg, &ast;.tif, &ast;.jpeg, &ast;.tiff, &ast;.bmp, &ast;.pdf, &ast;.svg, &ast;.rtf, &ast;.txt, &ast;.doc, &ast;.docx, &ast;.pps, &ast;.ppt, &ast;.pptx.

CustomHeaders

Power BI Report Server, Reporting Services 2019 and later only

Sets header values for all URLs matching the specified regex pattern. Users can update the CustomHeaders value with valid XML to set header values for selected request URLs. Admins can add any number of headers in the XML. By default in Reporting Services 2019, there are no custom headers and the value is blank. By default in Power BI Report Server January 2020 and later, the value is:

<CustomHeaders>
    <Header>
        <Name>X-Frame-Options</Name>
        <Pattern>(?(?=.*api.*|.*rs:embed=true.*|.*rc:toolbar=false.*)(^((?!(.+)((\/api)|(\/(.+)(rs:embed=true|rc:toolbar=false)))).*$))|(^(?!(http|https):\/\/([^\/]+)\/powerbi.*$)))</Pattern>
        <Value>SAMEORIGIN</Value>
    </Header>
</CustomHeaders>

Note

Too many headers may impact performance.

The X-Frame-Options default response header will block the ability to embed SSRS reports within an iframe html element. Removing this header from the <CustomHeaders /> advanced server property will allow reports to be used within iframes. It is not recommended to make this change on any report servers that will be hosted on the public internet.

We recommend validating the configuration of your topology to ensure the set of headers is compatible with your deployment of Reporting Services. It's possible to choose settings that cause errors in browsers if the browsers don't also have the appropriate settings. For example, you shouldn't add an HSTS configuration if your server isn't configured for https. Incompatible headers might result in browser rendering errors.

CustomHeaders XML format

<CustomHeaders>
    <Header>
        <Name>{Name of the header}</Name>
        <Pattern>{Regex pattern to match URLs}</Pattern>
        <Value>{Value of the header}</Value>
    </Header>
</CustomHeaders>

Set the CustomHeaders property

You can set it by using SetSystemProperties SOAP endpoint passing CustomHeaders property as parameter.
You can use REST endpoint UpdateSystemProperties: /System/Properties passing CustomHeaders property.

Example

The following example shows how to set the HSTS and other custom headers for URLs with matching regex pattern.

<CustomHeaders>
    <Header>
        <Name>Strict-Transport-Security</Name>
        <Pattern>(.+)\/Reports\/mobilereport(.+)</Pattern>
        <Value>max-age=86400; includeSubDomains=true</Value>
    </Header>
    <Header>
        <Name>Embed</Name>
        <Pattern>(.+)(/reports/)(.+)(rs:embed=true)</Pattern>
        <Value>True</Value>
    </Header>
</CustomHeaders>

The first header in the previous XML adds Strict-Transport-Security: max-age=86400; includeSubDomains=true header to the matched requests.

http://adventureworks/Reports/mobilereport/New%20Mobile%20Report - Regex matched and sets HSTS header
http://adventureworks/ReportServer/mobilereport/New%20Mobile%20Report - Match failed

The second header in the previous XML example adds Embed: True header for the URL that contains /reports/ and rs:embed=true query parameter.

https://adventureworks/reports/mobilereport/New%20Mobile%20Report?rs:embed=true - Match
https://adventureworks/reports/mobilereport/New%20Mobile%20Report?rs:embed=false - Fail to match

CustomUrlLabel and CustomUrlValue

Power BI Report Server, Reporting Services 2022 and later only

Branding option to add a custom hyperlink. Default values are empty.

Values	Description
CustomUrlLabel	Defines the text shown as the URL label in the top right navigation bar in the web portal (for example, `Go to Contoso`)
CustomUrlValue	Defines the URL (for example, `http://www.contoso.com`)

DisableMSRBConnect

Specifies if connected mode rendering from Microsoft Report Builder are disabled on the Report Server. When enabled, all connected mode requests from MSRB clients will be rejected. The default value is True.

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 (two hours).

EnableCDNVisuals

Power BI Report Server only

When enabled, Power BI reports load the latest certified custom visuals from a content delivery network (CDN) hosted by Microsoft. If your server doesn't have access to internet resources, you can turn off this option. In that case, custom visuals are loaded from the report that was published to the server. Default is True.

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 other settings that are required for this control, see Enable and disable client-side printing for Reporting Services.

EnableCommentOnReports

Power BI Report Server, Reporting Services 2019 and later only

Determines whether users viewing reports can access and interact with the comments pane. If the value is false then this pane is hidden to all users regardless of the permissions set on roles. The valid values are true and false. The default value is false.

EnableCustomVisuals

Power BI Report Server only

To enable the display of Power BI custom visuals. Values are True/False. Default is True.

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.

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 isn't enabled. Report data sources that are configured to use Windows-integrated security don't run.

EnableLoadReportDefinition

Select this option to specify whether users can perform an unplanned 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 is set to False. Report server doesn't generate clickthrough reports for reports that use a report model as a data source. Any calls to the LoadReportDefinition method are 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.

EnableMyReports

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

EnablePowerBIReportExportData

Power BI Report Server only

Enable Power BI Report Server data export from Power BI visuals. Values are True, False. Default is True.

EnablePowerBIReportExportUnderlyingData

Power BI Report Server only

Indicates whether or not a customer can export underlying data from Power BI visuals on Power BI Report Server. A value of True indicates that the feature is enabled.

EnablePowerBIReportMigrate

Power BI Report Server, Reporting Services 2022 and later only

Enables .rdl report migrations to Power BI by using the feature to publish in the web portal. The default is true. The valid values are as follows:

Values	Description
True	Migrate RDL reports is on
False	Migrate RDL reports is off

For more information, see Publish .rdl files to Power BI from Power BI Report Server and Reporting Services.

EnableRefererValidation

Power BI Report Server only

Enables referrer validation on the Report Server. This can be useful if reports are failing when a proxy is used. The default value is false.

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

EnableTestConnectionDetailedErrors

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

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 aren't deleted from the Execution Log table. The default value is 60.

Note

Setting a value of 0 deletes all entries from the execution log. A value of -1 keeps the entries of the execution log and doesn't delete them.

ExecutionLogLevel

Set the Execution Log Level. Default is Normal.

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.

InterProcessTimeoutMinutes

Power BI Report Server, Reporting Services 2019 and later only

Set the process timeout in minutes. Default is 30.

LogClientIPAddress

Power BI Report Server, Reporting Services 2022 and later only

Exclude/included Client IP Address when INFO Logging in Enabled. Default is false.

Values	Description
True	Client IP is logged
False	Client IP isn't logged

MaxFileSizeMb

Set the max file size of the report in MB. Default is 1000. Max is 2000.

ModelCleanupCycleMinutes

Power BI Report Server only

Set the frequency to check for unused models in memory in minutes. Default is 15.

ModelExpirationMinutes

Power BI Report Server only

Set the frequency when unused models are evicted from memory in minutes. Default is 60.

MyReportsRole

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

OfficeAccessTokenExpirationSeconds

Power BI Report Server, Reporting Services 2019 and later only

Set for how long you want the office access token to expire in seconds. Default is 60.

OfficeOnlineDiscoveryURL

Power BI Report Server only

Set the address of your Office Online Server instance for viewing Excel Workbooks.

PowerBIMigrateCountLimit

Power BI Report Server, Reporting Services 2022 and later only

The maximum number of reports that can be migrated to Power BI at a time. Default is 100.

PowerBIMigrateUrl

Power BI Report Server, Reporting Services 2022 and later only

URL used to define the Power BI cloud endpoint to use. Default is https://app.powerbi.com

RDLXReportTimetout

RDLX report (Power View reports in a SharePoint Server) 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 expires. Valid values are -1 through 2,147,483,647. If the value is -1, reports in the namespace don't time out during processing. The default value is 1800.

Note

Power View support is no longer available after SQL Server 2017.

RequireIntune

Power BI Report Server, Reporting Services 2017 and later only

Requires Intune to access your organization's reports via the Power BI mobile app. Default is False.

RestrictedResourceMimeTypeForUpload

Power BI Report Server, Reporting Services 2017 and later only

Set of mime types users aren't allowed to upload content with. Any resources that are already stored with a restricted mime type can only be downloaded as an application/octet-stream. By default this list will contain 'text/html' unless you had previously allowed the upload of *.html files. We recommended that organizations populate this list to provide the most secure experience.

Note

You cannot add 'text\html' to this list if *.html is in the AllowedResourceExtensionsForUpload property.

ScheduleRefreshTimeoutMinutes

Power BI Report Server only

Data refresh timeout in minutes for scheduled refresh on Power BI reports with embedded AS models. Default is 120 minutes.

SessionTimeout

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

SharePointIntegratedMode

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

ShowDownloadMenu

Power BI Report Server, Reporting Services 2017 and later only

Enables the client tools download menu. Default is true.

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.

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 compression is the current behavior.
None	Snapshots aren't compressed.
All	Snapshots are compressed for all storage options, which include the report server database or the file system.

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 the report server can store. Valid values are -1, +1 through 2,147,483,647. The default value is 1500.

SupportedHyperlinkSchemes

Power BI Report Server, Reporting Services 2019 and later only

Sets a comma separated list of the URI schemes allowed to be defined on Hyperlink actions that can be rendered or "*" to enable all hyperlink schemes. For example, setting "http, https" would allow hyperlinks to https://www.contoso.com, but would remove hyperlinks to mailto:bill@contoso.com or javascript:window.open('www.contoso.com', '_blank'). Default is http,https,mailto.

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 expires. Valid values are -1 through 2,147,483,647. If the value is -1, reports in the namespace don't 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's no snapshot limit.

TileViewByDefault

Power BI Report Server, Reporting Services 2022 and later only

List view by default option in catalog. It defines if Tiles or List view is selected for all users by default. The default is True for Tile view.

TimerInitialDelaySeconds

Power BI Report Server, Reporting Services 2017 and later only

Set for how long you want the initial time to be delayed in seconds. Default is 60.

TrustedFileFormat

Power BI Report Server, Reporting Services 2017 and later only

Set all the external file formats that open within the browser under the Reporting Services portal site. External file formats not listed prompts to download the option in the browser. The default values are jpg, jpeg, jpe, wav, bmp, img, gif, json, mp4, web, png.

UseSessionCookies

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

System role properties

Use the System Roles page to view the system role definitions that are currently defined for the report server. A system role definition contains a named collection of tasks that are performed relative to the entire site, instead of an individual item. Role definitions are assigned to a user or groups to create a resulting role assignment. The tasks in the role definition specify what the user or group can do.

Reporting Services has two predefined system role definitions: System Administrator and System User. You can modify these role definitions by changing the task list, or you can create a new system role that supports a different combination of tasks. Editing a role definition affects all role assignments that include the role definition.

Note

System role assignments are used only on a report server that runs in native mode. If the report server is configured for SharePoint integration, this page is not available.

Options

Name - Specifies the name of the system role definition.

Description - Shows a description of the system role definition. In SQL Server Management Studio, this description is only visible in this page. Users who view this item through Report Manager might see this description when browsing the folder hierarchy.

Task - Lists all system-level tasks that can be selected for this role definition. You can add or remove items from the predefined task list to define how users access a given item through this role. You can't create new tasks, and you can't modify existing tasks.

Description - Provides information about each task. You can't modify task descriptions.

User role properties

Use this page to view which tasks are included in an item-level role definition. You can also use this page to change the task list or modify a role description.

An item-level role definition is a named collection of tasks that users perform relative to a specific item (that is, a folder, report, resource, or shared data source). Role definitions are assigned to a user or group to create a role assignment in Report Manager. The tasks in the role definition describe what the user or group can do.

Reporting Services includes many predefined item-level role definitions that you can work with. You can modify the role definitions by changing the task list of each one. Editing a role definition affects all role assignments that include the role definition.

Note

User role assignments are used only on a report server that runs in native mode. If the report server is configured for SharePoint integration, this page displays read-only information about the roles and permission levels that are defined on the SharePoint site.

Options

Name - Specifies the name of the role definition.

Description - Shows a description of the role definition. In SQL Server Management Studio, this description is only visible in this page. In Report Manager, this description helps users decide whether to use the role in a role assignment.

Task - Lists all item-level tasks that can be selected for this role definition. You can add or remove items from the predefined task list to define how users access a given item through this role. You can't create new tasks, and you can't modify existing tasks. The task list of a role definition appears only in SQL Server Management Studio.

Task Description - Provides information about each task. You can't modify task descriptions.

SQL Server Management Studio (SSMS)

Feedback

Această pagină a fost utilă?

Last updated on 2026-02-27

Partajați prin

Reporting Services in SQL Server Management Studio (SSRS)

In this section

Report Server in Management Studio help

Cancel report server jobs

Delete catalog items

Job properties

New shared schedule

New system role

New user role

Schedule properties (General page)

Schedule properties (Reports page)

Server properties (General page)

Server properties (Execution page)

Server properties (History page)

Server properties (Logging page)

Server properties (Security page)

Server properties (Advanced page)

Options

AccessControlAllowCredentials

AccessControlAllowHeaders

AccessControlAllowMethods

AccessControlAllowOrigin

AccessControlExposeHeaders

AccessControlMaxAge

AllowedResourceExtensionsForUpload

CustomHeaders

CustomHeaders XML format

Set the CustomHeaders property

Example

CustomUrlLabel and CustomUrlValue

DisableMSRBConnect

EditSessionCacheLimit

EditSessionTimeout

EnableCDNVisuals

EnableClientPrinting

EnableCommentOnReports

EnableCustomVisuals

EnableExecutionLogging

EnableIntegratedSecurity

EnableLoadReportDefinition

EnableMyReports

EnablePowerBIReportExportData

EnablePowerBIReportExportUnderlyingData

EnablePowerBIReportMigrate

EnableRefererValidation

EnableRemoteErrors

EnableTestConnectionDetailedErrors

ExecutionLogDaysKept

ExecutionLogLevel

ExternalImagesTimeout

InterProcessTimeoutMinutes

LogClientIPAddress

MaxFileSizeMb

ModelCleanupCycleMinutes

ModelExpirationMinutes

MyReportsRole

OfficeAccessTokenExpirationSeconds

OfficeOnlineDiscoveryURL

PowerBIMigrateCountLimit

PowerBIMigrateUrl

RDLXReportTimetout

RequireIntune

RestrictedResourceMimeTypeForUpload

ScheduleRefreshTimeoutMinutes

SessionTimeout

SharePointIntegratedMode

ShowDownloadMenu

SiteName

SnapshotCompression

StoredParametersLifetime

StoredParametersThreshold

SupportedHyperlinkSchemes

SystemReportTimeout

SystemSnapshotLimit

TileViewByDefault

TimerInitialDelaySeconds

TrustedFileFormat

UseSessionCookies

System role properties