AlwaysON database not synchronizing mode SQL service account change Suddenly, one of our alwaysON server databases are went not synchronizing mode. Errors from the log The availability group database “DB” is changing roles from “RESOLVING” to “PRIMARY” because the mirroring session or availability group failed over due to role synchronization. This is an informational message only. No user action is required. DbMgrPartnerCommitPolicy::SetSyncState: 0000000CDCF67020:4 It is due to changes in service account from an existing account to the new account. It was a GUI setup, the GUI creates all behind the screen. The endpoint uses a dedicated SQL server service account for creating an endpoint. Thanks to Allan Hirt@SQLHA. Endpoints in…