Groups | Blog | Home
all groups > sql server clustering > june 2004 >

sql server clustering : Service Accounts on SQL Server, Best Practices


johnx02 NO[at]SPAM hotmail.com
6/28/2004 3:37:16 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
Rodney R. Fournier [MVP]
6/28/2004 6:52:15 AM
See the SQL 2000 section of:

http://support.microsoft.com/default.aspx?scid=kb;en-us;239885

Cheers,

Rod

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

[quoted text, click to view]

uttamkp NO[at]SPAM online.microsoft.com
7/2/2004 8:51:24 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

AddThis Social Bookmark Button