Manage a Reporting Services SharePoint service application

Applies to: ✅ SQL Server Reporting Services (2016) ✅ SharePoint ❌ Power BI Report Server

For content related to previous versions of SQL Server Reporting Services (SSRS), see SQL Server 2014 Reporting Services.

Reporting Services service applications are managed from SharePoint Central Administration. The Management and Properties pages allow you to update the configuration of the service application and common administration tasks.

Note

Reporting Services integration with SharePoint is no longer available after SQL Server 2016.

Open service application properties page

To open the properties page for a Reporting Services service application, complete the following actions:

  1. In Central Administration, in the Application Management group, select Manage service applications.

  2. Select near the name of your service application or on the type column, which selects the entire row, and then choose Properties in the SharePoint ribbon.

For more information on service application properties, see Step 3: Create a Reporting Services Service Application.

Open service application management pages

To open the management pages for a Reporting Services service application, complete the following actions:

  1. In Central Administration, in the Application Management group, select Manage service applications.

  2. Select the name of your service application, and the Manage Reporting Services Application page opens.

  3. Alternatively, you could select near the name or on the type column for your service application, which selects the entire row, and then choose Manage in the SharePoint ribbon.

System settings page

The systems settings page allows you to configure the behavior and user experience of your service application including various timeouts.

Report settings

Setting Comments
External Images Timeout Default is 600 seconds.
Snapshot Compression Default is SQL.
System Report Timeout Default is 1800 seconds.

Specify whether report processing times out on the report server after a certain number of seconds. This value applies to report processing on a report server. It doesn't 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. The value that you specify must be sufficient to complete both data processing and report processing.
System Snapshot Limit Default is -1, which is no limit.

Set a site-wide default value for the number of copies of report history to retain. The default value provides an initial setting that establishes the number of snapshots that can be stored for each report. You can specify different limits in property pages for specific reports.
Stored Parameters Lifetime Default is 180.
Stored Parameters Threshold Default is 1500 days.

Session settings

Setting Comments
Session Timeout Default is 600 seconds.
Use Session Cookies Default is TRUE.
EDLX Report Timeout Default is 1800 seconds.

System settings for logging

Setting Comments
Enable Execution Logging Default is TRUE.

specify whether the report server generates trace logs and the number of days the log is kept. The logs are stored on the report server computer in the \Microsoft SQL Server\MSSQL.n\ReportServer\Log folder. A new log file is started each time the service is restarted. For more information about log files, see Report Server Service Trace Log
Execution Log Days Kept Default is 60 days.

Reporting Services all supports SharePoint ULS logging. For more information, see Turn on Reporting Services events for the SharePoint trace log (ULS)

Security settings

Setting Comments
Enable Integrated Security Default is TRUE.

Specifies whether a connection to a report data source can be made using the Windows security token of the user who requested the report.
Enable Load Report Definition Default is TRUE.
Enable Remote Errors Default is FALSE.
Enable Test Connection Detailed Errors Default is TRUE.

Client settings

Setting Comments
Enable Report Builder Download Default is TRUE.

Specifies whether clients are able to see the button for downloading the report builder application.
Report Builder Launch URL Specify a custom URL when the report server doesn't use the default Report Builder URL. This setting is optional. If you don't specify a value, the default URL is used, which launches Report Builder. To launch Report Builder 3.0 as a Click-Once application, enter the following value: https://<computername>/ReportServer/ReportBuilder/ReportBuilder_3_0_0_0.application.
Enable Client Printing The Default is TRUE.

Specifies whether users can download the client side control, which provides printing options.
Edit Session Timeout Default is 7200 seconds.
Edit Session Cache Limit Default is 5.

Manage jobs

You can view and delete the running jobs, for example jobs that are created by report subscriptions and data-driven subscriptions. The page isn't used to manage subscriptions, but rather jobs that are triggered by a subscription. For example a subscription that is scheduled to run once an hour generates a job once an hour that appears on the Manage Jobs page.

Screenshot that shows the Manage Jobs page.

Key management

The following table summarizes the Kay Management pages.

Important

Periodically changing the Reporting Services encryption key is a security best practice. A recommended time to change the key is immediately following a major version upgrade of Reporting Services. Changing the key after an upgrade minimizes additional service interruption caused by changing the Reporting Services encryption key outside of the upgrade cycle.

