Docs Home Pulumi IaC Pulumi ESC Pulumi Cloud Packages Tutorials
  1. Packages
  2. Azure Native
  3. API Docs
  4. sql
  5. ManagedInstance
This is the latest version of Azure Native. Use the Azure Native v1 docs if using the v1 version of this package.
Azure Native v2.89.1 published on Sunday, Mar 2, 2025 by Pulumi
pulumi/pulumi-azure-native

azure-native.sql.ManagedInstance

Explore with Pulumi AI

azure-native logo
This is the latest version of Azure Native. Use the Azure Native v1 docs if using the v1 version of this package.
Azure Native v2.89.1 published on Sunday, Mar 2, 2025 by Pulumi
pulumi/pulumi-azure-native

    An Azure SQL managed instance. Azure REST API version: 2021-11-01. Prior API version in Azure Native 1.x: 2020-11-01-preview.

    Other available API versions: 2021-02-01-preview, 2022-11-01-preview, 2023-02-01-preview, 2023-05-01-preview, 2023-08-01-preview, 2024-05-01-preview.

    Example Usage

    Create managed instance with all properties

    using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;

return await Deployment.RunAsync(() => 
{
    var managedInstance = new AzureNative.Sql.ManagedInstance("managedInstance", new()
    {
        AdministratorLogin = "dummylogin",
        AdministratorLoginPassword = "PLACEHOLDER",
        Administrators = new AzureNative.Sql.Inputs.ManagedInstanceExternalAdministratorArgs
        {
            AzureADOnlyAuthentication = true,
            Login = "bob@contoso.com",
            PrincipalType = AzureNative.Sql.PrincipalType.User,
            Sid = "00000011-1111-2222-2222-123456789111",
            TenantId = "00000011-1111-2222-2222-123456789111",
        },
        Collation = "SQL_Latin1_General_CP1_CI_AS",
        DnsZonePartner = "/subscriptions/20D7082A-0FC7-4468-82BD-542694D5042B/resourceGroups/testrg/providers/Microsoft.Sql/managedInstances/testinstance",
        InstancePoolId = "/subscriptions/20D7082A-0FC7-4468-82BD-542694D5042B/resourceGroups/testrg/providers/Microsoft.Sql/instancePools/pool1",
        LicenseType = AzureNative.Sql.ManagedInstanceLicenseType.LicenseIncluded,
        Location = "Japan East",
        MaintenanceConfigurationId = "/subscriptions/20D7082A-0FC7-4468-82BD-542694D5042B/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_JapanEast_MI_1",
        ManagedInstanceName = "testinstance",
        MinimalTlsVersion = "1.2",
        ProxyOverride = AzureNative.Sql.ManagedInstanceProxyOverride.Redirect,
        PublicDataEndpointEnabled = false,
        RequestedBackupStorageRedundancy = AzureNative.Sql.BackupStorageRedundancy.Geo,
        ResourceGroupName = "testrg",
        ServicePrincipal = new AzureNative.Sql.Inputs.ServicePrincipalArgs
        {
            Type = AzureNative.Sql.ServicePrincipalType.SystemAssigned,
        },
        Sku = new AzureNative.Sql.Inputs.SkuArgs
        {
            Name = "GP_Gen5",
            Tier = "GeneralPurpose",
        },
        StorageSizeInGB = 1024,
        SubnetId = "/subscriptions/20D7082A-0FC7-4468-82BD-542694D5042B/resourceGroups/testrg/providers/Microsoft.Network/virtualNetworks/vnet1/subnets/subnet1",
        Tags = 
        {
            { "tagKey1", "TagValue1" },
        },
        TimezoneId = "UTC",
        VCores = 8,
    });

});

    package main

import (
	sql "github.com/pulumi/pulumi-azure-native-sdk/sql/v2"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := sql.NewManagedInstance(ctx, "managedInstance", &sql.ManagedInstanceArgs{
			AdministratorLogin:         pulumi.String("dummylogin"),
			AdministratorLoginPassword: pulumi.String("PLACEHOLDER"),
			Administrators: &sql.ManagedInstanceExternalAdministratorArgs{
				AzureADOnlyAuthentication: pulumi.Bool(true),
				Login:                     pulumi.String("bob@contoso.com"),
				PrincipalType:             pulumi.String(sql.PrincipalTypeUser),
				Sid:                       pulumi.String("00000011-1111-2222-2222-123456789111"),
				TenantId:                  pulumi.String("00000011-1111-2222-2222-123456789111"),
			},
			Collation:                        pulumi.String("SQL_Latin1_General_CP1_CI_AS"),
			DnsZonePartner:                   pulumi.String("/subscriptions/20D7082A-0FC7-4468-82BD-542694D5042B/resourceGroups/testrg/providers/Microsoft.Sql/managedInstances/testinstance"),
			InstancePoolId:                   pulumi.String("/subscriptions/20D7082A-0FC7-4468-82BD-542694D5042B/resourceGroups/testrg/providers/Microsoft.Sql/instancePools/pool1"),
			LicenseType:                      pulumi.String(sql.ManagedInstanceLicenseTypeLicenseIncluded),
			Location:                         pulumi.String("Japan East"),
			MaintenanceConfigurationId:       pulumi.String("/subscriptions/20D7082A-0FC7-4468-82BD-542694D5042B/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_JapanEast_MI_1"),
			ManagedInstanceName:              pulumi.String("testinstance"),
			MinimalTlsVersion:                pulumi.String("1.2"),
			ProxyOverride:                    pulumi.String(sql.ManagedInstanceProxyOverrideRedirect),
			PublicDataEndpointEnabled:        pulumi.Bool(false),
			RequestedBackupStorageRedundancy: pulumi.String(sql.BackupStorageRedundancyGeo),
			ResourceGroupName:                pulumi.String("testrg"),
			ServicePrincipal: &sql.ServicePrincipalArgs{
				Type: pulumi.String(sql.ServicePrincipalTypeSystemAssigned),
			},
			Sku: &sql.SkuArgs{
				Name: pulumi.String("GP_Gen5"),
				Tier: pulumi.String("GeneralPurpose"),
			},
			StorageSizeInGB: pulumi.Int(1024),
			SubnetId:        pulumi.String("/subscriptions/20D7082A-0FC7-4468-82BD-542694D5042B/resourceGroups/testrg/providers/Microsoft.Network/virtualNetworks/vnet1/subnets/subnet1"),
			Tags: pulumi.StringMap{
				"tagKey1": pulumi.String("TagValue1"),
			},
			TimezoneId: pulumi.String("UTC"),
			VCores:     pulumi.Int(8),
		})
		if err != nil {
			return err
		}
		return nil
	})
}

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azurenative.sql.ManagedInstance;
import com.pulumi.azurenative.sql.ManagedInstanceArgs;
import com.pulumi.azurenative.sql.inputs.ManagedInstanceExternalAdministratorArgs;
import com.pulumi.azurenative.sql.inputs.ServicePrincipalArgs;
import com.pulumi.azurenative.sql.inputs.SkuArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        var managedInstance = new ManagedInstance("managedInstance", ManagedInstanceArgs.builder()
            .administratorLogin("dummylogin")
            .administratorLoginPassword("PLACEHOLDER")
            .administrators(ManagedInstanceExternalAdministratorArgs.builder()
                .azureADOnlyAuthentication(true)
                .login("bob@contoso.com")
                .principalType("User")
                .sid("00000011-1111-2222-2222-123456789111")
                .tenantId("00000011-1111-2222-2222-123456789111")
                .build())
            .collation("SQL_Latin1_General_CP1_CI_AS")
            .dnsZonePartner("/subscriptions/20D7082A-0FC7-4468-82BD-542694D5042B/resourceGroups/testrg/providers/Microsoft.Sql/managedInstances/testinstance")
            .instancePoolId("/subscriptions/20D7082A-0FC7-4468-82BD-542694D5042B/resourceGroups/testrg/providers/Microsoft.Sql/instancePools/pool1")
            .licenseType("LicenseIncluded")
            .location("Japan East")
            .maintenanceConfigurationId("/subscriptions/20D7082A-0FC7-4468-82BD-542694D5042B/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_JapanEast_MI_1")
            .managedInstanceName("testinstance")
            .minimalTlsVersion("1.2")
            .proxyOverride("Redirect")
            .publicDataEndpointEnabled(false)
            .requestedBackupStorageRedundancy("Geo")
            .resourceGroupName("testrg")
            .servicePrincipal(ServicePrincipalArgs.builder()
                .type("SystemAssigned")
                .build())
            .sku(SkuArgs.builder()
                .name("GP_Gen5")
                .tier("GeneralPurpose")
                .build())
            .storageSizeInGB(1024)
            .subnetId("/subscriptions/20D7082A-0FC7-4468-82BD-542694D5042B/resourceGroups/testrg/providers/Microsoft.Network/virtualNetworks/vnet1/subnets/subnet1")
            .tags(Map.of("tagKey1", "TagValue1"))
            .timezoneId("UTC")
            .vCores(8)
            .build());

    }
}

    import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";

