 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Clustering / March 2005Passwords for cluster and servers
I have a 2 node cluster running Win2000 enterprise and MS clustering. Also SQL server. Would there be a problem using the same domain password for SQL and for the clustering service? I thought I read that there may be a problem but I don't recall where it read it. Thanks for any help. I'm using one domain account for SQL and Cluster services and I have no problems. Ayad Shammout SR.DBA/Analyst Caregroup IS > I have a 2 node cluster running Win2000 enterprise and MS clustering. > Also SQL server. Would there be a problem using the same domain > password for SQL and for the clustering service? I thought I read > that there may be a problem but I don't recall where it read it. > > Thanks for any help. im using 1 account for cluster and sql services, havent had any issues to date.... > I have a 2 node cluster running Win2000 enterprise and MS clustering. > Also SQL server. Would there be a problem using the same domain > password for SQL and for the clustering service? I thought I read > that there may be a problem but I don't recall where it read it. > > Thanks for any help. I don't think there's a functional issue, but if you use the same account, the domain admins will be able to log on to SQL Server as an SA. If you use separate accounts, you can set the cluster account to have minimal SQL privledges so the keep alive for SQL will work and not give the domain admins sa access to the database. In a small environment using the same account is probably no big deal, but in a larger enterprise it could be. > I have a 2 node cluster running Win2000 enterprise and MS clustering. > Also SQL server. Would there be a problem using the same domain > password for SQL and for the clustering service? I thought I read > that there may be a problem but I don't recall where it read it. > > Thanks for any help. If you do not want the domain admins to be admins of sql then remove buildin/admin group, create your own group "Sql Admins" add users who need admin to sql and add that. apart for that , using same cluster and sql login is not a prob > I don't think there's a functional issue, but if you use the same account, > the domain admins will be able to log on to SQL Server as an SA. If you use [quoted text clipped - 9 lines] > > > > Thanks for any help. |
Reply to this Message |
 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.