Install and Configure SQL Server Reporting Services Service Application in SharePoint 2010

In this SharePoint Administration tutorial, I will explain how to install and configure SQL server reporting services service applications in SharePoint 2010.

There are two ways to Install and Start the Reporting Services SharePoint Service in SharePoint, we can configure the same using GUI or using SharePoint PowerShell as well.

The trials in this topic guide you over a single server farm installation of a Reporting Services report server in SharePoint mode. This step includes configuration tasks that use SharePoint central administration.

Configure SQL Server Reporting Services Service Application from SharePoint Central Administration

Let us start with GUI mode to configure SQL Server Reporting services application step by step with the screenshot:

  • Log in to the SharePoint Server and Open Central Administrator page with farm Admin Permission.

Now click on Manage Services Application under Application Management.

How to Install and Start the Reporting Services SharePoint Service in SharePoint
How to Install and Start the Reporting Services SharePoint Service in SharePoint
  • Once clicked on the same, we will be navigating to Application Page where many applications will be configured by default, here we can configure other application as per our requirement.
  • We can navigate this page directly from Central admin using the Appended URL. _admin/ServiceApplications.aspx

Now Click on New option from Ribbon page, and select SQL Server Reporting Services Service Application as highlighted in below screenshot:

install reporting services sharepoint mode for sharepoint 2016
install reporting services sharepoint mode for sharepoint 2016
  • Wait for a moment after clicking on the same, as it will take some time to load the page to update the details. Once the page loaded you can see a form page where we need to update the following fields in terms to configure the SSRS service.
  • Service Name: Enter the name of the service, here we can choose as own.
  • Application Pool: We can choose the existing Application pool to user service application or can create a new one, in my case we are creating a new Application that will appear under IIS. Under the App pool need to select a Security account for the application pool, recommend using Farm account.
  • SSRS Database: Here we need to select the database server name and Enter the Database name, over here we can see the database authentic permission to select store procedure or windows, select windows.
  • Web Application association: Select the Web Application to be associated with and provisioned for access by this SQL server reporting service Application.
install reporting services sharepoint mode for sharepoint 2013
install reporting services sharepoint mode for sharepoint 2013

Once all above field is updated, click on ok and wait for completion of the process to create SSRS service.

install reporting services sharepoint mode for sharepoint 2010
install reporting services sharepoint mode for sharepoint 2010
  • Once the above process will get complete we will get the Successful message on the same page.
install reporting services sharepoint mode for sharepoint online
install reporting services sharepoint mode for sharepoint online
  • Click on Ok, will navigate to Manage Service Application page under CA.

We can verify this service by checking services under CA page: go to CA > System setting > Manage services on the server and check SSRS service is up and running.

install reporting services sharepoint mode for sharepoint
install reporting services sharepoint mode for sharepoint

You may like following SharePoint tutorials:

I hope this SharePoint administration tutorial gives you an idea on how to Install and Configure SQL Server Reporting Services Service Application in SharePoint 2010.

>