Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Over the past several months I have been working with customers and setting up a number of custom demos for SharePoint 2010 and PowerPivot. As most of you that have done this already have discovered there is a very specific set of steps that need to be executed in the exact order for this to be successful. Following these steps generally meant you had SharePoint\PowerPivot\SQL on a single machine (physical or virtual).
Today I found a tremendous white paper to help move from a single server to what I will “normal” or a “typical” SharePoint multi-server deployment. The white paper, from the SQL CAT team, can be found here.
It is worth noting that if you are now going to deploy PowerPivot to more than a handful of users it is my opinion that you should start with a multi-server deployment. To ensure you get there if possible I would follow the instructions for a single server deployment and then confirm it is working as expected. Then I would follow the instructions for moving that to a multi-server deployment.
PROPS to the SQL CAT team!!