SQL AlwaysOn template for ARM?

Question

From @RajSenap via Twitter:

Thanks very much for your continued support. I have a question regarding the "SQL Server AlwaysOn Cluster" offering in Azure Resource Portal. Is there a way I can deploy this using Azure Resource Manager Template? My situation is, I have an existing Virtual network, I need to create the availability groups within the existing network.

(provided aka.ms/d1048565) - Thanks very much. The link seems to provide guidance on how to set up SQL Server AlwaysOn Cluster using the Portal. What I am trying to do is to deploy using a Template. I have also the constraint that I should create this within my existing Virtual Network. Is there any official Microsoft published Resource Manager template for setting up SQL Always On Availability Group?  I found these in Azure Github: https://github.com/Azure/azure-quickstart-templates/tree/master/sql-server-2014-alwayson-dsc and https://github.com/Azure/azure-quickstart-templates/tree/5bebb09da6557582e9c93d8870b4ba8ff13a1d4b/sql-server-2014-alwayson-existing-vnet-and-adhttps://github.com/Azure/azure-quickstart-templates/tree/5bebb09da6557582e9c93d8870b4ba8ff13a1d4b/sql-server-2014-alwayson-existing-vnet-and-ad

Thanks!

@AzureSupport

Answer 1

From the Portal deployment detailed in this documentation page (https://azure.microsoft.com/en-us/documentation/articles/virtual-machines-sql-server-alwayson-availability-groups-gui-arm/ ), you can download the ARM template. You fill out the parameters in the portal and a template will be generated based on your input and you can download it in the "Summary" step. Once you have downloaded the template you can customize it to use your existing Virtual Network.

We will soon be adding templates to GitHub which will allow you to accomplish this without needing to download them from the Portal.

Answer 2

Thanks very much Ninar.

Answer 3

Any update on this?:

"We will soon be adding templates to GitHub which will allow you to accomplish this without needing to download them from the Portal."

I'm currently working on creating a little lab environment in ARM via PowerShell and would like to know if the PowerShell option would be eventually available soon.

Thanks in advance.