Windows Vista Tips

Windows Vista Tips > Newsgroups > Windows Server > Clustering > SQL Service account group members?

Reply
Thread Tools Display Modes

SQL Service account group members?

 
 
Jerome G. Pacificar
Guest
Posts: n/a

 
      05-14-2009
Hi,

I have created 4 Domain groups below for SQL Services. What accounts should
be the member of these groups. It is not specified in MSDN and Whitepaper.
IS it service accounts or group of users? Can anybody suggest other
resources aside from Microsoft!?

http://msdn.microsoft.com/en-us/libr...6(SQL.90).aspx


1. SQL Server - SQLAdmins
2. SQL Server Agent - SQLAgentAdmins
3. Full-Text Search - FTSAdmins
4. Analysis Services - AnalysisServicesAdmins

 
Reply With Quote
 
 
 
 
Herbert Zimbizi
Guest
Posts: n/a

 
      05-18-2009
Hie Jerome,
When you install your SQL Server, there are registry keys that created.
Initaially you may start with just two nodes that in the cluster. these will
have access entries in the registry. When you add a third node it will need
access as well to the same registry entries and you will need to add it as
well for you to be able add it as a third node. Rather than create individual
accounts for all nodes the registry, Microsoft is enforcing a system that
forces you to use groups. There will be no more registry changes for each you
add a node to the cluster. Its much more easier and much more neater.

"Jerome G. Pacificar" wrote:

> Hi,
>
> I have created 4 Domain groups below for SQL Services. What accounts should
> be the member of these groups. It is not specified in MSDN and Whitepaper.
> IS it service accounts or group of users? Can anybody suggest other
> resources aside from Microsoft!?
>
> http://msdn.microsoft.com/en-us/libr...6(SQL.90).aspx
>
>
> 1. SQL Server - SQLAdmins
> 2. SQL Server Agent - SQLAgentAdmins
> 3. Full-Text Search - FTSAdmins
> 4. Analysis Services - AnalysisServicesAdmins
>

 
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Allow OU administrative group permissions to modify their accounts and members of their group Marcin Active Directory 0 04-28-2008 01:57 PM
Display members of a group with more than 1500 members Simon G Scripting 3 08-22-2007 02:41 PM
Listing members of Group with >1500 members Umesh Thakur Scripting 4 04-14-2007 12:17 PM
Show group members account location Paul Bergson Scripting 3 08-31-2006 06:59 PM
How to allow a group to reset the passwords of protected group members François Beretti Active Directory 1 05-04-2005 08:36 PM



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59