search

Azure / azure-quickstart-templates

Azure Quickstart Templates
https://aka.ms/azqst
MIT License
14.07k stars 16.13k forks source link

sqlvm-alwayson-cluster failed to deploy #5344

Open sunbinzhu opened 6 years ago

sunbinzhu commented 6 years ago

--------------------MESSAGE FROM ADMIN, DELETE BEFORE SUBMITTING----------------------

sqlvm-alwayson-cluster

Issue Details

This template can never deploy because there is obvious issue.

  1. You had added a suffix in the virtual network name, but when specifying the values for variables "staticSubnetRef", "sqlSubnetRef", you are still using the original virtual network name without suffix. (AzureDeploy.json line 421, 422)
  2. In the provisioningVMx.json, when creating availability set for sql VMs, you had specified "platformFaultDomainCount" as 3, but for some locations, only supports 2.
sunbinzhu commented 6 years ago

And the sql server image MicrosoftSQLServer:SQL2014SP1-WS2012R2:Enterprise:latest is not available anymore, the offer shall be SQL2014SP2-WS2012R2