Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Clustering / June 2005

Tip: Looking for answers? Try searching our database.

cluster manager and sql authentication

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Neil W. - 23 Jun 2005 20:12 GMT
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 - 23 Jun 2005 20:18 GMT
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

>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
[quoted text clipped - 4 lines]
>
> Neil
Neil W. - 23 Jun 2005 21:04 GMT
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?

______________________

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

>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
[quoted text clipped - 4 lines]
>
> Neil
Geoff N. Hiten - 24 Jun 2005 02:05 GMT
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

> 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
[quoted text clipped - 20 lines]
>>
>> Neil
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.