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
- Change service account on the Node2 (secondary) - both SQL Server (InstanceName) (database engine) and SQL Server Agent (InstanceName) (job engine)
- Pause synchronization
- Restart the SQL Server (InstanceName) service and the SQL Server Agent (InstanceName)
- Failover the AOAG to the secondary, then change the account details of the primary (now the seconday)
- repeat step 2. and 3.
- Fail back to the primary again
Please let me know if I am missing any step here