While attempting to install PowerPivot SQL2012 for a new SharePoint 2013 farm I came across this interesting error. Basically, PowerPivot checks for SharePoint 2010 because that’s what existed when the SQL2012 product shipped. However, we now have SharePoint 2013 version 15.0 to think about. The workaround detailed below adds a few placeholder registry keys in order bypass the SQL rule check and keep moving forward.
Rule “SharePoint installation requirements for PowerPivot for SharePoint” failed. SharePoint Server 2010 is not installed on this computer. Please install SharePoint before you install PowerPivot for SharePoint.
Just save the below text as a .REG file and double click. Hope that helps!
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0]
"SharePoint"="Installed"
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0\InstalledLanguages]
"1033"="15.0.4420.1017"
[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\Secure\ConfigDB]
"dsn"="OK"
[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\WSS\InstalledProducts]
"{90140000-1014-0000-1000-0000000FF1CE}"="BEED1F75-C398-4447-AEF1-E66E1F0DF91E"
"{90140000-110D-0000-1000-0000000FF1CE}"="D5595F62-449B-4061-B0B2-0CBAD410BB51"
"{90140000-112D-0000-1000-0000000FF1CE}"="926E4E17-087B-47D1-8BD7-91A394BC6196"