const managedInstance = new azure_native.sql.ManagedInstance("managedInstance", {
    administratorLogin: "dummylogin",
    administratorLoginPassword: "PLACEHOLDER",
    administrators: {
        azureADOnlyAuthentication: true,
        login: "bob@contoso.com",
        principalType: azure_native.sql.PrincipalType.User,
        sid: "00000011-1111-2222-2222-123456789111",
        tenantId: "00000011-1111-2222-2222-123456789111",
    },
    collation: "SQL_Latin1_General_CP1_CI_AS",
    dnsZonePartner: "/subscriptions/20D7082A-0FC7-4468-82BD-542694D5042B/resourceGroups/testrg/providers/Microsoft.Sql/managedInstances/testinstance",
    instancePoolId: "/subscriptions/20D7082A-0FC7-4468-82BD-542694D5042B/resourceGroups/testrg/providers/Microsoft.Sql/instancePools/pool1",
    licenseType: azure_native.sql.ManagedInstanceLicenseType.LicenseIncluded,
    location: "Japan East",
    maintenanceConfigurationId: "/subscriptions/20D7082A-0FC7-4468-82BD-542694D5042B/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_JapanEast_MI_1",
    managedInstanceName: "testinstance",
    minimalTlsVersion: "1.2",
    proxyOverride: azure_native.sql.ManagedInstanceProxyOverride.Redirect,
    publicDataEndpointEnabled: false,
    requestedBackupStorageRedundancy: azure_native.sql.BackupStorageRedundancy.Geo,
    resourceGroupName: "testrg",
    servicePrincipal: {
        type: azure_native.sql.ServicePrincipalType.SystemAssigned,
    },
    sku: {
        name: "GP_Gen5",
        tier: "GeneralPurpose",
    },
    storageSizeInGB: 1024,
    subnetId: "/subscriptions/20D7082A-0FC7-4468-82BD-542694D5042B/resourceGroups/testrg/providers/Microsoft.Network/virtualNetworks/vnet1/subnets/subnet1",
    tags: {
        tagKey1: "TagValue1",
    },
    timezoneId: "UTC",
    vCores: 8,
});

    import pulumi
import pulumi_azure_native as azure_native

managed_instance = azure_native.sql.ManagedInstance("managedInstance",
    administrator_login="dummylogin",
    administrator_login_password="PLACEHOLDER",
    administrators={
        "azure_ad_only_authentication": True,
        "login": "bob@contoso.com",
        "principal_type": azure_native.sql.PrincipalType.USER,
        "sid": "00000011-1111-2222-2222-123456789111",
        "tenant_id": "00000011-1111-2222-2222-123456789111",
    },
    collation="SQL_Latin1_General_CP1_CI_AS",
    dns_zone_partner="/subscriptions/20D7082A-0FC7-4468-82BD-542694D5042B/resourceGroups/testrg/providers/Microsoft.Sql/managedInstances/testinstance",
    instance_pool_id="/subscriptions/20D7082A-0FC7-4468-82BD-542694D5042B/resourceGroups/testrg/providers/Microsoft.Sql/instancePools/pool1",
    license_type=azure_native.sql.ManagedInstanceLicenseType.LICENSE_INCLUDED,
    location="Japan East",
    maintenance_configuration_id="/subscriptions/20D7082A-0FC7-4468-82BD-542694D5042B/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_JapanEast_MI_1",
    managed_instance_name="testinstance",
    minimal_tls_version="1.2",
    proxy_override=azure_native.sql.ManagedInstanceProxyOverride.REDIRECT,
    public_data_endpoint_enabled=False,
    requested_backup_storage_redundancy=azure_native.sql.BackupStorageRedundancy.GEO,
    resource_group_name="testrg",
    service_principal={
        "type": azure_native.sql.ServicePrincipalType.SYSTEM_ASSIGNED,
    },
    sku={
        "name": "GP_Gen5",
        "tier": "GeneralPurpose",
    },
    storage_size_in_gb=1024,
    subnet_id="/subscriptions/20D7082A-0FC7-4468-82BD-542694D5042B/resourceGroups/testrg/providers/Microsoft.Network/virtualNetworks/vnet1/subnets/subnet1",
    tags={
        "tagKey1": "TagValue1",
    },
    timezone_id="UTC",
    v_cores=8)

    resources:
  managedInstance:
    type: azure-native:sql:ManagedInstance
    properties:
      administratorLogin: dummylogin
      administratorLoginPassword: PLACEHOLDER
      administrators:
        azureADOnlyAuthentication: true
        login: bob@contoso.com
        principalType: User
        sid: 00000011-1111-2222-2222-123456789111
        tenantId: 00000011-1111-2222-2222-123456789111
      collation: SQL_Latin1_General_CP1_CI_AS
      dnsZonePartner: /subscriptions/20D7082A-0FC7-4468-82BD-542694D5042B/resourceGroups/testrg/providers/Microsoft.Sql/managedInstances/testinstance
      instancePoolId: /subscriptions/20D7082A-0FC7-4468-82BD-542694D5042B/resourceGroups/testrg/providers/Microsoft.Sql/instancePools/pool1
      licenseType: LicenseIncluded
      location: Japan East
      maintenanceConfigurationId: /subscriptions/20D7082A-0FC7-4468-82BD-542694D5042B/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_JapanEast_MI_1
      managedInstanceName: testinstance
      minimalTlsVersion: '1.2'
      proxyOverride: Redirect
      publicDataEndpointEnabled: false
      requestedBackupStorageRedundancy: Geo
      resourceGroupName: testrg
      servicePrincipal:
        type: SystemAssigned
      sku:
        name: GP_Gen5
        tier: GeneralPurpose
      storageSizeInGB: 1024
      subnetId: /subscriptions/20D7082A-0FC7-4468-82BD-542694D5042B/resourceGroups/testrg/providers/Microsoft.Network/virtualNetworks/vnet1/subnets/subnet1
      tags:
        tagKey1: TagValue1
      timezoneId: UTC
      vCores: 8

    Create managed instance with minimal properties

    using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;

return await Deployment.RunAsync(() => 
{
    var managedInstance = new AzureNative.Sql.ManagedInstance("managedInstance", new()
    {
        AdministratorLogin = "dummylogin",
        AdministratorLoginPassword = "PLACEHOLDER",
        LicenseType = AzureNative.Sql.ManagedInstanceLicenseType.LicenseIncluded,
        Location = "Japan East",
        ManagedInstanceName = "testinstance",
        ResourceGroupName = "testrg",
        Sku = new AzureNative.Sql.Inputs.SkuArgs
        {
            Name = "GP_Gen4",
            Tier = "GeneralPurpose",
        },
        StorageSizeInGB = 1024,
        SubnetId = "/subscriptions/20D7082A-0FC7-4468-82BD-542694D5042B/resourceGroups/testrg/providers/Microsoft.Network/virtualNetworks/vnet1/subnets/subnet1",
        VCores = 8,
    });

});

    package main

import (
	sql "github.com/pulumi/pulumi-azure-native-sdk/sql/v2"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := sql.NewManagedInstance(ctx, "managedInstance", &sql.ManagedInstanceArgs{
			AdministratorLogin:         pulumi.String("dummylogin"),
			AdministratorLoginPassword: pulumi.String("PLACEHOLDER"),
			LicenseType:                pulumi.String(sql.ManagedInstanceLicenseTypeLicenseIncluded),
			Location:                   pulumi.String("Japan East"),
			ManagedInstanceName:        pulumi.String("testinstance"),
			ResourceGroupName:          pulumi.String("testrg"),
			Sku: &sql.SkuArgs{
				Name: pulumi.String("GP_Gen4"),
				Tier: pulumi.String("GeneralPurpose"),
			},
			StorageSizeInGB: pulumi.Int(1024),
			SubnetId:        pulumi.String("/subscriptions/20D7082A-0FC7-4468-82BD-542694D5042B/resourceGroups/testrg/providers/Microsoft.Network/virtualNetworks/vnet1/subnets/subnet1"),
			VCores:          pulumi.Int(8),
		})
		if err != nil {
			return err
		}
		return nil
	})
}

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azurenative.sql.ManagedInstance;
import com.pulumi.azurenative.sql.ManagedInstanceArgs;
import com.pulumi.azurenative.sql.inputs.SkuArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        var managedInstance = new ManagedInstance("managedInstance", ManagedInstanceArgs.builder()
            .administratorLogin("dummylogin")
            .administratorLoginPassword("PLACEHOLDER")
            .licenseType("LicenseIncluded")
            .location("Japan East")
            .managedInstanceName("testinstance")
            .resourceGroupName("testrg")
            .sku(SkuArgs.builder()
                .name("GP_Gen4")
                .tier("GeneralPurpose")
                .build())
            .storageSizeInGB(1024)
            .subnetId("/subscriptions/20D7082A-0FC7-4468-82BD-542694D5042B/resourceGroups/testrg/providers/Microsoft.Network/virtualNetworks/vnet1/subnets/subnet1")
            .vCores(8)
            .build());

    }
}

    import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";

const managedInstance = new azure_native.sql.ManagedInstance("managedInstance", {
    administratorLogin: "dummylogin",
    administratorLoginPassword: "PLACEHOLDER",
    licenseType: azure_native.sql.ManagedInstanceLicenseType.LicenseIncluded,
    location: "Japan East",
    managedInstanceName: "testinstance",
    resourceGroupName: "testrg",
    sku: {
        name: "GP_Gen4",
        tier: "GeneralPurpose",
    },
    storageSizeInGB: 1024,
    subnetId: "/subscriptions/20D7082A-0FC7-4468-82BD-542694D5042B/resourceGroups/testrg/providers/Microsoft.Network/virtualNetworks/vnet1/subnets/subnet1",
    vCores: 8,
});

    import pulumi
import pulumi_azure_native as azure_native

