Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
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: Thursday, June 19, 2014 6:36 PM
Points: 586, Visits: 822
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 http://notyelf.com/
Post #1526062
Posted Friday, January 10, 2014 11:21 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, March 27, 2014 2:39 PM
Points: 2,141, Visits: 486
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