Checklist when configuring Reporting Services for SharePoint 2013

Hi again! Continuing with my series of check lists, this time it's turn for Reporting Services from SQL Server 2012 with SharePoint 2013.

The high level steps are:

  1. Install SSRS in SharePoint mode (and the add-in) in the farm server you want to be the Reporting Server.
  2. Install the SSRS add-in in the remaining farm servers.
  3. Activate the service instances.
  4. Create the SSRS Service Application in your farm
  5. Activate the PowerView feature in your site collections

Things you should take in mind:

Currently there is a bug in some ISO's where SQL Server 2012 includes the Service Pack 2. I recommend to download the service pack 2 itself as well and install it after step 2. I have done it after all the process, though.

  • SSRS needs a SQL Server Instance, ensure both the SSRS and SQL Server have the same edition, same patch level.
  • Execute the Install-SPRSService and Install-SPRSServiceProxy only on the server you want the role. Then you are good to start them.
  • Ensure you have granted access the SSRS service identity to the web application by using this script:
    Get-SPWebApplication | % {$_.GrantAccessToProcessIdentity("your reporting service account")}
  • Ensure the SSRS service identity has access to the PowerPivot Service Application. You do this by selecting the Service Application and managing the Permissions (the big button in the ribbon).
  • Ensure Excel Service service identity has access to the SSRS Service, by the same way (from the service application permissions).
  • Ensure the SSRS service identity has access to the SSAS PowerPivot instance