SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SERVICE ACCOUNT PASSWORD CHANGE ON CLUSTER INSTANCE


SERVICE ACCOUNT PASSWORD CHANGE ON CLUSTER INSTANCE

Author
Message
hydbadrose
hydbadrose
Old Hand
Old Hand (372 reputation)Old Hand (372 reputation)Old Hand (372 reputation)Old Hand (372 reputation)Old Hand (372 reputation)Old Hand (372 reputation)Old Hand (372 reputation)Old Hand (372 reputation)

Group: General Forum Members
Points: 372 Visits: 934
Can some one please provide me the step by step procedure or site.
I have the following steps please confirm and provide any missing steps...

1. In SQL Server Configuration Manager Change the Pwd for SQL services. Start from Active node.
2. Change 1st Active instance and change its other passive nodes
3. Once done on all nodes, failover the instances to another nodes and make the pwd get effected.
4. Do the same for 2nd and 3rd Active instances.
5. Restart the Cluster services one by one to make the pwd get effected.


question:

1. Should the services have to be stopped while changing the password.
2. should I apply on active node supposed node 1 is active then apply on node b
3. Should I have to failover node 1 to node 2 to take effect?
sean.reece
sean.reece
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
Points: 11 Visits: 71
You will need to define your configuration for I cannot tell whether you have a single instance per cluster node or multiple instances per node.
In one setup that I worked on I had an Active Active 2 node cluster. with each node having two instances of SQL Server 2005.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search