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

  • Article

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