Manage a Reporting Services Service Application

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 as well as common administration tasks.

This topic covers the following information:

• Open Service Application Management Pages

• System Settings

• Manage Jobs

• Key Management

• Execution Account

• E-mail Settings

• Provision Subscriptions and Alerts

To Open Service Application Properties Page

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

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

2. Click near the name of your service application or on the type column, which will select the entire row, and then click Properties in the SharePoint ribbon.

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

To Open Service Application Management Pages

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

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

2. Click the name of your service application and the Manage Reporting Services Application page will open.

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

[Top]

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

• Session Settings

• System Settings for Logging

• Security Settings

• Client Settings

[Top]

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

[Top of System Settings]

Session Settings

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

[Top of System Settings]

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.

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

[Top of System Settings]

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.

[Top of System Settings]

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 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. To launch Report Builder 1.0 as a Click-Once application, enter the following value: http://<computername>/ReportServer/ReportBuilder/ReportBuilder_1_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.

[Top of System Settings]

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 is not 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 will generate a job once an hour that appears on the Manage Jobs page.

[Top]

Key Management

The following table summarizes the Kay Management pages

Security Note
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	Type a password in to the Password: and Confirm Password: boxes and click Export. You will see a warning if the password you typed is does not meet the complexity requirements of the domain policy. You will be 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	Type or browse to the key file in the File Location box In the Password box, type the password that was used to back up the encryption file. Click OK
Change Encryption Key	This operation will create a new key and re-encrypt your encrypted content. If you have a lot of content, this operation make take several hours. When the change encryption key operation is complete, it is recommended you make a backup of your new key.
Deleted Encrypted Content	Deleted content cannot be recovered. Important The action of deleting and recreating the symmetric key cannot 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 will also deleted. Deleted data includes connection strings to external report data sources, stored connection strings, and some subscription information.

[Top]

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 are not available:

• When the report server connects to a data source that does not 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 retrieving 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 retrieving 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 does not allow its service account credentials to be delegated or impersonated when connecting to other computers, so 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 are 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 logon 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. Do not 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.

[Top]

Options

• Specify an execution account
  Select to specify an account.

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

• Password
  Type the password.

• Confirm password
  Retype 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.

[Top]

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

[Top]

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, click Configure Service Application Associations.

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

3. Find and click the name of your new Reporting Services Service application. You could also click 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 click Ok.