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:
- Install SSRS in SharePoint mode (and the add-in) in the farm server you want to be the Reporting Server.
- Install the SSRS add-in in the remaining farm servers.
- Activate the service instances.
- Create the SSRS Service Application in your farm
- 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