SSRS 2012 R2 Integration with SharePoint 2013

So it came to my attention the other day that the setup for the SQL Server Reporting Services with SharePoint 2013 wasn't the most straight forward I've installation or configuration I've ever done. If you've got a multi-tier farm like we have, you'll have to actually install the Reporting Services on one of the SharePoint 2013 Servers away from the SQL Server box. In our environment, our Search runs on our second application server, so I decided to install SSRS 2010 R2 onto my first application server.

Mount the SQL ISO onto your SharePoint Application server. The reason for this install is to have Reporting Services talk to SharePoint. You'd rather not install SharePoint onto your SQL box, so the best solution is to install Reporting Services onto the SharePoint box. When coming to create the database for ReportServer, your DBA's may have a certain naming convention they like to use, so you'll want to use this when creating a database from SharePoint for SSRS.

Go through the SQL Reporting Services setup as below as we're only installing SSRS in SharePoint Integrated mode.

When you get to the below screen, choose the following options:

After running these steps, restart the server. 

Once restarted, you'll need to enable the services on the server. I used the powershell commands:

1. “Install-SPRSService “ cmdlet from “SharePoint 2013 Management Shell”

2. Run “Install-SPRSServiceProxy” to install the service proxy

3. Run “get-spserviceinstance -all | where {$_.TypeName -like "SQL Server Reporting*"} | Start-SPServiceInstance” to start the service.

It may say, the services have already been started, which is fine. Go into Central admin and make sure that they are started for sure.

The next step would be to create the SQL Reporting Services Service Application.

Click on Application Management > Manage Service Applications from Central Admin, then New and choose the SQL Reporting Services Service Application.

Fill in all the required details including the name of your Report Server which your DBA may want named in a certain way. And press OK.

Once done, you are all set to go.

You can either create a document library to store reports or see the content types now on your sites.