Docs Home Pulumi IaC Pulumi ESC Pulumi Cloud Packages Tutorials
  1. Packages
  2. Azure Classic
  3. API Docs
  4. mssql
  5. ManagedInstance

We recommend using Azure Native.

Azure Classic v6.2.0 published on Friday, Sep 27, 2024 by Pulumi
pulumi/pulumi-azure

azure.mssql.ManagedInstance

Explore with Pulumi AI

azure logo

We recommend using Azure Native.

Azure Classic v6.2.0 published on Friday, Sep 27, 2024 by Pulumi
pulumi/pulumi-azure

    Manages a Microsoft SQL Azure Managed Instance.

    Note: All arguments including the administrator login and password will be stored in the raw state as plain-text. Read more about sensitive data in state.

    Example Usage

    Coming soon!

    Coming soon!

    Coming soon!

    Coming soon!

    Coming soon!

    resources:
  example:
    type: azure:core:ResourceGroup
    properties:
      name: database-rg
      location: West Europe
  exampleNetworkSecurityGroup:
    type: azure:network:NetworkSecurityGroup
    name: example
    properties:
      name: mi-security-group
      location: ${example.location}
      resourceGroupName: ${example.name}
  allowManagementInbound:
    type: azure:network:NetworkSecurityRule
    name: allow_management_inbound
    properties:
      name: allow_management_inbound
      priority: 106
      direction: Inbound
      access: Allow
      protocol: Tcp
      sourcePortRange: '*'
      destinationPortRanges:
        - '9000'
        - '9003'
        - '1438'
        - '1440'
        - '1452'
      sourceAddressPrefix: '*'
      destinationAddressPrefix: '*'
      resourceGroupName: ${example.name}
      networkSecurityGroupName: ${exampleNetworkSecurityGroup.name}
  allowMisubnetInbound:
    type: azure:network:NetworkSecurityRule
    name: allow_misubnet_inbound
    properties:
      name: allow_misubnet_inbound
      priority: 200
      direction: Inbound
      access: Allow
      protocol: '*'
      sourcePortRange: '*'
      destinationPortRange: '*'
      sourceAddressPrefix: 10.0.0.0/24
      destinationAddressPrefix: '*'
      resourceGroupName: ${example.name}
      networkSecurityGroupName: ${exampleNetworkSecurityGroup.name}
  allowHealthProbeInbound:
    type: azure:network:NetworkSecurityRule
    name: allow_health_probe_inbound
    properties:
      name: allow_health_probe_inbound
      priority: 300
      direction: Inbound
      access: Allow
      protocol: '*'
      sourcePortRange: '*'
      destinationPortRange: '*'
      sourceAddressPrefix: AzureLoadBalancer
      destinationAddressPrefix: '*'
      resourceGroupName: ${example.name}
      networkSecurityGroupName: ${exampleNetworkSecurityGroup.name}
  allowTdsInbound:
    type: azure:network:NetworkSecurityRule
    name: allow_tds_inbound
    properties:
      name: allow_tds_inbound
      priority: 1000
      direction: Inbound
      access: Allow
      protocol: Tcp
      sourcePortRange: '*'
      destinationPortRange: '1433'
      sourceAddressPrefix: VirtualNetwork
      destinationAddressPrefix: '*'
      resourceGroupName: ${example.name}
      networkSecurityGroupName: ${exampleNetworkSecurityGroup.name}
  denyAllInbound:
    type: azure:network:NetworkSecurityRule
    name: deny_all_inbound
    properties:
      name: deny_all_inbound
      priority: 4096
      direction: Inbound
      access: Deny
      protocol: '*'
      sourcePortRange: '*'
      destinationPortRange: '*'
      sourceAddressPrefix: '*'
      destinationAddressPrefix: '*'
      resourceGroupName: ${example.name}
      networkSecurityGroupName: ${exampleNetworkSecurityGroup.name}
  allowManagementOutbound:
    type: azure:network:NetworkSecurityRule
    name: allow_management_outbound
    properties:
      name: allow_management_outbound
      priority: 102
      direction: Outbound
      access: Allow
      protocol: Tcp
      sourcePortRange: '*'
      destinationPortRanges:
        - '80'
        - '443'
        - '12000'
      sourceAddressPrefix: '*'
      destinationAddressPrefix: '*'
      resourceGroupName: ${example.name}
      networkSecurityGroupName: ${exampleNetworkSecurityGroup.name}
  allowMisubnetOutbound:
    type: azure:network:NetworkSecurityRule
    name: allow_misubnet_outbound
    properties:
      name: allow_misubnet_outbound
      priority: 200
      direction: Outbound
      access: Allow
      protocol: '*'
      sourcePortRange: '*'
      destinationPortRange: '*'
      sourceAddressPrefix: 10.0.0.0/24
      destinationAddressPrefix: '*'
      resourceGroupName: ${example.name}
      networkSecurityGroupName: ${exampleNetworkSecurityGroup.name}
  denyAllOutbound:
    type: azure:network:NetworkSecurityRule
    name: deny_all_outbound
    properties:
      name: deny_all_outbound
      priority: 4096
      direction: Outbound
      access: Deny
      protocol: '*'
      sourcePortRange: '*'
      destinationPortRange: '*'
      sourceAddressPrefix: '*'
      destinationAddressPrefix: '*'
      resourceGroupName: ${example.name}
      networkSecurityGroupName: ${exampleNetworkSecurityGroup.name}
  exampleVirtualNetwork:
    type: azure:network:VirtualNetwork
    name: example
    properties:
      name: vnet-mi
      resourceGroupName: ${example.name}
      addressSpaces:
        - 10.0.0.0/16
      location: ${example.location}
  exampleSubnet:
    type: azure:network:Subnet
    name: example
    properties:
      name: subnet-mi
      resourceGroupName: ${example.name}
      virtualNetworkName: ${exampleVirtualNetwork.name}
      addressPrefixes:
        - 10.0.0.0/24
      delegations:
        - name: managedinstancedelegation
          serviceDelegation:
            name: Microsoft.Sql/managedInstances
            actions:
              - Microsoft.Network/virtualNetworks/subnets/join/action
              - Microsoft.Network/virtualNetworks/subnets/prepareNetworkPolicies/action
              - Microsoft.Network/virtualNetworks/subnets/unprepareNetworkPolicies/action
  exampleSubnetNetworkSecurityGroupAssociation:
    type: azure:network:SubnetNetworkSecurityGroupAssociation
    name: example
    properties:
      subnetId: ${exampleSubnet.id}
      networkSecurityGroupId: ${exampleNetworkSecurityGroup.id}
  exampleRouteTable:
    type: azure:network:RouteTable
    name: example
    properties:
      name: routetable-mi
      location: ${example.location}
      resourceGroupName: ${example.name}
      disableBgpRoutePropagation: false
    options:
      dependson:
        - ${exampleSubnet}
  exampleSubnetRouteTableAssociation:
    type: azure:network:SubnetRouteTableAssociation
    name: example
    properties:
      subnetId: ${exampleSubnet.id}
      routeTableId: ${exampleRouteTable.id}
  exampleManagedInstance:
    type: azure:mssql:ManagedInstance
    name: example
    properties:
      name: managedsqlinstance
      resourceGroupName: ${example.name}
      location: ${example.location}
      licenseType: BasePrice
      skuName: GP_Gen5
      storageSizeInGb: 32
      subnetId: ${exampleSubnet.id}
      vcores: 4
      administratorLogin: mradministrator
      administratorLoginPassword: thisIsDog11
    options:
      dependson:
        - ${exampleSubnetNetworkSecurityGroupAssociation}
        - ${exampleSubnetRouteTableAssociation}

    Create ManagedInstance Resource

    Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.

    Constructor syntax

    new ManagedInstance(name: string, args: ManagedInstanceArgs, opts?: CustomResourceOptions);
    @overload
