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.47.1 published on Monday, Jun 24, 2024 by Pulumi

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.47.1 published on Monday, Jun 24, 2024 by Pulumi

    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.

    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 pulumi
    import pulumi_azure_native as azure_native
    
    managed_instance = azure_native.sql.ManagedInstance("managedInstance",
        administrator_login="dummylogin",
        administrator_login_password="PLACEHOLDER",
        administrators=azure_native.sql.ManagedInstanceExternalAdministratorArgs(
            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=azure_native.sql.ServicePrincipalArgs(
            type=azure_native.sql.ServicePrincipalType.SYSTEM_ASSIGNED,
        ),
        sku=azure_native.sql.SkuArgs(
            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)
    
    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,
    });
    
    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 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=azure_native.sql.SkuArgs(
            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)
    
    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,
    });
    
    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=azure_native.sql.ResourceIdentityArgs(
            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=azure_native.sql.ManagedInstanceExternalAdministratorArgs(
            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=azure_native.sql.ServicePrincipalArgs(
            type="string",
        ),
        sku=azure_native.sql.SkuArgs(
            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

    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.47.1 published on Monday, Jun 24, 2024 by Pulumi