managed_instance = azure_native.sql.ManagedInstance("managedInstance",
    administrator_login="dummylogin",
    administrator_login_password="PLACEHOLDER",
    license_type=azure_native.sql.ManagedInstanceLicenseType.LICENSE_INCLUDED,
    location="Japan East",
    managed_instance_name="testinstance",
    resource_group_name="testrg",
    sku={
        "name": "GP_Gen4",
        "tier": "GeneralPurpose",
    },
    storage_size_in_gb=1024,
    subnet_id="/subscriptions/20D7082A-0FC7-4468-82BD-542694D5042B/resourceGroups/testrg/providers/Microsoft.Network/virtualNetworks/vnet1/subnets/subnet1",
    v_cores=8)

    resources:
  managedInstance:
    type: azure-native:sql:ManagedInstance
    properties:
      administratorLogin: dummylogin
      administratorLoginPassword: PLACEHOLDER
      licenseType: LicenseIncluded
      location: Japan East
      managedInstanceName: testinstance
      resourceGroupName: testrg
      sku:
        name: GP_Gen4
        tier: GeneralPurpose
      storageSizeInGB: 1024
      subnetId: /subscriptions/20D7082A-0FC7-4468-82BD-542694D5042B/resourceGroups/testrg/providers/Microsoft.Network/virtualNetworks/vnet1/subnets/subnet1
      vCores: 8

    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,
                    resource_group_name: Optional[str] = None,
                    primary_user_assigned_identity_id: Optional[str] = None,
                    timezone_id: Optional[str] = None,
                    collation: Optional[str] = None,
                    dns_zone_partner: Optional[str] = None,
                    identity: Optional[ResourceIdentityArgs] = None,
                    instance_pool_id: Optional[str] = None,
                    key_id: Optional[str] = None,
                    license_type: Optional[Union[str, ManagedInstanceLicenseType]] = None,
                    location: Optional[str] = None,
                    maintenance_configuration_id: Optional[str] = None,
                    managed_instance_create_mode: Optional[Union[str, ManagedServerCreateMode]] = None,
                    managed_instance_name: Optional[str] = None,
                    zone_redundant: Optional[bool] = None,
                    administrators: Optional[ManagedInstanceExternalAdministratorArgs] = None,
                    restore_point_in_time: Optional[str] = None,
                    public_data_endpoint_enabled: Optional[bool] = None,
                    requested_backup_storage_redundancy: Optional[Union[str, BackupStorageRedundancy]] = None,
                    administrator_login_password: Optional[str] = None,
                    proxy_override: Optional[Union[str, ManagedInstanceProxyOverride]] = None,
                    service_principal: Optional[ServicePrincipalArgs] = None,
                    sku: Optional[SkuArgs] = None,
                    source_managed_instance_id: Optional[str] = None,
                    storage_size_in_gb: Optional[int] = None,
                    subnet_id: Optional[str] = None,
                    tags: Optional[Mapping[str, str]] = None,
                    administrator_login: Optional[str] = None,
                    v_cores: Optional[int] = None,
                    minimal_tls_version: Optional[str] = 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-native:sql: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 AzureNative.Sql.ManagedInstance("managedInstanceResource", new()
{
    ResourceGroupName = "string",
    PrimaryUserAssignedIdentityId = "string",
    TimezoneId = "string",
    Collation = "string",
    DnsZonePartner = "string",
    Identity = new AzureNative.Sql.Inputs.ResourceIdentityArgs
    {
        Type = "string",
        UserAssignedIdentities = new[]
        {
            "string",
        },
    },
    InstancePoolId = "string",
    KeyId = "string",
    LicenseType = "string",
    Location = "string",
    MaintenanceConfigurationId = "string",
    ManagedInstanceCreateMode = "string",
    ManagedInstanceName = "string",
    ZoneRedundant = false,
    Administrators = new AzureNative.Sql.Inputs.ManagedInstanceExternalAdministratorArgs
    {
        AdministratorType = "string",
        AzureADOnlyAuthentication = false,
        Login = "string",
        PrincipalType = "string",
        Sid = "string",
        TenantId = "string",
    },
    RestorePointInTime = "string",
    PublicDataEndpointEnabled = false,
    RequestedBackupStorageRedundancy = "string",
    AdministratorLoginPassword = "string",
    ProxyOverride = "string",
    ServicePrincipal = new AzureNative.Sql.Inputs.ServicePrincipalArgs
    {
        Type = "string",
    },
    Sku = new AzureNative.Sql.Inputs.SkuArgs
    {
        Name = "string",
        Capacity = 0,
        Family = "string",
        Size = "string",
        Tier = "string",
    },
    SourceManagedInstanceId = "string",
    StorageSizeInGB = 0,
    SubnetId = "string",
    Tags = 
    {
        { "string", "string" },
    },
    AdministratorLogin = "string",
    VCores = 0,
    MinimalTlsVersion = "string",
});

    example, err := sql.NewManagedInstance(ctx, "managedInstanceResource", &sql.ManagedInstanceArgs{
	ResourceGroupName:             pulumi.String("string"),
	PrimaryUserAssignedIdentityId: pulumi.String("string"),
	TimezoneId:                    pulumi.String("string"),
	Collation:                     pulumi.String("string"),
	DnsZonePartner:                pulumi.String("string"),
	Identity: &sql.ResourceIdentityArgs{
		Type: pulumi.String("string"),
		UserAssignedIdentities: pulumi.StringArray{
			pulumi.String("string"),
		},
	},
	InstancePoolId:             pulumi.String("string"),
	KeyId:                      pulumi.String("string"),
	LicenseType:                pulumi.String("string"),
	Location:                   pulumi.String("string"),
	MaintenanceConfigurationId: pulumi.String("string"),
	ManagedInstanceCreateMode:  pulumi.String("string"),
	ManagedInstanceName:        pulumi.String("string"),
	ZoneRedundant:              pulumi.Bool(false),
	Administrators: &sql.ManagedInstanceExternalAdministratorArgs{
		AdministratorType:         pulumi.String("string"),
		AzureADOnlyAuthentication: pulumi.Bool(false),
		Login:                     pulumi.String("string"),
		PrincipalType:             pulumi.String("string"),
		Sid:                       pulumi.String("string"),
		TenantId:                  pulumi.String("string"),
	},
	RestorePointInTime:               pulumi.String("string"),
	PublicDataEndpointEnabled:        pulumi.Bool(false),
	RequestedBackupStorageRedundancy: pulumi.String("string"),
	AdministratorLoginPassword:       pulumi.String("string"),
	ProxyOverride:                    pulumi.String("string"),
	ServicePrincipal: &sql.ServicePrincipalArgs{
		Type: pulumi.String("string"),
	},
	Sku: &sql.SkuArgs{
		Name:     pulumi.String("string"),
		Capacity: pulumi.Int(0),
		Family:   pulumi.String("string"),
		Size:     pulumi.String("string"),
		Tier:     pulumi.String("string"),
	},
	SourceManagedInstanceId: pulumi.String("string"),
	StorageSizeInGB:         pulumi.Int(0),
	SubnetId:                pulumi.String("string"),
	Tags: pulumi.StringMap{
		"string": pulumi.String("string"),
	},
	AdministratorLogin: pulumi.String("string"),
	VCores:             pulumi.Int(0),
	MinimalTlsVersion:  pulumi.String("string"),
})

    var managedInstanceResource = new ManagedInstance("managedInstanceResource", ManagedInstanceArgs.builder()
    .resourceGroupName("string")
    .primaryUserAssignedIdentityId("string")
    .timezoneId("string")
    .collation("string")
    .dnsZonePartner("string")
    .identity(ResourceIdentityArgs.builder()
        .type("string")
        .userAssignedIdentities("string")
        .build())
    .instancePoolId("string")
    .keyId("string")
    .licenseType("string")
    .location("string")
    .maintenanceConfigurationId("string")
    .managedInstanceCreateMode("string")
    .managedInstanceName("string")
    .zoneRedundant(false)
    .administrators(ManagedInstanceExternalAdministratorArgs.builder()
        .administratorType("string")
        .azureADOnlyAuthentication(false)
        .login("string")
        .principalType("string")
        .sid("string")
        .tenantId("string")
        .build())
    .restorePointInTime("string")
    .publicDataEndpointEnabled(false)
    .requestedBackupStorageRedundancy("string")
    .administratorLoginPassword("string")
    .proxyOverride("string")
    .servicePrincipal(ServicePrincipalArgs.builder()
        .type("string")
        .build())
    .sku(SkuArgs.builder()
        .name("string")
        .capacity(0)
        .family("string")
        .size("string")
        .tier("string")
        .build())
    .sourceManagedInstanceId("string")
    .storageSizeInGB(0)
    .subnetId("string")
    .tags(Map.of("string", "string"))
    .administratorLogin("string")
    .vCores(0)
    .minimalTlsVersion("string")
    .build());

    managed_instance_resource = azure_native.sql.ManagedInstance("managedInstanceResource",
    resource_group_name="string",
    primary_user_assigned_identity_id="string",
    timezone_id="string",
    collation="string",
    dns_zone_partner="string",
    identity={
        "type": "string",
        "user_assigned_identities": ["string"],
    },
    instance_pool_id="string",
    key_id="string",
    license_type="string",
    location="string",
    maintenance_configuration_id="string",
    managed_instance_create_mode="string",
    managed_instance_name="string",
    zone_redundant=False,
    administrators={
        "administrator_type": "string",
        "azure_ad_only_authentication": False,
        "login": "string",
        "principal_type": "string",
        "sid": "string",
        "tenant_id": "string",
    },
    restore_point_in_time="string",
    public_data_endpoint_enabled=False,
    requested_backup_storage_redundancy="string",
    administrator_login_password="string",
    proxy_override="string",
    service_principal={
        "type": "string",
    },
    sku={
        "name": "string",
        "capacity": 0,
        "family": "string",
        "size": "string",
        "tier": "string",
    },
    source_managed_instance_id="string",
    storage_size_in_gb=0,
    subnet_id="string",
    tags={
        "string": "string",
    },
    administrator_login="string",
    v_cores=0,
    minimal_tls_version="string")

    const managedInstanceResource = new azure_native.sql.ManagedInstance("managedInstanceResource", {
    resourceGroupName: "string",
    primaryUserAssignedIdentityId: "string",
    timezoneId: "string",
    collation: "string",
    dnsZonePartner: "string",
    identity: {
        type: "string",
        userAssignedIdentities: ["string"],
    },
    instancePoolId: "string",
    keyId: "string",
    licenseType: "string",
    location: "string",
    maintenanceConfigurationId: "string",
    managedInstanceCreateMode: "string",
    managedInstanceName: "string",
    zoneRedundant: false,
    administrators: {
        administratorType: "string",
        azureADOnlyAuthentication: false,
        login: "string",
        principalType: "string",
        sid: "string",
        tenantId: "string",
    },
    restorePointInTime: "string",
    publicDataEndpointEnabled: false,
    requestedBackupStorageRedundancy: "string",
    administratorLoginPassword: "string",
    proxyOverride: "string",
    servicePrincipal: {
        type: "string",
    },
    sku: {
        name: "string",
        capacity: 0,
        family: "string",
        size: "string",
        tier: "string",
    },
    sourceManagedInstanceId: "string",
    storageSizeInGB: 0,
    subnetId: "string",
    tags: {
        string: "string",
    },
    administratorLogin: "string",
    vCores: 0,
    minimalTlsVersion: "string",
});

    type: azure-native:sql:ManagedInstance
