Perms, perms, perms (or deploying BAM activities with cubes when Analysis Services runs as a different service account)

This will be the first of a two part blog post about real-world adventures in BAM deployment.  As time has proven over and over, permissions and environment variables tend to trip even the most careful planners up when deploying artifacts to non-development environments.   I have developed a BAM solution for a customer which has been…

0

The right tool for the right job

Here’s a little gem I discovered today.  I am running down a permissions issue with BAM and SQL Server Analysis Services.  On my local dev box, I wanted to fully emulate the permissions from my full-blown dev environment, so in my Services MMC, I changed the Analysis Services log on account from LocalSystem to the…

0