Reporting Services SharePoint Service and Service Applications (SharePoint Mode)

Reporting Services SharePoint mode is architected on the SharePoint service architecture and utilizes a SharePoint service and one to many service applications. Creating a service application makes the service available and generates the service application database. You can create multiple Reporting Services service applications but one service application is sufficient for most deployment scenarios.

This topic covers the following information:

  • Creating A Service Application

  • Modify Associations

  • Edit Service Application Properties

  • Create a Service Application with PowerShell

  • Related Tasks

Creating a Reporting Services Service Application

You can use SharePoint Central Administration or PowerShell scripts to create the Reporting Services services applications. For more information on using SharePoint Central Administration, see the “Create a Reporting Services Service Application” section in Install Reporting Services SharePoint Mode in a Single Server Farm. See the PowerShell section later in this topic for a sample PowerShell script for creating service applications.

Arrow icon used with Back to Top linkTOP

Modify the Associations of the Service Application with a proxy group

The New page for creating a services application contains the section Web Application Association. The section allows you to associate your service application as you create it. Use the following steps to change the association and assign a customer configuration to the service application. The same general process can also be used to add the proxy to the default group rather than changing the association of the service application to a custom group.

  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.

Arrow icon used with Back to Top linkTOP

Edit Service Application Properties

You can reopen the property page of the service application to modify the properties.

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

  2. Select the service application by clicking the type column to select the entire row. If you click the name of the application it, the Management options page for the service opens instead of opening the properties of the service application.

  3. In the Service Applications ribbon, click Properties.

Arrow icon used with Back to Top linkTOP

To create a Reporting Services Service Application using PowerShell

You can use PowerShell to create the Service application and proxy. The sample below assumes that you know what application pool you want to configure the service application to use.

  1. Add the application pool object of your application pool name to a variable that is passed into the New action.

    $appPoolName = get-spserviceapplicationpool “<application pool name>”
  2. Create the service application with a name and application pool name you provide.

    New-SPRSServiceApplication –Name ‘MyServiceApplication’ –ApplicationPool $appPoolName –DatabaseName ‘MyServiceApplicationDatabase’ –DatabaseServer ‘<Server Name>’
  3. Get the new service application object, and pipe the object into the Pipe the new proxy cmdlet.

    Get-SPRSServiceApplication –name MyServiceApplication | New-SPRSServiceApplicationProxy “MyServiceApplicationProxy”

Arrow icon used with Back to Top linkTOP



Manage the settings of your Service Application.

Manage a Reporting Services Service Application

Backup and restore the service application and related components such as encryption keys and proxy.

Backup and Restore Reporting Services Service Applications

Arrow icon used with Back to Top linkTOP