Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Passwords for cluster and servers

 
   Database Help (Home) -> Clustering RSS
Next:  How do I set up several different e-mail account ..  
Author Message
Dave

External


Since: Feb 22, 2005
Posts: 1



(Msg. 1) Posted: Tue Feb 22, 2005 7:58 am
Post subject: Passwords for cluster and servers
Archived from groups: microsoft>public>sqlserver>clustering (more info?)

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.

 >> Stay informed about: Passwords for cluster and servers 
Back to top
Login to vote
user

External


Since: Feb 22, 2005
Posts: 1



(Msg. 2) Posted: Tue Feb 22, 2005 10:40 am
Post subject: Re: Passwords for cluster and servers [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I'm using one domain account for SQL and Cluster services and I have no
problems.

Ayad Shammout
SR.DBA/Analyst
Caregroup IS

"Dave" wrote in message

 > 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.
 >

 >> Stay informed about: Passwords for cluster and servers 
Back to top
Login to vote
Calvin Do

External


Since: Sep 16, 2004
Posts: 2



(Msg. 3) Posted: Tue Feb 22, 2005 4:53 pm
Post subject: Re: Passwords for cluster and servers [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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



"Dave" wrote in message

 > 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.
 >
 >> Stay informed about: Passwords for cluster and servers 
Back to top
Login to vote
Al

External


Since: Feb 20, 2005
Posts: 3



(Msg. 4) Posted: Tue Feb 22, 2005 10:09 pm
Post subject: Re: Passwords for cluster and servers [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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" wrote in message

 > 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.
 >
 >> Stay informed about: Passwords for cluster and servers 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
CLUSTER NAME - Hi , is there any command to display current cluster name through query . Thanks ARR

Using SQL Mail in a cluster - Hello, I'm trying to set up alerts for jobs and backups, using sql mail. Will this work in a clustered enviroment? if so, can you please forward some information on how to get this set up? thanks in advace. Calvin

Need to add additional NIC to SQL Cluster - Hi We recently built a W2K Advanced server, SQL Ent 2000 cluster. Each node of the cluster had 2 NIC ports: 1 NIC was used for Cross over cable Other NIC was used for LAN. All standard build servers in our environment should have 2 NIC connections -....

2000 Cluster - We're going to have to move data to a new 2000 SP4 server. We want to cluster it down the road, probably Q4 of 2008, but can't do it right now. So here's my question: 1. What do I have to do to this new server to make sure it can be clustered abou...

Cluster Issue - Hello, I have a Wndows 2003 Sql 2005 Cluster consisting of two servers, on Failover from node2 to node1 the application user is unable to login until the sql server is restarted, on failover all the resourses come online but the user is unable to..
   Database Help (Home) -> Clustering All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]