properties:
    administratorLogin: string
    administratorLoginPassword: string
    administrators:
        administratorType: string
        azureADOnlyAuthentication: false
        login: string
        principalType: string
        sid: string
        tenantId: string
    collation: string
    dnsZonePartner: string
    identity:
        type: string
        userAssignedIdentities:
            - string
    instancePoolId: string
    keyId: string
    licenseType: string
    location: string
    maintenanceConfigurationId: string
    managedInstanceCreateMode: string
    managedInstanceName: string
    minimalTlsVersion: string
    primaryUserAssignedIdentityId: string
    proxyOverride: string
    publicDataEndpointEnabled: false
    requestedBackupStorageRedundancy: string
    resourceGroupName: string
    restorePointInTime: string
    servicePrincipal:
        type: string
    sku:
        capacity: 0
        family: string
        name: string
        size: string
        tier: string
    sourceManagedInstanceId: string
    storageSizeInGB: 0
    subnetId: string
    tags:
        string: string
    timezoneId: string
    vCores: 0
    zoneRedundant: 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

    In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.

    The ManagedInstance resource accepts the following input properties:

    ResourceGroupName string
    The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
    AdministratorLogin string
    Administrator username for the managed instance. Can only be specified when the managed instance is being created (and is required for creation).
    AdministratorLoginPassword string
    The administrator login password (required for managed instance creation).
    Administrators Pulumi.AzureNative.Sql.Inputs.ManagedInstanceExternalAdministrator
    The Azure Active Directory administrator of the server.
    Collation string
    Collation of the managed instance.
    DnsZonePartner string
    The resource id of another managed instance whose DNS zone this managed instance will share after creation.
    Identity Pulumi.AzureNative.Sql.Inputs.ResourceIdentity
    The Azure Active Directory identity of the managed instance.
    InstancePoolId string
    The Id of the instance pool this managed server belongs to.
    KeyId string
    A CMK URI of the key to use for encryption.
    LicenseType string | Pulumi.AzureNative.Sql.ManagedInstanceLicenseType
    The license type. Possible values are 'LicenseIncluded' (regular price inclusive of a new SQL license) and 'BasePrice' (discounted AHB price for bringing your own SQL licenses).
    Location string
    Resource location.
    MaintenanceConfigurationId string
    Specifies maintenance configuration id to apply to this managed instance.
    ManagedInstanceCreateMode string | Pulumi.AzureNative.Sql.ManagedServerCreateMode

    Specifies the mode of database creation.

    Default: Regular instance creation.

    Restore: Creates an instance by restoring a set of backups to specific point in time. RestorePointInTime and SourceManagedInstanceId must be specified.

    ManagedInstanceName string
    The name of the managed instance.
    MinimalTlsVersion string
    Minimal TLS version. Allowed values: 'None', '1.0', '1.1', '1.2'
    PrimaryUserAssignedIdentityId string
    The resource id of a user assigned identity to be used by default.
    ProxyOverride string | Pulumi.AzureNative.Sql.ManagedInstanceProxyOverride
    Connection type used for connecting to the instance.
    PublicDataEndpointEnabled bool
    Whether or not the public data endpoint is enabled.
    RequestedBackupStorageRedundancy string | Pulumi.AzureNative.Sql.BackupStorageRedundancy
    The storage account type to be used to store backups for this instance. The options are Local (LocallyRedundantStorage), Zone (ZoneRedundantStorage), Geo (GeoRedundantStorage) and GeoZone(GeoZoneRedundantStorage)
    RestorePointInTime string
    Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.
    ServicePrincipal Pulumi.AzureNative.Sql.Inputs.ServicePrincipal
    The managed instance's service principal.
    Sku Pulumi.AzureNative.Sql.Inputs.Sku
    Managed instance SKU. Allowed values for sku.name: GP_Gen5, GP_G8IM, GP_G8IH, BC_Gen5, BC_G8IM, BC_G8IH
    SourceManagedInstanceId string
    The resource identifier of the source managed instance associated with create operation of this instance.
    StorageSizeInGB int
    Storage size in GB. Minimum value: 32. Maximum value: 16384. Increments of 32 GB allowed only. Maximum value depends on the selected hardware family and number of vCores.
    SubnetId string
    Subnet resource ID for the managed instance.
    Tags Dictionary<string, string>
    Resource tags.
    TimezoneId string
    Id of the timezone. Allowed values are timezones supported by Windows. Windows keeps details on supported timezones, including the id, in registry under KEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Time Zones. You can get those registry values via SQL Server by querying SELECT name AS timezone_id FROM sys.time_zone_info. List of Ids can also be obtained by executing [System.TimeZoneInfo]::GetSystemTimeZones() in PowerShell. An example of valid timezone id is "Pacific Standard Time" or "W. Europe Standard Time".
    VCores int
    The number of vCores. Allowed values: 8, 16, 24, 32, 40, 64, 80.
    ZoneRedundant bool
    Whether or not the multi-az is enabled.
    ResourceGroupName string
    The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
    AdministratorLogin string
    Administrator username for the managed instance. Can only be specified when the managed instance is being created (and is required for creation).
    AdministratorLoginPassword string
    The administrator login password (required for managed instance creation).
    Administrators ManagedInstanceExternalAdministratorArgs
    The Azure Active Directory administrator of the server.
    Collation string
    Collation of the managed instance.
    DnsZonePartner string
    The resource id of another managed instance whose DNS zone this managed instance will share after creation.
    Identity ResourceIdentityArgs
    The Azure Active Directory identity of the managed instance.
    InstancePoolId string
    The Id of the instance pool this managed server belongs to.
    KeyId string
    A CMK URI of the key to use for encryption.
    LicenseType string | ManagedInstanceLicenseType
    The license type. Possible values are 'LicenseIncluded' (regular price inclusive of a new SQL license) and 'BasePrice' (discounted AHB price for bringing your own SQL licenses).
    Location string
    Resource location.
    MaintenanceConfigurationId string
    Specifies maintenance configuration id to apply to this managed instance.
    ManagedInstanceCreateMode string | ManagedServerCreateMode

    Specifies the mode of database creation.

    Default: Regular instance creation.

    Restore: Creates an instance by restoring a set of backups to specific point in time. RestorePointInTime and SourceManagedInstanceId must be specified.

    ManagedInstanceName string
    The name of the managed instance.
    MinimalTlsVersion string
    Minimal TLS version. Allowed values: 'None', '1.0', '1.1', '1.2'
    PrimaryUserAssignedIdentityId string
    The resource id of a user assigned identity to be used by default.
    ProxyOverride string | ManagedInstanceProxyOverride
    Connection type used for connecting to the instance.
    PublicDataEndpointEnabled bool
    Whether or not the public data endpoint is enabled.
    RequestedBackupStorageRedundancy string | BackupStorageRedundancy
    The storage account type to be used to store backups for this instance. The options are Local (LocallyRedundantStorage), Zone (ZoneRedundantStorage), Geo (GeoRedundantStorage) and GeoZone(GeoZoneRedundantStorage)
    RestorePointInTime string
    Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.
    ServicePrincipal ServicePrincipalArgs
    The managed instance's service principal.
    Sku SkuArgs
    Managed instance SKU. Allowed values for sku.name: GP_Gen5, GP_G8IM, GP_G8IH, BC_Gen5, BC_G8IM, BC_G8IH
    SourceManagedInstanceId string
    The resource identifier of the source managed instance associated with create operation of this instance.
    StorageSizeInGB int
    Storage size in GB. Minimum value: 32. Maximum value: 16384. Increments of 32 GB allowed only. Maximum value depends on the selected hardware family and number of vCores.
    SubnetId string
    Subnet resource ID for the managed instance.
    Tags map[string]string
    Resource tags.
    TimezoneId string
    Id of the timezone. Allowed values are timezones supported by Windows. Windows keeps details on supported timezones, including the id, in registry under KEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Time Zones. You can get those registry values via SQL Server by querying SELECT name AS timezone_id FROM sys.time_zone_info. List of Ids can also be obtained by executing [System.TimeZoneInfo]::GetSystemTimeZones() in PowerShell. An example of valid timezone id is "Pacific Standard Time" or "W. Europe Standard Time".
    VCores int
    The number of vCores. Allowed values: 8, 16, 24, 32, 40, 64, 80.
    ZoneRedundant bool
    Whether or not the multi-az is enabled.
    resourceGroupName String
    The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
    administratorLogin String
    Administrator username for the managed instance. Can only be specified when the managed instance is being created (and is required for creation).
    administratorLoginPassword String
    The administrator login password (required for managed instance creation).
    administrators ManagedInstanceExternalAdministrator
    The Azure Active Directory administrator of the server.
    collation String
    Collation of the managed instance.
    dnsZonePartner String
    The resource id of another managed instance whose DNS zone this managed instance will share after creation.
    identity ResourceIdentity
    The Azure Active Directory identity of the managed instance.
    instancePoolId String
    The Id of the instance pool this managed server belongs to.
    keyId String
    A CMK URI of the key to use for encryption.
    licenseType String | ManagedInstanceLicenseType
    The license type. Possible values are 'LicenseIncluded' (regular price inclusive of a new SQL license) and 'BasePrice' (discounted AHB price for bringing your own SQL licenses).
    location String
    Resource location.
    maintenanceConfigurationId String
    Specifies maintenance configuration id to apply to this managed instance.
    managedInstanceCreateMode String | ManagedServerCreateMode

    Specifies the mode of database creation.

    Default: Regular instance creation.

    Restore: Creates an instance by restoring a set of backups to specific point in time. RestorePointInTime and SourceManagedInstanceId must be specified.

    managedInstanceName String
    The name of the managed instance.
    minimalTlsVersion String
    Minimal TLS version. Allowed values: 'None', '1.0', '1.1', '1.2'
    primaryUserAssignedIdentityId String
    The resource id of a user assigned identity to be used by default.
    proxyOverride String | ManagedInstanceProxyOverride
    Connection type used for connecting to the instance.
    publicDataEndpointEnabled Boolean
    Whether or not the public data endpoint is enabled.
    requestedBackupStorageRedundancy String | BackupStorageRedundancy
    The storage account type to be used to store backups for this instance. The options are Local (LocallyRedundantStorage), Zone (ZoneRedundantStorage), Geo (GeoRedundantStorage) and GeoZone(GeoZoneRedundantStorage)
    restorePointInTime String
    Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.
    servicePrincipal ServicePrincipal
    The managed instance's service principal.
    sku Sku
    Managed instance SKU. Allowed values for sku.name: GP_Gen5, GP_G8IM, GP_G8IH, BC_Gen5, BC_G8IM, BC_G8IH
    sourceManagedInstanceId String
    The resource identifier of the source managed instance associated with create operation of this instance.
    storageSizeInGB Integer
    Storage size in GB. Minimum value: 32. Maximum value: 16384. Increments of 32 GB allowed only. Maximum value depends on the selected hardware family and number of vCores.
    subnetId String
    Subnet resource ID for the managed instance.
    tags Map<String,String>
    Resource tags.
    timezoneId String
    Id of the timezone. Allowed values are timezones supported by Windows. Windows keeps details on supported timezones, including the id, in registry under KEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Time Zones. You can get those registry values via SQL Server by querying SELECT name AS timezone_id FROM sys.time_zone_info. List of Ids can also be obtained by executing [System.TimeZoneInfo]::GetSystemTimeZones() in PowerShell. An example of valid timezone id is "Pacific Standard Time" or "W. Europe Standard Time".
    vCores Integer
    The number of vCores. Allowed values: 8, 16, 24, 32, 40, 64, 80.
    zoneRedundant Boolean
    Whether or not the multi-az is enabled.
    resourceGroupName string
    The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
    administratorLogin string
    Administrator username for the managed instance. Can only be specified when the managed instance is being created (and is required for creation).
    administratorLoginPassword string
    The administrator login password (required for managed instance creation).
    administrators ManagedInstanceExternalAdministrator
    The Azure Active Directory administrator of the server.
    collation string
    Collation of the managed instance.
    dnsZonePartner string
    The resource id of another managed instance whose DNS zone this managed instance will share after creation.
    identity ResourceIdentity
    The Azure Active Directory identity of the managed instance.
    instancePoolId string
    The Id of the instance pool this managed server belongs to.
    keyId string
    A CMK URI of the key to use for encryption.
    licenseType string | ManagedInstanceLicenseType
    The license type. Possible values are 'LicenseIncluded' (regular price inclusive of a new SQL license) and 'BasePrice' (discounted AHB price for bringing your own SQL licenses).
    location string
    Resource location.
    maintenanceConfigurationId string
    Specifies maintenance configuration id to apply to this managed instance.
    managedInstanceCreateMode string | ManagedServerCreateMode

    Specifies the mode of database creation.

    Default: Regular instance creation.

    Restore: Creates an instance by restoring a set of backups to specific point in time. RestorePointInTime and SourceManagedInstanceId must be specified.

    managedInstanceName string
    The name of the managed instance.
    minimalTlsVersion string
    Minimal TLS version. Allowed values: 'None', '1.0', '1.1', '1.2'
    primaryUserAssignedIdentityId string
    The resource id of a user assigned identity to be used by default.
    proxyOverride string | ManagedInstanceProxyOverride
    Connection type used for connecting to the instance.
    publicDataEndpointEnabled boolean
    Whether or not the public data endpoint is enabled.
    requestedBackupStorageRedundancy string | BackupStorageRedundancy
    The storage account type to be used to store backups for this instance. The options are Local (LocallyRedundantStorage), Zone (ZoneRedundantStorage), Geo (GeoRedundantStorage) and GeoZone(GeoZoneRedundantStorage)
    restorePointInTime string
    Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.
    servicePrincipal ServicePrincipal
    The managed instance's service principal.
    sku Sku
    Managed instance SKU. Allowed values for sku.name: GP_Gen5, GP_G8IM, GP_G8IH, BC_Gen5, BC_G8IM, BC_G8IH
    sourceManagedInstanceId string
    The resource identifier of the source managed instance associated with create operation of this instance.
    storageSizeInGB number
    Storage size in GB. Minimum value: 32. Maximum value: 16384. Increments of 32 GB allowed only. Maximum value depends on the selected hardware family and number of vCores.
    subnetId string
    Subnet resource ID for the managed instance.
    tags {[key: string]: string}
    Resource tags.
    timezoneId string
    Id of the timezone. Allowed values are timezones supported by Windows. Windows keeps details on supported timezones, including the id, in registry under KEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Time Zones. You can get those registry values via SQL Server by querying SELECT name AS timezone_id FROM sys.time_zone_info. List of Ids can also be obtained by executing [System.TimeZoneInfo]::GetSystemTimeZones() in PowerShell. An example of valid timezone id is "Pacific Standard Time" or "W. Europe Standard Time".
    vCores number
    The number of vCores. Allowed values: 8, 16, 24, 32, 40, 64, 80.
    zoneRedundant boolean
    Whether or not the multi-az is enabled.
    resource_group_name str
    The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
    administrator_login str
    Administrator username for the managed instance. Can only be specified when the managed instance is being created (and is required for creation).
    administrator_login_password str
    The administrator login password (required for managed instance creation).
    administrators ManagedInstanceExternalAdministratorArgs
    The Azure Active Directory administrator of the server.
    collation str
    Collation of the managed instance.
    dns_zone_partner str
    The resource id of another managed instance whose DNS zone this managed instance will share after creation.
    identity ResourceIdentityArgs
    The Azure Active Directory identity of the managed instance.
    instance_pool_id str
    The Id of the instance pool this managed server belongs to.
    key_id str
    A CMK URI of the key to use for encryption.
    license_type str | ManagedInstanceLicenseType
    The license type. Possible values are 'LicenseIncluded' (regular price inclusive of a new SQL license) and 'BasePrice' (discounted AHB price for bringing your own SQL licenses).
    location str
    Resource location.
    maintenance_configuration_id str
    Specifies maintenance configuration id to apply to this managed instance.
    managed_instance_create_mode str | ManagedServerCreateMode

    Specifies the mode of database creation.

    Default: Regular instance creation.

    Restore: Creates an instance by restoring a set of backups to specific point in time. RestorePointInTime and SourceManagedInstanceId must be specified.

    managed_instance_name str
    The name of the managed instance.
    minimal_tls_version str
    Minimal TLS version. Allowed values: 'None', '1.0', '1.1', '1.2'
    primary_user_assigned_identity_id str
    The resource id of a user assigned identity to be used by default.
    proxy_override str | ManagedInstanceProxyOverride
    Connection type used for connecting to the instance.
    public_data_endpoint_enabled bool
    Whether or not the public data endpoint is enabled.
    requested_backup_storage_redundancy str | BackupStorageRedundancy
    The storage account type to be used to store backups for this instance. The options are Local (LocallyRedundantStorage), Zone (ZoneRedundantStorage), Geo (GeoRedundantStorage) and GeoZone(GeoZoneRedundantStorage)
    restore_point_in_time str
    Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.
    service_principal ServicePrincipalArgs
    The managed instance's service principal.
    sku SkuArgs
    Managed instance SKU. Allowed values for sku.name: GP_Gen5, GP_G8IM, GP_G8IH, BC_Gen5, BC_G8IM, BC_G8IH
    source_managed_instance_id str
    The resource identifier of the source managed instance associated with create operation of this instance.
    storage_size_in_gb int
    Storage size in GB. Minimum value: 32. Maximum value: 16384. Increments of 32 GB allowed only. Maximum value depends on the selected hardware family and number of vCores.
    subnet_id str
    Subnet resource ID for the managed instance.
    tags Mapping[str, str]
    Resource tags.
    timezone_id str
    Id of the timezone. Allowed values are timezones supported by Windows. Windows keeps details on supported timezones, including the id, in registry under KEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Time Zones. You can get those registry values via SQL Server by querying SELECT name AS timezone_id FROM sys.time_zone_info. List of Ids can also be obtained by executing [System.TimeZoneInfo]::GetSystemTimeZones() in PowerShell. An example of valid timezone id is "Pacific Standard Time" or "W. Europe Standard Time".
    v_cores int
    The number of vCores. Allowed values: 8, 16, 24, 32, 40, 64, 80.
    zone_redundant bool
    Whether or not the multi-az is enabled.
    resourceGroupName String
    The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
    administratorLogin String
    Administrator username for the managed instance. Can only be specified when the managed instance is being created (and is required for creation).
    administratorLoginPassword String
    The administrator login password (required for managed instance creation).
    administrators Property Map
    The Azure Active Directory administrator of the server.
    collation String
    Collation of the managed instance.
    dnsZonePartner String
    The resource id of another managed instance whose DNS zone this managed instance will share after creation.
    identity Property Map
    The Azure Active Directory identity of the managed instance.
    instancePoolId String
    The Id of the instance pool this managed server belongs to.
    keyId String
    A CMK URI of the key to use for encryption.
    licenseType String | "LicenseIncluded" | "BasePrice"
    The license type. Possible values are 'LicenseIncluded' (regular price inclusive of a new SQL license) and 'BasePrice' (discounted AHB price for bringing your own SQL licenses).
    location String
    Resource location.
    maintenanceConfigurationId String
    Specifies maintenance configuration id to apply to this managed instance.
    managedInstanceCreateMode String | "Default" | "PointInTimeRestore"

    Specifies the mode of database creation.

    Default: Regular instance creation.

    Restore: Creates an instance by restoring a set of backups to specific point in time. RestorePointInTime and SourceManagedInstanceId must be specified.

    managedInstanceName String
    The name of the managed instance.
    minimalTlsVersion String
    Minimal TLS version. Allowed values: 'None', '1.0', '1.1', '1.2'
    primaryUserAssignedIdentityId String
    The resource id of a user assigned identity to be used by default.
    proxyOverride String | "Proxy" | "Redirect" | "Default"
    Connection type used for connecting to the instance.
    publicDataEndpointEnabled Boolean
    Whether or not the public data endpoint is enabled.
    requestedBackupStorageRedundancy String | "Geo" | "Local" | "Zone" | "GeoZone"
    The storage account type to be used to store backups for this instance. The options are Local (LocallyRedundantStorage), Zone (ZoneRedundantStorage), Geo (GeoRedundantStorage) and GeoZone(GeoZoneRedundantStorage)
    restorePointInTime String
    Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.
    servicePrincipal Property Map
    The managed instance's service principal.
    sku Property Map
    Managed instance SKU. Allowed values for sku.name: GP_Gen5, GP_G8IM, GP_G8IH, BC_Gen5, BC_G8IM, BC_G8IH
    sourceManagedInstanceId String
    The resource identifier of the source managed instance associated with create operation of this instance.
    storageSizeInGB Number
    Storage size in GB. Minimum value: 32. Maximum value: 16384. Increments of 32 GB allowed only. Maximum value depends on the selected hardware family and number of vCores.
    subnetId String
    Subnet resource ID for the managed instance.
    tags Map<String>
    Resource tags.
    timezoneId String
    Id of the timezone. Allowed values are timezones supported by Windows. Windows keeps details on supported timezones, including the id, in registry under KEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Time Zones. You can get those registry values via SQL Server by querying SELECT name AS timezone_id FROM sys.time_zone_info. List of Ids can also be obtained by executing [System.TimeZoneInfo]::GetSystemTimeZones() in PowerShell. An example of valid timezone id is "Pacific Standard Time" or "W. Europe Standard Time".
    vCores Number
    The number of vCores. Allowed values: 8, 16, 24, 32, 40, 64, 80.
    zoneRedundant Boolean
    Whether or not the multi-az is enabled.

    Outputs

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

    CurrentBackupStorageRedundancy string
    The storage account type used to store backups for this instance. The options are Local (LocallyRedundantStorage), Zone (ZoneRedundantStorage), Geo (GeoRedundantStorage) and GeoZone(GeoZoneRedundantStorage)
    DnsZone string
    The Dns Zone that the managed instance is in.
    FullyQualifiedDomainName string
    The fully qualified domain name of the managed instance.
    Id string
    The provider-assigned unique ID for this managed resource.
    Name string
    Resource name.
    PrivateEndpointConnections List<Pulumi.AzureNative.Sql.Outputs.ManagedInstancePecPropertyResponse>
    List of private endpoint connections on a managed instance.
    ProvisioningState string
    State string
    The state of the managed instance.
    Type string
    Resource type.
    CurrentBackupStorageRedundancy string
    The storage account type used to store backups for this instance. The options are Local (LocallyRedundantStorage), Zone (ZoneRedundantStorage), Geo (GeoRedundantStorage) and GeoZone(GeoZoneRedundantStorage)
    DnsZone string
    The Dns Zone that the managed instance is in.
    FullyQualifiedDomainName string
    The fully qualified domain name of the managed instance.
    Id string
    The provider-assigned unique ID for this managed resource.
    Name string
    Resource name.
    PrivateEndpointConnections []ManagedInstancePecPropertyResponse
    List of private endpoint connections on a managed instance.
    ProvisioningState string
    State string
    The state of the managed instance.
    Type string
    Resource type.
    currentBackupStorageRedundancy String
    The storage account type used to store backups for this instance. The options are Local (LocallyRedundantStorage), Zone (ZoneRedundantStorage), Geo (GeoRedundantStorage) and GeoZone(GeoZoneRedundantStorage)
    dnsZone String
    The Dns Zone that the managed instance is in.
    fullyQualifiedDomainName String
    The fully qualified domain name of the managed instance.
    id String
    The provider-assigned unique ID for this managed resource.
    name String
    Resource name.
    privateEndpointConnections List<ManagedInstancePecPropertyResponse>
    List of private endpoint connections on a managed instance.
    provisioningState String
    state String
    The state of the managed instance.
    type String
    Resource type.
    currentBackupStorageRedundancy string
    The storage account type used to store backups for this instance. The options are Local (LocallyRedundantStorage), Zone (ZoneRedundantStorage), Geo (GeoRedundantStorage) and GeoZone(GeoZoneRedundantStorage)
    dnsZone string
    The Dns Zone that the managed instance is in.
    fullyQualifiedDomainName string
    The fully qualified domain name of the managed instance.
    id string
    The provider-assigned unique ID for this managed resource.
    name string
    Resource name.
    privateEndpointConnections ManagedInstancePecPropertyResponse[]
    List of private endpoint connections on a managed instance.
    provisioningState string
    state string
    The state of the managed instance.
    type string
    Resource type.
    current_backup_storage_redundancy str
    The storage account type used to store backups for this instance. The options are Local (LocallyRedundantStorage), Zone (ZoneRedundantStorage), Geo (GeoRedundantStorage) and GeoZone(GeoZoneRedundantStorage)
    dns_zone str
    The Dns Zone that the managed instance is in.
    fully_qualified_domain_name str
    The fully qualified domain name of the managed instance.
    id str
    The provider-assigned unique ID for this managed resource.
    name str
    Resource name.
    private_endpoint_connections Sequence[ManagedInstancePecPropertyResponse]
    List of private endpoint connections on a managed instance.
    provisioning_state str
    state str
    The state of the managed instance.
    type str
    Resource type.
    currentBackupStorageRedundancy String
    The storage account type used to store backups for this instance. The options are Local (LocallyRedundantStorage), Zone (ZoneRedundantStorage), Geo (GeoRedundantStorage) and GeoZone(GeoZoneRedundantStorage)
    dnsZone String
    The Dns Zone that the managed instance is in.
    fullyQualifiedDomainName String
    The fully qualified domain name of the managed instance.
    id String
    The provider-assigned unique ID for this managed resource.
    name String
    Resource name.
    privateEndpointConnections List<Property Map>
    List of private endpoint connections on a managed instance.
    provisioningState String
    state String
    The state of the managed instance.
    type String
    Resource type.

    Supporting Types

    AdministratorType, AdministratorTypeArgs

    ActiveDirectory
    ActiveDirectory
    AdministratorTypeActiveDirectory
    ActiveDirectory
    ActiveDirectory
    ActiveDirectory
    ActiveDirectory
    ActiveDirectory
    ACTIVE_DIRECTORY
    ActiveDirectory
    "ActiveDirectory"
    ActiveDirectory

    BackupStorageRedundancy, BackupStorageRedundancyArgs

    Geo
    Geo
    Local
    Local
    Zone
    Zone
    GeoZone
    GeoZone
    BackupStorageRedundancyGeo
    Geo
    BackupStorageRedundancyLocal
    Local
    BackupStorageRedundancyZone
    Zone
    BackupStorageRedundancyGeoZone
    GeoZone
    Geo
    Geo
    Local
    Local
    Zone
    Zone
    GeoZone
    GeoZone
    Geo
    Geo
    Local
    Local
    Zone
    Zone
    GeoZone
    GeoZone
    GEO
    Geo
    LOCAL
    Local
    ZONE
    Zone
    GEO_ZONE
    GeoZone
    "Geo"
    Geo
    "Local"
    Local
    "Zone"
    Zone
    "GeoZone"
    GeoZone

    IdentityType, IdentityTypeArgs

    None
    None
    SystemAssigned
    SystemAssigned
    UserAssigned
    UserAssigned
    SystemAssigned_UserAssigned
    SystemAssigned,UserAssigned
    IdentityTypeNone
    None
    IdentityTypeSystemAssigned
    SystemAssigned
    IdentityTypeUserAssigned
    UserAssigned
    IdentityType_SystemAssigned_UserAssigned
    SystemAssigned,UserAssigned
    None
    None
    SystemAssigned
    SystemAssigned
    UserAssigned
    UserAssigned
    SystemAssigned_UserAssigned
    SystemAssigned,UserAssigned
    None
    None
    SystemAssigned
    SystemAssigned
    UserAssigned
    UserAssigned
    SystemAssigned_UserAssigned
    SystemAssigned,UserAssigned
    NONE
    None
    SYSTEM_ASSIGNED
    SystemAssigned
    USER_ASSIGNED
    UserAssigned
    SYSTEM_ASSIGNED_USER_ASSIGNED
    SystemAssigned,UserAssigned
    "None"
    None
    "SystemAssigned"
    SystemAssigned
    "UserAssigned"
    UserAssigned
    "SystemAssigned,UserAssigned"
    SystemAssigned,UserAssigned

    ManagedInstanceExternalAdministrator, ManagedInstanceExternalAdministratorArgs

    AdministratorType string | Pulumi.AzureNative.Sql.AdministratorType
    Type of the sever administrator.
    AzureADOnlyAuthentication bool
    Azure Active Directory only Authentication enabled.
    Login string
    Login name of the server administrator.
    PrincipalType string | Pulumi.AzureNative.Sql.PrincipalType
    Principal Type of the sever administrator.
    Sid string
    SID (object ID) of the server administrator.
    TenantId string
    Tenant ID of the administrator.
    AdministratorType string | AdministratorType
    Type of the sever administrator.
    AzureADOnlyAuthentication bool
    Azure Active Directory only Authentication enabled.
    Login string
    Login name of the server administrator.
    PrincipalType string | PrincipalType
    Principal Type of the sever administrator.
    Sid string
    SID (object ID) of the server administrator.
    TenantId string
    Tenant ID of the administrator.
    administratorType String | AdministratorType
    Type of the sever administrator.
    azureADOnlyAuthentication Boolean
    Azure Active Directory only Authentication enabled.
    login String
    Login name of the server administrator.
    principalType String | PrincipalType
    Principal Type of the sever administrator.
    sid String
    SID (object ID) of the server administrator.
    tenantId String
    Tenant ID of the administrator.
    administratorType string | AdministratorType
    Type of the sever administrator.
    azureADOnlyAuthentication boolean
    Azure Active Directory only Authentication enabled.
    login string
    Login name of the server administrator.
    principalType string | PrincipalType
    Principal Type of the sever administrator.
    sid string
    SID (object ID) of the server administrator.
    tenantId string
    Tenant ID of the administrator.
    administrator_type str | AdministratorType
    Type of the sever administrator.
    azure_ad_only_authentication bool
    Azure Active Directory only Authentication enabled.
    login str
    Login name of the server administrator.
    principal_type str | PrincipalType
    Principal Type of the sever administrator.
    sid str
    SID (object ID) of the server administrator.
    tenant_id str
    Tenant ID of the administrator.
    administratorType String | "ActiveDirectory"
    Type of the sever administrator.
    azureADOnlyAuthentication Boolean
    Azure Active Directory only Authentication enabled.
    login String
    Login name of the server administrator.
    principalType String | "User" | "Group" | "Application"
    Principal Type of the sever administrator.
    sid String
    SID (object ID) of the server administrator.
    tenantId String
    Tenant ID of the administrator.

    ManagedInstanceExternalAdministratorResponse, ManagedInstanceExternalAdministratorResponseArgs

    AdministratorType string
    Type of the sever administrator.
    AzureADOnlyAuthentication bool
    Azure Active Directory only Authentication enabled.
    Login string
    Login name of the server administrator.
    PrincipalType string
    Principal Type of the sever administrator.
    Sid string
    SID (object ID) of the server administrator.
    TenantId string
    Tenant ID of the administrator.
    AdministratorType string
    Type of the sever administrator.
    AzureADOnlyAuthentication bool
    Azure Active Directory only Authentication enabled.
    Login string
    Login name of the server administrator.
    PrincipalType string
    Principal Type of the sever administrator.
    Sid string
    SID (object ID) of the server administrator.
    TenantId string
    Tenant ID of the administrator.
    administratorType String
    Type of the sever administrator.
    azureADOnlyAuthentication Boolean
    Azure Active Directory only Authentication enabled.
    login String
    Login name of the server administrator.
    principalType String
    Principal Type of the sever administrator.
    sid String
    SID (object ID) of the server administrator.
    tenantId String
    Tenant ID of the administrator.
    administratorType string
    Type of the sever administrator.
    azureADOnlyAuthentication boolean
    Azure Active Directory only Authentication enabled.
    login string
    Login name of the server administrator.
    principalType string
    Principal Type of the sever administrator.
    sid string
    SID (object ID) of the server administrator.
    tenantId string
    Tenant ID of the administrator.
    administrator_type str
    Type of the sever administrator.
    azure_ad_only_authentication bool
    Azure Active Directory only Authentication enabled.
    login str
    Login name of the server administrator.
    principal_type str
    Principal Type of the sever administrator.
    sid str
    SID (object ID) of the server administrator.
    tenant_id str
    Tenant ID of the administrator.
    administratorType String
    Type of the sever administrator.
    azureADOnlyAuthentication Boolean
    Azure Active Directory only Authentication enabled.
    login String
    Login name of the server administrator.
    principalType String
    Principal Type of the sever administrator.
    sid String
    SID (object ID) of the server administrator.
    tenantId String
    Tenant ID of the administrator.

    ManagedInstanceLicenseType, ManagedInstanceLicenseTypeArgs

    LicenseIncluded
    LicenseIncluded
    BasePrice
    BasePrice
    ManagedInstanceLicenseTypeLicenseIncluded
    LicenseIncluded
    ManagedInstanceLicenseTypeBasePrice
    BasePrice
    LicenseIncluded
    LicenseIncluded
    BasePrice
    BasePrice
    LicenseIncluded
    LicenseIncluded
    BasePrice
    BasePrice
    LICENSE_INCLUDED
    LicenseIncluded
    BASE_PRICE
    BasePrice
    "LicenseIncluded"
    LicenseIncluded
    "BasePrice"
    BasePrice

    ManagedInstancePecPropertyResponse, ManagedInstancePecPropertyResponseArgs

    Id string
    Resource ID.
    Properties ManagedInstancePrivateEndpointConnectionPropertiesResponse
    Private endpoint connection properties
    id String
    Resource ID.
    properties ManagedInstancePrivateEndpointConnectionPropertiesResponse
    Private endpoint connection properties
    id string
    Resource ID.
    properties ManagedInstancePrivateEndpointConnectionPropertiesResponse
    Private endpoint connection properties
    id str
    Resource ID.
    properties ManagedInstancePrivateEndpointConnectionPropertiesResponse
    Private endpoint connection properties
    id String
    Resource ID.
    properties Property Map
    Private endpoint connection properties

    ManagedInstancePrivateEndpointConnectionPropertiesResponse, ManagedInstancePrivateEndpointConnectionPropertiesResponseArgs

    ProvisioningState string
    State of the Private Endpoint Connection.
    PrivateEndpoint ManagedInstancePrivateEndpointPropertyResponse
    Private endpoint which the connection belongs to.
    PrivateLinkServiceConnectionState ManagedInstancePrivateLinkServiceConnectionStatePropertyResponse
    Connection State of the Private Endpoint Connection.
    provisioningState String
    State of the Private Endpoint Connection.
    privateEndpoint ManagedInstancePrivateEndpointPropertyResponse
    Private endpoint which the connection belongs to.
    privateLinkServiceConnectionState ManagedInstancePrivateLinkServiceConnectionStatePropertyResponse
    Connection State of the Private Endpoint Connection.
    provisioningState string
    State of the Private Endpoint Connection.
    privateEndpoint ManagedInstancePrivateEndpointPropertyResponse
    Private endpoint which the connection belongs to.
    privateLinkServiceConnectionState ManagedInstancePrivateLinkServiceConnectionStatePropertyResponse
    Connection State of the Private Endpoint Connection.
    provisioning_state str
    State of the Private Endpoint Connection.
    private_endpoint ManagedInstancePrivateEndpointPropertyResponse
    Private endpoint which the connection belongs to.
    private_link_service_connection_state ManagedInstancePrivateLinkServiceConnectionStatePropertyResponse
    Connection State of the Private Endpoint Connection.
    provisioningState String
    State of the Private Endpoint Connection.
    privateEndpoint Property Map
    Private endpoint which the connection belongs to.
    privateLinkServiceConnectionState Property Map
    Connection State of the Private Endpoint Connection.

    ManagedInstancePrivateEndpointPropertyResponse, ManagedInstancePrivateEndpointPropertyResponseArgs

    Id string
    Resource id of the private endpoint.
    Id string
    Resource id of the private endpoint.
    id String
    Resource id of the private endpoint.
    id string
    Resource id of the private endpoint.
    id str
    Resource id of the private endpoint.
    id String
    Resource id of the private endpoint.

    ManagedInstancePrivateLinkServiceConnectionStatePropertyResponse, ManagedInstancePrivateLinkServiceConnectionStatePropertyResponseArgs

    ActionsRequired string
    The private link service connection description.
    Description string
    The private link service connection description.
    Status string
    The private link service connection status.
    ActionsRequired string
    The private link service connection description.
    Description string
    The private link service connection description.
    Status string
    The private link service connection status.
    actionsRequired String
    The private link service connection description.
    description String
    The private link service connection description.
    status String
    The private link service connection status.
    actionsRequired string
    The private link service connection description.
    description string
    The private link service connection description.
    status string
    The private link service connection status.
    actions_required str
    The private link service connection description.
    description str
    The private link service connection description.
    status str
    The private link service connection status.
    actionsRequired String
    The private link service connection description.
    description String
    The private link service connection description.
    status String
    The private link service connection status.

    ManagedInstanceProxyOverride, ManagedInstanceProxyOverrideArgs

    Proxy
    Proxy
    Redirect
    Redirect
    Default
    Default
    ManagedInstanceProxyOverrideProxy
    Proxy
    ManagedInstanceProxyOverrideRedirect
    Redirect
    ManagedInstanceProxyOverrideDefault
    Default
    Proxy
    Proxy
    Redirect
    Redirect
    Default
    Default
    Proxy
    Proxy
    Redirect
    Redirect
    Default
    Default
    PROXY
    Proxy
    REDIRECT
    Redirect
    DEFAULT
    Default
    "Proxy"
    Proxy
    "Redirect"
    Redirect
    "Default"
    Default

    ManagedServerCreateMode, ManagedServerCreateModeArgs

    Default
    Default
    PointInTimeRestore
    PointInTimeRestore
    ManagedServerCreateModeDefault
    Default
    ManagedServerCreateModePointInTimeRestore
    PointInTimeRestore
    Default
    Default
    PointInTimeRestore
    PointInTimeRestore
    Default
    Default
    PointInTimeRestore
    PointInTimeRestore
    DEFAULT
    Default
    POINT_IN_TIME_RESTORE
    PointInTimeRestore
    "Default"
    Default
    "PointInTimeRestore"
    PointInTimeRestore

    PrincipalType, PrincipalTypeArgs

    User
    User
    Group
    Group
    Application
    Application
    PrincipalTypeUser
    User
    PrincipalTypeGroup
    Group
    PrincipalTypeApplication
    Application
    User
    User
    Group
    Group
    Application
    Application
    User
    User
    Group
    Group
    Application
    Application
    USER
    User
    GROUP
    Group
    APPLICATION
    Application
    "User"
    User
    "Group"
    Group
    "Application"
    Application

    ResourceIdentity, ResourceIdentityArgs

    Type string | Pulumi.AzureNative.Sql.IdentityType
    The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
    UserAssignedIdentities List<string>
    The resource ids of the user assigned identities to use
    Type string | IdentityType
    The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
    UserAssignedIdentities []string
    The resource ids of the user assigned identities to use
    type String | IdentityType
    The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
    userAssignedIdentities List<String>
    The resource ids of the user assigned identities to use
    type string | IdentityType
    The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
    userAssignedIdentities string[]
    The resource ids of the user assigned identities to use
    type str | IdentityType
    The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
    user_assigned_identities Sequence[str]
    The resource ids of the user assigned identities to use
    type String | "None" | "SystemAssigned" | "UserAssigned" | "SystemAssigned,UserAssigned"
    The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
    userAssignedIdentities List<String>
    The resource ids of the user assigned identities to use

    ResourceIdentityResponse, ResourceIdentityResponseArgs

    PrincipalId string
    The Azure Active Directory principal id.
    TenantId string
    The Azure Active Directory tenant id.
    Type string
    The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
    UserAssignedIdentities Dictionary<string, Pulumi.AzureNative.Sql.Inputs.UserIdentityResponse>
    The resource ids of the user assigned identities to use
    PrincipalId string
    The Azure Active Directory principal id.
    TenantId string
    The Azure Active Directory tenant id.
    Type string
    The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
    UserAssignedIdentities map[string]UserIdentityResponse
    The resource ids of the user assigned identities to use
    principalId String
    The Azure Active Directory principal id.
    tenantId String
    The Azure Active Directory tenant id.
    type String
    The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
    userAssignedIdentities Map<String,UserIdentityResponse>
    The resource ids of the user assigned identities to use
    principalId string
    The Azure Active Directory principal id.
    tenantId string
    The Azure Active Directory tenant id.
    type string
    The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
    userAssignedIdentities {[key: string]: UserIdentityResponse}
    The resource ids of the user assigned identities to use
    principal_id str
    The Azure Active Directory principal id.
    tenant_id str
    The Azure Active Directory tenant id.
    type str
    The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
    user_assigned_identities Mapping[str, UserIdentityResponse]
    The resource ids of the user assigned identities to use
    principalId String
    The Azure Active Directory principal id.
    tenantId String
    The Azure Active Directory tenant id.
    type String
    The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
    userAssignedIdentities Map<Property Map>
    The resource ids of the user assigned identities to use

    ServicePrincipal, ServicePrincipalArgs

    Type string | Pulumi.AzureNative.Sql.ServicePrincipalType
    Service principal type.
    Type string | ServicePrincipalType
    Service principal type.
    type String | ServicePrincipalType
    Service principal type.
    type string | ServicePrincipalType
    Service principal type.
    type str | ServicePrincipalType
    Service principal type.
    type String | "None" | "SystemAssigned"
    Service principal type.

    ServicePrincipalResponse, ServicePrincipalResponseArgs

    ClientId string
    The Azure Active Directory application client id.
    PrincipalId string
    The Azure Active Directory application object id.
    TenantId string
    The Azure Active Directory tenant id.
    Type string
    Service principal type.
    ClientId string
    The Azure Active Directory application client id.
    PrincipalId string
    The Azure Active Directory application object id.
    TenantId string
    The Azure Active Directory tenant id.
    Type string
    Service principal type.
    clientId String
    The Azure Active Directory application client id.
    principalId String
    The Azure Active Directory application object id.
    tenantId String
    The Azure Active Directory tenant id.
    type String
    Service principal type.
    clientId string
    The Azure Active Directory application client id.
    principalId string
    The Azure Active Directory application object id.
    tenantId string
    The Azure Active Directory tenant id.
    type string
    Service principal type.
    client_id str
    The Azure Active Directory application client id.
    principal_id str
    The Azure Active Directory application object id.
    tenant_id str
    The Azure Active Directory tenant id.
    type str
    Service principal type.
    clientId String
    The Azure Active Directory application client id.
    principalId String
    The Azure Active Directory application object id.
    tenantId String
    The Azure Active Directory tenant id.
    type String
    Service principal type.

    ServicePrincipalType, ServicePrincipalTypeArgs

    None
    None
    SystemAssigned
    SystemAssigned
    ServicePrincipalTypeNone
    None
    ServicePrincipalTypeSystemAssigned
    SystemAssigned
    None
    None
    SystemAssigned
    SystemAssigned
    None
    None
    SystemAssigned
    SystemAssigned
    NONE
    None
    SYSTEM_ASSIGNED
    SystemAssigned
    "None"
    None
    "SystemAssigned"
    SystemAssigned

    Sku, SkuArgs

    Name string
    The name of the SKU, typically, a letter + Number code, e.g. P3.
    Capacity int
    Capacity of the particular SKU.
    Family string
    If the service has different generations of hardware, for the same SKU, then that can be captured here.
    Size string
    Size of the particular SKU
    Tier string
    The tier or edition of the particular SKU, e.g. Basic, Premium.
    Name string
    The name of the SKU, typically, a letter + Number code, e.g. P3.
    Capacity int
    Capacity of the particular SKU.
    Family string
    If the service has different generations of hardware, for the same SKU, then that can be captured here.
    Size string
    Size of the particular SKU
    Tier string
    The tier or edition of the particular SKU, e.g. Basic, Premium.
    name String
    The name of the SKU, typically, a letter + Number code, e.g. P3.
    capacity Integer
    Capacity of the particular SKU.
    family String
    If the service has different generations of hardware, for the same SKU, then that can be captured here.
    size String
    Size of the particular SKU
    tier String
    The tier or edition of the particular SKU, e.g. Basic, Premium.
    name string
    The name of the SKU, typically, a letter + Number code, e.g. P3.
    capacity number
    Capacity of the particular SKU.
    family string
    If the service has different generations of hardware, for the same SKU, then that can be captured here.
    size string
    Size of the particular SKU
    tier string
    The tier or edition of the particular SKU, e.g. Basic, Premium.
    name str
    The name of the SKU, typically, a letter + Number code, e.g. P3.
    capacity int
    Capacity of the particular SKU.
    family str
    If the service has different generations of hardware, for the same SKU, then that can be captured here.
    size str
    Size of the particular SKU
    tier str
    The tier or edition of the particular SKU, e.g. Basic, Premium.
    name String
    The name of the SKU, typically, a letter + Number code, e.g. P3.
    capacity Number
    Capacity of the particular SKU.
    family String
    If the service has different generations of hardware, for the same SKU, then that can be captured here.
    size String
    Size of the particular SKU
    tier String
    The tier or edition of the particular SKU, e.g. Basic, Premium.

    SkuResponse, SkuResponseArgs

    Name string
    The name of the SKU, typically, a letter + Number code, e.g. P3.
    Capacity int
    Capacity of the particular SKU.
    Family string
    If the service has different generations of hardware, for the same SKU, then that can be captured here.
    Size string
    Size of the particular SKU
    Tier string
    The tier or edition of the particular SKU, e.g. Basic, Premium.
    Name string
    The name of the SKU, typically, a letter + Number code, e.g. P3.
    Capacity int
    Capacity of the particular SKU.
    Family string
    If the service has different generations of hardware, for the same SKU, then that can be captured here.
    Size string
    Size of the particular SKU
    Tier string
    The tier or edition of the particular SKU, e.g. Basic, Premium.
    name String
    The name of the SKU, typically, a letter + Number code, e.g. P3.
    capacity Integer
    Capacity of the particular SKU.
    family String
    If the service has different generations of hardware, for the same SKU, then that can be captured here.
    size String
    Size of the particular SKU
    tier String
    The tier or edition of the particular SKU, e.g. Basic, Premium.
    name string
    The name of the SKU, typically, a letter + Number code, e.g. P3.
    capacity number
    Capacity of the particular SKU.
    family string
    If the service has different generations of hardware, for the same SKU, then that can be captured here.
    size string
    Size of the particular SKU
    tier string
    The tier or edition of the particular SKU, e.g. Basic, Premium.
    name str
    The name of the SKU, typically, a letter + Number code, e.g. P3.
    capacity int
    Capacity of the particular SKU.
    family str
    If the service has different generations of hardware, for the same SKU, then that can be captured here.
    size str
    Size of the particular SKU
    tier str
    The tier or edition of the particular SKU, e.g. Basic, Premium.
    name String
    The name of the SKU, typically, a letter + Number code, e.g. P3.
    capacity Number
    Capacity of the particular SKU.
    family String
    If the service has different generations of hardware, for the same SKU, then that can be captured here.
    size String
    Size of the particular SKU
    tier String
    The tier or edition of the particular SKU, e.g. Basic, Premium.

    UserIdentityResponse, UserIdentityResponseArgs

    ClientId string
    The Azure Active Directory client id.
    PrincipalId string
    The Azure Active Directory principal id.
    ClientId string
    The Azure Active Directory client id.
    PrincipalId string
    The Azure Active Directory principal id.
    clientId String
    The Azure Active Directory client id.
    principalId String
    The Azure Active Directory principal id.
    clientId string
    The Azure Active Directory client id.
    principalId string
    The Azure Active Directory principal id.
    client_id str
    The Azure Active Directory client id.
    principal_id str
    The Azure Active Directory principal id.
    clientId String
    The Azure Active Directory client id.
    principalId String
    The Azure Active Directory principal id.

    Import

    An existing resource can be imported using its type token, name, and identifier, e.g.

    $ pulumi import azure-native:sql:ManagedInstance testinstance /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/managedInstances/{managedInstanceName}

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

    Package Details

    Repository
    Azure Native pulumi/pulumi-azure-native
    License
    Apache-2.0
    azure-native logo
    This is the latest version of Azure Native. Use the Azure Native v1 docs if using the v1 version of this package.
    Azure Native v2.89.1 published on Sunday, Mar 2, 2025 by Pulumi
    pulumi/pulumi-azure-native