Your Take: Choosing the PWA Administrator Account during provisioning

[gojackets5]

Concerning this blog post - http://www.epmfaq.com/ssanderlin/pro...-it-afterwards

I was experiencing trouble which this helped to resolve. Basically, I provisioned PWA with my own acct instead of the Service Account. When I would go to build an OLAP Cube, I was getting the error:

[I]DATE/TIME[/i] Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server dalacctlib. Error: Your permissions on the server computer do not allow you to administer this Analysis server.

I couldn't find anything anywhere on the 'net with a resolution, but I finally figured it out. Basically, the OLAP Cube build process is run by the SSP Service Acct, but it wasn't an admin in PWA since I provisioned PWA with my own account. So once I added the SSP acct as an Administrator in PWA, all was well. Moral of the story: Do what Steve recommends in this blog post and provision PWA using the Service Account, not your own!