Environment required to deploy Azure SQL Managed Instance.

Last updated: 15/03/2020

This template allows you to create an environment required to deploy Azure SQL Managed Instance - Virtual Network with two subnets.

This Azure Resource Manager (ARM) template was created by a member of the community and not by Microsoft. Each ARM template is licensed to you under a licence agreement by its owner, not Microsoft. Microsoft is not responsible for ARM templates provided and licensed by community members and does not screen for security, compatibility or performance. Community ARM templates are not supported under any Microsoft support programme or service, and are made available AS IS without warranty of any kind.


Parameter Name Description
virtualNetworkName The name of new Azure VNet where you can deploy Azure Sql Managed Instances and the resources that use them
virtualNetworkAddressPrefix VNet IP address range (VNet prefix)
defaultSubnetName The name of default subnet for VNet (used to deploy VMs, web, and other client apps - no Managed Instances). You can delete this subnet later if you don't need it.
defaultSubnetPrefix Default subnet address range (subnet prefix)
managedInstanceSubnetName The name of the subnet dedicated to Azure SQL Managed Instances
managedInstanceSubnetPrefix IP Address range in the subnet dedicated to Azure SQL Managed Instances
nsgForManagedInstanceSubnet Name of network security group dedicated to managed instance subnet
routeTableForManagedInstanceSubnet The name of the existing or new route table that enables access to Azure SQL Managed Instance Management Service that controls the instance, manages backups and other maintenance operations
location Azure data center location where all resources will be deployed

Use the template


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
New-AzResourceGroupDeployment -ResourceGroupName <resource-group-name> -TemplateUri https://raw.githubusercontent.com/Azure/azure-quickstart-templates/master/101-sql-managed-instance-azure-environment/azuredeploy.json
Installing and configuring Azure PowerShell

Command line

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
az group deployment create --resource-group <my-resource-group> --template-uri https://raw.githubusercontent.com/Azure/azure-quickstart-templates/master/101-sql-managed-instance-azure-environment/azuredeploy.json
Installing and configuring the Azure cross-platform command-line interface