0

My current environment is on Availability groups sql 2012 with 1 Synchronous and 1 Asynchronous replica. Soon we need to change the sql service account passwords.
Can any one suggest to me do I need to take any extra step(s) while changing the passwords? so that it will not disturb any existing settings or configurations?

Hope below steps are correct:
1. Changing the sql service account password on primary server, then secondary servers and restarting them
2. Ensure the data synchronization is properly running.

2

I would do it in this order:

  1. Change on Async Replica and restart SQL.
    • Make sure everything is still synchronizing after restart
  2. Change Sync Replica and restart.
    • Make sure everything is still synchronizing after restart
  3. Failover to Sync Replica
  4. Change on former Primary (Current Sync Replica), and restart.
    • Make sure everything is still synchronizing after restart

You can then fail back to the old primary if need be, or leave on the Sync Replica if all things are equal.

  • Have you done the same before? – Phani Apr 26 '16 at 21:43
  • My answer was based on how you would apply updates/service packs. But according to the advice here: social.msdn.microsoft.com/Forums/en-US/… no failover is needed, all replicas should be updated and restarted simoultaniously. – Chad Mattox Apr 27 '16 at 18:33
  • @ChadMattox Would you first set the AG to Manual Failover, and then re-set it to Automatic Failover at the end? – youcantryreachingme Oct 15 at 22:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.