Cannot Create Always On Availability Group on Azure Virtual Machines
I have encountered the following error whilst creating Availability Group on Azure Virtual Machines. Tried again with TSQL and got the same error:
1 2 3 4 |
Msg 41131, Level 16, State 0, Line 3 Failed to bring availability group 'agMAQ' online. The operation timed out. Verify that the local Windows Server Failover Clustering (WSFC) node is online. Then verify that the availability group resource exists in the WSFC cluster. If the problem persists, you might need to drop the availability group and create it again. Msg 41152, Level 16, State 2, Line 3 Failed to create availability group 'agMAQ'. The operation encountered SQL Server error 41131 and has been rolled back. Check the SQL Server error log for more details. When the cause of the error has been resolved, retry CREATE AVAILABILITY GROUP command. |
Checked SQL Server error log and found the following:
1 2 3 4 |
The state of the local availability replica in availability group 'agMAQ' has changed from 'NOT_AVAILABLE' to 'RESOLVING_NORMAL'. The state changed because the local availability replica is joining the availability group. For more information, see the SQL Server error log, Windows Server Failover Clustering (WSFC) management console, or WSFC log. The state of the local availability replica in availability group 'agMAQ' has changed from 'RESOLVING_NORMAL' to 'NOT_AVAILABLE'. The state changed because either the associated availability group has been deleted, or the local availability replica has been removed from another SQL Server instance. For more information, see the SQL Server error log, Windows Server Failover Clustering (WSFC) management console, or WSFC log. Error: 19435, Severity: 16, State: 1. Always On: WSFC AG integrity check failed for AG 'agMAQ' with error 41044, severity 16, state 1. |
Decided to google the error and found this link. It’s a known issue to Microsoft. I have executed the following statement…