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

  6. Auto bitcoin bot Celeste Barber is an actor, standup comedian, and TV presenter known for her role in the famous Australian TV series, All Saints. She is estimated to be worth nearly half a billion dollars. There are rumours that Celeste Barber has invested in several bitcoin robots to grow her wealth.

  7. Fintech is a portmanteau of the terms "money" and also "technology" as well as describes any type of organisation that uses technology to improve or automate economic solutions as well as processes. The term is a wide and swiftly growing sector offering both consumers and companies. From mobile financial and also insurance coverage to cryptocurrency as well as financial investment applications, fintech has wide applications. Eyal Nachum is a fintech guru and a director at Bruc Bond. Eyal is the architect of the software that SMEs use to do cross-border payments.

  8. Good post. I learn something totally new and challenging on sites I stumbleupon on a daily basis. It will always be helpful to read articles from other writers and practice something from KBC Lottery Winner 2020 web sites.