Friday 30 November 2012

SQL Server Reporting Services Service not installed after running Install-SPRSService and Install-SPRSServiceProxy



I was recently setting up a reporting server running in sharepoint integarted mode connected to an existing farm. After installing SQL 2012 in SharePoint integrated mode I executed  following commands (Install-SPRSService, Install-SPRSServiceProxy) to setup the reporting shared service in sharepoint. The command executed successfully but i was unable to see  SQL Server Reporting Services Service under system settings in Central AdminI went through the sharepoint logs and couldn't find anything in there. NO ERRORS. After spending a lot of time i figured out the solution. 

SOLUTION:


I downloaded Microsoft® SQL Server® 2012 Reporting Services Add-in for Microsoft® SharePoint® Technologies 2010 and installed on all WFE in the farm so they can be upgraded to use SQL 2012 Reporting Service.After successfully installing it and running the  Install-SPRSService, Install-SPRSServiceProxy commands again the service appeared under system settings of the REPORT SERVER.