The Azure Quickstart templates are currently available in English

Deploy SQL Managed Instance with Networking

게시자: John Scott
마지막 업데이트: 2019-09-13

Deploy UDR and NSG to support Azure SQL Managed Instance and deploy the Managed Instance

이 Azure Resource Manager 템플릿은 Microsoft가 아니라 커뮤니티 구성원에 의해 만들어졌습니다. 각 Resource Manager 템플릿은 Microsoft가 아닌 해당 소유자의 사용권 계약에 의거하여 사용이 허가됩니다. Microsoft는 커뮤니티 구성원에 의해 제공 및 라이선스가 부여된 Resource Manager 템플릿에 대해 책임이 없으며, 보안, 호환성 또는 성능을 검사하지 않습니다. 커뮤니티 Resource Manager 템플릿은 Microsoft 지원 프로그램 또는 서비스에서 지원되지 않고, 어떠한 보증도 없이 있는 그대로 제공됩니다.

매개 변수

매개 변수 이름 설명
location Location for all resources
vnetResourceName The name of the vnet
managedInstanceSubnetName Managed Instance Subnet name
sqlManagedInstanceName Name of the Azure SQL Managed Instance - must be globally unique, contain only lowercase letters, numbers and '-'
sqlManagedInstanceAdminLogin Admin user for Managed Instance
sqlManagedInstancePassword Admin user password - must be 16-128 characters, must contain 3 of uppercase, lowercase, numbers and non-alphanumeric characters, and cannot contain all or part of the login name
sqlManagedInstance-storageSizeInGB Amount of Storage in GB for this instance
sqlManagedInstance-vCores Number of vCores for this instance
sqlManagedInstance-licenseType Type of license: BasePrice (BYOL) or LicenceIncluded
sqlManagedInstance-skuName SKU NAME (GP_Gen4, GP_Gen5, BC_GEN5)
sqlManagedInstance-skuEdition SKU Edition (GeneralPurpose, BusinessCritical)
sqlManagedInstance-hardwareFamily Hardware family (Gen4, Gen5)
sqlManagedInstance-collation SQL Collation
tags Tags for the Managed Instance SQL resource.
_artifactsLocation The location of resources, such as templates and DSC modules, that the template depends on
_artifactsLocationSasToken Auto-generated token to access _artifactsLocation
vnetAddressRange Address range for the virtual network in CIDR notation
managedInstanceNSGName Name of the Managed Instance NSG
managedInstanceRouteTableName Name of the Managed Instance Route Table
managedInstanceSubnetAddressRange Managed Instance Subnet range
miManagementIps List of MI management IP ranges

템플릿 사용


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
Azure PowerShell 설치 및 구성


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
Azure 크로스 플랫폼 명령줄 인터페이스 설치 및 구성

John Scott의 추가 템플릿