def ManagedInstance(resource_name: str,
                    args: ManagedInstanceArgs,
                    opts: Optional[ResourceOptions] = None)

@overload
def ManagedInstance(resource_name: str,
                    opts: Optional[ResourceOptions] = None,
                    administrator_login: Optional[str] = None,
                    administrator_login_password: Optional[str] = None,
                    vcores: Optional[int] = None,
                    subnet_id: Optional[str] = None,
                    storage_size_in_gb: Optional[int] = None,
                    license_type: Optional[str] = None,
                    sku_name: Optional[str] = None,
                    resource_group_name: Optional[str] = None,
                    proxy_override: Optional[str] = None,
                    storage_account_type: Optional[str] = None,
                    minimum_tls_version: Optional[str] = None,
                    public_data_endpoint_enabled: Optional[bool] = None,
                    maintenance_configuration_name: Optional[str] = None,
                    service_principal_type: Optional[str] = None,
                    location: Optional[str] = None,
                    name: Optional[str] = None,
                    identity: Optional[ManagedInstanceIdentityArgs] = None,
                    dns_zone_partner_id: Optional[str] = None,
                    tags: Optional[Mapping[str, str]] = None,
                    timezone_id: Optional[str] = None,
                    collation: Optional[str] = None,
                    zone_redundant_enabled: Optional[bool] = None)
    func NewManagedInstance(ctx *Context, name string, args ManagedInstanceArgs, opts ...ResourceOption) (*ManagedInstance, error)
    public ManagedInstance(string name, ManagedInstanceArgs args, CustomResourceOptions? opts = null)
    public ManagedInstance(String name, ManagedInstanceArgs args)
public ManagedInstance(String name, ManagedInstanceArgs args, CustomResourceOptions options)

    type: azure:mssql:ManagedInstance
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.

    Parameters

    name string
    The unique name of the resource.
    args ManagedInstanceArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    resource_name str
    The unique name of the resource.
    args ManagedInstanceArgs
    The arguments to resource properties.
    opts ResourceOptions
    Bag of options to control resource's behavior.
    ctx Context
    Context object for the current deployment.
    name string
    The unique name of the resource.
    args ManagedInstanceArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args ManagedInstanceArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args ManagedInstanceArgs
    The arguments to resource properties.
    options CustomResourceOptions
    Bag of options to control resource's behavior.

    Constructor example

    The following reference example uses placeholder values for all input properties.

    var managedInstanceResource = new Azure.MSSql.ManagedInstance("managedInstanceResource", new()
{
    AdministratorLogin = "string",
    AdministratorLoginPassword = "string",
    Vcores = 0,
    SubnetId = "string",
    StorageSizeInGb = 0,
    LicenseType = "string",
    SkuName = "string",
    ResourceGroupName = "string",
    ProxyOverride = "string",
    StorageAccountType = "string",
    MinimumTlsVersion = "string",
    PublicDataEndpointEnabled = false,
    MaintenanceConfigurationName = "string",
    ServicePrincipalType = "string",
    Location = "string",
    Name = "string",
    Identity = new Azure.MSSql.Inputs.ManagedInstanceIdentityArgs
    {
        Type = "string",
        IdentityIds = new[]
        {
            "string",
        },
        PrincipalId = "string",
        TenantId = "string",
    },
    DnsZonePartnerId = "string",
    Tags = 
    {
        { "string", "string" },
    },
    TimezoneId = "string",
    Collation = "string",
    ZoneRedundantEnabled = false,
});

    example, err := mssql.NewManagedInstance(ctx, "managedInstanceResource", &mssql.ManagedInstanceArgs{
	AdministratorLogin:           pulumi.String("string"),
	AdministratorLoginPassword:   pulumi.String("string"),
	Vcores:                       pulumi.Int(0),
	SubnetId:                     pulumi.String("string"),
	StorageSizeInGb:              pulumi.Int(0),
	LicenseType:                  pulumi.String("string"),
	SkuName:                      pulumi.String("string"),
	ResourceGroupName:            pulumi.String("string"),
	ProxyOverride:                pulumi.String("string"),
	StorageAccountType:           pulumi.String("string"),
	MinimumTlsVersion:            pulumi.String("string"),
	PublicDataEndpointEnabled:    pulumi.Bool(false),
	MaintenanceConfigurationName: pulumi.String("string"),
	ServicePrincipalType:         pulumi.String("string"),
	Location:                     pulumi.String("string"),
	Name:                         pulumi.String("string"),
	Identity: &mssql.ManagedInstanceIdentityArgs{
		Type: pulumi.String("string"),
		IdentityIds: pulumi.StringArray{
			pulumi.String("string"),
		},
		PrincipalId: pulumi.String("string"),
		TenantId:    pulumi.String("string"),
	},
	DnsZonePartnerId: pulumi.String("string"),
	Tags: pulumi.StringMap{
		"string": pulumi.String("string"),
	},
	TimezoneId:           pulumi.String("string"),
	Collation:            pulumi.String("string"),
	ZoneRedundantEnabled: pulumi.Bool(false),
})

    var managedInstanceResource = new ManagedInstance("managedInstanceResource", ManagedInstanceArgs.builder()
    .administratorLogin("string")
    .administratorLoginPassword("string")
    .vcores(0)
    .subnetId("string")
    .storageSizeInGb(0)
    .licenseType("string")
    .skuName("string")
    .resourceGroupName("string")
    .proxyOverride("string")
    .storageAccountType("string")
    .minimumTlsVersion("string")
    .publicDataEndpointEnabled(false)
    .maintenanceConfigurationName("string")
    .servicePrincipalType("string")
    .location("string")
    .name("string")
    .identity(ManagedInstanceIdentityArgs.builder()
        .type("string")
        .identityIds("string")
        .principalId("string")
        .tenantId("string")
        .build())
    .dnsZonePartnerId("string")
    .tags(Map.of("string", "string"))
    .timezoneId("string")
    .collation("string")
    .zoneRedundantEnabled(false)
    .build());

    managed_instance_resource = azure.mssql.ManagedInstance("managedInstanceResource",
    administrator_login="string",
    administrator_login_password="string",
    vcores=0,
    subnet_id="string",
    storage_size_in_gb=0,
    license_type="string",
    sku_name="string",
    resource_group_name="string",
    proxy_override="string",
    storage_account_type="string",
    minimum_tls_version="string",
    public_data_endpoint_enabled=False,
    maintenance_configuration_name="string",
    service_principal_type="string",
    location="string",
    name="string",
    identity={
        "type": "string",
        "identityIds": ["string"],
        "principalId": "string",
        "tenantId": "string",
    },
    dns_zone_partner_id="string",
    tags={
        "string": "string",
    },
    timezone_id="string",
    collation="string",
    zone_redundant_enabled=False)

    const managedInstanceResource = new azure.mssql.ManagedInstance("managedInstanceResource", {
    administratorLogin: "string",
    administratorLoginPassword: "string",
    vcores: 0,
    subnetId: "string",
    storageSizeInGb: 0,
    licenseType: "string",
    skuName: "string",
    resourceGroupName: "string",
    proxyOverride: "string",
    storageAccountType: "string",
    minimumTlsVersion: "string",
    publicDataEndpointEnabled: false,
    maintenanceConfigurationName: "string",
    servicePrincipalType: "string",
    location: "string",
    name: "string",
    identity: {
        type: "string",
        identityIds: ["string"],
        principalId: "string",
        tenantId: "string",
    },
    dnsZonePartnerId: "string",
    tags: {
        string: "string",
    },
    timezoneId: "string",
    collation: "string",
    zoneRedundantEnabled: false,
});

    type: azure:mssql:ManagedInstance
