How to setup multi-subnets Azure SQL VM AG group based WSFC (Windows Server 2019)


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