Trying to get the install of Denali, PowerPivot, Sharepoint in the correct order

Question

As I understand things, it is crucial to install these items in the correct order (and also to defer configuration until the right components are installed). I have done an install of Denali. What's next? I thought that now I install the PowerPivot feature of Denali, no? I thought I saw that as an option before. But now when I fire up the installer again, I seem to be led here:

 

 

 

Is that my next step? Is there a detailed step by step for installing these items in conjunction with each other? Thanks... and I love PowerPivot!

---

-------------- Bill Ross

Answer 1

The following links should help:

* http://denglishbi.wordpress.com/2011/07/22/configuring-sql-server-denali-reporting-services-sharepoint-2010-integration

* http://blogs.msdn.com/b/oneclickbi/archive/2011/07/21/getting-up-and-running-with-sql-server-denali-for-business-intelligence-crescent-and-powerpivot-in-ctp3.aspx

* MSDN Deployment checklist: http://msdn.microsoft.com/en-us/library/hh231687(SQL.110).aspx

 

HTH,
Robert

---

Robert Bruckner   http://blogs.msdn.com/robertbruckner
This posting is provided "AS IS" with no warranties, and confers no rights.

Answer 2

I summarized the helpful article here:

 

As I’ve been able to piece this together, I need to do this:

 

·         Install Sharepoint (Server Farm install, Complete, all components)

·         Install Sharepoint SP1

·         Install Denali (New, Stand-alone – “Perform a new installation of Sql Server” – with defaults, hit next, then choose “Sql Server PowerPivot for SharePoint” with “add the RDBMS Engine” checked)

·         Use PowerPiovt Configuration Tool to “Repair PowerPivot for Sharepoint”

·         Install a new instance of Denali and select “Sql Server Feature Installation” from the “Setup Role” screen [Uncheck SSRS-Native, Distributed Replay Controller and Client)] and during the install of SSAS, choose “Tabular” model rather than “Multidimensionald”

·         Optionally, install another instance of Denali (new instance/features, and choose SSAS and configure this one Multidimensional)

·         Go to Sharepoint Central Administration, select “Manage Service Applications” and select New, then “Sal Server Reporting Services Service Application” and give credentials

 

I got this from http://blogs.msdn.com/b/oneclickbi/archive/2011/07/21/getting-up-and-running-with-sql-server-denali-for-business-intelligence-crescent-and-powerpivot-in-ctp3.aspx

 

Many thanks!

---

-------------- Bill Ross