view SQL cluster global group

is it possible to view the global domain groups that were defined to run the sql cluster. If so, how and where can I view them? I wanted to know the global group that the account running sql services is a member of.

The problem I have is the account running sql services is a member of two global groups, so I need to know which global group is defined to run sql cluster
LVL 1
sqlserverdbaAsked:
Who is Participating?
 
Marten RuneConnect With a Mentor SQL Expert/Infrastructure ArchitectCommented:
I don't think thats possible. But you can see under services what account (not group) is used for microsoft clustering services, and also for sql server service.

A longshot is to see if any of these groups has been added to the sql servers security, if so this group ought to be it.

Otherwise, whats left is to do some detective work!

Regards Marten
0
 
65tdConnect With a Mentor Commented:
Domain groups for SQL are manual created (for clusters).
Hopefully the groups were setup with some intuition.  Otherwise I would concur with Marten's comment.

http://technet.microsoft.com/en-us/library/ms345196(SQL.90).aspx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.