Re: Service Accounts on SQL Server, Best Practices

From: Uttam Parui[MS] (uttamkp_at_online.microsoft.com)
Date: 07/02/04


Date: Fri, 02 Jul 2004 20:51:24 GMT

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



Relevant Pages

  • Re: SQL 2000 Problems on One Node Only
    ... Since both the Cluster and SQL Server service accounts are Local ... how is SQL Server set up to allow Local Administrators to log into SQL ...
    (microsoft.public.sqlserver.clustering)
  • Re: Error 42d during Fail Over SQL 2000 Enterprise in a Server 2003 Ent. Cluster
    ... a valid login that you add back the service account that operates the ... Cluster service. ... Microsoft SQL Server MVP ... Administrator account, have re-entered the username and password 3+ ...
    (microsoft.public.sqlserver.clustering)
  • Online Pending status in cluster
    ... I have SQL Server 2k Enterprise Edition, sp3 installed on a cluster. ... When SQL Server first installs, everything looks fine in the cluster ... the status of the services in the cluster administrator goes from ...
    (microsoft.public.sqlserver.server)
  • Re: Sql server 2005 clustered service group
    ... I always do this as part of cluster setup (prepoulate the groups with the ... Jasper Smith (SQL Server MVP) ... add accounts to the domain groups. ... needs rights to add the service accounts to the domain group ...
    (microsoft.public.sqlserver.setup)
  • Re: Cluster Taken Offline Accidentally
    ... Can you use RDP to connect to one of the nodes and run Cluster Admin from ... SQL Server MVP ... taken offline and neither node can connect to it, since the IP, name, a Q ... Administrator to turn them back online, ...
    (microsoft.public.sqlserver.clustering)