Hi,

I had installed SQL Server 2012 PowerPivot on WFE and App Server. This is test farm with 1 WFE and 1 APP and 1 SQL Server.

However, we had a heap of issues with Windows Claims Authentication and PowerPivot - issues were raised with "unable to make a connection to EntityDataSource" . Now we uninstalled the PowerPivot and Reporting Services features and wanted to install with the SQL Server 2012 with SP2. Originally SP2 was installed seperately and we had read there had been issues.

Anyway on trying to install the features again using the SQL Server 2012 with SP2 iso I get 

Could not open key UNKNOWN\Components

I don't want to start deleting or changing permissions as quite dodgey. What is this key for anyway and how do I resolve my issue.

Thanks.

John.

Hi John,

Did you meet the error message during the process of configuring the PowerPivot for SharePoint?

If yes, I suppose that the existing features or components have not been uninstalled completely.

I recommend to delete the two keys left when uninstalling the PowerPivot and please make a copy of the registry keys before you delete the two keys:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\15.0\WSS\ServiceProxies\Microsoft.AnalysisServices.Sharepoint.Integration.MidTierServiceProxy

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\15.0\WSS\ServiceProxies\Microsoft.AnalysisServices.Sharepoint.Integration.MidTierServicea

Please check the steps in the link below to see if there anything wrong when you uninstalling the PowerPivot and then re-install it to see how it works:

https://technet.microsoft.com/en-us/library/ff487866(v=sql.110).aspx

Thanks,

Victoria

Forum Support

Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

Hi John,

How is everything going?

Is there anything else that I can help?

If you have any questions, please feel free to let me know.

Thanks,

Victoria

Forum Support

Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.