Torrwin
asked on
SSAS permission issues
Hello,
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.
Any thoughts?
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.
Any thoughts?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.