Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SERVICE ACCOUNT PASSWORD CHANGE ON CLUSTER INSTANCE Expand / Collapse
Author
Message
Posted Tuesday, February 22, 2011 5:33 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 8:31 AM
Points: 236, 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?
Post #1068009
Posted Friday, December 9, 2011 4:58 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 28, 2013 10:43 AM
Points: 5, 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.

Post #1219253
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse