In this article, we will learn how to set up Azure SQL VM AOAG based on Windows Server 2019 Failover Cluster step-by-step, it is a detailed supplement to the Microsoft official articles and it is a beginner’s guide for people who have no experience to do that, please read this article closely with Mircosoft’s guide: https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/availability-group-manually-configure-prerequisites-tutorial-multi-subnet?view=azuresql
Architecture
There are two subnets created in Azure, and each node in the cluster with two IP addresses, one for VM itself and another for the AG listener:
Prerequisites
When you finished the step « Join the servers to the domain » in