Passwords for cluster and servers

#1

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.

#2

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 (AT) none (DOT) com> wrote

Quote:

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.

#3

im using 1 account for cluster and sql services, havent had any issues to
date....

"Dave" <mine (AT) none (DOT) com> wrote

Quote:

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.

#4

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 (AT) none (DOT) com> wrote

Quote:

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.

#5

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 (AT) nospam (DOT) com> wrote

Quote:

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 (AT) none (DOT) com> wrote in message
news:foam11pg95kfd57jefn88eou8o160kc3r1 (AT) 4ax (DOT) 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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Passwords for cluster and servers

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

Passwords for cluster and servers - 02-22-2005 , 06:58 AM

Re: Passwords for cluster and servers - 02-22-2005 , 08:52 AM

Re: Passwords for cluster and servers - 02-22-2005 , 05:53 PM

Re: Passwords for cluster and servers - 02-22-2005 , 09:09 PM

Re: Passwords for cluster and servers - 03-29-2005 , 04:40 PM