Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Security groups not working in Analysis Services (2008) Expand / Collapse
Posted Thursday, December 26, 2013 4:39 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, September 27, 2016 2:08 PM
Points: 587, Visits: 827
Greetings all!

So I have a Windows Domain Security Group (yes it is in active directory and all that jazz). When I add it to a role (the role functions as well, I have tested that independently) it does not allow members of that security group to access the cube data.

I have read quite a lot of literature online regarding setting up security groups in SSAS cubes, and much of it seems pretty straightforward and simple. However, I must be missing something somewhere :).

Is there something specific I can check to see why this is not allowing users to connect?

Link to my blog
Post #1526062
Posted Friday, January 10, 2014 11:21 AM


Group: General Forum Members
Last Login: Monday, July 28, 2014 7:12 PM
Points: 2,148, Visits: 487
By default SSAS roles are not granted cube access. You must explicity grant privileges to that role you created. Have you done that yet?
Post #1529913
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse