last sync: 2025-Apr-29 17:44:12 Etc/UTC

Azure SQL Managed Instance - Microsoft Azure Resource type
microsoft.sql/managedinstances

Azure Resource Provider Resource provider (RP) - Microsoft SQL Database [Microsoft.Sql]
RP Microsoft.Sql
RP display name Microsoft SQL Database
Azure Resource Type
RP Resource types
Resource types: 405
Azure Policy Alias
RP aliases
RP aliases: 1292
Azure Policy definition
RP Azure Policy
Azure Policy definitions: 112
if: 112
then.deployment: 24
then.details: 2
then.existenceCondition: 0
then.operations: 0
Azure RBAC Role Based Access Control
RP RBAC operations
RP RBAC operations: 595
RP RBAC operationType action: 84
RP RBAC operationType delete: 61
RP RBAC operationType read: 338
RP RBAC operationType write: 112
Azure RBAC Role definition
RP RBAC Roles & Operation actions
Unique RBAC Roles: 25
RBAC Roles with action operationType: 10
RBAC Roles with delete operationType: 10
RBAC Roles with read operationType: 24
RBAC Roles with write operationType: 11
Azure Application
RP related 1st party Service Principals
RP related 1st party Service Principals: 7
• SQLDBControlPlaneFirstPartyApp (appId: ceecbdd6-288c-4be9-8445-74f139e5db19) [ JSON;CSV]
• Azure SQL Virtual Network to Network Resource Provider (appId: 76cd24bf-a9fc-4344-b1dc-908275de6d6d) [ JSON;CSV]
• Azure SQL Managed Instance to Microsoft.Network (appId: 76c7f279-7959-468f-8943-3954880e0d8c) [ JSON;CSV]
• Azure SQL Managed Instance to Azure AD Resource Provider (appId: 9c8b80bc-6887-42d0-b1af-d0c40f9bf1fa) [ JSON;CSV]
• Azure SQL Database Backup To Azure Backup Vault (appId: e4ab13ed-33cb-41b4-9140-6e264582cf85) [ JSON;CSV]
• Azure SQL Database (appId: 022907d3-0f1b-48f7-badc-1ba6abab6d66) [ JSON;CSV]
• Azure Data Warehouse Polybase (appId: 0130cc9f-7ac5-4026-bd5f-80a08a54e6d9) [ JSON;CSV]
All Azure RPs Microsoft Learn
AzResourceTypesAdvertizer (Microsoft only)
Azure Resource Type Resource type (RT) - Azure SQL Managed Instance [microsoft.sql/managedinstances]
RT information
RT microsoft.sql/managedinstances
RT display name Azure SQL Managed Instance
RT type only
(without RP)
managedInstances
RT sub- Resource types sub-Resource types: 58
RT schema RT schema API versions: 19
All Microsoft Azure RTs AzResourceTypesAdvertizer
Aliases and Azure Policy
Azure Policy Alias
Aliases
aliases: 67
Azure Policy definition
Azure Policy
Azure Policy definitions: 23
if: 23
then.deployment: 2
then.details: 0
then.existenceCondition: 0
then.operations: 0
RBAC Operations and Roles & Roles related operation actions
Azure RBAC Role Based Access Control
RBAC operations
RBAC operations: 11
RBAC operationType action: 8
RBAC operationType delete: 1
RBAC operationType read: 1
RBAC operationType write: 1
Azure RBAC Role definition
RBAC Roles & Operation actions
Unique RBAC Roles: 20
RBAC Roles with action operationType: 5
RBAC Roles with delete operationType: 5
RBAC Roles with read operationType: 20
RBAC Roles with write operationType: 6
Capabilities & Locations
Azure Resource Diagnostic settings logs
Diagnostic logs
True
log-categories
Azure Resource Diagnostic settings metrics
Diagnostic metrics
True
metrics
Azure Customer-managed key
Customer-managed key (CMK) [experimental]
True
Microsoft Learn
Enforce Encryption with a customer-managed key (CMK) at scale
Azure Managed identity
System-Assigned-Resource-Identity
True
Azure Resource Mover
Cross-ResourceGroup-Resource-Move
False
Azure Resource Mover
Cross-Subscription-Resource-Move
False
Azure Resource Tags
Tags
True
Azure Extension
Extension
False
Azure Private Endpoint
Private-Endpoint
True
Azure Private Endpoint location Azure Private Endpoint location
Supported Locations for Private-Endpoint
Supported Locations for Private-Endpoint: 44
australiacentral, australiaeast, australiasoutheast, brazilsouth, canadacentral, canadaeast, centralindia, centralus, eastasia, eastus, eastus2, francecentral, germanywestcentral, indonesiacentral, israelcentral, italynorth, japaneast, japanwest, jioindiawest, koreacentral, koreasouth, mexicocentral, newzealandnorth, northcentralus, northeurope, norwayeast, polandcentral, qatarcentral, southafricanorth, southcentralus, southeastasia, southindia, spaincentral, swedencentral, switzerlandnorth, uaenorth, uksouth, ukwest, westcentralus, westeurope, westindia, westus, westus2, westus3
Non supported Locations for Private-Endpoint Non supported Locations for Private-Endpoint: 14
brazilus, eastusstg, centraluseuap, eastus2euap, southcentralusstg, southafricawest, australiacentral2, jioindiacentral, francesouth, germanynorth, norwaywest, switzerlandwest, uaecentral, brazilsoutheast
Azure location
Location
True
Azure Resource type location Azure Resource type location
Locations
Locations: 43
australiacentral, australiaeast, australiasoutheast, brazilsouth, canadacentral, canadaeast, centralindia, centralus, eastasia, eastus, eastus2, francecentral, germanywestcentral, indonesiacentral, israelcentral, italynorth, japaneast, japanwest, koreacentral, koreasouth, mexicocentral, newzealandnorth, northcentralus, northeurope, norwayeast, polandcentral, qatarcentral, southafricanorth, southcentralus, southeastasia, southindia, spaincentral, swedencentral, switzerlandnorth, uaenorth, uksouth, ukwest, westcentralus, westeurope, westindia, westus, westus2, westus3
Not locations Not locations: 54
asia, asiapacific, australia, australiacentral2, brazil, brazilsoutheast, brazilus, canada, centraluseuap, centralusstage, eastasiastage, eastus2euap, eastus2stage, eastusstage, eastusstg, europe, france, francesouth, germany, germanynorth, global, india, indonesia, israel, italy, japan, jioindiacentral, jioindiawest, korea, mexico, newzealand, northcentralusstage, norway, norwaywest, poland, qatar, singapore, southafrica, southafricawest, southcentralusstage, southcentralusstg, southeastasiastage, spain, sweden, switzerland, switzerlandwest, taiwan, uae, uaecentral, uk, unitedstates, unitedstateseuap, westus2stage, westusstage
Assessment tooling
Azure Advisor
Azure Advisor
Azure Advisor recommendations: 6
Security [High] Microsoft Defender for SQL should be enabled for unprotected SQL Managed Instances
Security [High] SQL managed instances should have vulnerability assessment configured
Security [Low] [Enable if required] SQL managed instances should use customer-managed keys to encrypt data at rest
Security [Medium] All advanced threat protection types should be enabled in SQL managed instance advanced data security settings
Security [Medium] Azure SQL Managed Instance authentication mode should be Azure Active Directory Only
Security [Medium] Azure SQL Managed Instances should disable public network access
Azure Proactive Resilience Library v2 (APRLv2)
Azure Proactive Resilience Library v2 (APRLv2)
Azure Proactive Resilience Library v2 recommendations: 6
DisasterRecovery [High] Use Zone-redundant or Geo-zone-redundant Backup storage redundancy
DisasterRecovery [High] Configure a secondary instance and a Failover group to enable failover to another region
DisasterRecovery [Medium] Back Up Your Keys
HighAvailability [High] Enable zone redundancy for Azure SQL Managed Instance to improve high availability and resiliency
MonitoringAndAlerting [Medium] Monitor your Azure SQL MI Managed Instance in near-real time to detect reliability incidents
Scalability [Medium] Use Redirect connection type to accelerate application access
PSRule for Azure
PSRule for Azure
PSRule for Azure rules: 4
Operational Excellence [Awareness] Use valid SQL Managed Instance names
Security [Critical] Use AAD authentication with SQL Managed Instance
Security [Important] Azure AD-only authentication
Security [Important] Managed identity
Azure Quick Review (AZQR)
Azure Quick Review (AZQR)
n/a
Infrastructure as Code (IaC)
ARM (Azure Resource Manager)
ARM (Azure Resource Manager) templates
ARM (Azure Resource Manager) template API versions: 19
latest
Azure Bicep
Bicep templates
Bicep template API versions: 19
latest
Terraform
Terraform provider
Terraform providers: 1
mssql_managed_instance
AzAPI Terraform
AzAPI Terraform templates
AzAPI Terraform template API versions: 19
latest
Pulumi
Pulumi provider
Pulumi providers: 1
sql/managedinstance
OpenTofu
OpenTofu provider
OpenTofu TF providers: 1
mssql_managed_instance
Azure Verified Modules (AVM) Bicep Azure Verified Modules (AVM) Bicep
Azure Verified Modules (AVM) Bicep
SQL Managed Instance
Azure Verified Modules (AVM) Terraform Azure Verified Modules (AVM) Terraform
Azure Verified Modules (AVM) Terraform
• GitHub: SQL Managed Instance
• Terraform registry: SQL Managed Instance
REST-API (Representational State Transfer - Application Programming Interface)
REST-API versions REST-API versions: 23
2024-08-01-preview
2024-05-01-preview
2023-08-01-preview
2023-08-01
2023-05-01-preview
2023-02-01-preview
2022-11-01-preview
2022-08-01-preview
2022-05-01-preview
2022-02-01-preview
2021-11-01-preview
2021-11-01
2021-08-01-preview
2021-05-01-preview
2021-02-01-preview
2020-11-01-preview
2020-08-01-preview
2020-02-02-preview
2019-06-01-preview
2018-06-01-preview
2017-10-01-preview
2017-03-01-preview
2015-05-01-preview
REST-API version default n/a
API profiles n/a
Resource naming
Azure Naming Tool
Azure Naming Tool
The Azure Naming Tool was created to help administrators define and manage their naming conventions, while providing a simple interface for users to generate a compliant name.
Resource naming details
{
  "property": "",
  "ShortName": "sqlmi",
  "scope": "global",
  "lengthMin": "1",
  "lengthMax": "63",
  "validText": "Lowercase letters, numbers, and hyphens.",
  "invalidText": "Can't start or end with hyphen.",
  "invalidCharacters": "",
  "invalidCharactersStart": "-",
  "invalidCharactersEnd": "-",
  "invalidCharactersConsecutive": "",
  "regx": "^(?!-.*)(?!.*-$)[a-z0-9-]{1,63}$",
  "staticValues": ""
}