In this Scenario I used Azure internal load balancer with SQL Server 2022 on Windows Server 2022 image to setup the Virtual machines. And also used another VM for install Microsoft Active Directory.
Virtual Network Configuration
In this scenario i create virtual network on EASTUS Region with 192.168.0.0/16 network range and divided that VNET to two subnets as Domain Subnet and SQL Subnet. And Changed the VNET DNS to custom and putted the Domain VM Private IP address for the DNS server on this VNET.
Vnet Image
Subnet’s
Custom DNS
Windows AD Configuration
In this scenario i created three virtual machines on Azure and Join that all Virtual Machines to the Same AD Domain. and then add another feature of Failover Cluster and configured it.
Azure Load Balancer
Created Azure internal load balancer and health probe, Rule, frontend IP and backend pool. I put the 192.168.1.7 as a Frontend IP on Load Balancer and same thing configured on Windows Server Failover cluster.
SQL Server on VM configurations
Create file share location on Domain VM
Create file share location on Domain VM (Part2)
Failover Cluster Configuration 01
Failover Cluster Configuration 02
SQl Server Always On Availability Group
Availability Group Create and Validation
This all Scenario Base on Azure IAAS. We can simply do this same scenario Using Azure PAAS Solution (Azure SQL DATABASE FAILOVER CLUSTER).
Azure SQL DATABASE FAILOVER CLUSTER
