SharePoint 2010 - SQL Server 2012 Reporting Services Integration Steps (Multiple Server Farm)
Most SharePoint customers suffer no issues when integrating SQL Server Reporting Services 2012 (SSRS 2012) with SharePoint 2010 (SP 2010), I however, had quite a bit of trouble. So for those at home who may also be having some trouble, I thought I'd prescibe you some troubleshooting medicine along with a few spoonfuls of errors. The official steps you may have read about: - Install SQL Server with Reporting Services Add-in for SharePoint - Install SharePoint on the Reporting Services Server and connect that server up to the farm (using Configuration Wizard) - Install the rsSharePoint.msi file provided by Microsoft on all your front-end servers running SharePoint. - Run these two commands on all front-end servers running sharepoint Install-SPRSService Install-SPRSServiceProxy - Navigate to Central Administration > System Settings > Manage services on server. Start the SQL Server Reporting Services Service - Navigate to Central Administration > Applic...