SharePoint 2010 Integrated Mode Reporting Services SQL Server 2012 SP1

Today I have new test configure SharePoint 2010 sp1 integrated mode reporting service with SQL server 2012 SP1.  In last case I have configure reporting service sharepoint 2010 and SQL 2008 R2 . Configure reporting between SQL 2008 R2 and SQL 2012 reporting with sharepoint 2010  it not same model configure.

My Environment lab base on Windows server 2008 R2.

1. SharePoint 2010 SP1

2. SQL server 2012 SP1

3. AD2008

Model Integrated Mode reporting.

http://msdn.microsoft.com/en-us/library/bb510781(v=sql.105).aspx

How to configure sharepoint 2010 Integrated Mode Reporting Services SQL Server 2012.

On SQL Server 2012

1. In  SQL Server I have service database engine and reporting service it have already.

On SharePoint 2010

1. On Web-front end sharepoint you must install reporting service add-in for sharepoint products before configure.

Microsoft recommend download add-in this link : http://msdn.microsoft.com/en-us/library/gg426282

reference : http://msdn.microsoft.com/en-us/library/c2804a9a-08ea-4f4a-805d-a2c19c68733d

But I not recommend download reporting service add-in for sharepoint (rsSharepoint.msi) because when you run wizard complete  it can’t start SQL Server Reporting service . It’s show error when your start : installation error : Could not find software\microsoft\microsoft sql server\110 registy key

I suggest you install SQL server 2012 SP1 on WFE SharePoint and Select feature below only.

- Reporting Service SharePoint

- Reporting Service Add-in for sharepoint products.

2.  Choose reporting service sharepoint integrated mode : Install Only

3. Waiting for install feature  and show succeeded for installed.

4. Open sharepoint powershell sharepoint 2010.

Run command :

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

5. Go to central Administration > Manage service on Server : Find SQL Service reporting Service it start.

If service not start , Click to start this service.

6. Manage Service Application > New > SQL Server Reporting Service Application.

7. Create Application Poll , DATABASE Name  and select your web application use this service.

8. Waiting and Done.

9. Active feature site action > Site Setting > Site Collection feature > activate feature SQL Server Reporting Services.

10. Done.