Cannot install SQL Server (2012) PowerPivot for SharePoint, always fails Sharepoint Version check

Question

Trying to install a fresh install of Sharepoint 2010 (w/ SP1) Enterprise Evaluation and SQL Server 2012 PowerPivot for Sharepoint.

The prerequisites clearly show that Sharepoint 2010 SP1 is needed, which we have installed. However after when trying to install the SQL Server portion we consistently fail the rule SharePoint version requirement for PowerPivot for SharePoint' validation in theSQL Server` install process.

It seems the Evaluation version of Sharepoint EE 2010 does not put the correct version # in the registry and thus it causes the install to fail. However we are not ready to purchase a license without evaluating this tool to see if it meets our needs...

Here is the process we are following:

1. install Sharepoint 2010
2. install Sharepoint 2010 SP1
3. install SQL Server 2012 PowerPivot for SharePoint

Here is a screen shot of the error and the log file error. We are completely stuck at this point, anyone run into this before?

EDIT

This Article mentions an issue with the eval version of Sharepoint 2010 not correctly inserting the version into the registry but it does not mention how to fix this or work around..... if this helps anyone...

Answer 1

I solved this by copying Registry Keys from another machine running SharePoint 2010 Enterprise.

I used Process Monitor from SysInternals to identify the missing keys:

The contents of the resultant exported file are unfortunately too large to paste into this answer, but you can go into RegEdit on a SharePoint 2010 machine and export the following:

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0\WSS]

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0\Secure]

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0\WSS\InstalledProducts]

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0\Secure\ConfigDB]

[Disclaimer: I think the required registry file would be quite small, however I do not have time to refine it. You could also just export the whole \14.0\ key]