The correct order to set up a single server PowerPivot installation.
The order in which you install SQL Server 2008 R2, SharePoint 2010, and PowerPivot for SharePoint on a single server currently matters. There is a glitch that occurs when you install some components of SQL Server 2008 R2 prior to installing PowerPivot.
This is the order that works for me:
- Provision a new Windows 2008 SP2 server.
- Add IIS role.
- Make it a domain controller with dcpromo.
- Install SharePoint 2010 prerequisites.
- Install SharePoint 2010, do not check configure at the end.
- Install PowerPivot instance (choose new server) from SQL Server 2008 R2 installation.
Now you may install any other instances of SQL Server 2008 R2.
Here is a link that helped me identify the problem:
About
A Market Street Solutions business intelligence advisory consultant with deep experience in Microsoft and Cognos data warehousing architecture, data modeling, data loading and reporting. Microsoft certified – MCITP, MCT (Microsoft Certified Trainer) - in Business Intelligence and Database Development, Wharton MBA, chess player, dog lover, and husband. I live in Chattanooga, Tennessee, with my wife Jill, son Henry, dogs Bubba and Caesar, and cats Priscilla, Elvis, Prudence and Precious.
Email me, please: will.thrash@marketstreetsolutions.com
Twitter: @willthrash1
Website: Market Street Solutions
-
Recent Comments
-
Archives
- April 2012 (1)
- September 2011 (1)
- April 2011 (1)
- June 2010 (1)
- May 2010 (1)
- April 2010 (1)
- March 2010 (1)
- January 2010 (1)
- December 2009 (1)
- May 2009 (3)
- April 2009 (2)
- March 2009 (5)
-
Categories
-
RSS
Entries RSS
Comments RSS
