title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | ms.custom | monikerRange |
---|---|---|---|---|---|---|---|---|---|---|
Azure Resource Manager templates |
Use Azure Resource Manager templates to create and configure Azure SQL Managed Instance. |
urosmil |
urmilano |
wiassaf, mathoma |
04/30/2024 |
azure-sql-managed-instance |
deployment-configuration |
conceptual |
overview-samples, azure-sql-split, devx-track-arm-template |
= azuresql || = azuresql-mi |
[!INCLUDEappliesto-sqldb-sqlmi]
[!div class="op_single_selector"]
Azure Resource Manager templates enable you to define your infrastructure as code and deploy your solutions to the Azure cloud for Azure SQL Managed Instance.
The following table includes links to Azure Resource Manager templates for Azure SQL Managed Instance.
Link | Description |
---|---|
SQL Managed Instance in a new virtual network | This Azure Resource Manager template creates and configures a new Azure virtual network and creates a new managed instance in the virtual network. |
Network environment for SQL Managed Instance | This deployment creates and configures an Azure virtual network with two subnets, one that is dedicated to your managed instances and another where you can place other resources (such as VMs, App Service environments). This template creates a properly configured networking environment where you can deploy managed instances. |
SQL Managed Instance with P2S connection | This deployment creates an Azure virtual network with two subnets, ManagedInstance and GatewaySubnet . SQL Managed Instance is deployed in the ManagedInstance subnet. A virtual network gateway is created in the GatewaySubnet subnet and configured for a Point-to-Site VPN connection. |
SQL Managed Instance with a virtual machine | This deployment creates an Azure virtual network with two subnets, ManagedInstance and Management . SQL Managed Instance is deployed in the ManagedInstance subnet. A virtual machine with the latest version of SQL Server Management Studio (SSMS) is deployed in the Management subnet. |
SQL Managed Instance with diagnostic logs enabled | This deployment creates an Azure Virtual Network with a ManagedInstance subnet and deploys a SQL Managed Instance with diagnostic logs enabled. It also deploys event hub, diagnostic workspace, and the storage account for the purpose of sending and storing instance diagnostic logs. |