Skip Ribbon Commands
Skip to main content

KnowPoint

:

Chris McNulty > KnowPoint > Posts > Microsoft SQL 2012 BI Support for SharePoint 2013 – Double Denali
August 07
Microsoft SQL 2012 BI Support for SharePoint 2013 – Double Denali

Ok, it's not really called Double Denali. MC Kinley, in the house! No?

But if you're expecting that since SQL Server 2012 is new (just released earlier this year) it should already support SharePoint 2013? Yes, and no.

  • Yes, it can be made to support SharePoint 2013.
  • No, it doesn't do that out of the box.

To do that, you need the less attractively named SQL Server 2012 SP1 CTP3. You can download this from: http://www.microsoft.com/en-us/download/details.aspx?id=30375 It's a big download, about 4.8GN for the ISO. Detailed instructions on the installation order and proper sequence are also posted at http://msdn.microsoft.com/en-us/library/jj200106.aspx and at http://msdn.microsoft.com/en-us/library/jj218795.aspx

The key oversimplified sequence:

  • Install and configure SharePoint 2013 (e.g. the gray wizard, aka SharePoint 20103 Product Configuration wizard)
  • Enable Excel Services
  • Install Analysis Services in SharePoint mode.
  • Configure Excel Services to use the new AS instance for SharePoint
  • Install Reporting Services in SharePoint mode and the RS add-in for SharePoint
  • Configure the Reporting Services SharePoint service and an SSA

 

I've already written about the headaches of doing a database attach for Power Pivot v1 based SharePoint 20910 content databases. Here's Microsoft's documented approach. I expect this to work just fine if the source is Power Pivot v2. Will test against Power Pivot v1 to see if this sequence allows you to perform Site Collection Upgrade (the new "Visual Upgrade") at the end.

  • Install a new SharePoint Server 2013 farm.
  • Complete a SharePoint database-attach upgrade, and migrate your Power Pivot related content databases to the SharePoint 2013 farm.
  • Install an instance of SQL Server Analysis Services in SharePoint mode.
  • Install the Power Pivot for SharePoint 2013 installation package spPowerPivot.msi on each server in the SharePoint farm.
  • In SharePoint 2013 Central Administration, configure Excel Services to use the Analysis Services SharePoint mode server created in the previous step.
  • Configure the Power Pivot service application to migrate refresh schedules.

There's also some information that if you directly jump ahead to the RS install without the Power Pivot pieces, you still may need to separately reinstall the SQL Server 2012 SP1 Feature Pack for Power View support. And that download isn't available yet.

Finally, PLEASE REMEMEBER – this is preview, beta-grade software. Do not try this out on production.

More to come!

 

Comments

There are no comments for this post.