Friday, 31 March 2017

Error configuring PowerPivot 2012 on SharePoint 2013. New-PowerPivotSystemServiceInstance - The PowerPivot System Service does not exist in the farm


This is the PowerShell output if I run that command on its own:

PS C:\Users\sharepointsetup> New-PowerPivotSystemServiceInstance -Provision:$true New-PowerPivotSystemServiceInstance : The PowerPivot System Service does not exist in the farm. At line:1 char:1 + New-PowerPivotSystemServiceInstance -Provision:$true + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidData: (Microsoft.Analy...ServiceInstance: NewPowerPivotMidTierServiceInstance) [New-PowerPivotSystemServiceInstance] , GeminiException + FullyQualifiedErrorId : Microsoft.AnalysisServices.SPAddin.PowerShell.NewPowerPivotMidTierServiceInstance
Solution:
Configure Local Service Instances,
  • -Register PowerPivot System Services on local server
  • -Cannot create the service instances because the parent service doesnot exist
  • -Prerequisites check for execution filed. Farm is not in a valid state. in powerpivot by doing
Before installing or trying to install powerpivot in sharepoint 2013--
create secure store service key for powerpivot -- by going to CentralAdmin>secure store service>New and give name to target application ID-Powerpivotunattendedaccount, display name- Power pivot unattended account data refresh, contact email address, select none for target application name and click next. In the 1st field name type- username and field type a windows username, 2nd field type as - password and field type windows password and click next and provide admin account username name. Now go to download spPowerPivot installer Here and install the installer and open the power pivot configuration tool and follow the instructions.
or if you are using sql server 2012 standard version after installing the sp installer go to tools in the sql server 2012 and click configure powerpivot and follow instructions.

No comments:

Post a Comment

Create Sites, Lists and Libraries in SharePoint 2016

Source:YouTube