I do not see the SSRS Shared Service in SharePoint CA after installing SSRS "Denali" CTP SharePoint mode

After successfully installing the latest SSRS "Denali" CTP SharePoint mode Service and SSRS "Denali" Add-in for SharePoint 2010, if you do not see "SQL Server Reporting Services"  in the Service or Service Application list:

• SharePoint 2010 Central Admin -> "Application Management" -> "Manage Services on Server" OR
• SharePoint 2010 Central Admin -> "Application Management" -> "Manages Service Applications" -> Click on "New" menu

Then it is likely the SSRS Shared Service did not get registered with SharePoint correctly at the time of installation. This state is also expected behavior if SSRS SharePoint mode was installed before the SharePoint installation.

Work Around

To register and start the SSRS SharPoint Service, complete the following:

1. On the computer that runs SharePoint 2010 Central Administration:
   1. Open a PowerShell command prompt with administrator privileges. Right click the icon  and click, "Run As Administrator". Run the following cmdlets from the shell:
      1. Add-PSSnapin Microsoft.SharePoint.PowerShell
      2. Install-SPRSService
      3. Install-SPRSServiceProxy
      4. Get-SPServiceInstance -all |where {$_.TypeName -like "SQL Server Reporting*"} | Start-SPServiceInstance
2. Verify the SQL Server Reporting Services Service Instance shows status as "Started" on the SharePoint 2010 Central Admin -> "Application Management" -> "Manage Services on Server" page.

HTH

RegisterSSRSInstance.ps1

Comments

• Anonymous
  February 10, 2012
  You are missing a fix for the: "You do not see the SQL Server Reporting Services service in SharePoint CA after installing SSRS "Denali" CTP in SharePoint mode."

• Restart IIS on the Central Administration host server. (Especially important in multi-server farm situation)  I ran the powershell commands but they didn't actually make it show up in the CA.