dbTalk Databases Forums  

Service Accounts on SQL Server, Best Practices

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Service Accounts on SQL Server, Best Practices in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
John
 
Posts: n/a

Default Service Accounts on SQL Server, Best Practices - 06-28-2004 , 05:37 AM






MS SQLSever service accounts should not be members of the local
Administrator or Domain Admins groups. Is this also troug for SQL
Server Cluster?

Many Thanks
John

Reply With Quote
  #2  
Old   
Rodney R. Fournier [MVP]
 
Posts: n/a

Default Re: Service Accounts on SQL Server, Best Practices - 06-28-2004 , 06:52 AM






See the SQL 2000 section of:

http://support.microsoft.com/default...b;en-us;239885

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering

"John" <johnx02 (AT) hotmail (DOT) com> wrote

Quote:
MS SQLSever service accounts should not be members of the local
Administrator or Domain Admins groups. Is this also troug for SQL
Server Cluster?

Many Thanks
John



Reply With Quote
  #3  
Old   
Uttam Parui[MS]
 
Posts: n/a

Default Re: Service Accounts on SQL Server, Best Practices - 07-02-2004 , 03:51 PM



Thats true. SQL Server and SQL Server Agent service accounts do not need to be a local administrator or domain administrator for Failover Clustering on Windows 2000
or 2003 server clusters.

Note: If the service account for SQL Server is not an administrator in a cluster, the administrative shares cannot be deleted on any nodes of the cluster. The administrative
shares must be available in a cluster for SQL Server to function.

Best Regards,

Uttam Parui
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way
to do this is to visit the following websites: http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx



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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.