Install and configure SQL server reporting services (SSRS) in SharePoint 2013/2016

ssrs integrated mode sharepoint 2016
SharePoint deveopment training course

This SharePoint tutorial we will discuss how to install and configure SQL server reporting services (SSRS) in SharePoint 2013/2016/2019.

I would like to walk you through the installation and importance of SQL Server Reporting Services (SSRS) in SharePoint 2013 & 2016. The below screenshots were taken while configuring SSRS in SharePoint 2013 with SQL Server 2012 the same approach can be used to configure SharePoint 2016.

Install and configure SQL server reporting services (SSRS) in SharePoint

I would like to divide this article into 2 different sections:

  • Installation of SSRS for SharePoint
  • Configure SSRS in a Site Collection

Log on to SQL server / SharePoint WFE server with an admin account and follow the screens to install SSRS:

Note: SSRS can be installed either on SQL server and attach that to FARM and then install Reporting services add-in SharePoint FARM or install SSRS on SharePoint WFE.

Run SQL server 2012 setup file and select Installation in the left side menu and select “add features to an existing installation” as shown below.

configure ssrs in sharepoint 2013
configure ssrs in sharepoint 2016

This will validate all the prerequisites to add the feature.

ssrs in sharepoint 2016

Now accept the license term and click “Next”.

ssrs configuration in sharepoint 2013 step by step

As soon as you click on next it will validate the setup support rules as shown below.

sql server reporting services

Select “Setup Role” from the left menu and click on “SQL Server Feature Installation” and click on “Next” button.

sql server reporting services sharepoint 2013

Select all the options as shown below to install “Reporting Services” for SQL Server and then click on Next.

sql server reporting services sharepoint 2016

Now you can select which server you want to configure these services, select Default instance as shown below.

sql server reporting services sharepoint 2019
sharepoint online sql server reporting services

As part of Server Configuration, you can mention which account you want to run these services in Server.

configure sql server reporting services sharepoint 2016
configure sql server reporting services sharepoint 2013

As part of Database Engine configuration, please add the SharePoint FARM account and all the account you want to nominate them as admins.

configure sql server reporting services sharepoint 2019

Now the SQL setup will validate all the configuration rule as shown below.

sharepoint 2013 sql server reporting services

As soon as you click on Next button setup will list out all the features getting installed. Review all the features and click on “Install”.

sharepoint 2016 sql server reporting services

Once the installation completed setup will show you the completed slide as below.

sharepoint 2019 sql server reporting services

With this, we have completed the installation of SSRS now let us see the steps to configure the same in SharePoint.

As soon as SSRS installation completed you will see “SQL Server Reporting Services Service” as part of Services in server central admin.

Open SharePoint Central Administration -> Application Management -> Service application -> Manage service on server.

Install and configure sql server reporting services (ssrs) in SharePoint 2013/2016

You may like following SharePoint tutorials:

This SharePoint tutorial, we learned how to install and configure SSRS in SharePoint 2013/2016/2019.

Check out Best Alternative to InfoPath -> Try Now

free sharepoint training

SharePoint Online FREE Training

JOIN a FREE SharePoint Video Course (3 Part Video Series)

envelope
envelope

About Krishna Vandanapu

I am Krishna.Vandanapu a SharePoint architect working in IT from last 13+ years, I worked in SharePoint 2007, 2010, 2013, 2016 and Office 365. I have extensive hands on experience in customizing SharePoint sites from end to end. Expertise in SharePoint migration tools like Sharegate, Doc Ave and Metalogix. Migrated SharePoint sites from SharePoint 2007 to 2010 and 2010 to 2013 several times seamlessly. Implementing CSOM with Microsoft best practices. Spent quality time in configuring SharePoint application services like User Profile, Search, Managed Meta data services etc. Now exploring SharePoint Framework and SharePoint 2019

View all posts by Krishna Vandanapu →