Skip Navigation

Environment required to deploy Azure SQL Managed Instance.

Last updated: 7/1/2018

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

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

Parameters

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
routeTableToAzureService 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

PowerShell

New-AzureRmResourceGroupDeployment -Name <deployment-name> -ResourceGroupName <resource-group-name> -TemplateUri https://raw.githubusercontent.com/Azure/azure-quickstart-templates/master/101-sql-managed-instance-azure-environment/azuredeploy.json
Install and configure Azure PowerShell

Command line

azure config mode arm
azure group deployment create <my-resource-group> <my-deployment-name> --template-uri https://raw.githubusercontent.com/Azure/azure-quickstart-templates/master/101-sql-managed-instance-azure-environment/azuredeploy.json
Install and Configure the Azure Cross-Platform Command-Line Interface