?
Solved

view SQL cluster global group

Posted on 2011-09-19
2
Medium Priority
?
278 Views
Last Modified: 2012-06-21
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
0
Comment
Question by:sqlserverdba
2 Comments
 
LVL 20

Accepted Solution

by:
Marten Rune earned 600 total points
ID: 36566126
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
 
LVL 22

Assisted Solution

by:65td
65td earned 400 total points
ID: 36569001
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

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are some very powerful Dynamic Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a di…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question