Cannot Create the service instance because the parent Service does not exist

Question

I have been trying to install powerpivot for SharePoint Feature in our SharePoint 2013 Enterprise Farm. I installed SQl for powerpivot instance called "POWERPIVOT" ssas instance in SharePoint App Server. It completed no issues. Then i started PowerPivot Config Window for SharePoint 2013, thats where i get the error:

"Register Powerpivot System Service on Local Server"

"Cannot create the service instance because the parent Service does not exist."

"Prerequisite check for execution failed. Farm is not in a valid state."

Then i checked my server this is what i found:

I have Powerpivot Services Working Properly, it is in running state.

Service Account for the instance is not local or Network Account it is FQDN Account.

So in this case what is the config wizard talking about? MSFT please show me some insight?

I then individually ran the script "

New-PowerPivotSystemServiceInstance -Provision:$true

This is what i got:

I dont get it, please help?

Answer 1

Hi octopus123,

As your description, you got an error when you ran PowerPivot Configuration tool for SharePoint.

Please check if your SharePoint meets the Software Requirements, for example,  Excel Services, Secure Store Service.

More information, please refer to:
https://technet.microsoft.com/en-us/library/ee210708(v=sql.110).aspx

https://technet.microsoft.com/en-us/library/ee210708.aspx#bkmk_config

There are some similar threads for your reference:

http://skezonsharepoint.blogspot.com/2013/11/installing-powerpivot-for-sql-2012-on.html

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/288a3936-08f5-4e9d-9b79-83d5aebdd5f5/cannot-create-the-service-instance-because-the-parent-service-does-not-exist?forum=sqlkjpowerpivotforexcel

In addition, Microsoft has a dedicated forum for PowerPviot called "SQL Server PowerPivot for SharePoint", I suggest you create a new thread on this forum. The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

SQL Server PowerPivot for SharePoint:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlkjpowerpointforsharepoint&filter=alltypes&sort=lastpostdesc

Thanks,

Wendy

---

TechNet Community Support
Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact [e-mail].

Answer 2

I tried all of your suggestions, none of them seems to work, i dont how to make Sharepoint recognize that there exists a POWERPIVOT instance in local server?

Answer 3

Hi octopus123,

Please ran the PowerPivot config tool to remove all features, services, etc.  Then re-ran the tool.

A similar thread for your reference:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/07326884-fef1-4e07-9d26-897bffeb8c6b/unable-to-get-powerpivot-2012-to-register-service-with-sharepoint

Like I said in my first reply, Microsoft has a dedicated forum for PowerPviot called "SQL Server PowerPivot for SharePoint", if the above doesn't work, I suggest you create a new thread on this forum.

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

SQL Server PowerPivot for SharePoint:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlkjpowerpointforsharepoint&filter=alltypes&sort=lastpostdesc

Thanks,

Wendy

---

TechNet Community Support
Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact [e-mail].

Answer 4

Re-run setup again under farm admin account.