Forum Discussion
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 SQL Server Reporting Services Service is not listed "Manage Services On Server".
I am using Sharepoint 2016 ENT + SQL 2016 ENT,
Print screean attached,
"P" - is the primary
"S" - is the secondary
When the primary server is down the SQL Server Reporting Services not working,
Thanks
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
- Yep, install SSRS on the second SharePoint server, run Install-SPRSService/Proxy, start the SSRS service instance.
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.InstallReportingServiceAny ideas?
