2026.8.25.2

Overview
Name sqlmanagedinstance
Tag 2026.8.25.2
FullName br:bicepacrdevwcom.azurecr.io/bicep/modules/sqlmanagedinstance:2026.8.25.2
Last updated 2026-08-25 09:48:21:+00:00
Created 2026-08-25 09:48:21:+00:00
Digest sha256:d87ac1818d056e2cbc641a8c36397bcad936dc560cb329e0923104360ed9f21d

Parameters

Name Type Required Description
env string Yes
tags object Yes
location string No
resourceGroup().location
 Location for deployment
namePrefix string No
''
system string Yes
country string No
''
region string No
''
nameSuffix string No
''
publicDataEndpointEnabled bool No
false
managedInstanceName string No
format('{0}{1}{2}-sqlmi{3}{4}{5}{6}-{7}{8}{9}', namePrefix, if(empty(namePrefix), '', '-'), system, if(empty(country), '', '-'), country, if(empty(region), '', '-'), region, env, if(empty(nameSuffix), '', '-'), nameSuffix)
 Full managed instance name, if not specified use default namePrefix-system-sqlmi-country-region-env-suffix
azureADOnlyAuthentication bool No
false
administratorLogin string No
''
 Admin username
administratorLoginPassword ▲ secure ▲
string		 No
''
 Admin password
principalType string
'Application',
'Group',
'User'
 No
'Group'
 AAD Admin principal type
aadAdministratorLoginName string Yes AAD Admin Login Name
aadAdministratorLoginSid ▲ secure ▲
string		 Yes AAD Admin Login Sid
subnetResourceId string Yes Virtual network name
instancePoolId string No
''
 Virtual network name
skuName string
'GP_Gen5',
'BC_Gen5',
'GP_G8IM'
 No
'GP_Gen5'
 SKU name
skuFamily string
'Gen5',
'Gen8IM'
 No
'Gen5'
 SKU family
vCores int
2,
4,
8,
16,
24,
32,
40,
64,
80
 No
8
 Number of vCores
storageSizeInGB int
Value: ≧32 ≦8192		 No
32
 Storage size
licenseType string
'BasePrice',
'LicenseIncluded'
 Yes License type
collation string Yes Default database collation
requestedBackupStorageRedundancy string
'Geo',
'GeoZone',
'Local',
'Zone'
 No
'Local'
 Default database collation
maintenanceConfiguration string No
'SQL_Default'

Outputs

Name Type Description

Example

@description('The target environment.')
param env string

@description('The deployment version.')
param version string = '1.0.0.0'

param tags object

param system string

@description('AAD Admin Login Name')
param aadAdministratorLoginName string

@description('AAD Admin Login Sid')
@secure()
param aadAdministratorLoginSid string

@description('Virtual network name')
param subnetResourceId string

@description('License type')
param licenseType string

@description('Default database collation')
param collation string


module sqlmanagedinstance 'br:bicepacrdevwcom.azurecr.io/bicep/modules/sqlmanagedinstance:2026.8.25.2' = {
    name: 'sqlmanagedinstance${env}${version}'
    params: {
      env: env
      tags: tags
      system: system
      aadAdministratorLoginName: aadAdministratorLoginName
      aadAdministratorLoginSid: aadAdministratorLoginSid
      subnetResourceId: subnetResourceId
      licenseType: licenseType
      collation: collation
    }
}