Peter Christiansen


I have some troubles connecting to an Analysis service from my client. I can connect, but i can not see any databases. I can connect on the server and see/create database there. But when i try from my client, it says user is not permitted to create object. The object explorer in management studio, the connection icon is white, and not with a green arrow as i think it should be.

I probably just need some generel direction where to look for solving this problem. Thanks.




Re: Connecting to AS2005 via management studio

Deepak Puri


If you're just trying to browse AS 2005 databases from Management Studio, setting "ReadDefinition" permission may help, as discussed in this thread:

cube browsing permissions - what am I doing wrong

...

Adding the Read Definition permission to the database solved my problem -- users can browse cube from SSMS.

...