Forum Discussion

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

jcgonzalezmartin

MVP

Sep 11, 2017

My understanding here is that you need to follow the same deployments steps you did for the first server also in the second one...tagging here Trevor Seward that will provide more accurate information

MVP

Sep 11, 2017

Yep, install SSRS on the second SharePoint server, run Install-SPRSService/Proxy, start the SSRS service instance.

Sagi Lavian
Copper Contributor
Sep 11, 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
  MVP
  Sep 11, 2017
  That means you haven't installed SSRS and/or the SSRS addin properly.
  - Sagi Lavian
    Copper Contributor
    Sep 12, 2017
    I uninstall and install the SSRS addin again but the same error :(

Resources