Solved

view SQL cluster global group

Posted on 2011-09-19
2
242 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 150 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 100 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
OPENDATASOURCE 8 40
Get row count of current SQL query 8 55
SQL Backup skipping a few tables 7 43
Help with SQL - TOP 10 by date and by group 13 39
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

770 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