INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Granting cube access to a Windows group

Granting cube access to a Windows group

(OP)
I am very new to SQL BI – so please bear with me ... I am trying to give a Windows group access to a cube I created in SSAS.

I created a role in BIDS for my SSAS project, but could not find where I give the Windows group access to my cube. Thinking I created the role in the wrong place, I went to Management Studio and connected to my Analysis Server. I again created a role that I wanted to assign my Windows group to ... but again, I don't see how I can assign the Windows group access to the cube. Oddly enough, I cannot see the role I created in BIDS in Management Studio, or vice versa.

So, I have two questions: 1 – How do I give a Windows group permissions to connect to my cube (via Excel); and 2 – why does the role I created in BIDS not show up in Management Studio under my Analysis Server; they seem totally independent of one another. I assumed any role created in BIDS would inherently show up in Management Studio (sorry - I really am a newbie!).

Thanks in advance for your assistance! ... oh, I'm using SQL '08.

RE: Granting cube access to a Windows group

create your role in BIDS then open this role in BIDS and you will be able to edit the various pieces of the role including members.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
                           - Daffy Duck

RE: Granting cube access to a Windows group

(OP)
Thank you for your reply. I must have something else set up wrong then because I still can not create a connection to my cube from Excel. I noticed on a sample that in the SQL Server Config Manager, the Analysis Services was set up to Log On as Local Systems, I have mine set to Log On as Administrator. Could this have any effect on connecting to the cube? Or does my Windows group have to be part of one of the SQL Server groups I see listed? Thank you so much for your time!

RE: Granting cube access to a Windows group

I believe your Users Windows Domain needs to be the same as that in which SSAS is running.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
                           - Daffy Duck

RE: Granting cube access to a Windows group

(OP)
Being a little analyst who was recently drafted (oh, I mean volunteered) into this DBA position, I've had to ask our network guy what you mean, he confirmed my users and group setup.

BUT as it turns out, we recently purchased a new server for our SQL '08 and the server's fire wall was stopping my pc from connecting to the data.

Nope – drafted is the word I want to use! :-)

Thanks for all your assistance!!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close