Passwords 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
"Dave" <mine@.none.com> wrote in message
news:foam11pg95kfd57jefn88eou8o160kc3r1@.4ax.com...
> 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...
"Dave" <mine@.none.com> wrote in message
news:foam11pg95kfd57jefn88eou8o160kc3r1@.4ax.com...
> 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.
"Dave" <mine@.none.com> wrote in message
news:foam11pg95kfd57jefn88eou8o160kc3r1@.4ax.com...
> 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
"Al" <al@.nospam.com> wrote in message
news:OBnYmUVGFHA.1836@.tk2msftngp13.phx.gbl...
> 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.
> "Dave" <mine@.none.com> wrote in message
> news:foam11pg95kfd57jefn88eou8o160kc3r1@.4ax.com...
>