Page Description
Backup Encryptions Key 1) Enter a password in to the Password: and Confirm Password: boxes and select Export. You see a warning if the password you entered doesn't meet the complexity requirements of the domain policy.

2) You're prompted for a file location of where to save the key file. You should consider storing the key file on a separate computer from the one that is running Reporting Services. The default file name is the same name as the service application.
Restore Encryption Key 1) Type or browse to the key file in the File Location box.

2) In the Password box, enter the password that was used to back up the encryption file.

3) Select OK.
Change Encryption Key This operation creates a new key and re-encrypts your encrypted content. If you have a large amount of content, this operation make take several hours.

When the change encryption key operation is complete, you should make a backup of your new key.
Deleted Encrypted Content Deleted content can't be recovered.

** Important ** The action of deleting and recreating the symmetric key can't be reversed or undone. Deleting or recreating the key can have important ramifications on your current installation. If you delete the key, any existing data encrypted by the symmetric key is also deleted. Deleted data includes connection strings to external report data sources, stored connection strings, and some subscription information.

Execution account

Use this page to configure an account to use for unattended processing. This account is used under special circumstances when other sources of credentials aren't available:

  • When the report server connects to a data source that doesn't require credentials. Examples of data sources that might not require credentials include XML documents and some client-side database applications.

  • When the report server connects to another server to retrieve external image files or other resources that are referenced in a report.

Setting this account is optional, but not setting it limits your use of external images and connections to some data sources. When you retrieve external image files, the report server checks to see if an anonymous connection can be made. If the connection is password protected, the report server uses the unattended report processing account to connect to the remote server. When you retrieve data for a report, the report server either impersonates the current user, prompts the user to provide credentials, uses stored credentials, or uses the unattended processing account if the data source connection specifies None as the credential type. The report server doesn't allow its service account credentials to be delegated or impersonated when connecting to other computers. It must use the unattended processing account if no other credentials are available.

The account you specify should be different from the one used to run the service account. If you're running the report server in a scale-out deployment, you must configure this account the same way on each report server.

You can use any Windows user account. For best results, choose an account that has read permissions and network sign-in permissions to support connections to other computers. It must have read permissions on any external image or data file that you want to use in a report. Don't specify a local account unless all report data sources and external images are stored on the report server computer. Use the account only for unattended report processing.

PowerShell command

The following example is a PowerShell command to return the list of Reporting Services service applications with the UEAccount property:

Get-SPRSServiceApplication | select typename, name, service, ueaccountname  

For more information, see PowerShell cmdlets for Reporting Services SharePoint Mode.

Options

Specify an execution account
Select to specify an account.

Account
Enter a Windows domain user account. Use this format: <domain>\<user account>.

Password
Enter the password.

Confirm password
Reenter the password.

E-mail settings

Use this page to specify Simple Mail Transport Protocol (SMTP) settings that enable report server e-mail delivery from the report server. You can use the Report Server E-Mail delivery extension to distribute reports or report processing notifications through e-mail subscriptions. The Report Server E-Mail delivery extension requires an SMTP server and an e-mail address to use in the From: field.

Options

Use SMTP Server
Specifies that report server e-mail is routed through an SMTP server.

Outbound SMTP Server
Specify the SMTP server or gateway to use. You can use a local server or an SMTP server on your network.

From Address
Specifies the e-mail address to use in the From: field of a generated e-mail. You must specify a user account that has permission to send mail from the SMTP server.

Provision subscriptions and alerts

Use this page to verify if SQL Server Agent is running and to provision access for reporting services to use SQL Server Agent. SQL Server Agent is required for Reporting Services subscriptions, schedules, and data alerts. Provision Subscriptions and Alerts for SSRS Service Applications

Proxy association

When you created the Reporting Services service application, you selected the web application to associate and provision permissions for access by the Reporting Services service application. If you chose to not associate or you want to change the association, you can use the following steps.

  1. In SharePoint Central Administration, in the Application Management, select Configure Service Application Associations.

  2. On the Service application Associations page, change the view to Service Applications.

  3. Find and select the name of your new Reporting Services Service application. You could also select the application proxy group name default to add the proxy to default group rather than completing the following steps.

  4. Select Custom in the selection box Edit the following group of connections.

  5. Check the box for your proxy and select Ok.

More questions? Try asking the Reporting Services forum