How to configure SSRS in SharePoint 2013/2016

In my previous article, we have discussed how to configure SSRS, now we will see the Configure SSRS in a Site Collection in SharePoint 2013/2016. Now that we have installed SSRS login to SharePoint Central admin server as FARM administrator and perform the below steps.

Configure SSRS in SharePoint

Ensure that “SQL Server Reporting Services Service” as part of Services in server central admin.

Then Open SharePoint 2013/2016 Central administration -> Application Management -> Service applications -> Manage service on server.

ssrs 2016 sharepoint 2013
ssrs 2016 sharepoint 2013

Now we need to create SSRS service application in Central Administration. Select Central administration -> Application Management -> Service applications -> Manage Service Application

create ssrs report in sharepoint 2013
create ssrs report in sharepoint 2013

Provide all the details to create SSRS service application as shown below and click on OK

deploy ssrs report to sharepoint 2013
deploy ssrs report to sharepoint 2013
ssrs reports in sharepoint 2013
ssrs reports in sharepoint 2013

As soon as the service application got created it will be listed as below:

configure ssrs in sharepoint 2013
configure ssrs in sharepoint 2013

Once the service application created successfully navigate any site collection where you want to deploy an SSRS report. Then Navigate to site settings and site collection features.

configure ssrs sharepoint 2016
configure ssrs sharepoint 2016

Locate “Report Server Integration” feature deactivate and activate the feature

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

Now create a document library “Data Connections” attach reporting service content types by enabling content types in a library advanced settings.

Open any library and Library settings -> Advanced settings -> Allow management of content types to “Yes” and click on OK

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

Now click on “Add from existing site content types” as part of library settings. Now attach the below-listed content types to library:

  • Report Builder Model
  • Report Data Source
  • Report Builder Report
sql server reporting services service application missing sharepoint 2016
sql server reporting services service application missing sharepoint 2016

Now you should see 3 different options when you click on the new item in the document library.

sharepoint configure ssrs
sharepoint configure ssrs

Now we have completed configuring SharePoint to render SSRS reports.

You may like following SharePoint tutorials:

I this SharePoint tutorials helps to know how to configure SSRS in SharePoint 2013 or SharePoint 2016.

  • >