Forum Discussion

Sagi Lavian's avatar
Sagi Lavian
Copper Contributor
Sep 11, 2017

Sharepoint 2016 - SQL Server Reporting Services Service

Hi,   I would like to know how to add SQL Server Reporting Services Service to second Sahrepoint server that I join to farm, on the first server I install the service but in the second server the S...
sharepoint server
Trevor Seward's avatar
Trevor Seward
MVP
Sep 11, 2017
Yep, install SSRS on the second SharePoint server, run Install-SPRSService/Proxy, start the SSRS service instance.
Sagi Lavian's avatar
Sagi Lavian
Copper Contributor
Sep 12, 2017

Hi Trevor,

 

I am getting this error when running Install-SPRSService:

Install-SPRSService : Failed to call GetTypes on assembly
Microsoft.AnalysisServices.SPAddin16, Version=13.0.0.0, Culture=neutral,
PublicKeyToken=89845dcd8080cc91. Could not load file or assembly
'Microsoft.AnalysisServices.SPClient16, Version=13.0.0.0, Culture=neutral,
PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot
find the file specified.
At line:1 char:1
+ Install-SPRSService
+ ~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidData: (Microsoft.Repor...eportingService:
   InstallReportingService) [Install-SPRSService], SPUpgradeException
    + FullyQualifiedErrorId : Microsoft.ReportingServices.SharePoint.PowerShel
   l.InstallReportingService

 

Any ideas?

 

  • Trevor Seward's avatar
    Trevor Seward
    MVP
    Sep 12, 2017

    That means you haven't installed SSRS and/or the SSRS addin properly.

    • Sagi Lavian's avatar
      Sagi Lavian
      Copper Contributor
      Sep 12, 2017

      I uninstall and install the SSRS addin again but the same error :(

      • Sagi Lavian's avatar
        Sagi Lavian
        Copper Contributor
        Sep 13, 2017

        I have some progress,

        But now I am getting this error:

        The local farm is not accessible. Cmdlets with FeatureDependencyId are not regis
        tered.
        PS C:\Users\spfarm> Install-SPRSService
        Install-SPRSService : Cannot access the local farm. Verify that the local farm
        is properly configured, currently available, and that you have the appropriate
        permissions to access the database before trying again.
        At line:1 char:1
        + Install-SPRSService
        + ~~~~~~~~~~~~~~~~~~~
            + CategoryInfo          : InvalidData: (Microsoft.Repor...eportingService:
           InstallReportingService) [Install-SPRSService], SPCmdletException
            + FullyQualifiedErrorId : Microsoft.ReportingServices.SharePoint.PowerShel
           l.InstallReportingService

Resources