properties:
    administratorLogin: string
    administratorLoginPassword: string
    collation: string
    dnsZonePartnerId: string
    identity:
        identityIds:
            - string
        principalId: string
        tenantId: string
        type: string
    licenseType: string
    location: string
    maintenanceConfigurationName: string
    minimumTlsVersion: string
    name: string
    proxyOverride: string
    publicDataEndpointEnabled: false
    resourceGroupName: string
    servicePrincipalType: string
    skuName: string
    storageAccountType: string
    storageSizeInGb: 0
    subnetId: string
    tags:
        string: string
    timezoneId: string
    vcores: 0
    zoneRedundantEnabled: false

    ManagedInstance Resource Properties

    To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

    Inputs

    The ManagedInstance resource accepts the following input properties:

    AdministratorLogin string
    The administrator login name for the new SQL Managed Instance. Changing this forces a new resource to be created.
    AdministratorLoginPassword string
    The password associated with the administrator_login user. Needs to comply with Azure's Password Policy
    LicenseType string
    What type of license the Managed Instance will use. Possible values are LicenseIncluded and BasePrice.
    ResourceGroupName string
    The name of the resource group in which to create the SQL Managed Instance. Changing this forces a new resource to be created.
    SkuName string
    Specifies the SKU Name for the SQL Managed Instance. Valid values include GP_Gen4, GP_Gen5, GP_Gen8IM, GP_Gen8IH, BC_Gen4, BC_Gen5, BC_Gen8IM or BC_Gen8IH.
    StorageSizeInGb int
    Maximum storage space for the SQL Managed instance. This should be a multiple of 32 (GB).
    SubnetId string
    The subnet resource id that the SQL Managed Instance will be associated with. Changing this forces a new resource to be created.
    Vcores int
    Number of cores that should be assigned to the SQL Managed Instance. Values can be 8, 16, or 24 for Gen4 SKUs, or 4, 6, 8, 10, 12, 16, 20, 24, 32, 40, 48, 56, 64, 80, 96 or 128 for Gen5 SKUs.
    Collation string
    Specifies how the SQL Managed Instance will be collated. Default value is SQL_Latin1_General_CP1_CI_AS. Changing this forces a new resource to be created.
    DnsZonePartnerId string
    The ID of the SQL Managed Instance which will share the DNS zone. This is a prerequisite for creating an azurerm_sql_managed_instance_failover_group. Setting this after creation forces a new resource to be created.
    Identity ManagedInstanceIdentity
    An identity block as defined below.
    Location string
    Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
    MaintenanceConfigurationName string
    The name of the Public Maintenance Configuration window to apply to the SQL Managed Instance. Valid values include SQL_Default or an Azure Location in the format SQL_{Location}_MI_{Size}(for example SQL_EastUS_MI_1). Defaults to SQL_Default.
    MinimumTlsVersion string
    The Minimum TLS Version. Default value is 1.2 Valid values include 1.0, 1.1, 1.2.
    Name string
    The name of the SQL Managed Instance. This needs to be globally unique within Azure. Changing this forces a new resource to be created.
    ProxyOverride string
    Specifies how the SQL Managed Instance will be accessed. Default value is Default. Valid values include Default, Proxy, and Redirect.
    PublicDataEndpointEnabled bool
    Is the public data endpoint enabled? Default value is false.
    ServicePrincipalType string
    The service principal type. The only possible value is SystemAssigned.
    StorageAccountType string
    Specifies the storage account type used to store backups for this database. Changing this forces a new resource to be created. Possible values are GRS, GZRS, LRS, and ZRS. Defaults to GRS.
    Tags Dictionary<string, string>
    A mapping of tags to assign to the resource.
    TimezoneId string
    The TimeZone ID that the SQL Managed Instance will be operating in. Default value is UTC. Changing this forces a new resource to be created.
    ZoneRedundantEnabled bool
    Specifies whether or not the SQL Managed Instance is zone redundant. Defaults to false.
    AdministratorLogin string
    The administrator login name for the new SQL Managed Instance. Changing this forces a new resource to be created.
    AdministratorLoginPassword string
    The password associated with the administrator_login user. Needs to comply with Azure's Password Policy
    LicenseType string
    What type of license the Managed Instance will use. Possible values are LicenseIncluded and BasePrice.
    ResourceGroupName string
    The name of the resource group in which to create the SQL Managed Instance. Changing this forces a new resource to be created.
    SkuName string
    Specifies the SKU Name for the SQL Managed Instance. Valid values include GP_Gen4, GP_Gen5, GP_Gen8IM, GP_Gen8IH, BC_Gen4, BC_Gen5, BC_Gen8IM or BC_Gen8IH.
    StorageSizeInGb int
    Maximum storage space for the SQL Managed instance. This should be a multiple of 32 (GB).
    SubnetId string
    The subnet resource id that the SQL Managed Instance will be associated with. Changing this forces a new resource to be created.
    Vcores int
    Number of cores that should be assigned to the SQL Managed Instance. Values can be 8, 16, or 24 for Gen4 SKUs, or 4, 6, 8, 10, 12, 16, 20, 24, 32, 40, 48, 56, 64, 80, 96 or 128 for Gen5 SKUs.
    Collation string
    Specifies how the SQL Managed Instance will be collated. Default value is SQL_Latin1_General_CP1_CI_AS. Changing this forces a new resource to be created.
    DnsZonePartnerId string
    The ID of the SQL Managed Instance which will share the DNS zone. This is a prerequisite for creating an azurerm_sql_managed_instance_failover_group. Setting this after creation forces a new resource to be created.
    Identity ManagedInstanceIdentityArgs
    An identity block as defined below.
    Location string
    Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
    MaintenanceConfigurationName string
    The name of the Public Maintenance Configuration window to apply to the SQL Managed Instance. Valid values include SQL_Default or an Azure Location in the format SQL_{Location}_MI_{Size}(for example SQL_EastUS_MI_1). Defaults to SQL_Default.
    MinimumTlsVersion string
    The Minimum TLS Version. Default value is 1.2 Valid values include 1.0, 1.1, 1.2.
    Name string
    The name of the SQL Managed Instance. This needs to be globally unique within Azure. Changing this forces a new resource to be created.
    ProxyOverride string
    Specifies how the SQL Managed Instance will be accessed. Default value is Default. Valid values include Default, Proxy, and Redirect.
    PublicDataEndpointEnabled bool
    Is the public data endpoint enabled? Default value is false.
    ServicePrincipalType string
    The service principal type. The only possible value is SystemAssigned.
    StorageAccountType string
    Specifies the storage account type used to store backups for this database. Changing this forces a new resource to be created. Possible values are GRS, GZRS, LRS, and ZRS. Defaults to GRS.
    Tags map[string]string
    A mapping of tags to assign to the resource.
    TimezoneId string
    The TimeZone ID that the SQL Managed Instance will be operating in. Default value is UTC. Changing this forces a new resource to be created.
    ZoneRedundantEnabled bool
    Specifies whether or not the SQL Managed Instance is zone redundant. Defaults to false.
    administratorLogin String
    The administrator login name for the new SQL Managed Instance. Changing this forces a new resource to be created.
    administratorLoginPassword String
    The password associated with the administrator_login user. Needs to comply with Azure's Password Policy
    licenseType String
    What type of license the Managed Instance will use. Possible values are LicenseIncluded and BasePrice.
    resourceGroupName String
    The name of the resource group in which to create the SQL Managed Instance. Changing this forces a new resource to be created.
    skuName String
    Specifies the SKU Name for the SQL Managed Instance. Valid values include GP_Gen4, GP_Gen5, GP_Gen8IM, GP_Gen8IH, BC_Gen4, BC_Gen5, BC_Gen8IM or BC_Gen8IH.
    storageSizeInGb Integer
    Maximum storage space for the SQL Managed instance. This should be a multiple of 32 (GB).
    subnetId String
    The subnet resource id that the SQL Managed Instance will be associated with. Changing this forces a new resource to be created.
    vcores Integer
    Number of cores that should be assigned to the SQL Managed Instance. Values can be 8, 16, or 24 for Gen4 SKUs, or 4, 6, 8, 10, 12, 16, 20, 24, 32, 40, 48, 56, 64, 80, 96 or 128 for Gen5 SKUs.
    collation String
    Specifies how the SQL Managed Instance will be collated. Default value is SQL_Latin1_General_CP1_CI_AS. Changing this forces a new resource to be created.
    dnsZonePartnerId String
    The ID of the SQL Managed Instance which will share the DNS zone. This is a prerequisite for creating an azurerm_sql_managed_instance_failover_group. Setting this after creation forces a new resource to be created.
    identity ManagedInstanceIdentity
    An identity block as defined below.
    location String
    Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
    maintenanceConfigurationName String
    The name of the Public Maintenance Configuration window to apply to the SQL Managed Instance. Valid values include SQL_Default or an Azure Location in the format SQL_{Location}_MI_{Size}(for example SQL_EastUS_MI_1). Defaults to SQL_Default.
    minimumTlsVersion String
    The Minimum TLS Version. Default value is 1.2 Valid values include 1.0, 1.1, 1.2.
    name String
    The name of the SQL Managed Instance. This needs to be globally unique within Azure. Changing this forces a new resource to be created.
    proxyOverride String
    Specifies how the SQL Managed Instance will be accessed. Default value is Default. Valid values include Default, Proxy, and Redirect.
    publicDataEndpointEnabled Boolean
    Is the public data endpoint enabled? Default value is false.
    servicePrincipalType String
    The service principal type. The only possible value is SystemAssigned.
    storageAccountType String
    Specifies the storage account type used to store backups for this database. Changing this forces a new resource to be created. Possible values are GRS, GZRS, LRS, and ZRS. Defaults to GRS.
    tags Map<String,String>
    A mapping of tags to assign to the resource.
    timezoneId String
    The TimeZone ID that the SQL Managed Instance will be operating in. Default value is UTC. Changing this forces a new resource to be created.
    zoneRedundantEnabled Boolean
    Specifies whether or not the SQL Managed Instance is zone redundant. Defaults to false.
    administratorLogin string
    The administrator login name for the new SQL Managed Instance. Changing this forces a new resource to be created.
    administratorLoginPassword string
    The password associated with the administrator_login user. Needs to comply with Azure's Password Policy
    licenseType string
    What type of license the Managed Instance will use. Possible values are LicenseIncluded and BasePrice.
    resourceGroupName string
    The name of the resource group in which to create the SQL Managed Instance. Changing this forces a new resource to be created.
    skuName string
    Specifies the SKU Name for the SQL Managed Instance. Valid values include GP_Gen4, GP_Gen5, GP_Gen8IM, GP_Gen8IH, BC_Gen4, BC_Gen5, BC_Gen8IM or BC_Gen8IH.
    storageSizeInGb number
    Maximum storage space for the SQL Managed instance. This should be a multiple of 32 (GB).
    subnetId string
    The subnet resource id that the SQL Managed Instance will be associated with. Changing this forces a new resource to be created.
    vcores number
    Number of cores that should be assigned to the SQL Managed Instance. Values can be 8, 16, or 24 for Gen4 SKUs, or 4, 6, 8, 10, 12, 16, 20, 24, 32, 40, 48, 56, 64, 80, 96 or 128 for Gen5 SKUs.
    collation string
    Specifies how the SQL Managed Instance will be collated. Default value is SQL_Latin1_General_CP1_CI_AS. Changing this forces a new resource to be created.
    dnsZonePartnerId string
    The ID of the SQL Managed Instance which will share the DNS zone. This is a prerequisite for creating an azurerm_sql_managed_instance_failover_group. Setting this after creation forces a new resource to be created.
    identity ManagedInstanceIdentity
    An identity block as defined below.
    location string
    Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
    maintenanceConfigurationName string
    The name of the Public Maintenance Configuration window to apply to the SQL Managed Instance. Valid values include SQL_Default or an Azure Location in the format SQL_{Location}_MI_{Size}(for example SQL_EastUS_MI_1). Defaults to SQL_Default.
    minimumTlsVersion string
    The Minimum TLS Version. Default value is 1.2 Valid values include 1.0, 1.1, 1.2.
    name string
    The name of the SQL Managed Instance. This needs to be globally unique within Azure. Changing this forces a new resource to be created.
    proxyOverride string
    Specifies how the SQL Managed Instance will be accessed. Default value is Default. Valid values include Default, Proxy, and Redirect.
    publicDataEndpointEnabled boolean
    Is the public data endpoint enabled? Default value is false.
    servicePrincipalType string
    The service principal type. The only possible value is SystemAssigned.
    storageAccountType string
    Specifies the storage account type used to store backups for this database. Changing this forces a new resource to be created. Possible values are GRS, GZRS, LRS, and ZRS. Defaults to GRS.
    tags {[key: string]: string}
    A mapping of tags to assign to the resource.
    timezoneId string
    The TimeZone ID that the SQL Managed Instance will be operating in. Default value is UTC. Changing this forces a new resource to be created.
    zoneRedundantEnabled boolean
    Specifies whether or not the SQL Managed Instance is zone redundant. Defaults to false.
    administrator_login str
    The administrator login name for the new SQL Managed Instance. Changing this forces a new resource to be created.
    administrator_login_password str
    The password associated with the administrator_login user. Needs to comply with Azure's Password Policy
    license_type str
    What type of license the Managed Instance will use. Possible values are LicenseIncluded and BasePrice.
    resource_group_name str
    The name of the resource group in which to create the SQL Managed Instance. Changing this forces a new resource to be created.
    sku_name str
    Specifies the SKU Name for the SQL Managed Instance. Valid values include GP_Gen4, GP_Gen5, GP_Gen8IM, GP_Gen8IH, BC_Gen4, BC_Gen5, BC_Gen8IM or BC_Gen8IH.
    storage_size_in_gb int
    Maximum storage space for the SQL Managed instance. This should be a multiple of 32 (GB).
    subnet_id str
    The subnet resource id that the SQL Managed Instance will be associated with. Changing this forces a new resource to be created.
    vcores int
    Number of cores that should be assigned to the SQL Managed Instance. Values can be 8, 16, or 24 for Gen4 SKUs, or 4, 6, 8, 10, 12, 16, 20, 24, 32, 40, 48, 56, 64, 80, 96 or 128 for Gen5 SKUs.
    collation str
    Specifies how the SQL Managed Instance will be collated. Default value is SQL_Latin1_General_CP1_CI_AS. Changing this forces a new resource to be created.
    dns_zone_partner_id str
    The ID of the SQL Managed Instance which will share the DNS zone. This is a prerequisite for creating an azurerm_sql_managed_instance_failover_group. Setting this after creation forces a new resource to be created.
    identity ManagedInstanceIdentityArgs
    An identity block as defined below.
    location str
    Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
    maintenance_configuration_name str
    The name of the Public Maintenance Configuration window to apply to the SQL Managed Instance. Valid values include SQL_Default or an Azure Location in the format SQL_{Location}_MI_{Size}(for example SQL_EastUS_MI_1). Defaults to SQL_Default.
    minimum_tls_version str
    The Minimum TLS Version. Default value is 1.2 Valid values include 1.0, 1.1, 1.2.
    name str
    The name of the SQL Managed Instance. This needs to be globally unique within Azure. Changing this forces a new resource to be created.
    proxy_override str
    Specifies how the SQL Managed Instance will be accessed. Default value is Default. Valid values include Default, Proxy, and Redirect.
    public_data_endpoint_enabled bool
    Is the public data endpoint enabled? Default value is false.
    service_principal_type str
    The service principal type. The only possible value is SystemAssigned.
    storage_account_type str
    Specifies the storage account type used to store backups for this database. Changing this forces a new resource to be created. Possible values are GRS, GZRS, LRS, and ZRS. Defaults to GRS.
    tags Mapping[str, str]
    A mapping of tags to assign to the resource.
    timezone_id str
    The TimeZone ID that the SQL Managed Instance will be operating in. Default value is UTC. Changing this forces a new resource to be created.
    zone_redundant_enabled bool
    Specifies whether or not the SQL Managed Instance is zone redundant. Defaults to false.
    administratorLogin String
    The administrator login name for the new SQL Managed Instance. Changing this forces a new resource to be created.
    administratorLoginPassword String
    The password associated with the administrator_login user. Needs to comply with Azure's Password Policy
    licenseType String
    What type of license the Managed Instance will use. Possible values are LicenseIncluded and BasePrice.
    resourceGroupName String
    The name of the resource group in which to create the SQL Managed Instance. Changing this forces a new resource to be created.
    skuName String
    Specifies the SKU Name for the SQL Managed Instance. Valid values include GP_Gen4, GP_Gen5, GP_Gen8IM, GP_Gen8IH, BC_Gen4, BC_Gen5, BC_Gen8IM or BC_Gen8IH.
    storageSizeInGb Number
    Maximum storage space for the SQL Managed instance. This should be a multiple of 32 (GB).
    subnetId String
    The subnet resource id that the SQL Managed Instance will be associated with. Changing this forces a new resource to be created.
    vcores Number
    Number of cores that should be assigned to the SQL Managed Instance. Values can be 8, 16, or 24 for Gen4 SKUs, or 4, 6, 8, 10, 12, 16, 20, 24, 32, 40, 48, 56, 64, 80, 96 or 128 for Gen5 SKUs.
    collation String
    Specifies how the SQL Managed Instance will be collated. Default value is SQL_Latin1_General_CP1_CI_AS. Changing this forces a new resource to be created.
    dnsZonePartnerId String
    The ID of the SQL Managed Instance which will share the DNS zone. This is a prerequisite for creating an azurerm_sql_managed_instance_failover_group. Setting this after creation forces a new resource to be created.
    identity Property Map
    An identity block as defined below.
    location String
    Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
    maintenanceConfigurationName String
    The name of the Public Maintenance Configuration window to apply to the SQL Managed Instance. Valid values include SQL_Default or an Azure Location in the format SQL_{Location}_MI_{Size}(for example SQL_EastUS_MI_1). Defaults to SQL_Default.
    minimumTlsVersion String
    The Minimum TLS Version. Default value is 1.2 Valid values include 1.0, 1.1, 1.2.
    name String
    The name of the SQL Managed Instance. This needs to be globally unique within Azure. Changing this forces a new resource to be created.
    proxyOverride String
    Specifies how the SQL Managed Instance will be accessed. Default value is Default. Valid values include Default, Proxy, and Redirect.
    publicDataEndpointEnabled Boolean
    Is the public data endpoint enabled? Default value is false.
    servicePrincipalType String
    The service principal type. The only possible value is SystemAssigned.
    storageAccountType String
    Specifies the storage account type used to store backups for this database. Changing this forces a new resource to be created. Possible values are GRS, GZRS, LRS, and ZRS. Defaults to GRS.
    tags Map<String>
    A mapping of tags to assign to the resource.
    timezoneId String
    The TimeZone ID that the SQL Managed Instance will be operating in. Default value is UTC. Changing this forces a new resource to be created.
    zoneRedundantEnabled Boolean
    Specifies whether or not the SQL Managed Instance is zone redundant. Defaults to false.

    Outputs

    All input properties are implicitly available as output properties. Additionally, the ManagedInstance resource produces the following output properties:

    DnsZone string
    The Dns Zone where the SQL Managed Instance is located.
    Fqdn string
    The fully qualified domain name of the Azure Managed SQL Instance
    Id string
    The provider-assigned unique ID for this managed resource.
    DnsZone string
    The Dns Zone where the SQL Managed Instance is located.
    Fqdn string
    The fully qualified domain name of the Azure Managed SQL Instance
    Id string
    The provider-assigned unique ID for this managed resource.
    dnsZone String
    The Dns Zone where the SQL Managed Instance is located.
    fqdn String
    The fully qualified domain name of the Azure Managed SQL Instance
    id String
    The provider-assigned unique ID for this managed resource.
    dnsZone string
    The Dns Zone where the SQL Managed Instance is located.
    fqdn string
    The fully qualified domain name of the Azure Managed SQL Instance
    id string
    The provider-assigned unique ID for this managed resource.
    dns_zone str
    The Dns Zone where the SQL Managed Instance is located.
    fqdn str
    The fully qualified domain name of the Azure Managed SQL Instance
    id str
    The provider-assigned unique ID for this managed resource.
    dnsZone String
    The Dns Zone where the SQL Managed Instance is located.
    fqdn String
    The fully qualified domain name of the Azure Managed SQL Instance
    id String
    The provider-assigned unique ID for this managed resource.

    Look up Existing ManagedInstance Resource

    Get an existing ManagedInstance resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.

    public static get(name: string, id: Input<ID>, state?: ManagedInstanceState, opts?: CustomResourceOptions): ManagedInstance
    @staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        administrator_login: Optional[str] = None,
        administrator_login_password: Optional[str] = None,
        collation: Optional[str] = None,
        dns_zone: Optional[str] = None,
        dns_zone_partner_id: Optional[str] = None,
        fqdn: Optional[str] = None,
        identity: Optional[ManagedInstanceIdentityArgs] = None,
        license_type: Optional[str] = None,
        location: Optional[str] = None,
        maintenance_configuration_name: Optional[str] = None,
        minimum_tls_version: Optional[str] = None,
        name: Optional[str] = None,
        proxy_override: Optional[str] = None,
        public_data_endpoint_enabled: Optional[bool] = None,
        resource_group_name: Optional[str] = None,
        service_principal_type: Optional[str] = None,
        sku_name: Optional[str] = None,
        storage_account_type: Optional[str] = None,
        storage_size_in_gb: Optional[int] = None,
        subnet_id: Optional[str] = None,
        tags: Optional[Mapping[str, str]] = None,
        timezone_id: Optional[str] = None,
        vcores: Optional[int] = None,
        zone_redundant_enabled: Optional[bool] = None) -> ManagedInstance
    func GetManagedInstance(ctx *Context, name string, id IDInput, state *ManagedInstanceState, opts ...ResourceOption) (*ManagedInstance, error)
    public static ManagedInstance Get(string name, Input<string> id, ManagedInstanceState? state, CustomResourceOptions? opts = null)
    public static ManagedInstance get(String name, Output<String> id, ManagedInstanceState state, CustomResourceOptions options)
    Resource lookup is not supported in YAML
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    resource_name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    The following state arguments are supported:
    AdministratorLogin string
    The administrator login name for the new SQL Managed Instance. Changing this forces a new resource to be created.
    AdministratorLoginPassword string
    The password associated with the administrator_login user. Needs to comply with Azure's Password Policy
    Collation string
    Specifies how the SQL Managed Instance will be collated. Default value is SQL_Latin1_General_CP1_CI_AS. Changing this forces a new resource to be created.
    DnsZone string
    The Dns Zone where the SQL Managed Instance is located.
    DnsZonePartnerId string
    The ID of the SQL Managed Instance which will share the DNS zone. This is a prerequisite for creating an azurerm_sql_managed_instance_failover_group. Setting this after creation forces a new resource to be created.
    Fqdn string
    The fully qualified domain name of the Azure Managed SQL Instance
    Identity ManagedInstanceIdentity
    An identity block as defined below.
    LicenseType string
    What type of license the Managed Instance will use. Possible values are LicenseIncluded and BasePrice.
    Location string
    Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
    MaintenanceConfigurationName string
    The name of the Public Maintenance Configuration window to apply to the SQL Managed Instance. Valid values include SQL_Default or an Azure Location in the format SQL_{Location}_MI_{Size}(for example SQL_EastUS_MI_1). Defaults to SQL_Default.
    MinimumTlsVersion string
    The Minimum TLS Version. Default value is 1.2 Valid values include 1.0, 1.1, 1.2.
    Name string
    The name of the SQL Managed Instance. This needs to be globally unique within Azure. Changing this forces a new resource to be created.
    ProxyOverride string
    Specifies how the SQL Managed Instance will be accessed. Default value is Default. Valid values include Default, Proxy, and Redirect.
    PublicDataEndpointEnabled bool
    Is the public data endpoint enabled? Default value is false.
    ResourceGroupName string
    The name of the resource group in which to create the SQL Managed Instance. Changing this forces a new resource to be created.
    ServicePrincipalType string
    The service principal type. The only possible value is SystemAssigned.
    SkuName string
    Specifies the SKU Name for the SQL Managed Instance. Valid values include GP_Gen4, GP_Gen5, GP_Gen8IM, GP_Gen8IH, BC_Gen4, BC_Gen5, BC_Gen8IM or BC_Gen8IH.
    StorageAccountType string
    Specifies the storage account type used to store backups for this database. Changing this forces a new resource to be created. Possible values are GRS, GZRS, LRS, and ZRS. Defaults to GRS.
    StorageSizeInGb int
    Maximum storage space for the SQL Managed instance. This should be a multiple of 32 (GB).
    SubnetId string
    The subnet resource id that the SQL Managed Instance will be associated with. Changing this forces a new resource to be created.
    Tags Dictionary<string, string>
    A mapping of tags to assign to the resource.
    TimezoneId string
    The TimeZone ID that the SQL Managed Instance will be operating in. Default value is UTC. Changing this forces a new resource to be created.
    Vcores int
    Number of cores that should be assigned to the SQL Managed Instance. Values can be 8, 16, or 24 for Gen4 SKUs, or 4, 6, 8, 10, 12, 16, 20, 24, 32, 40, 48, 56, 64, 80, 96 or 128 for Gen5 SKUs.
    ZoneRedundantEnabled bool
    Specifies whether or not the SQL Managed Instance is zone redundant. Defaults to false.
    AdministratorLogin string
    The administrator login name for the new SQL Managed Instance. Changing this forces a new resource to be created.
    AdministratorLoginPassword string
    The password associated with the administrator_login user. Needs to comply with Azure's Password Policy
    Collation string
    Specifies how the SQL Managed Instance will be collated. Default value is SQL_Latin1_General_CP1_CI_AS. Changing this forces a new resource to be created.
    DnsZone string
    The Dns Zone where the SQL Managed Instance is located.
    DnsZonePartnerId string
    The ID of the SQL Managed Instance which will share the DNS zone. This is a prerequisite for creating an azurerm_sql_managed_instance_failover_group. Setting this after creation forces a new resource to be created.
    Fqdn string
    The fully qualified domain name of the Azure Managed SQL Instance
    Identity ManagedInstanceIdentityArgs
    An identity block as defined below.
    LicenseType string
    What type of license the Managed Instance will use. Possible values are LicenseIncluded and BasePrice.
    Location string
    Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
    MaintenanceConfigurationName string
    The name of the Public Maintenance Configuration window to apply to the SQL Managed Instance. Valid values include SQL_Default or an Azure Location in the format SQL_{Location}_MI_{Size}(for example SQL_EastUS_MI_1). Defaults to SQL_Default.
    MinimumTlsVersion string
    The Minimum TLS Version. Default value is 1.2 Valid values include 1.0, 1.1, 1.2.
    Name string
    The name of the SQL Managed Instance. This needs to be globally unique within Azure. Changing this forces a new resource to be created.
    ProxyOverride string
    Specifies how the SQL Managed Instance will be accessed. Default value is Default. Valid values include Default, Proxy, and Redirect.
    PublicDataEndpointEnabled bool
    Is the public data endpoint enabled? Default value is false.
    ResourceGroupName string
    The name of the resource group in which to create the SQL Managed Instance. Changing this forces a new resource to be created.
    ServicePrincipalType string
    The service principal type. The only possible value is SystemAssigned.
    SkuName string
    Specifies the SKU Name for the SQL Managed Instance. Valid values include GP_Gen4, GP_Gen5, GP_Gen8IM, GP_Gen8IH, BC_Gen4, BC_Gen5, BC_Gen8IM or BC_Gen8IH.
    StorageAccountType string
    Specifies the storage account type used to store backups for this database. Changing this forces a new resource to be created. Possible values are GRS, GZRS, LRS, and ZRS. Defaults to GRS.
    StorageSizeInGb int
    Maximum storage space for the SQL Managed instance. This should be a multiple of 32 (GB).
    SubnetId string
    The subnet resource id that the SQL Managed Instance will be associated with. Changing this forces a new resource to be created.
    Tags map[string]string
    A mapping of tags to assign to the resource.
    TimezoneId string
    The TimeZone ID that the SQL Managed Instance will be operating in. Default value is UTC. Changing this forces a new resource to be created.
    Vcores int
    Number of cores that should be assigned to the SQL Managed Instance. Values can be 8, 16, or 24 for Gen4 SKUs, or 4, 6, 8, 10, 12, 16, 20, 24, 32, 40, 48, 56, 64, 80, 96 or 128 for Gen5 SKUs.
    ZoneRedundantEnabled bool
    Specifies whether or not the SQL Managed Instance is zone redundant. Defaults to false.
    administratorLogin String
    The administrator login name for the new SQL Managed Instance. Changing this forces a new resource to be created.
    administratorLoginPassword String
    The password associated with the administrator_login user. Needs to comply with Azure's Password Policy
    collation String
    Specifies how the SQL Managed Instance will be collated. Default value is SQL_Latin1_General_CP1_CI_AS. Changing this forces a new resource to be created.
    dnsZone String
    The Dns Zone where the SQL Managed Instance is located.
    dnsZonePartnerId String
    The ID of the SQL Managed Instance which will share the DNS zone. This is a prerequisite for creating an azurerm_sql_managed_instance_failover_group. Setting this after creation forces a new resource to be created.
    fqdn String
    The fully qualified domain name of the Azure Managed SQL Instance
    identity ManagedInstanceIdentity
    An identity block as defined below.
    licenseType String
    What type of license the Managed Instance will use. Possible values are LicenseIncluded and BasePrice.
    location String
    Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
    maintenanceConfigurationName String
    The name of the Public Maintenance Configuration window to apply to the SQL Managed Instance. Valid values include SQL_Default or an Azure Location in the format SQL_{Location}_MI_{Size}(for example SQL_EastUS_MI_1). Defaults to SQL_Default.
    minimumTlsVersion String
    The Minimum TLS Version. Default value is 1.2 Valid values include 1.0, 1.1, 1.2.
    name String
    The name of the SQL Managed Instance. This needs to be globally unique within Azure. Changing this forces a new resource to be created.
    proxyOverride String
    Specifies how the SQL Managed Instance will be accessed. Default value is Default. Valid values include Default, Proxy, and Redirect.
    publicDataEndpointEnabled Boolean
    Is the public data endpoint enabled? Default value is false.
    resourceGroupName String
    The name of the resource group in which to create the SQL Managed Instance. Changing this forces a new resource to be created.
    servicePrincipalType String
    The service principal type. The only possible value is SystemAssigned.
    skuName String
    Specifies the SKU Name for the SQL Managed Instance. Valid values include GP_Gen4, GP_Gen5, GP_Gen8IM, GP_Gen8IH, BC_Gen4, BC_Gen5, BC_Gen8IM or BC_Gen8IH.
    storageAccountType String
    Specifies the storage account type used to store backups for this database. Changing this forces a new resource to be created. Possible values are GRS, GZRS, LRS, and ZRS. Defaults to GRS.
    storageSizeInGb Integer
    Maximum storage space for the SQL Managed instance. This should be a multiple of 32 (GB).
    subnetId String
    The subnet resource id that the SQL Managed Instance will be associated with. Changing this forces a new resource to be created.
    tags Map<String,String>
    A mapping of tags to assign to the resource.
    timezoneId String
    The TimeZone ID that the SQL Managed Instance will be operating in. Default value is UTC. Changing this forces a new resource to be created.
    vcores Integer
    Number of cores that should be assigned to the SQL Managed Instance. Values can be 8, 16, or 24 for Gen4 SKUs, or 4, 6, 8, 10, 12, 16, 20, 24, 32, 40, 48, 56, 64, 80, 96 or 128 for Gen5 SKUs.
    zoneRedundantEnabled Boolean
    Specifies whether or not the SQL Managed Instance is zone redundant. Defaults to false.
    administratorLogin string
    The administrator login name for the new SQL Managed Instance. Changing this forces a new resource to be created.
    administratorLoginPassword string
    The password associated with the administrator_login user. Needs to comply with Azure's Password Policy
    collation string
    Specifies how the SQL Managed Instance will be collated. Default value is SQL_Latin1_General_CP1_CI_AS. Changing this forces a new resource to be created.
    dnsZone string
    The Dns Zone where the SQL Managed Instance is located.
    dnsZonePartnerId string
    The ID of the SQL Managed Instance which will share the DNS zone. This is a prerequisite for creating an azurerm_sql_managed_instance_failover_group. Setting this after creation forces a new resource to be created.
    fqdn string
    The fully qualified domain name of the Azure Managed SQL Instance
    identity ManagedInstanceIdentity
    An identity block as defined below.
    licenseType string
    What type of license the Managed Instance will use. Possible values are LicenseIncluded and BasePrice.
    location string
    Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
    maintenanceConfigurationName string
    The name of the Public Maintenance Configuration window to apply to the SQL Managed Instance. Valid values include SQL_Default or an Azure Location in the format SQL_{Location}_MI_{Size}(for example SQL_EastUS_MI_1). Defaults to SQL_Default.
    minimumTlsVersion string
    The Minimum TLS Version. Default value is 1.2 Valid values include 1.0, 1.1, 1.2.
    name string
    The name of the SQL Managed Instance. This needs to be globally unique within Azure. Changing this forces a new resource to be created.
    proxyOverride string
    Specifies how the SQL Managed Instance will be accessed. Default value is Default. Valid values include Default, Proxy, and Redirect.
    publicDataEndpointEnabled boolean
    Is the public data endpoint enabled? Default value is false.
    resourceGroupName string
    The name of the resource group in which to create the SQL Managed Instance. Changing this forces a new resource to be created.
    servicePrincipalType string
    The service principal type. The only possible value is SystemAssigned.
    skuName string
    Specifies the SKU Name for the SQL Managed Instance. Valid values include GP_Gen4, GP_Gen5, GP_Gen8IM, GP_Gen8IH, BC_Gen4, BC_Gen5, BC_Gen8IM or BC_Gen8IH.
    storageAccountType string
    Specifies the storage account type used to store backups for this database. Changing this forces a new resource to be created. Possible values are GRS, GZRS, LRS, and ZRS. Defaults to GRS.
    storageSizeInGb number
    Maximum storage space for the SQL Managed instance. This should be a multiple of 32 (GB).
    subnetId string
    The subnet resource id that the SQL Managed Instance will be associated with. Changing this forces a new resource to be created.
    tags {[key: string]: string}
    A mapping of tags to assign to the resource.
    timezoneId string
    The TimeZone ID that the SQL Managed Instance will be operating in. Default value is UTC. Changing this forces a new resource to be created.
    vcores number
    Number of cores that should be assigned to the SQL Managed Instance. Values can be 8, 16, or 24 for Gen4 SKUs, or 4, 6, 8, 10, 12, 16, 20, 24, 32, 40, 48, 56, 64, 80, 96 or 128 for Gen5 SKUs.
    zoneRedundantEnabled boolean
    Specifies whether or not the SQL Managed Instance is zone redundant. Defaults to false.
    administrator_login str
    The administrator login name for the new SQL Managed Instance. Changing this forces a new resource to be created.
    administrator_login_password str
    The password associated with the administrator_login user. Needs to comply with Azure's Password Policy
    collation str
    Specifies how the SQL Managed Instance will be collated. Default value is SQL_Latin1_General_CP1_CI_AS. Changing this forces a new resource to be created.
    dns_zone str
    The Dns Zone where the SQL Managed Instance is located.
    dns_zone_partner_id str
    The ID of the SQL Managed Instance which will share the DNS zone. This is a prerequisite for creating an azurerm_sql_managed_instance_failover_group. Setting this after creation forces a new resource to be created.
    fqdn str
    The fully qualified domain name of the Azure Managed SQL Instance
    identity ManagedInstanceIdentityArgs
    An identity block as defined below.
    license_type str
    What type of license the Managed Instance will use. Possible values are LicenseIncluded and BasePrice.
    location str
    Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
    maintenance_configuration_name str
    The name of the Public Maintenance Configuration window to apply to the SQL Managed Instance. Valid values include SQL_Default or an Azure Location in the format SQL_{Location}_MI_{Size}(for example SQL_EastUS_MI_1). Defaults to SQL_Default.
    minimum_tls_version str
    The Minimum TLS Version. Default value is 1.2 Valid values include 1.0, 1.1, 1.2.
    name str
    The name of the SQL Managed Instance. This needs to be globally unique within Azure. Changing this forces a new resource to be created.
    proxy_override str
    Specifies how the SQL Managed Instance will be accessed. Default value is Default. Valid values include Default, Proxy, and Redirect.
    public_data_endpoint_enabled bool
    Is the public data endpoint enabled? Default value is false.
    resource_group_name str
    The name of the resource group in which to create the SQL Managed Instance. Changing this forces a new resource to be created.
    service_principal_type str
    The service principal type. The only possible value is SystemAssigned.
    sku_name str
    Specifies the SKU Name for the SQL Managed Instance. Valid values include GP_Gen4, GP_Gen5, GP_Gen8IM, GP_Gen8IH, BC_Gen4, BC_Gen5, BC_Gen8IM or BC_Gen8IH.
    storage_account_type str
    Specifies the storage account type used to store backups for this database. Changing this forces a new resource to be created. Possible values are GRS, GZRS, LRS, and ZRS. Defaults to GRS.
    storage_size_in_gb int
    Maximum storage space for the SQL Managed instance. This should be a multiple of 32 (GB).
    subnet_id str
    The subnet resource id that the SQL Managed Instance will be associated with. Changing this forces a new resource to be created.
    tags Mapping[str, str]
    A mapping of tags to assign to the resource.
    timezone_id str
    The TimeZone ID that the SQL Managed Instance will be operating in. Default value is UTC. Changing this forces a new resource to be created.
    vcores int
    Number of cores that should be assigned to the SQL Managed Instance. Values can be 8, 16, or 24 for Gen4 SKUs, or 4, 6, 8, 10, 12, 16, 20, 24, 32, 40, 48, 56, 64, 80, 96 or 128 for Gen5 SKUs.
    zone_redundant_enabled bool
    Specifies whether or not the SQL Managed Instance is zone redundant. Defaults to false.
    administratorLogin String
    The administrator login name for the new SQL Managed Instance. Changing this forces a new resource to be created.
    administratorLoginPassword String
    The password associated with the administrator_login user. Needs to comply with Azure's Password Policy
    collation String
    Specifies how the SQL Managed Instance will be collated. Default value is SQL_Latin1_General_CP1_CI_AS. Changing this forces a new resource to be created.
    dnsZone String
    The Dns Zone where the SQL Managed Instance is located.
    dnsZonePartnerId String
    The ID of the SQL Managed Instance which will share the DNS zone. This is a prerequisite for creating an azurerm_sql_managed_instance_failover_group. Setting this after creation forces a new resource to be created.
    fqdn String
    The fully qualified domain name of the Azure Managed SQL Instance
    identity Property Map
    An identity block as defined below.
    licenseType String
    What type of license the Managed Instance will use. Possible values are LicenseIncluded and BasePrice.
    location String
    Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
    maintenanceConfigurationName String
    The name of the Public Maintenance Configuration window to apply to the SQL Managed Instance. Valid values include SQL_Default or an Azure Location in the format SQL_{Location}_MI_{Size}(for example SQL_EastUS_MI_1). Defaults to SQL_Default.
    minimumTlsVersion String
    The Minimum TLS Version. Default value is 1.2 Valid values include 1.0, 1.1, 1.2.
    name String
    The name of the SQL Managed Instance. This needs to be globally unique within Azure. Changing this forces a new resource to be created.
    proxyOverride String
    Specifies how the SQL Managed Instance will be accessed. Default value is Default. Valid values include Default, Proxy, and Redirect.
    publicDataEndpointEnabled Boolean
    Is the public data endpoint enabled? Default value is false.
    resourceGroupName String
    The name of the resource group in which to create the SQL Managed Instance. Changing this forces a new resource to be created.
    servicePrincipalType String
    The service principal type. The only possible value is SystemAssigned.
    skuName String
    Specifies the SKU Name for the SQL Managed Instance. Valid values include GP_Gen4, GP_Gen5, GP_Gen8IM, GP_Gen8IH, BC_Gen4, BC_Gen5, BC_Gen8IM or BC_Gen8IH.
    storageAccountType String
    Specifies the storage account type used to store backups for this database. Changing this forces a new resource to be created. Possible values are GRS, GZRS, LRS, and ZRS. Defaults to GRS.
    storageSizeInGb Number
    Maximum storage space for the SQL Managed instance. This should be a multiple of 32 (GB).
    subnetId String
    The subnet resource id that the SQL Managed Instance will be associated with. Changing this forces a new resource to be created.
    tags Map<String>
    A mapping of tags to assign to the resource.
    timezoneId String
    The TimeZone ID that the SQL Managed Instance will be operating in. Default value is UTC. Changing this forces a new resource to be created.
    vcores Number
    Number of cores that should be assigned to the SQL Managed Instance. Values can be 8, 16, or 24 for Gen4 SKUs, or 4, 6, 8, 10, 12, 16, 20, 24, 32, 40, 48, 56, 64, 80, 96 or 128 for Gen5 SKUs.
    zoneRedundantEnabled Boolean
    Specifies whether or not the SQL Managed Instance is zone redundant. Defaults to false.

    Supporting Types

    ManagedInstanceIdentity, ManagedInstanceIdentityArgs

    Type string
    Specifies the type of Managed Service Identity that should be configured on this SQL Managed Instance. Possible values are SystemAssigned, UserAssigned.
    IdentityIds List<string>

    Specifies a list of User Assigned Managed Identity IDs to be assigned to this SQL Managed Instance. Required when type is set to UserAssigned.

    The assigned principal_id and tenant_id can be retrieved after the identity type has been set to SystemAssigned and SQL Managed Instance has been created.

    PrincipalId string
    The Principal ID for the Service Principal associated with the Identity of this SQL Managed Instance.
    TenantId string
    The Tenant ID for the Service Principal associated with the Identity of this SQL Managed Instance.
    Type string
    Specifies the type of Managed Service Identity that should be configured on this SQL Managed Instance. Possible values are SystemAssigned, UserAssigned.
    IdentityIds []string

    Specifies a list of User Assigned Managed Identity IDs to be assigned to this SQL Managed Instance. Required when type is set to UserAssigned.

    The assigned principal_id and tenant_id can be retrieved after the identity type has been set to SystemAssigned and SQL Managed Instance has been created.

    PrincipalId string
    The Principal ID for the Service Principal associated with the Identity of this SQL Managed Instance.
    TenantId string
    The Tenant ID for the Service Principal associated with the Identity of this SQL Managed Instance.
    type String
    Specifies the type of Managed Service Identity that should be configured on this SQL Managed Instance. Possible values are SystemAssigned, UserAssigned.
    identityIds List<String>

    Specifies a list of User Assigned Managed Identity IDs to be assigned to this SQL Managed Instance. Required when type is set to UserAssigned.

    The assigned principal_id and tenant_id can be retrieved after the identity type has been set to SystemAssigned and SQL Managed Instance has been created.

    principalId String
    The Principal ID for the Service Principal associated with the Identity of this SQL Managed Instance.
    tenantId String
    The Tenant ID for the Service Principal associated with the Identity of this SQL Managed Instance.
    type string
    Specifies the type of Managed Service Identity that should be configured on this SQL Managed Instance. Possible values are SystemAssigned, UserAssigned.
    identityIds string[]

    Specifies a list of User Assigned Managed Identity IDs to be assigned to this SQL Managed Instance. Required when type is set to UserAssigned.

    The assigned principal_id and tenant_id can be retrieved after the identity type has been set to SystemAssigned and SQL Managed Instance has been created.

    principalId string
    The Principal ID for the Service Principal associated with the Identity of this SQL Managed Instance.
    tenantId string
    The Tenant ID for the Service Principal associated with the Identity of this SQL Managed Instance.
    type str
    Specifies the type of Managed Service Identity that should be configured on this SQL Managed Instance. Possible values are SystemAssigned, UserAssigned.
    identity_ids Sequence[str]

    Specifies a list of User Assigned Managed Identity IDs to be assigned to this SQL Managed Instance. Required when type is set to UserAssigned.

    The assigned principal_id and tenant_id can be retrieved after the identity type has been set to SystemAssigned and SQL Managed Instance has been created.

    principal_id str
    The Principal ID for the Service Principal associated with the Identity of this SQL Managed Instance.
    tenant_id str
    The Tenant ID for the Service Principal associated with the Identity of this SQL Managed Instance.
    type String
    Specifies the type of Managed Service Identity that should be configured on this SQL Managed Instance. Possible values are SystemAssigned, UserAssigned.
    identityIds List<String>

    Specifies a list of User Assigned Managed Identity IDs to be assigned to this SQL Managed Instance. Required when type is set to UserAssigned.

    The assigned principal_id and tenant_id can be retrieved after the identity type has been set to SystemAssigned and SQL Managed Instance has been created.

    principalId String
    The Principal ID for the Service Principal associated with the Identity of this SQL Managed Instance.
    tenantId String
    The Tenant ID for the Service Principal associated with the Identity of this SQL Managed Instance.

    Import

    Microsoft SQL Managed Instances can be imported using the resource id, e.g.

    $ pulumi import azure:mssql/managedInstance:ManagedInstance example /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/myresourcegroup/providers/Microsoft.Sql/managedInstances/myserver

    To learn more about importing existing cloud resources, see Importing resources.

    Package Details

    Repository
    Azure Classic pulumi/pulumi-azure
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the azurerm Terraform Provider.
    azure logo

    We recommend using Azure Native.

    Azure Classic v6.2.0 published on Friday, Sep 27, 2024 by Pulumi
    pulumi/pulumi-azure