Docs Packages
  1. Pulumi Registry
  2. Azure Native
  3. API Docs
  4. sql
  5. ManagedInstance
azure-native logo
Azure Native v1.102.0, May 2 23

azure-native.sql.ManagedInstance

Explore with Pulumi AI

An Azure SQL managed instance. API Version: 2020-11-01-preview.

Example Usage

Create managed instance with all properties

using System.Collections.Generic;
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 = "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,
        ResourceGroupName = "testrg",
        Sku = new AzureNative.Sql.Inputs.SkuArgs
        {
            Name = "GP_Gen5",
            Tier = "GeneralPurpose",
        },
        StorageAccountType = "GRS",
        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/go/azure/sql"
	"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("User"),
				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("LicenseIncluded"),
			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("Redirect"),
			PublicDataEndpointEnabled:  pulumi.Bool(false),
			ResourceGroupName:          pulumi.String("testrg"),
			Sku: sql.SkuResponse{
				Name: pulumi.String("GP_Gen5"),
				Tier: pulumi.String("GeneralPurpose"),
			},
			StorageAccountType: pulumi.String("GRS"),
			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 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(Map.ofEntries(
                Map.entry("azureADOnlyAuthentication", true),
                Map.entry("login", "bob@contoso.com"),
                Map.entry("principalType", "User"),
                Map.entry("sid", "00000011-1111-2222-2222-123456789111"),
                Map.entry("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)
            .resourceGroupName("testrg")
            .sku(Map.ofEntries(
                Map.entry("name", "GP_Gen5"),
                Map.entry("tier", "GeneralPurpose")
            ))
            .storageAccountType("GRS")
            .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="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="LicenseIncluded",
    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="Redirect",
    public_data_endpoint_enabled=False,
    resource_group_name="testrg",
    sku=azure_native.sql.SkuResponseArgs(
        name="GP_Gen5",
        tier="GeneralPurpose",
    ),
    storage_account_type="GRS",
    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: "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,
    resourceGroupName: "testrg",
    sku: {
        name: "GP_Gen5",
        tier: "GeneralPurpose",
    },
    storageAccountType: "GRS",
    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
      resourceGroupName: testrg
      sku:
        name: GP_Gen5
        tier: GeneralPurpose
      storageAccountType: GRS
      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 Pulumi;
using AzureNative = Pulumi.AzureNative;

return await Deployment.RunAsync(() => 
{
    var managedInstance = new AzureNative.Sql.ManagedInstance("managedInstance", new()
    {
        AdministratorLogin = "dummylogin",
        AdministratorLoginPassword = "PLACEHOLDER",
        LicenseType = "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/go/azure/sql"
	"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("LicenseIncluded"),
			Location:                   pulumi.String("Japan East"),
			ManagedInstanceName:        pulumi.String("testinstance"),
			ResourceGroupName:          pulumi.String("testrg"),
			Sku: sql.SkuResponse{
				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 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(Map.ofEntries(
                Map.entry("name", "GP_Gen4"),
                Map.entry("tier", "GeneralPurpose")
            ))
            .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="LicenseIncluded",
    location="Japan East",
    managed_instance_name="testinstance",
    resource_group_name="testrg",
    sku=azure_native.sql.SkuResponseArgs(
        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: "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

new ManagedInstance(name: string, args: ManagedInstanceArgs, opts?: CustomResourceOptions);
@overload
def ManagedInstance(resource_name: str,
                    opts: Optional[ResourceOptions] = None,
                    administrator_login: Optional[str] = None,
                    administrator_login_password: Optional[str] = None,
                    administrators: Optional[ManagedInstanceExternalAdministratorArgs] = 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,
                    minimal_tls_version: Optional[str] = None,
                    primary_user_assigned_identity_id: Optional[str] = None,
                    proxy_override: Optional[Union[str, ManagedInstanceProxyOverride]] = None,
                    public_data_endpoint_enabled: Optional[bool] = None,
                    resource_group_name: Optional[str] = None,
                    restore_point_in_time: Optional[str] = None,
                    sku: Optional[SkuArgs] = None,
                    source_managed_instance_id: Optional[str] = None,
                    storage_account_type: Optional[Union[str, StorageAccountType]] = None,
                    storage_size_in_gb: Optional[int] = None,
                    subnet_id: Optional[str] = None,
                    tags: Optional[Mapping[str, str]] = None,
                    timezone_id: Optional[str] = None,
                    v_cores: Optional[int] = None,
                    zone_redundant: Optional[bool] = None)
@overload
def ManagedInstance(resource_name: str,
                    args: ManagedInstanceArgs,
                    opts: Optional[ResourceOptions] = 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.
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.

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.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 Pulumi.AzureNative.Sql.Inputs.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 | 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.

RestorePointInTime string

Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.

Sku Pulumi.AzureNative.Sql.Inputs.SkuArgs

Managed instance SKU. Allowed values for sku.name: GP_Gen4, GP_Gen5, BC_Gen4, BC_Gen5

SourceManagedInstanceId string

The resource identifier of the source managed instance associated with create operation of this instance.

StorageAccountType string | Pulumi.AzureNative.Sql.StorageAccountType

The storage account type used to store backups for this instance. The options are LRS (LocallyRedundantStorage), ZRS (ZoneRedundantStorage) and GRS (GeoRedundantStorage)

StorageSizeInGB int

Storage size in GB. Minimum value: 32. Maximum value: 8192. Increments of 32 GB allowed only.

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.

RestorePointInTime string

Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.

Sku SkuArgs

Managed instance SKU. Allowed values for sku.name: GP_Gen4, GP_Gen5, BC_Gen4, BC_Gen5

SourceManagedInstanceId string

The resource identifier of the source managed instance associated with create operation of this instance.

StorageAccountType string | StorageAccountType

The storage account type used to store backups for this instance. The options are LRS (LocallyRedundantStorage), ZRS (ZoneRedundantStorage) and GRS (GeoRedundantStorage)

StorageSizeInGB int

Storage size in GB. Minimum value: 32. Maximum value: 8192. Increments of 32 GB allowed only.

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 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 Boolean

Whether or not the public data endpoint is enabled.

restorePointInTime String

Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.

sku SkuArgs

Managed instance SKU. Allowed values for sku.name: GP_Gen4, GP_Gen5, BC_Gen4, BC_Gen5

sourceManagedInstanceId String

The resource identifier of the source managed instance associated with create operation of this instance.

storageAccountType String | StorageAccountType

The storage account type used to store backups for this instance. The options are LRS (LocallyRedundantStorage), ZRS (ZoneRedundantStorage) and GRS (GeoRedundantStorage)

storageSizeInGB Integer

Storage size in GB. Minimum value: 32. Maximum value: 8192. Increments of 32 GB allowed only.

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 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 boolean

Whether or not the public data endpoint is enabled.

restorePointInTime string

Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.

sku SkuArgs

Managed instance SKU. Allowed values for sku.name: GP_Gen4, GP_Gen5, BC_Gen4, BC_Gen5

sourceManagedInstanceId string

The resource identifier of the source managed instance associated with create operation of this instance.

storageAccountType string | StorageAccountType

The storage account type used to store backups for this instance. The options are LRS (LocallyRedundantStorage), ZRS (ZoneRedundantStorage) and GRS (GeoRedundantStorage)

storageSizeInGB number

Storage size in GB. Minimum value: 32. Maximum value: 8192. Increments of 32 GB allowed only.

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.

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.

sku SkuArgs

Managed instance SKU. Allowed values for sku.name: GP_Gen4, GP_Gen5, BC_Gen4, BC_Gen5

source_managed_instance_id str

The resource identifier of the source managed instance associated with create operation of this instance.

storage_account_type str | StorageAccountType

The storage account type used to store backups for this instance. The options are LRS (LocallyRedundantStorage), ZRS (ZoneRedundantStorage) and GRS (GeoRedundantStorage)

storage_size_in_gb int

Storage size in GB. Minimum value: 32. Maximum value: 8192. Increments of 32 GB allowed only.

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.

restorePointInTime String

Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.

sku Property Map

Managed instance SKU. Allowed values for sku.name: GP_Gen4, GP_Gen5, BC_Gen4, BC_Gen5

sourceManagedInstanceId String

The resource identifier of the source managed instance associated with create operation of this instance.

storageAccountType String | "GRS" | "LRS" | "ZRS"

The storage account type used to store backups for this instance. The options are LRS (LocallyRedundantStorage), ZRS (ZoneRedundantStorage) and GRS (GeoRedundantStorage)

storageSizeInGB Number

Storage size in GB. Minimum value: 32. Maximum value: 8192. Increments of 32 GB allowed only.

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:

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.

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.

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.

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.

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.

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

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

IdentityType

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

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

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

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

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

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

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

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

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

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

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

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 Dictionary<string, object>

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 map[string]interface{}

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 Map<String,Object>

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 {[key: string]: any}

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 Mapping[str, Any]

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 Map<Any>

The resource ids of the user assigned identities to use

ResourceIdentityResponse

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

Sku

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

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.

StorageAccountType

GRS
GRS
LRS
LRS
ZRS
ZRS
StorageAccountTypeGRS
GRS
StorageAccountTypeLRS
LRS
StorageAccountTypeZRS
ZRS
GRS
GRS
LRS
LRS
ZRS
ZRS
GRS
GRS
LRS
LRS
ZRS
ZRS
GRS
GRS
LRS
LRS
ZRS
ZRS
"GRS"
GRS
"LRS"
LRS
"ZRS"
ZRS

UserIdentityResponse

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/20d7082a-0fc7-4468-82bd-542694d5042b/resourceGroups/testrg/providers/Microsoft.Sql/managedInstances/testinstance

Package Details

Repository
Azure Native pulumi/pulumi-azure-native
License
Apache-2.0