SSAS permission issues
Posted on 2008-09-29
We are running SQL Server 2K5 SP2.
I have a user who needs to be able to access/create/modify cubes/dimensions etc. on our server but is unable to do so. He can connect to SSAS, but once he does none of the databases are listed.
I have even set his domain account up as an admin (every role checked on the server roles list) on the server and he still cannot use analysis services.
As far as I can tell, he has the exact same permissions as me and I can do everything just fine.