Resolved–SQL 2012 PowerPivot install on SharePoint 2013 “SharePoint installation requirements for Po

So I have the brand spanking new version of SharePoint downloaded from MSDN, this is the RTM and I am super excited.. Oh, look here, the new SQL 2012 as well.. if only we could have Server 2012 as well.. Imagine that, the entire bunch just lying around on our server and I am tasked to do a showcase on what Enterprise SQL server is good for… POWERVIEW!!!Just a note: If you encounter this, assume that your SQL 2012 media is outdated and start downloading the latest version.. you know, just in case. Why? Because if you encounter this error, your media is old. Ask yourself “If it does not pick up SharePoint 2013 now, how will I run the PowerPivot Configuration Tool for SharePoint 2013 after this..?” If you want PowerView on SharePoint 2013 you will need  SQL Server 2012 SP1 CTP It will not work on the  RTM Evaluation Edition – 11.0.2100.60 How will you know? Under the installation media there is a file called.. wait for it.. Mediainfo, in it you will find: <Property Id=”BaselineVersion” Value=”11.0.2100.60″ />So while installing I come across this teeny tiny little error: 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. But I just did! Didn’t I?

image

It would seem that SQL server is looking for SharePoint 2010 installed, which is great, but I have 2013, so what to do? Well it seems it is simply a registry issue, so you can override it with the following registry entries:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0]
"SharePoint"="Installed"
"Location"="C:\\Program Files\\Common Files\\Microsoft Shared\\Web Server Extensions\\14\\"
"UsingUIInstallMode"=dword:00000001
"BinPath"="C:\\Program Files\\Microsoft Office\\Office14\\"
"ServerId"="f44ebd3f-4855-4765-8223-c015258194ad"
"Version"="14.0.0.6112"
"AdminServerLocation"="1227812612"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0\Secure\ConfigDB]
"dsn"="ok"
"Id"="ef16bb8a-3385-45fe-b53a-9dee7a3c15f5"

[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"
"{90140000-110F-0000-1000-0000000FF1CE}"="ED21638F-97FF-4A65-AD9B-6889B93065E2"

Create a .reg file and run, if you feel up for it.

Worked for me.

And when in doubt, make sure you have the most up to date media available.

Adrian

0 views0 comments