none
SSRS RRS feed

  • Question

  • I have installed ssrs in sql server

    and install add in in sp

    but ssrs service application doesn't show in CA

    am I missing something?

    Monday, April 30, 2018 12:27 AM

All replies

  • Hi,

    It seems that the issue is caused by that SSRS Shared Service did not get registered with SharePoint correctly at the time of installation.

    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:

    Add-PSSnapin Microsoft.SharePoint.PowerShell

    Install-SPRSService

    Install-SPRSServiceProxy

    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.

    Best Regards,

    Dean Wang


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.


    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Tuesday, May 1, 2018 4:48 AM
    Moderator