My Favorite Blogs

Monday, September 28, 2009

Best practices of Password Change on SQL Failover cluster (Applicable n+1 nodes cluster)

As per my experience, I could suggest the following steps will help to change periodic password change on SQL Service account password on your Active/Passive and n+1 node cluster environment.

Important note: This activity is required downtime, make sure you informed your business about this outage.

Use RDP to log into each physical node of the cluster

Chaning password for Windows Cluster services.

Executed directly by: Start Run and enter Services.msc

1. Change password for windows cluster services.

Chaning password for SQL Services.

Executed directly by: StartRun and enter SQLServerManager.msc(SQL 2005) or SQLServerManager10.msc(SQL 2008)

2. In SQL Server Configuration Manager Change the Pwd for SQL services. Start from Active node.
3. Change 1st Active instance and change its other passive nodes

Once password change on all SQL services on Active and Passive nodes, SQL Instances need to be failed over to all cluster nodes to ensure that the password updated on all.

Failover test on Cluster Administrator.

Executed directly by:Start Run and entering cluadmin.exe

4. Once done on all nodes, failover the instances to another nodes and make the pwd get effected.

6. Restart the Cluster services on each nodes to make the pwd get effected.

This tip is applicable for SQL Server 2000 and 2005 on Windows 2000 & 2003 Cluster.



  1. I hope you will share such type of impressive contents again with us so that we can utilize it and get more advantage. dashlane

  2. Considering that reinstalling the whole system will remove all your settings and files, many people rely on using a password reset program to remove the password from your computer & allow you to gain access to it again.reset windows 10 password

  3. I curious more interest in some of them hope you will give more information on this topics in your next articles. south african brokers list

  4. I am glad that I saw this post. It is informative blog for us and we need this type of blog thanks for share this blog, Keep posting such instructional blogs and I am looking forward for your future posts.
    Cyber Security Projects for Final Year

    JavaScript Training in Chennai

    Project Centers in Chennai

    JavaScript Training in Chennai

  5. Extremely useful tips! Very pleased to find these