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.

Improve this question

1 Answer 1

Reset to default
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.

Improve this answer
4
  • Have you done the same before?
    – Phani
    Commented Apr 26, 2016 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
    Commented Apr 27, 2016 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
    Commented Oct 15, 2019 at 22:18
  • Is the same process for changing service accounts?
    – variable
    Commented Aug 14 at 16:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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