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

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

Trevor Seward

MVP

Sep 13, 2017

Then either there is an issue with that server accessing the Config db or you're not running PowerShell as admin.

Sagi Lavian
Copper Contributor
Sep 24, 2017
Hi Trevor,

After install spPowerPivot.msi I managed to install SSRS service successfully,
Thank you for your support!

Forum Discussion

Sharepoint 2016 - SQL Server Reporting Services Service

Resources