FIXED–SharePoint 2010 SP1 is not installed on this computer. You must apply SP1 before using a SQL Server 2012

Today I came across an error when attempting to run the “PowerPivot Configuration Tool” for SQL 2012 Denali. The strange part is that I had applied both SP1 and June 20120 CU to SharePoint 2010. The farm build number was clearly shown in PowerShell as 14.0.6123.5000. After running PROCMON to watch the read/write activity for file and registry I believe I narrowed it down to a REGKEY which still showed the old RTM version number (14.0.4763.1000) for some reason. For this install I slipstreamed the SP1 and June CU (in that order) to the Updates subfolder of the install media. The patching was successful and I even ran both the Configuration Wizard and “psconfig -cmd upgrade -inplace b2b –force” to confirm everything was upgraded OK.

Error Message

SharePoint 2010 SP1 is not installed on this computer. You must apply SP1 before using a SQL Server 2012 instance of the Database Engine as the farm’s database server.

Suspected Root Cause

An old version number somewhere in the registry. Maybe not correctly updated by the slipstream or June CU to reflect the current farm build number.

Workaround

Open SharePoint 2010 Management Shell
Run “(get-spfarm).buildversion”
Modify the registry key “HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice Server14.0BuildVersion” to match the PowerShell version. For me that should be “14.0.6123.5000” The bad value I saw in the registry was “14.0.4763.1000” (RTM version, very old)
Run PowerPivot Configuration Tool again

PowerPivot Log Detail

07/07/12 20:12:13:9051    Log    Verbose:    Running function IsSharePointSP1Installed function to check whether SharePoint SP1 is install
07/07/12 20:12:13:9051    Error    High:    SharePoint 2010 SP1 is not installed on this computer. You must apply SP1 before using a SQL Server 2012 instance of the Database Engine as the farm’s database server.
07/07/12 20:12:13:9051    Log    Verbose:    SharePointEnvCheck;.NeedsExecute
07/07/12 20:12:13:9051    Log    Verbose:    SharePointEnvCheck;.NeedsExecute(True)
07/07/12 20:12:13:9403    Log    Verbose:    Finished running validation
07/07/12 20:12:13:9422    Error    High:    System validation error:
07/07/12 20:12:13:9432    Error    High:    SharePoint 2010 SP1 is not installed on this computer. You must apply SP1 before using a SQL Server 2012 instance of the Database Engine as the farm’s database server.

Screenshots