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 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 = "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/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.SkuArgs{
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.SkuArgs(
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 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 = "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"
"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.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 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.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: "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,
zone_redundant: Optional[bool] = None,
minimal_tls_version: 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,
collation: Optional[str] = None,
administrators: Optional[ManagedInstanceExternalAdministratorArgs] = None,
storage_size_in_gb: Optional[int] = None,
public_data_endpoint_enabled: Optional[bool] = None,
administrator_login_password: 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,
proxy_override: Optional[Union[str, ManagedInstanceProxyOverride]] = None,
subnet_id: Optional[str] = None,
tags: Optional[Mapping[str, str]] = None,
timezone_id: Optional[str] = None,
v_cores: Optional[int] = None,
administrator_login: 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",
ZoneRedundant = false,
MinimalTlsVersion = "string",
DnsZonePartner = "string",
Identity =
{
{ "type", "string" },
{ "userAssignedIdentities",
{
{ "string", "any" },
} },
},
InstancePoolId = "string",
KeyId = "string",
LicenseType = "string",
Location = "string",
MaintenanceConfigurationId = "string",
ManagedInstanceCreateMode = "string",
ManagedInstanceName = "string",
Collation = "string",
Administrators =
{
{ "administratorType", "string" },
{ "azureADOnlyAuthentication", false },
{ "login", "string" },
{ "principalType", "string" },
{ "sid", "string" },
{ "tenantId", "string" },
},
StorageSizeInGB = 0,
PublicDataEndpointEnabled = false,
AdministratorLoginPassword = "string",
RestorePointInTime = "string",
Sku =
{
{ "name", "string" },
{ "capacity", 0 },
{ "family", "string" },
{ "size", "string" },
{ "tier", "string" },
},
SourceManagedInstanceId = "string",
StorageAccountType = "string",
ProxyOverride = "string",
SubnetId = "string",
Tags =
{
{ "string", "string" },
},
TimezoneId = "string",
VCores = 0,
AdministratorLogin = "string",
});
example, err := sql.NewManagedInstance(ctx, "managedInstanceResource", &sql.ManagedInstanceArgs{
ResourceGroupName: "string",
PrimaryUserAssignedIdentityId: "string",
ZoneRedundant: false,
MinimalTlsVersion: "string",
DnsZonePartner: "string",
Identity: map[string]interface{}{
"type": "string",
"userAssignedIdentities": map[string]interface{}{
"string": "any",
},
},
InstancePoolId: "string",
KeyId: "string",
LicenseType: "string",
Location: "string",
MaintenanceConfigurationId: "string",
ManagedInstanceCreateMode: "string",
ManagedInstanceName: "string",
Collation: "string",
Administrators: map[string]interface{}{
"administratorType": "string",
"azureADOnlyAuthentication": false,
"login": "string",
"principalType": "string",
"sid": "string",
"tenantId": "string",
},
StorageSizeInGB: 0,
PublicDataEndpointEnabled: false,
AdministratorLoginPassword: "string",
RestorePointInTime: "string",
Sku: map[string]interface{}{
"name": "string",
"capacity": 0,
"family": "string",
"size": "string",
"tier": "string",
},
SourceManagedInstanceId: "string",
StorageAccountType: "string",
ProxyOverride: "string",
SubnetId: "string",
Tags: map[string]interface{}{
"string": "string",
},
TimezoneId: "string",
VCores: 0,
AdministratorLogin: "string",
})
var managedInstanceResource = new ManagedInstance("managedInstanceResource", ManagedInstanceArgs.builder()
.resourceGroupName("string")
.primaryUserAssignedIdentityId("string")
.zoneRedundant(false)
.minimalTlsVersion("string")
.dnsZonePartner("string")
.identity(%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference))
.instancePoolId("string")
.keyId("string")
.licenseType("string")
.location("string")
.maintenanceConfigurationId("string")
.managedInstanceCreateMode("string")
.managedInstanceName("string")
.collation("string")
.administrators(%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference))
.storageSizeInGB(0)
.publicDataEndpointEnabled(false)
.administratorLoginPassword("string")
.restorePointInTime("string")
.sku(%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference))
.sourceManagedInstanceId("string")
.storageAccountType("string")
.proxyOverride("string")
.subnetId("string")
.tags(%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference))
.timezoneId("string")
.vCores(0)
.administratorLogin("string")
.build());
managed_instance_resource = azure_native.sql.ManagedInstance("managedInstanceResource",
resource_group_name=string,
primary_user_assigned_identity_id=string,
zone_redundant=False,
minimal_tls_version=string,
dns_zone_partner=string,
identity={
type: string,
userAssignedIdentities: {
string: any,
},
},
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,
collation=string,
administrators={
administratorType: string,
azureADOnlyAuthentication: False,
login: string,
principalType: string,
sid: string,
tenantId: string,
},
storage_size_in_gb=0,
public_data_endpoint_enabled=False,
administrator_login_password=string,
restore_point_in_time=string,
sku={
name: string,
capacity: 0,
family: string,
size: string,
tier: string,
},
source_managed_instance_id=string,
storage_account_type=string,
proxy_override=string,
subnet_id=string,
tags={
string: string,
},
timezone_id=string,
v_cores=0,
administrator_login=string)
const managedInstanceResource = new azure_native.sql.ManagedInstance("managedInstanceResource", {
resourceGroupName: "string",
primaryUserAssignedIdentityId: "string",
zoneRedundant: false,
minimalTlsVersion: "string",
dnsZonePartner: "string",
identity: {
type: "string",
userAssignedIdentities: {
string: "any",
},
},
instancePoolId: "string",
keyId: "string",
licenseType: "string",
location: "string",
maintenanceConfigurationId: "string",
managedInstanceCreateMode: "string",
managedInstanceName: "string",
collation: "string",
administrators: {
administratorType: "string",
azureADOnlyAuthentication: false,
login: "string",
principalType: "string",
sid: "string",
tenantId: "string",
},
storageSizeInGB: 0,
publicDataEndpointEnabled: false,
administratorLoginPassword: "string",
restorePointInTime: "string",
sku: {
name: "string",
capacity: 0,
family: "string",
size: "string",
tier: "string",
},
sourceManagedInstanceId: "string",
storageAccountType: "string",
proxyOverride: "string",
subnetId: "string",
tags: {
string: "string",
},
timezoneId: "string",
vCores: 0,
administratorLogin: "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: any
instancePoolId: string
keyId: string
licenseType: string
location: string
maintenanceConfigurationId: string
managedInstanceCreateMode: string
managedInstanceName: string
minimalTlsVersion: string
primaryUserAssignedIdentityId: string
proxyOverride: string
publicDataEndpointEnabled: false
resourceGroupName: string
restorePointInTime: string
sku:
capacity: 0
family: string
name: string
size: string
tier: string
sourceManagedInstanceId: string
storageAccountType: string
storageSizeInGB: 0
subnetId: string
tags:
string: string
timezoneId: string
vCores: 0
zoneRedundant: false
ManagedInstance Resource Properties
To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.
Inputs
In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.
The ManagedInstance resource accepts the following input properties:
- Resource
Group stringName - 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 string - Administrator username for the managed instance. Can only be specified when the managed instance is being created (and is required for creation).
- Administrator
Login stringPassword - The administrator login password (required for managed instance creation).
- Administrators
Pulumi.
Azure Native. Sql. Inputs. Managed Instance External Administrator - The Azure Active Directory administrator of the server.
- Collation string
- Collation of the managed instance.
- Dns
Zone stringPartner - The resource id of another managed instance whose DNS zone this managed instance will share after creation.
- Identity
Pulumi.
Azure Native. Sql. Inputs. Resource Identity - The Azure Active Directory identity of the managed instance.
- Instance
Pool stringId - The Id of the instance pool this managed server belongs to.
- Key
Id string - A CMK URI of the key to use for encryption.
- License
Type string | Pulumi.Azure Native. Sql. Managed Instance License Type - 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.
- Maintenance
Configuration stringId - Specifies maintenance configuration id to apply to this managed instance.
- Managed
Instance string | Pulumi.Create Mode Azure Native. Sql. Managed Server Create Mode 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 stringName - The name of the managed instance.
- Minimal
Tls stringVersion - Minimal TLS version. Allowed values: 'None', '1.0', '1.1', '1.2'
- Primary
User stringAssigned Identity Id - The resource id of a user assigned identity to be used by default.
- Proxy
Override string | Pulumi.Azure Native. Sql. Managed Instance Proxy Override - Connection type used for connecting to the instance.
- Public
Data boolEndpoint Enabled - Whether or not the public data endpoint is enabled.
- Restore
Point stringIn Time - Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.
- Sku
Pulumi.
Azure Native. Sql. Inputs. Sku - Managed instance SKU. Allowed values for sku.name: GP_Gen4, GP_Gen5, BC_Gen4, BC_Gen5
- Source
Managed stringInstance Id - The resource identifier of the source managed instance associated with create operation of this instance.
- Storage
Account string | Pulumi.Type Azure Native. Sql. Storage Account Type - The storage account type used to store backups for this instance. The options are LRS (LocallyRedundantStorage), ZRS (ZoneRedundantStorage) and GRS (GeoRedundantStorage)
- Storage
Size intIn GB - Storage size in GB. Minimum value: 32. Maximum value: 8192. Increments of 32 GB allowed only.
- Subnet
Id string - Subnet resource ID for the managed instance.
- Dictionary<string, string>
- Resource tags.
- Timezone
Id 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.
- Zone
Redundant bool - Whether or not the multi-az is enabled.
- Resource
Group stringName - 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 string - Administrator username for the managed instance. Can only be specified when the managed instance is being created (and is required for creation).
- Administrator
Login stringPassword - The administrator login password (required for managed instance creation).
- Administrators
Managed
Instance External Administrator Args - The Azure Active Directory administrator of the server.
- Collation string
- Collation of the managed instance.
- Dns
Zone stringPartner - The resource id of another managed instance whose DNS zone this managed instance will share after creation.
- Identity
Resource
Identity Args - The Azure Active Directory identity of the managed instance.
- Instance
Pool stringId - The Id of the instance pool this managed server belongs to.
- Key
Id string - A CMK URI of the key to use for encryption.
- License
Type string | ManagedInstance License Type - 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.
- Maintenance
Configuration stringId - Specifies maintenance configuration id to apply to this managed instance.
- Managed
Instance string | ManagedCreate Mode Server Create Mode 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 stringName - The name of the managed instance.
- Minimal
Tls stringVersion - Minimal TLS version. Allowed values: 'None', '1.0', '1.1', '1.2'
- Primary
User stringAssigned Identity Id - The resource id of a user assigned identity to be used by default.
- Proxy
Override string | ManagedInstance Proxy Override - Connection type used for connecting to the instance.
- Public
Data boolEndpoint Enabled - Whether or not the public data endpoint is enabled.
- Restore
Point stringIn Time - Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.
- Sku
Sku
Args - Managed instance SKU. Allowed values for sku.name: GP_Gen4, GP_Gen5, BC_Gen4, BC_Gen5
- Source
Managed stringInstance Id - The resource identifier of the source managed instance associated with create operation of this instance.
- Storage
Account string | StorageType Account Type - The storage account type used to store backups for this instance. The options are LRS (LocallyRedundantStorage), ZRS (ZoneRedundantStorage) and GRS (GeoRedundantStorage)
- Storage
Size intIn GB - Storage size in GB. Minimum value: 32. Maximum value: 8192. Increments of 32 GB allowed only.
- Subnet
Id string - Subnet resource ID for the managed instance.
- map[string]string
- Resource tags.
- Timezone
Id 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.
- Zone
Redundant bool - Whether or not the multi-az is enabled.
- resource
Group StringName - 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 String - Administrator username for the managed instance. Can only be specified when the managed instance is being created (and is required for creation).
- administrator
Login StringPassword - The administrator login password (required for managed instance creation).
- administrators
Managed
Instance External Administrator - The Azure Active Directory administrator of the server.
- collation String
- Collation of the managed instance.
- dns
Zone StringPartner - The resource id of another managed instance whose DNS zone this managed instance will share after creation.
- identity
Resource
Identity - The Azure Active Directory identity of the managed instance.
- instance
Pool StringId - The Id of the instance pool this managed server belongs to.
- key
Id String - A CMK URI of the key to use for encryption.
- license
Type String | ManagedInstance License Type - 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.
- maintenance
Configuration StringId - Specifies maintenance configuration id to apply to this managed instance.
- managed
Instance String | ManagedCreate Mode Server Create Mode 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 StringName - The name of the managed instance.
- minimal
Tls StringVersion - Minimal TLS version. Allowed values: 'None', '1.0', '1.1', '1.2'
- primary
User StringAssigned Identity Id - The resource id of a user assigned identity to be used by default.
- proxy
Override String | ManagedInstance Proxy Override - Connection type used for connecting to the instance.
- public
Data BooleanEndpoint Enabled - Whether or not the public data endpoint is enabled.
- restore
Point StringIn Time - Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.
- sku Sku
- Managed instance SKU. Allowed values for sku.name: GP_Gen4, GP_Gen5, BC_Gen4, BC_Gen5
- source
Managed StringInstance Id - The resource identifier of the source managed instance associated with create operation of this instance.
- storage
Account String | StorageType Account Type - The storage account type used to store backups for this instance. The options are LRS (LocallyRedundantStorage), ZRS (ZoneRedundantStorage) and GRS (GeoRedundantStorage)
- storage
Size IntegerIn GB - Storage size in GB. Minimum value: 32. Maximum value: 8192. Increments of 32 GB allowed only.
- subnet
Id String - Subnet resource ID for the managed instance.
- Map<String,String>
- Resource tags.
- timezone
Id 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".
- v
Cores Integer - The number of vCores. Allowed values: 8, 16, 24, 32, 40, 64, 80.
- zone
Redundant Boolean - Whether or not the multi-az is enabled.
- resource
Group stringName - 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 string - Administrator username for the managed instance. Can only be specified when the managed instance is being created (and is required for creation).
- administrator
Login stringPassword - The administrator login password (required for managed instance creation).
- administrators
Managed
Instance External Administrator - The Azure Active Directory administrator of the server.
- collation string
- Collation of the managed instance.
- dns
Zone stringPartner - The resource id of another managed instance whose DNS zone this managed instance will share after creation.
- identity
Resource
Identity - The Azure Active Directory identity of the managed instance.
- instance
Pool stringId - The Id of the instance pool this managed server belongs to.
- key
Id string - A CMK URI of the key to use for encryption.
- license
Type string | ManagedInstance License Type - 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.
- maintenance
Configuration stringId - Specifies maintenance configuration id to apply to this managed instance.
- managed
Instance string | ManagedCreate Mode Server Create Mode 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 stringName - The name of the managed instance.
- minimal
Tls stringVersion - Minimal TLS version. Allowed values: 'None', '1.0', '1.1', '1.2'
- primary
User stringAssigned Identity Id - The resource id of a user assigned identity to be used by default.
- proxy
Override string | ManagedInstance Proxy Override - Connection type used for connecting to the instance.
- public
Data booleanEndpoint Enabled - Whether or not the public data endpoint is enabled.
- restore
Point stringIn Time - Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.
- sku Sku
- Managed instance SKU. Allowed values for sku.name: GP_Gen4, GP_Gen5, BC_Gen4, BC_Gen5
- source
Managed stringInstance Id - The resource identifier of the source managed instance associated with create operation of this instance.
- storage
Account string | StorageType Account Type - The storage account type used to store backups for this instance. The options are LRS (LocallyRedundantStorage), ZRS (ZoneRedundantStorage) and GRS (GeoRedundantStorage)
- storage
Size numberIn GB - Storage size in GB. Minimum value: 32. Maximum value: 8192. Increments of 32 GB allowed only.
- subnet
Id string - Subnet resource ID for the managed instance.
- {[key: string]: string}
- Resource tags.
- timezone
Id 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".
- v
Cores number - The number of vCores. Allowed values: 8, 16, 24, 32, 40, 64, 80.
- zone
Redundant boolean - Whether or not the multi-az is enabled.
- resource_
group_ strname - 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_ strpassword - The administrator login password (required for managed instance creation).
- administrators
Managed
Instance External Administrator Args - The Azure Active Directory administrator of the server.
- collation str
- Collation of the managed instance.
- dns_
zone_ strpartner - The resource id of another managed instance whose DNS zone this managed instance will share after creation.
- identity
Resource
Identity Args - The Azure Active Directory identity of the managed instance.
- instance_
pool_ strid - 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 | ManagedInstance License Type - 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_ strid - Specifies maintenance configuration id to apply to this managed instance.
- managed_
instance_ str | Managedcreate_ mode Server Create Mode 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_ strname - The name of the managed instance.
- minimal_
tls_ strversion - Minimal TLS version. Allowed values: 'None', '1.0', '1.1', '1.2'
- primary_
user_ strassigned_ identity_ id - The resource id of a user assigned identity to be used by default.
- proxy_
override str | ManagedInstance Proxy Override - Connection type used for connecting to the instance.
- public_
data_ boolendpoint_ enabled - Whether or not the public data endpoint is enabled.
- restore_
point_ strin_ time - Specifies the point in time (ISO8601 format) of the source database that will be restored to create the new database.
- sku
Sku
Args - Managed instance SKU. Allowed values for sku.name: GP_Gen4, GP_Gen5, BC_Gen4, BC_Gen5
- source_
managed_ strinstance_ id - The resource identifier of the source managed instance associated with create operation of this instance.
- storage_
account_ str | Storagetype Account Type - The storage account type used to store backups for this instance. The options are LRS (LocallyRedundantStorage), ZRS (ZoneRedundantStorage) and GRS (GeoRedundantStorage)
- storage_
size_ intin_ gb - 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.
- 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.
- resource
Group StringName - 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 String - Administrator username for the managed instance. Can only be specified when the managed instance is being created (and is required for creation).
- administrator
Login StringPassword - 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.
- dns
Zone StringPartner - 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.
- instance
Pool StringId - The Id of the instance pool this managed server belongs to.
- key
Id String - A CMK URI of the key to use for encryption.
- license
Type String | "LicenseIncluded" | "Base Price" - 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.
- maintenance
Configuration StringId - Specifies maintenance configuration id to apply to this managed instance.
- managed
Instance String | "Default" | "PointCreate Mode In Time Restore" 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 StringName - The name of the managed instance.
- minimal
Tls StringVersion - Minimal TLS version. Allowed values: 'None', '1.0', '1.1', '1.2'
- primary
User StringAssigned Identity Id - The resource id of a user assigned identity to be used by default.
- proxy
Override String | "Proxy" | "Redirect" | "Default" - Connection type used for connecting to the instance.
- public
Data BooleanEndpoint Enabled - Whether or not the public data endpoint is enabled.
- restore
Point StringIn Time - 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
- source
Managed StringInstance Id - The resource identifier of the source managed instance associated with create operation of this instance.
- storage
Account String | "GRS" | "LRS" | "ZRS"Type - The storage account type used to store backups for this instance. The options are LRS (LocallyRedundantStorage), ZRS (ZoneRedundantStorage) and GRS (GeoRedundantStorage)
- storage
Size NumberIn GB - Storage size in GB. Minimum value: 32. Maximum value: 8192. Increments of 32 GB allowed only.
- subnet
Id String - Subnet resource ID for the managed instance.
- Map<String>
- Resource tags.
- timezone
Id 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".
- v
Cores Number - The number of vCores. Allowed values: 8, 16, 24, 32, 40, 64, 80.
- zone
Redundant 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:
- Dns
Zone string - The Dns Zone that the managed instance is in.
- Fully
Qualified stringDomain Name - The fully qualified domain name of the managed instance.
- Id string
- The provider-assigned unique ID for this managed resource.
- Name string
- Resource name.
- Private
Endpoint List<Pulumi.Connections Azure Native. Sql. Outputs. Managed Instance Pec Property Response> - List of private endpoint connections on a managed instance.
- Provisioning
State string - State string
- The state of the managed instance.
- Type string
- Resource type.
- Dns
Zone string - The Dns Zone that the managed instance is in.
- Fully
Qualified stringDomain Name - The fully qualified domain name of the managed instance.
- Id string
- The provider-assigned unique ID for this managed resource.
- Name string
- Resource name.
- Private
Endpoint []ManagedConnections Instance Pec Property Response - List of private endpoint connections on a managed instance.
- Provisioning
State string - State string
- The state of the managed instance.
- Type string
- Resource type.
- dns
Zone String - The Dns Zone that the managed instance is in.
- fully
Qualified StringDomain Name - The fully qualified domain name of the managed instance.
- id String
- The provider-assigned unique ID for this managed resource.
- name String
- Resource name.
- private
Endpoint List<ManagedConnections Instance Pec Property Response> - List of private endpoint connections on a managed instance.
- provisioning
State String - state String
- The state of the managed instance.
- type String
- Resource type.
- dns
Zone string - The Dns Zone that the managed instance is in.
- fully
Qualified stringDomain Name - The fully qualified domain name of the managed instance.
- id string
- The provider-assigned unique ID for this managed resource.
- name string
- Resource name.
- private
Endpoint ManagedConnections Instance Pec Property Response[] - List of private endpoint connections on a managed instance.
- provisioning
State 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_ strdomain_ name - 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_ Sequence[Managedconnections Instance Pec Property Response] - List of private endpoint connections on a managed instance.
- provisioning_
state str - state str
- The state of the managed instance.
- type str
- Resource type.
- dns
Zone String - The Dns Zone that the managed instance is in.
- fully
Qualified StringDomain Name - The fully qualified domain name of the managed instance.
- id String
- The provider-assigned unique ID for this managed resource.
- name String
- Resource name.
- private
Endpoint List<Property Map>Connections - List of private endpoint connections on a managed instance.
- provisioning
State String - state String
- The state of the managed instance.
- type String
- Resource type.
Supporting Types
AdministratorType, AdministratorTypeArgs
- Active
Directory - ActiveDirectory
- Administrator
Type Active Directory - ActiveDirectory
- Active
Directory - ActiveDirectory
- Active
Directory - ActiveDirectory
- ACTIVE_DIRECTORY
- ActiveDirectory
- "Active
Directory" - ActiveDirectory
IdentityType, IdentityTypeArgs
- None
- None
- System
Assigned - SystemAssigned
- User
Assigned - UserAssigned
- System
Assigned_User Assigned - SystemAssigned,UserAssigned
- Identity
Type None - None
- Identity
Type System Assigned - SystemAssigned
- Identity
Type User Assigned - UserAssigned
- Identity
Type_System Assigned_User Assigned - SystemAssigned,UserAssigned
- None
- None
- System
Assigned - SystemAssigned
- User
Assigned - UserAssigned
- System
Assigned_User Assigned - SystemAssigned,UserAssigned
- None
- None
- System
Assigned - SystemAssigned
- User
Assigned - UserAssigned
- System
Assigned_User Assigned - SystemAssigned,UserAssigned
- NONE
- None
- SYSTEM_ASSIGNED
- SystemAssigned
- USER_ASSIGNED
- UserAssigned
- SYSTEM_ASSIGNED_USER_ASSIGNED
- SystemAssigned,UserAssigned
- "None"
- None
- "System
Assigned" - SystemAssigned
- "User
Assigned" - UserAssigned
- "System
Assigned,User Assigned" - SystemAssigned,UserAssigned
ManagedInstanceExternalAdministrator, ManagedInstanceExternalAdministratorArgs
- Administrator
Type string | Pulumi.Azure Native. Sql. Administrator Type - Type of the sever administrator.
- Azure
ADOnly boolAuthentication - Azure Active Directory only Authentication enabled.
- Login string
- Login name of the server administrator.
- Principal
Type string | Pulumi.Azure Native. Sql. Principal Type - Principal Type of the sever administrator.
- Sid string
- SID (object ID) of the server administrator.
- Tenant
Id string - Tenant ID of the administrator.
- Administrator
Type string | AdministratorType - Type of the sever administrator.
- Azure
ADOnly boolAuthentication - Azure Active Directory only Authentication enabled.
- Login string
- Login name of the server administrator.
- Principal
Type string | PrincipalType - Principal Type of the sever administrator.
- Sid string
- SID (object ID) of the server administrator.
- Tenant
Id string - Tenant ID of the administrator.
- administrator
Type String | AdministratorType - Type of the sever administrator.
- azure
ADOnly BooleanAuthentication - Azure Active Directory only Authentication enabled.
- login String
- Login name of the server administrator.
- principal
Type String | PrincipalType - Principal Type of the sever administrator.
- sid String
- SID (object ID) of the server administrator.
- tenant
Id String - Tenant ID of the administrator.
- administrator
Type string | AdministratorType - Type of the sever administrator.
- azure
ADOnly booleanAuthentication - Azure Active Directory only Authentication enabled.
- login string
- Login name of the server administrator.
- principal
Type string | PrincipalType - Principal Type of the sever administrator.
- sid string
- SID (object ID) of the server administrator.
- tenant
Id string - Tenant ID of the administrator.
- administrator_
type str | AdministratorType - Type of the sever administrator.
- azure_
ad_ boolonly_ authentication - 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.
- administrator
Type String | "ActiveDirectory" - Type of the sever administrator.
- azure
ADOnly BooleanAuthentication - Azure Active Directory only Authentication enabled.
- login String
- Login name of the server administrator.
- principal
Type String | "User" | "Group" | "Application" - Principal Type of the sever administrator.
- sid String
- SID (object ID) of the server administrator.
- tenant
Id String - Tenant ID of the administrator.
ManagedInstanceExternalAdministratorResponse, ManagedInstanceExternalAdministratorResponseArgs
- Administrator
Type string - Type of the sever administrator.
- Azure
ADOnly boolAuthentication - Azure Active Directory only Authentication enabled.
- Login string
- Login name of the server administrator.
- Principal
Type string - Principal Type of the sever administrator.
- Sid string
- SID (object ID) of the server administrator.
- Tenant
Id string - Tenant ID of the administrator.
- Administrator
Type string - Type of the sever administrator.
- Azure
ADOnly boolAuthentication - Azure Active Directory only Authentication enabled.
- Login string
- Login name of the server administrator.
- Principal
Type string - Principal Type of the sever administrator.
- Sid string
- SID (object ID) of the server administrator.
- Tenant
Id string - Tenant ID of the administrator.
- administrator
Type String - Type of the sever administrator.
- azure
ADOnly BooleanAuthentication - Azure Active Directory only Authentication enabled.
- login String
- Login name of the server administrator.
- principal
Type String - Principal Type of the sever administrator.
- sid String
- SID (object ID) of the server administrator.
- tenant
Id String - Tenant ID of the administrator.
- administrator
Type string - Type of the sever administrator.
- azure
ADOnly booleanAuthentication - Azure Active Directory only Authentication enabled.
- login string
- Login name of the server administrator.
- principal
Type string - Principal Type of the sever administrator.
- sid string
- SID (object ID) of the server administrator.
- tenant
Id string - Tenant ID of the administrator.
- administrator_
type str - Type of the sever administrator.
- azure_
ad_ boolonly_ authentication - 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.
- administrator
Type String - Type of the sever administrator.
- azure
ADOnly BooleanAuthentication - Azure Active Directory only Authentication enabled.
- login String
- Login name of the server administrator.
- principal
Type String - Principal Type of the sever administrator.
- sid String
- SID (object ID) of the server administrator.
- tenant
Id String - Tenant ID of the administrator.
ManagedInstanceLicenseType, ManagedInstanceLicenseTypeArgs
- License
Included - LicenseIncluded
- Base
Price - BasePrice
- Managed
Instance License Type License Included - LicenseIncluded
- Managed
Instance License Type Base Price - BasePrice
- License
Included - LicenseIncluded
- Base
Price - BasePrice
- License
Included - LicenseIncluded
- Base
Price - BasePrice
- LICENSE_INCLUDED
- LicenseIncluded
- BASE_PRICE
- BasePrice
- "License
Included" - LicenseIncluded
- "Base
Price" - BasePrice
ManagedInstancePecPropertyResponse, ManagedInstancePecPropertyResponseArgs
- Id string
- Resource ID.
- Properties
Pulumi.
Azure Native. Sql. Inputs. Managed Instance Private Endpoint Connection Properties Response - Private endpoint connection properties
- Id string
- Resource ID.
- Properties
Managed
Instance Private Endpoint Connection Properties Response - Private endpoint connection properties
- id String
- Resource ID.
- properties
Managed
Instance Private Endpoint Connection Properties Response - Private endpoint connection properties
- id string
- Resource ID.
- properties
Managed
Instance Private Endpoint Connection Properties Response - Private endpoint connection properties
- id str
- Resource ID.
- properties
Managed
Instance Private Endpoint Connection Properties Response - Private endpoint connection properties
- id String
- Resource ID.
- properties Property Map
- Private endpoint connection properties
ManagedInstancePrivateEndpointConnectionPropertiesResponse, ManagedInstancePrivateEndpointConnectionPropertiesResponseArgs
- Provisioning
State string - State of the Private Endpoint Connection.
- Private
Endpoint Pulumi.Azure Native. Sql. Inputs. Managed Instance Private Endpoint Property Response - Private endpoint which the connection belongs to.
- Private
Link Pulumi.Service Connection State Azure Native. Sql. Inputs. Managed Instance Private Link Service Connection State Property Response - Connection State of the Private Endpoint Connection.
- Provisioning
State string - State of the Private Endpoint Connection.
- Private
Endpoint ManagedInstance Private Endpoint Property Response - Private endpoint which the connection belongs to.
- Private
Link ManagedService Connection State Instance Private Link Service Connection State Property Response - Connection State of the Private Endpoint Connection.
- provisioning
State String - State of the Private Endpoint Connection.
- private
Endpoint ManagedInstance Private Endpoint Property Response - Private endpoint which the connection belongs to.
- private
Link ManagedService Connection State Instance Private Link Service Connection State Property Response - Connection State of the Private Endpoint Connection.
- provisioning
State string - State of the Private Endpoint Connection.
- private
Endpoint ManagedInstance Private Endpoint Property Response - Private endpoint which the connection belongs to.
- private
Link ManagedService Connection State Instance Private Link Service Connection State Property Response - Connection State of the Private Endpoint Connection.
- provisioning_
state str - State of the Private Endpoint Connection.
- private_
endpoint ManagedInstance Private Endpoint Property Response - Private endpoint which the connection belongs to.
- private_
link_ Managedservice_ connection_ state Instance Private Link Service Connection State Property Response - Connection State of the Private Endpoint Connection.
- provisioning
State String - State of the Private Endpoint Connection.
- private
Endpoint Property Map - Private endpoint which the connection belongs to.
- private
Link Property MapService Connection State - 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
- Actions
Required 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 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 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 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.
- actions
Required 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
- Managed
Instance Proxy Override Proxy - Proxy
- Managed
Instance Proxy Override Redirect - Redirect
- Managed
Instance Proxy Override Default - 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
- Point
In Time Restore - PointInTimeRestore
- Managed
Server Create Mode Default - Default
- Managed
Server Create Mode Point In Time Restore - PointInTimeRestore
- Default
- Default
- Point
In Time Restore - PointInTimeRestore
- Default
- Default
- Point
In Time Restore - PointInTimeRestore
- DEFAULT
- Default
- POINT_IN_TIME_RESTORE
- PointInTimeRestore
- "Default"
- Default
- "Point
In Time Restore" - PointInTimeRestore
PrincipalType, PrincipalTypeArgs
- User
- User
- Group
- Group
- Application
- Application
- Principal
Type User - User
- Principal
Type Group - Group
- Principal
Type Application - 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.
Azure Native. Sql. Identity Type - The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
- User
Assigned Dictionary<string, object>Identities - The resource ids of the user assigned identities to use
- Type
string | Identity
Type - The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
- User
Assigned map[string]interface{}Identities - The resource ids of the user assigned identities to use
- type
String | Identity
Type - The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
- user
Assigned Map<String,Object>Identities - The resource ids of the user assigned identities to use
- type
string | Identity
Type - The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
- user
Assigned {[key: string]: any}Identities - The resource ids of the user assigned identities to use
- type
str | Identity
Type - The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
- user_
assigned_ Mapping[str, Any]identities - The resource ids of the user assigned identities to use
- type
String | "None" | "System
Assigned" | "User Assigned" | "System Assigned,User Assigned" - The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
- user
Assigned Map<Any>Identities - The resource ids of the user assigned identities to use
ResourceIdentityResponse, ResourceIdentityResponseArgs
- Principal
Id string - The Azure Active Directory principal id.
- Tenant
Id 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.
- User
Assigned Dictionary<string, Pulumi.Identities Azure Native. Sql. Inputs. User Identity Response> - The resource ids of the user assigned identities to use
- Principal
Id string - The Azure Active Directory principal id.
- Tenant
Id 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.
- User
Assigned map[string]UserIdentities Identity Response - The resource ids of the user assigned identities to use
- principal
Id String - The Azure Active Directory principal id.
- tenant
Id 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.
- user
Assigned Map<String,UserIdentities Identity Response> - The resource ids of the user assigned identities to use
- principal
Id string - The Azure Active Directory principal id.
- tenant
Id 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.
- user
Assigned {[key: string]: UserIdentities Identity Response} - 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_ Mapping[str, Useridentities Identity Response] - The resource ids of the user assigned identities to use
- principal
Id String - The Azure Active Directory principal id.
- tenant
Id 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.
- user
Assigned Map<Property Map>Identities - The resource ids of the user assigned identities to use
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.
StorageAccountType, StorageAccountTypeArgs
- GRS
- GRS
- LRS
- LRS
- ZRS
- ZRS
- Storage
Account Type GRS - GRS
- Storage
Account Type LRS - LRS
- Storage
Account Type ZRS - 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, UserIdentityResponseArgs
- Client
Id string - The Azure Active Directory client id.
- Principal
Id string - The Azure Active Directory principal id.
- Client
Id string - The Azure Active Directory client id.
- Principal
Id string - The Azure Active Directory principal id.
- client
Id String - The Azure Active Directory client id.
- principal
Id String - The Azure Active Directory principal id.
- client
Id string - The Azure Active Directory client id.
- principal
Id 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.
- client
Id String - The Azure Active Directory client id.
- principal
Id 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
To learn more about importing existing cloud resources, see Importing resources.
Package Details
- Repository
- azure-native-v1 pulumi/pulumi-azure-native
- License
- Apache-2.0