Problem with Reporting Services 2012 SharePoint 2010 integration

Question

We have an environment which uses 3 Servers:

- Front-end server which hosts SharePoint 2010.

- Database server (SQL Server 2008R2) which has the WSS_content and other SP2010 databases

- BI server into which we import data with SSIS, build cubes and reports. This server hosts SQL Server 2012 and it is installed in SharePoint integrated mode(i.e. the Shared Features "Reporting Services - SharePoint" and "Reporting Services Add-in for SharePoint products" are installed).

I ran the two commands:
Install-SPRSService
Install-SPRSServiceProxy

But when I try to add a new Managed Service(SQL Server Reporting Services Service Application), I get an error

Installation Error: Could not find SOFTWARE\Microsoft\Microsoft SQL Server\110 registry key. 
Troubleshoot issues with Microsoft SharePoint Foundation. 
Correlation ID: d41d6629-3d8d-4f88-b6ed-284bc0cc8478

Does anyone have any idea what this could mean?

Answer 1

Hello,

If you configure the Reporting service in SharePoint Integrated Mode with distributed server deployment, the BI server that host SSRS also has at least the "SharePoint Object Model" installed.
For more information, please see:
Deployment Topologies for Reporting Services in SharePoint Integrated Mode

Regards,

Fanny Liu

---

Fanny Liu
TechNet Community Support