SQL Server 2012 SP1 SSRS Integration with SharePoint 2013

There are a few documents in Internet for SQL Server 2008 R2 SSRS Integration with SharePoint. But for SQL Server 2012 SP1, I couldn't find a good one. The aim is to help someone is Installing SQL Server 2012 SP2 with SSRS Integration mode and Integrate in SharePoint 2013 Server.

The below are the Important points

1. Install SQL Server 2012 featured installation with SharePoint Integrated mode (Install only)

If App server and WFE server is in a single box, then follow the steps 2 and 3
2. Install SQL Server 2012 SP1 featured installation option in "App server"
3. Choose the shared features "Reporting Services - SharePoint" and "Reporting Services Add-in for SharePoint products"

If App server and WFE server are in different box 4 to 6
4. Install SQL Server 2013 SP1 featured installation option in "App server"
5. Choose the shared features "Reporting Services - SharePoint" in "App server"
6. Choose the shared features "Reporting Services Add-in for SharePoint Products" in WFE server.

7. In app server (where we installed SSRS) you have to run the below power shell scripts

Install-SPRSService
Install-SPRSServiceProxy
get-spserviceinstance -all |where {$_.TypeName -like “SQL Server Reporting*”} | Start-SPServiceInstance

Note : SSRS in integrated mode (now as a service application) needs to be installed on the SharePoint server, not the SQL
Server.Also, with 2012, you should be installing the SP1 update in order to integrate with SharePoint 2013.