title: Cant connect to analysis services via excel
body: <p>I have an analysis services cube in SQL server 2005 which I'm connecting to via an excel front end.</p>
  
  <p>When I connect via one user its fine, but when I log on to the same machine as another user I get an error in my excel spreadhseet - "user...does not have access to the [Cube name] database"</p>
  
  <p>Obviously the first user has the correct permissions, but how do I set up analysis services to allow other users to join the party?</p>