Changing startup accounts on alwayson setup
0
votes
2
answers
2053
views
I have a 2 node Always On Availability Group cluster where we are planning to take backups to a file share which will then be moved to Azure cloud. We have a service account from the Windows team for the backup job, but the startup account of the database engine and the SQL Server Agent are local accounts. Using proxies did not help me with the situation so I am now thinking of providing the service account credentials in the SQL Server Configuration Manager.
What I want to know is how do I proceed?
This is what I have planned. Please let me know if I have missed something in the flow
1. Change service account on the Node2 (secondary) - both **SQL Server (_InstanceName_)** (database engine) and **SQL Server Agent (_InstanceName_)** (job engine)
2. Pause synchronization
3. Restart the **SQL Server (_InstanceName_)** service and the **SQL Server Agent (_InstanceName_)**
4. Failover the **AOAG** to the secondary, then change the account details of the primary (now the seconday)
5. repeat step 2. and 3.
6. Fail back to the primary again
Please let me know if I am missing any step here
Thanks!
Asked by buddinggeek
(623 rep)
Nov 18, 2016, 03:33 PM
Last activity: Jul 22, 2025, 06:06 AM
Last activity: Jul 22, 2025, 06:06 AM