Deploy SQL Always ON setup with existing SQL Virtual Machines

Azure Public Test Date Azure Public Test Result

Azure US Gov Last Test Date Azure US Gov Last Test Result

Best Practice Check Cred Scan Check

Before deploying the template you must have the following

  1. Domain Domain must exist in which the underlying Windows Server Failover Cluster will be created
  2. VM Virtual Machines in same location, joined to the existing domain

Deploy To Azure Deploy To Azure US Gov Visualize

Tags: Azure, SQL, VirtualMachine, AlwaysON, Cluster, Microsoft.SqlVirtualMachine/SqlVirtualMachines, Microsoft.Storage/storageAccounts, Microsoft.SqlVirtualMachine/SqlVirtualMachineGroups, Microsoft.Resources/deployments

Solution overview and deployed resources

This deployment will create a WS failover cluster with cloud witness on the provided VMs (in same region) and enable SQL Always ON them. This will enable creating SQL Availability Groups over the created Always ON setup. Following resources will be created

  • Storage Account to be used as Cloud Witness for failover cluster
  • Resource of type "SqlVirtualMachine" in Microsoft.SqlVirtualMachine resource provider. This corresponds to the existing VirtualMachine
  • Resource of type "SqlVirtualMachineGroup" in Microsoft.SqlVirtualMachine resource provider. This captures details of WS failover cluster setup