Installing and Configuring PowerPivot has been painful for me – Partly because I managed to dive in and not read the readme.txt and release notes ;-)
The three things I did wrong and have learned are:
- “Standalone” SharePoint option is not supported as this uses network service accounts. (see below why)
- Domain accounts are a MUST. No local option (yet)
- You need to login with the service account in “Interactive” MODE.
More tips are on http://powerpivotgeek.com/server-installation/reported-problems/#001 thanks to Dave Wickert.