Setup SSRS on a single SharePoint server farm

  • Article

Installing SQL Server Reporting Services (SSRS) in a SharePoint environment requires several pre-installation steps before you can create the SharePoint service application.  This post is focused on installing SSRS on a single SharePoint server farm.  The topology would be resemble to the following:

singleservertopology

NOTE:  The SharePoint server contains all roles for the farm (service applications, central admin, search, web front end etc).

A high level overview of the steps to install SSRS on a single server farm are:

  1. On the SharePoint application server hosting the SQL Server Reporting Server Service,  install the Reporting Services Feature and Add-In components.
  2. Create and configure the SQL Server Reporting Service Application in Central Admin.

 

Install Reporting Services Feature components

  1. On the SharePoint Server  that is going to host the SQL Server Reporting Server Service application, locate the SQL Server media and launch the setup wizard as if you were installing SQL Server.
  2. Select the add features to an existing installation option.

ssrsinstal1

3.  Select SQL Server Feature Installation to see the features to install.

ssrsinstal2

4.  Select the 2 features shown below.  As an option you can install the Management Tools so you can manage SQL Server from SharePoint but it's not required as part of the install.

ssrsinstal3

5.  The only configuration option will be "Install Only" since this is not an actual SQL Server.

ssrsinstal4

6.  The next screen will list all the features that are going to be installed.  This is read only and informational.

7.  Once the installation is complete, you should see all features installed successfully.

ssrsinstal5

 

Configure SharePoint

  1. Now that the SSRS binaries are installed on the SharePoint the necessary configuration components are available to SharePoint.
  2. Open Central Administration -> Manage Services on Server and make sure the SQL Server Reporting Services Service is started.

ssrsserviceappinstall2

3.  From Central Administration go to Manage Service Applications and select SQL Server Reporting Services Service Application from the New menu.

ssrsserviceappinstall1

4.  To create the service application, you'll need the following information.

ssrsserviceappinstall3

NOTES:

  • Name – this can be anything you want but make sure it’s descriptive enough for other administrators.
  • Application Pool – it’s recommended that you create a new application pool for performance and security reasons.  It’s also best to use a separate managed account for security and traceability when troubleshooting.
  • Web Application Association – select what web apps you want to enable SSRS on.

5.  SharePoint will confirm the service application was created successfully.

ssrsserviceappinstall4

6.  The service application will also appear in Central Admin.

ssrsserviceappinstall5

From here you can modify the SSRS settings  by selecting the service application and "Manage" in the ribbon.

7.  When setting the the authentication mode in SSRS Settings, if you are NOT running Kerberos be sure to select "Trusted Account", otherwise select Windows Authentication.  When using the Trusted Account mode, SSRS will use the App Pool account for the web application.

trustedaccount