SQL Server Reporting Services installation and configuration in SharePoint 2016 and SharePoint 2013

ssrs integrated mode sharepoint 2016

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


I would like to divide this article in 2 different sections:
1. Installation of SSRS for SharePoint
2. Configure SSRS in a Site Collection

Installation of SSRS for SharePoint:

Log on to SQL server / SharePoint WFE server with 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.

Download some SharePoint 2016 and SharePoint Online FREE pdf books
SharePoint Server 2016 Installation FREE PDF guide

Hub Sites SharePoint Online Office 365 Tutorial Download PDF Free

SharePoint online: Ultimate tutorial guide PDF download

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


ssrs sharepoint
ssrs sharepoint
ssrs sharepoint 2013
ssrs sharepoint 2013

This will validate all the prerequisites to add the feature.

ssrs sharepoint 2016
ssrs sharepoint 2016

Now accept the license term and click “Next”

sql server reporting services 2014
sql server reporting services 2014

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

ssrs sharepoint online
ssrs sharepoint online

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

install sql server reporting services 2012
install sql server reporting services 2012

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

deploy ssrs report to sharepoint 2013
deploy ssrs report to sharepoint 2013

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

reporting services add in for sharepoint
reporting services add in for sharepoint
ssrs 2014 sharepoint 2013
ssrs 2014 sharepoint 2013

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

ssrs sharepoint integration
ssrs sharepoint integration
ssrs sharepoint configuration
ssrs sharepoint configuration

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


sharepoint ssrs service application
sharepoint ssrs service application

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

sql server reporting services 2014 download
sql server reporting services 2014 download

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

ssrs integrated mode sharepoint 2016
ssrs integrated mode sharepoint 2016

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

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

With this we have completed 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.

Central administration -> Application Management -> Service application -> Manage service on server

sql server 2014 reporting services add-in for sharepoint 2013
sql server 2014 reporting services add-in for sharepoint 2013

We will see the step-2 of SSRS configuration in site collection in next article.



Hope this helps, enjoy SharePoint development.

Check out Best Alternative to InfoPath -> Try Now

You May Also like the Following SharePoint Online Tutorials:

About Krishna Vandanapu

I am Krishna.Vandanapu a SharePoint architect working in IT from last 12 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 →