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

sql server clustering : cluster manager and sql authentication


Neil W.
6/23/2005 12:00:00 AM
I am a newbie to clustering so I hope this makes sense. Does the Cluster
Manager have to be in the sysadmin role? If not, what are the roles that it
does require?

Thanks for any guidance.

Neil


Geoff N. Hiten
6/23/2005 12:00:00 AM
The Cluster Service must be a local admin on each server. The Cluster
Manager application is an MMC snap-in and can run wherever. Specific
cluster functions may need specific security role membership. I generally
give the person who administers a Cluster local administrator rights on each
node.

Geoff N. Hiten
Microsoft SQL Server MVP


[quoted text, click to view]

Neil W.
6/23/2005 4:04:10 PM
Thanks for the reply. The cluster manager appears to login with Windows
login: domain\Cluster. However, I cannot locate a domain user or a local
user named "Cluster". Am I missing something?

______________________

[quoted text, click to view]
The Cluster Service must be a local admin on each server. The Cluster
Manager application is an MMC snap-in and can run wherever. Specific
cluster functions may need specific security role membership. I generally
give the person who administers a Cluster local administrator rights on each
node.

Geoff N. Hiten
Microsoft SQL Server MVP


[quoted text, click to view]


Geoff N. Hiten
6/23/2005 9:05:19 PM
Are you sure? The cluster service account should be a domain-level account
with local admin rights on each node. There should be a domain account that
matches the service account.

Geoff N. Hiten
Microsoft SQL Server MVP

[quoted text, click to view]

AddThis Social Bookmark Button