The Azure Quickstart templates are currently available in English
Deploy SQL AvailabilityGroup listener on existing Always ON setup. This creates Listener on an existing SQL Availability Group, sets up corresponding load balancer rules and probe ports on Azure Load balancer to get the listener connections working.
此 Azure Resource Manager (ARM) 範本是由社群成員 (而非 Microsoft) 建立。每個 ARM 範本都是由其擁有者 (而非 Microsoft) 依據授權合約授權給您。Microsoft 並不負責社群成員所提供和授權的 ARM 範本，而不會為了安全性、相容性或效能進行篩選。社群 ARM 範本並未依據任何 Microsoft 支援方案或服務提供支援，而且會在沒有任何擔保的情況下依現況提供。
參數
| 參數名稱 | 說明 |
|---|---|
| existingFailoverClusterName | Specify the name of the failover cluster |
| existingSqlAvailabilityGroup | Specify the name of SQL Availability Group for which listener is being created |
| existingVmList | Specify the Virtual machine list participating in SQL Availability Group e.g. VM1, VM2. Maximum number is 6. |
| Listener | Specify a name for the listener for SQL Availability Group |
| ListenerPort | Specify the port for listener |
| ListenerIp | Specify the available private IP address for the listener from the subnet the existing Vms are part of. |
| existingVnetResourcegroup | Specify the resourcegroup for virtual network |
| existingVnet | Specify the virtual network for Listener IP Address |
| existingSubnet | Specify the subnet under Vnet for Listener IP address |
| existingInternalLoadBalancer | Name of existing internal load balancer for the AG listener. Choose Standard Sku if the VMs are not in an availability set. |
| ProbePort | Specify the load balancer port number (e.g. 59999) |
| Location | Location for all resources. |
使用範本
PowerShell
New-AzResourceGroup -Name <resource-group-name> -Location <resource-group-location> #use this command when you need to create a new resource group for your deployment安裝和設定 Azure PowerShell
New-AzResourceGroupDeployment -ResourceGroupName <resource-group-name> -TemplateUri https://raw.githubusercontent.com/Azure/azure-quickstart-templates/master/101-sql-vm-aglistener-setup/azuredeploy.json
命令列
az group create --name <resource-group-name> --location <resource-group-location> #use this command when you need to create a new resource group for your deployment安裝和設定 Azure 跨平台命令列介面
az group deployment create --resource-group <my-resource-group> --template-uri https://raw.githubusercontent.com/Azure/azure-quickstart-templates/master/101-sql-vm-aglistener-setup/azuredeploy.json