We recommend using Azure Native.
azure.mssql.ManagedInstance
Explore with Pulumi AI
Manages a Microsoft SQL Azure Managed Instance.
Note: All arguments including the administrator login and password will be stored in the raw state as plain-text. Read more about sensitive data in state.
Example Usage
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Azure = Pulumi.Azure;
return await Deployment.RunAsync(() =>
{
var exampleResourceGroup = new Azure.Core.ResourceGroup("exampleResourceGroup", new()
{
Location = "West Europe",
});
var exampleNetworkSecurityGroup = new Azure.Network.NetworkSecurityGroup("exampleNetworkSecurityGroup", new()
{
Location = exampleResourceGroup.Location,
ResourceGroupName = exampleResourceGroup.Name,
});
var allowManagementInbound = new Azure.Network.NetworkSecurityRule("allowManagementInbound", new()
{
Priority = 106,
Direction = "Inbound",
Access = "Allow",
Protocol = "Tcp",
SourcePortRange = "*",
DestinationPortRanges = new[]
{
"9000",
"9003",
"1438",
"1440",
"1452",
},
SourceAddressPrefix = "*",
DestinationAddressPrefix = "*",
ResourceGroupName = exampleResourceGroup.Name,
NetworkSecurityGroupName = exampleNetworkSecurityGroup.Name,
});
var allowMisubnetInbound = new Azure.Network.NetworkSecurityRule("allowMisubnetInbound", new()
{
Priority = 200,
Direction = "Inbound",
Access = "Allow",
Protocol = "*",
SourcePortRange = "*",
DestinationPortRange = "*",
SourceAddressPrefix = "10.0.0.0/24",
DestinationAddressPrefix = "*",
ResourceGroupName = exampleResourceGroup.Name,
NetworkSecurityGroupName = exampleNetworkSecurityGroup.Name,
});
var allowHealthProbeInbound = new Azure.Network.NetworkSecurityRule("allowHealthProbeInbound", new()
{
Priority = 300,
Direction = "Inbound",
Access = "Allow",
Protocol = "*",
SourcePortRange = "*",
DestinationPortRange = "*",
SourceAddressPrefix = "AzureLoadBalancer",
DestinationAddressPrefix = "*",
ResourceGroupName = exampleResourceGroup.Name,
NetworkSecurityGroupName = exampleNetworkSecurityGroup.Name,
});
var allowTdsInbound = new Azure.Network.NetworkSecurityRule("allowTdsInbound", new()
{
Priority = 1000,
Direction = "Inbound",
Access = "Allow",
Protocol = "Tcp",
SourcePortRange = "*",
DestinationPortRange = "1433",
SourceAddressPrefix = "VirtualNetwork",
DestinationAddressPrefix = "*",
ResourceGroupName = exampleResourceGroup.Name,
NetworkSecurityGroupName = exampleNetworkSecurityGroup.Name,
});
var denyAllInbound = new Azure.Network.NetworkSecurityRule("denyAllInbound", new()
{
Priority = 4096,
Direction = "Inbound",
Access = "Deny",
Protocol = "*",
SourcePortRange = "*",
DestinationPortRange = "*",
SourceAddressPrefix = "*",
DestinationAddressPrefix = "*",
ResourceGroupName = exampleResourceGroup.Name,
NetworkSecurityGroupName = exampleNetworkSecurityGroup.Name,
});
var allowManagementOutbound = new Azure.Network.NetworkSecurityRule("allowManagementOutbound", new()
{
Priority = 102,
Direction = "Outbound",
Access = "Allow",
Protocol = "Tcp",
SourcePortRange = "*",
DestinationPortRanges = new[]
{
"80",
"443",
"12000",
},
SourceAddressPrefix = "*",
DestinationAddressPrefix = "*",
ResourceGroupName = exampleResourceGroup.Name,
NetworkSecurityGroupName = exampleNetworkSecurityGroup.Name,
});
var allowMisubnetOutbound = new Azure.Network.NetworkSecurityRule("allowMisubnetOutbound", new()
{
Priority = 200,
Direction = "Outbound",
Access = "Allow",
Protocol = "*",
SourcePortRange = "*",
DestinationPortRange = "*",
SourceAddressPrefix = "10.0.0.0/24",
DestinationAddressPrefix = "*",
ResourceGroupName = exampleResourceGroup.Name,
NetworkSecurityGroupName = exampleNetworkSecurityGroup.Name,
});
var denyAllOutbound = new Azure.Network.NetworkSecurityRule("denyAllOutbound", new()
{
Priority = 4096,
Direction = "Outbound",
Access = "Deny",
Protocol = "*",
SourcePortRange = "*",
DestinationPortRange = "*",
SourceAddressPrefix = "*",
DestinationAddressPrefix = "*",
ResourceGroupName = exampleResourceGroup.Name,
NetworkSecurityGroupName = exampleNetworkSecurityGroup.Name,
});
var exampleVirtualNetwork = new Azure.Network.VirtualNetwork("exampleVirtualNetwork", new()
{
ResourceGroupName = exampleResourceGroup.Name,
AddressSpaces = new[]
{
"10.0.0.0/16",
},
Location = exampleResourceGroup.Location,
});
var exampleSubnet = new Azure.Network.Subnet("exampleSubnet", new()
{
ResourceGroupName = exampleResourceGroup.Name,
VirtualNetworkName = exampleVirtualNetwork.Name,
AddressPrefixes = new[]
{
"10.0.0.0/24",
},
Delegations = new[]
{
new Azure.Network.Inputs.SubnetDelegationArgs
{
Name = "managedinstancedelegation",
ServiceDelegation = new Azure.Network.Inputs.SubnetDelegationServiceDelegationArgs
{
Name = "Microsoft.Sql/managedInstances",
Actions = new[]
{
"Microsoft.Network/virtualNetworks/subnets/join/action",
"Microsoft.Network/virtualNetworks/subnets/prepareNetworkPolicies/action",
"Microsoft.Network/virtualNetworks/subnets/unprepareNetworkPolicies/action",
},
},
},
},
});
var exampleSubnetNetworkSecurityGroupAssociation = new Azure.Network.SubnetNetworkSecurityGroupAssociation("exampleSubnetNetworkSecurityGroupAssociation", new()
{
SubnetId = exampleSubnet.Id,
NetworkSecurityGroupId = exampleNetworkSecurityGroup.Id,
});
var exampleRouteTable = new Azure.Network.RouteTable("exampleRouteTable", new()
{
Location = exampleResourceGroup.Location,
ResourceGroupName = exampleResourceGroup.Name,
DisableBgpRoutePropagation = false,
}, new CustomResourceOptions
{
DependsOn = new[]
{
exampleSubnet,
},
});
var exampleSubnetRouteTableAssociation = new Azure.Network.SubnetRouteTableAssociation("exampleSubnetRouteTableAssociation", new()
{
SubnetId = exampleSubnet.Id,
RouteTableId = exampleRouteTable.Id,
});
var exampleManagedInstance = new Azure.MSSql.ManagedInstance("exampleManagedInstance", new()
{
ResourceGroupName = exampleResourceGroup.Name,
Location = exampleResourceGroup.Location,
LicenseType = "BasePrice",
SkuName = "GP_Gen5",
StorageSizeInGb = 32,
SubnetId = exampleSubnet.Id,
Vcores = 4,
AdministratorLogin = "mradministrator",
AdministratorLoginPassword = "thisIsDog11",
}, new CustomResourceOptions
{
DependsOn = new[]
{
exampleSubnetNetworkSecurityGroupAssociation,
exampleSubnetRouteTableAssociation,
},
});
});
package main
import (
"github.com/pulumi/pulumi-azure/sdk/v5/go/azure/core"
"github.com/pulumi/pulumi-azure/sdk/v5/go/azure/mssql"
"github.com/pulumi/pulumi-azure/sdk/v5/go/azure/network"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
exampleResourceGroup, err := core.NewResourceGroup(ctx, "exampleResourceGroup", &core.ResourceGroupArgs{
Location: pulumi.String("West Europe"),
})
if err != nil {
return err
}
exampleNetworkSecurityGroup, err := network.NewNetworkSecurityGroup(ctx, "exampleNetworkSecurityGroup", &network.NetworkSecurityGroupArgs{
Location: exampleResourceGroup.Location,
ResourceGroupName: exampleResourceGroup.Name,
})
if err != nil {
return err
}
_, err = network.NewNetworkSecurityRule(ctx, "allowManagementInbound", &network.NetworkSecurityRuleArgs{
Priority: pulumi.Int(106),
Direction: pulumi.String("Inbound"),
Access: pulumi.String("Allow"),
Protocol: pulumi.String("Tcp"),
SourcePortRange: pulumi.String("*"),
DestinationPortRanges: pulumi.StringArray{
pulumi.String("9000"),
pulumi.String("9003"),
pulumi.String("1438"),
pulumi.String("1440"),
pulumi.String("1452"),
},
SourceAddressPrefix: pulumi.String("*"),
DestinationAddressPrefix: pulumi.String("*"),
ResourceGroupName: exampleResourceGroup.Name,
NetworkSecurityGroupName: exampleNetworkSecurityGroup.Name,
})
if err != nil {
return err
}
_, err = network.NewNetworkSecurityRule(ctx, "allowMisubnetInbound", &network.NetworkSecurityRuleArgs{
Priority: pulumi.Int(200),
Direction: pulumi.String("Inbound"),
Access: pulumi.String("Allow"),
Protocol: pulumi.String("*"),
SourcePortRange: pulumi.String("*"),
DestinationPortRange: pulumi.String("*"),
SourceAddressPrefix: pulumi.String("10.0.0.0/24"),
DestinationAddressPrefix: pulumi.String("*"),
ResourceGroupName: exampleResourceGroup.Name,
NetworkSecurityGroupName: exampleNetworkSecurityGroup.Name,
})
if err != nil {
return err
}
_, err = network.NewNetworkSecurityRule(ctx, "allowHealthProbeInbound", &network.NetworkSecurityRuleArgs{
Priority: pulumi.Int(300),
Direction: pulumi.String("Inbound"),
Access: pulumi.String("Allow"),
Protocol: pulumi.String("*"),
SourcePortRange: pulumi.String("*"),
DestinationPortRange: pulumi.String("*"),
SourceAddressPrefix: pulumi.String("AzureLoadBalancer"),
DestinationAddressPrefix: pulumi.String("*"),
ResourceGroupName: exampleResourceGroup.Name,
NetworkSecurityGroupName: exampleNetworkSecurityGroup.Name,
})
if err != nil {
return err
}
_, err = network.NewNetworkSecurityRule(ctx, "allowTdsInbound", &network.NetworkSecurityRuleArgs{
Priority: pulumi.Int(1000),
Direction: pulumi.String("Inbound"),
Access: pulumi.String("Allow"),
Protocol: pulumi.String("Tcp"),
SourcePortRange: pulumi.String("*"),
DestinationPortRange: pulumi.String("1433"),
SourceAddressPrefix: pulumi.String("VirtualNetwork"),
DestinationAddressPrefix: pulumi.String("*"),
ResourceGroupName: exampleResourceGroup.Name,
NetworkSecurityGroupName: exampleNetworkSecurityGroup.Name,
})
if err != nil {
return err
}
_, err = network.NewNetworkSecurityRule(ctx, "denyAllInbound", &network.NetworkSecurityRuleArgs{
Priority: pulumi.Int(4096),
Direction: pulumi.String("Inbound"),
Access: pulumi.String("Deny"),
Protocol: pulumi.String("*"),
SourcePortRange: pulumi.String("*"),
DestinationPortRange: pulumi.String("*"),
SourceAddressPrefix: pulumi.String("*"),
DestinationAddressPrefix: pulumi.String("*"),
ResourceGroupName: exampleResourceGroup.Name,
NetworkSecurityGroupName: exampleNetworkSecurityGroup.Name,
})
if err != nil {
return err
}
_, err = network.NewNetworkSecurityRule(ctx, "allowManagementOutbound", &network.NetworkSecurityRuleArgs{
Priority: pulumi.Int(102),
Direction: pulumi.String("Outbound"),
Access: pulumi.String("Allow"),
Protocol: pulumi.String("Tcp"),
SourcePortRange: pulumi.String("*"),
DestinationPortRanges: pulumi.StringArray{
pulumi.String("80"),
pulumi.String("443"),
pulumi.String("12000"),
},
SourceAddressPrefix: pulumi.String("*"),
DestinationAddressPrefix: pulumi.String("*"),
ResourceGroupName: exampleResourceGroup.Name,
NetworkSecurityGroupName: exampleNetworkSecurityGroup.Name,
})
if err != nil {
return err
}
_, err = network.NewNetworkSecurityRule(ctx, "allowMisubnetOutbound", &network.NetworkSecurityRuleArgs{
Priority: pulumi.Int(200),
Direction: pulumi.String("Outbound"),
Access: pulumi.String("Allow"),
Protocol: pulumi.String("*"),
SourcePortRange: pulumi.String("*"),
DestinationPortRange: pulumi.String("*"),
SourceAddressPrefix: pulumi.String("10.0.0.0/24"),
DestinationAddressPrefix: pulumi.String("*"),
ResourceGroupName: exampleResourceGroup.Name,
NetworkSecurityGroupName: exampleNetworkSecurityGroup.Name,
})
if err != nil {
return err
}
_, err = network.NewNetworkSecurityRule(ctx, "denyAllOutbound", &network.NetworkSecurityRuleArgs{
Priority: pulumi.Int(4096),
Direction: pulumi.String("Outbound"),
Access: pulumi.String("Deny"),
Protocol: pulumi.String("*"),
SourcePortRange: pulumi.String("*"),
DestinationPortRange: pulumi.String("*"),
SourceAddressPrefix: pulumi.String("*"),
DestinationAddressPrefix: pulumi.String("*"),
ResourceGroupName: exampleResourceGroup.Name,
NetworkSecurityGroupName: exampleNetworkSecurityGroup.Name,
})
if err != nil {
return err
}
exampleVirtualNetwork, err := network.NewVirtualNetwork(ctx, "exampleVirtualNetwork", &network.VirtualNetworkArgs{
ResourceGroupName: exampleResourceGroup.Name,
AddressSpaces: pulumi.StringArray{
pulumi.String("10.0.0.0/16"),
},
Location: exampleResourceGroup.Location,
})
if err != nil {
return err
}
exampleSubnet, err := network.NewSubnet(ctx, "exampleSubnet", &network.SubnetArgs{
ResourceGroupName: exampleResourceGroup.Name,
VirtualNetworkName: exampleVirtualNetwork.Name,
AddressPrefixes: pulumi.StringArray{
pulumi.String("10.0.0.0/24"),
},
Delegations: network.SubnetDelegationArray{
&network.SubnetDelegationArgs{
Name: pulumi.String("managedinstancedelegation"),
ServiceDelegation: &network.SubnetDelegationServiceDelegationArgs{
Name: pulumi.String("Microsoft.Sql/managedInstances"),
Actions: pulumi.StringArray{
pulumi.String("Microsoft.Network/virtualNetworks/subnets/join/action"),
pulumi.String("Microsoft.Network/virtualNetworks/subnets/prepareNetworkPolicies/action"),
pulumi.String("Microsoft.Network/virtualNetworks/subnets/unprepareNetworkPolicies/action"),
},
},
},
},
})
if err != nil {
return err
}
exampleSubnetNetworkSecurityGroupAssociation, err := network.NewSubnetNetworkSecurityGroupAssociation(ctx, "exampleSubnetNetworkSecurityGroupAssociation", &network.SubnetNetworkSecurityGroupAssociationArgs{
SubnetId: exampleSubnet.ID(),
NetworkSecurityGroupId: exampleNetworkSecurityGroup.ID(),
})
if err != nil {
return err
}
exampleRouteTable, err := network.NewRouteTable(ctx, "exampleRouteTable", &network.RouteTableArgs{
Location: exampleResourceGroup.Location,
ResourceGroupName: exampleResourceGroup.Name,
DisableBgpRoutePropagation: pulumi.Bool(false),
}, pulumi.DependsOn([]pulumi.Resource{
exampleSubnet,
}))
if err != nil {
return err
}
exampleSubnetRouteTableAssociation, err := network.NewSubnetRouteTableAssociation(ctx, "exampleSubnetRouteTableAssociation", &network.SubnetRouteTableAssociationArgs{
SubnetId: exampleSubnet.ID(),
RouteTableId: exampleRouteTable.ID(),
})
if err != nil {
return err
}
_, err = mssql.NewManagedInstance(ctx, "exampleManagedInstance", &mssql.ManagedInstanceArgs{
ResourceGroupName: exampleResourceGroup.Name,
Location: exampleResourceGroup.Location,
LicenseType: pulumi.String("BasePrice"),
SkuName: pulumi.String("GP_Gen5"),
StorageSizeInGb: pulumi.Int(32),
SubnetId: exampleSubnet.ID(),
Vcores: pulumi.Int(4),
AdministratorLogin: pulumi.String("mradministrator"),
AdministratorLoginPassword: pulumi.String("thisIsDog11"),
}, pulumi.DependsOn([]pulumi.Resource{
exampleSubnetNetworkSecurityGroupAssociation,
exampleSubnetRouteTableAssociation,
}))
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.azure.core.ResourceGroup;
import com.pulumi.azure.core.ResourceGroupArgs;
import com.pulumi.azure.network.NetworkSecurityGroup;
import com.pulumi.azure.network.NetworkSecurityGroupArgs;
import com.pulumi.azure.network.NetworkSecurityRule;
import com.pulumi.azure.network.NetworkSecurityRuleArgs;
import com.pulumi.azure.network.VirtualNetwork;
import com.pulumi.azure.network.VirtualNetworkArgs;
import com.pulumi.azure.network.Subnet;
import com.pulumi.azure.network.SubnetArgs;
import com.pulumi.azure.network.inputs.SubnetDelegationArgs;
import com.pulumi.azure.network.inputs.SubnetDelegationServiceDelegationArgs;
import com.pulumi.azure.network.SubnetNetworkSecurityGroupAssociation;
import com.pulumi.azure.network.SubnetNetworkSecurityGroupAssociationArgs;
import com.pulumi.azure.network.RouteTable;
import com.pulumi.azure.network.RouteTableArgs;
import com.pulumi.azure.network.SubnetRouteTableAssociation;
import com.pulumi.azure.network.SubnetRouteTableAssociationArgs;
import com.pulumi.azure.mssql.ManagedInstance;
import com.pulumi.azure.mssql.ManagedInstanceArgs;
import com.pulumi.resources.CustomResourceOptions;
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 exampleResourceGroup = new ResourceGroup("exampleResourceGroup", ResourceGroupArgs.builder()
.location("West Europe")
.build());
var exampleNetworkSecurityGroup = new NetworkSecurityGroup("exampleNetworkSecurityGroup", NetworkSecurityGroupArgs.builder()
.location(exampleResourceGroup.location())
.resourceGroupName(exampleResourceGroup.name())
.build());
var allowManagementInbound = new NetworkSecurityRule("allowManagementInbound", NetworkSecurityRuleArgs.builder()
.priority(106)
.direction("Inbound")
.access("Allow")
.protocol("Tcp")
.sourcePortRange("*")
.destinationPortRanges(
"9000",
"9003",
"1438",
"1440",
"1452")
.sourceAddressPrefix("*")
.destinationAddressPrefix("*")
.resourceGroupName(exampleResourceGroup.name())
.networkSecurityGroupName(exampleNetworkSecurityGroup.name())
.build());
var allowMisubnetInbound = new NetworkSecurityRule("allowMisubnetInbound", NetworkSecurityRuleArgs.builder()
.priority(200)
.direction("Inbound")
.access("Allow")
.protocol("*")
.sourcePortRange("*")
.destinationPortRange("*")
.sourceAddressPrefix("10.0.0.0/24")
.destinationAddressPrefix("*")
.resourceGroupName(exampleResourceGroup.name())
.networkSecurityGroupName(exampleNetworkSecurityGroup.name())
.build());
var allowHealthProbeInbound = new NetworkSecurityRule("allowHealthProbeInbound", NetworkSecurityRuleArgs.builder()
.priority(300)
.direction("Inbound")
.access("Allow")
.protocol("*")
.sourcePortRange("*")
.destinationPortRange("*")
.sourceAddressPrefix("AzureLoadBalancer")
.destinationAddressPrefix("*")
.resourceGroupName(exampleResourceGroup.name())
.networkSecurityGroupName(exampleNetworkSecurityGroup.name())
.build());
var allowTdsInbound = new NetworkSecurityRule("allowTdsInbound", NetworkSecurityRuleArgs.builder()
.priority(1000)
.direction("Inbound")
.access("Allow")
.protocol("Tcp")
.sourcePortRange("*")
.destinationPortRange("1433")
.sourceAddressPrefix("VirtualNetwork")
.destinationAddressPrefix("*")
.resourceGroupName(exampleResourceGroup.name())
.networkSecurityGroupName(exampleNetworkSecurityGroup.name())
.build());
var denyAllInbound = new NetworkSecurityRule("denyAllInbound", NetworkSecurityRuleArgs.builder()
.priority(4096)
.direction("Inbound")
.access("Deny")
.protocol("*")
.sourcePortRange("*")
.destinationPortRange("*")
.sourceAddressPrefix("*")
.destinationAddressPrefix("*")
.resourceGroupName(exampleResourceGroup.name())
.networkSecurityGroupName(exampleNetworkSecurityGroup.name())
.build());
var allowManagementOutbound = new NetworkSecurityRule("allowManagementOutbound", NetworkSecurityRuleArgs.builder()
.priority(102)
.direction("Outbound")
.access("Allow")
.protocol("Tcp")
.sourcePortRange("*")
.destinationPortRanges(
"80",
"443",
"12000")
.sourceAddressPrefix("*")
.destinationAddressPrefix("*")
.resourceGroupName(exampleResourceGroup.name())
.networkSecurityGroupName(exampleNetworkSecurityGroup.name())
.build());
var allowMisubnetOutbound = new NetworkSecurityRule("allowMisubnetOutbound", NetworkSecurityRuleArgs.builder()
.priority(200)
.direction("Outbound")
.access("Allow")
.protocol("*")
.sourcePortRange("*")
.destinationPortRange("*")
.sourceAddressPrefix("10.0.0.0/24")
.destinationAddressPrefix("*")
.resourceGroupName(exampleResourceGroup.name())
.networkSecurityGroupName(exampleNetworkSecurityGroup.name())
.build());
var denyAllOutbound = new NetworkSecurityRule("denyAllOutbound", NetworkSecurityRuleArgs.builder()
.priority(4096)
.direction("Outbound")
.access("Deny")
.protocol("*")
.sourcePortRange("*")
.destinationPortRange("*")
.sourceAddressPrefix("*")
.destinationAddressPrefix("*")
.resourceGroupName(exampleResourceGroup.name())
.networkSecurityGroupName(exampleNetworkSecurityGroup.name())
.build());
var exampleVirtualNetwork = new VirtualNetwork("exampleVirtualNetwork", VirtualNetworkArgs.builder()
.resourceGroupName(exampleResourceGroup.name())
.addressSpaces("10.0.0.0/16")
.location(exampleResourceGroup.location())
.build());
var exampleSubnet = new Subnet("exampleSubnet", SubnetArgs.builder()
.resourceGroupName(exampleResourceGroup.name())
.virtualNetworkName(exampleVirtualNetwork.name())
.addressPrefixes("10.0.0.0/24")
.delegations(SubnetDelegationArgs.builder()
.name("managedinstancedelegation")
.serviceDelegation(SubnetDelegationServiceDelegationArgs.builder()
.name("Microsoft.Sql/managedInstances")
.actions(
"Microsoft.Network/virtualNetworks/subnets/join/action",
"Microsoft.Network/virtualNetworks/subnets/prepareNetworkPolicies/action",
"Microsoft.Network/virtualNetworks/subnets/unprepareNetworkPolicies/action")
.build())
.build())
.build());
var exampleSubnetNetworkSecurityGroupAssociation = new SubnetNetworkSecurityGroupAssociation("exampleSubnetNetworkSecurityGroupAssociation", SubnetNetworkSecurityGroupAssociationArgs.builder()
.subnetId(exampleSubnet.id())
.networkSecurityGroupId(exampleNetworkSecurityGroup.id())
.build());
var exampleRouteTable = new RouteTable("exampleRouteTable", RouteTableArgs.builder()
.location(exampleResourceGroup.location())
.resourceGroupName(exampleResourceGroup.name())
.disableBgpRoutePropagation(false)
.build(), CustomResourceOptions.builder()
.dependsOn(exampleSubnet)
.build());
var exampleSubnetRouteTableAssociation = new SubnetRouteTableAssociation("exampleSubnetRouteTableAssociation", SubnetRouteTableAssociationArgs.builder()
.subnetId(exampleSubnet.id())
.routeTableId(exampleRouteTable.id())
.build());
var exampleManagedInstance = new ManagedInstance("exampleManagedInstance", ManagedInstanceArgs.builder()
.resourceGroupName(exampleResourceGroup.name())
.location(exampleResourceGroup.location())
.licenseType("BasePrice")
.skuName("GP_Gen5")
.storageSizeInGb(32)
.subnetId(exampleSubnet.id())
.vcores(4)
.administratorLogin("mradministrator")
.administratorLoginPassword("thisIsDog11")
.build(), CustomResourceOptions.builder()
.dependsOn(
exampleSubnetNetworkSecurityGroupAssociation,
exampleSubnetRouteTableAssociation)
.build());
}
}
import pulumi
import pulumi_azure as azure
example_resource_group = azure.core.ResourceGroup("exampleResourceGroup", location="West Europe")
example_network_security_group = azure.network.NetworkSecurityGroup("exampleNetworkSecurityGroup",
location=example_resource_group.location,
resource_group_name=example_resource_group.name)
allow_management_inbound = azure.network.NetworkSecurityRule("allowManagementInbound",
priority=106,
direction="Inbound",
access="Allow",
protocol="Tcp",
source_port_range="*",
destination_port_ranges=[
"9000",
"9003",
"1438",
"1440",
"1452",
],
source_address_prefix="*",
destination_address_prefix="*",
resource_group_name=example_resource_group.name,
network_security_group_name=example_network_security_group.name)
allow_misubnet_inbound = azure.network.NetworkSecurityRule("allowMisubnetInbound",
priority=200,
direction="Inbound",
access="Allow",
protocol="*",
source_port_range="*",
destination_port_range="*",
source_address_prefix="10.0.0.0/24",
destination_address_prefix="*",
resource_group_name=example_resource_group.name,
network_security_group_name=example_network_security_group.name)
allow_health_probe_inbound = azure.network.NetworkSecurityRule("allowHealthProbeInbound",
priority=300,
direction="Inbound",
access="Allow",
protocol="*",
source_port_range="*",
destination_port_range="*",
source_address_prefix="AzureLoadBalancer",
destination_address_prefix="*",
resource_group_name=example_resource_group.name,
network_security_group_name=example_network_security_group.name)
allow_tds_inbound = azure.network.NetworkSecurityRule("allowTdsInbound",
priority=1000,
direction="Inbound",
access="Allow",
protocol="Tcp",
source_port_range="*",
destination_port_range="1433",
source_address_prefix="VirtualNetwork",
destination_address_prefix="*",
resource_group_name=example_resource_group.name,
network_security_group_name=example_network_security_group.name)
deny_all_inbound = azure.network.NetworkSecurityRule("denyAllInbound",
priority=4096,
direction="Inbound",
access="Deny",
protocol="*",
source_port_range="*",
destination_port_range="*",
source_address_prefix="*",
destination_address_prefix="*",
resource_group_name=example_resource_group.name,
network_security_group_name=example_network_security_group.name)
allow_management_outbound = azure.network.NetworkSecurityRule("allowManagementOutbound",
priority=102,
direction="Outbound",
access="Allow",
protocol="Tcp",
source_port_range="*",
destination_port_ranges=[
"80",
"443",
"12000",
],
source_address_prefix="*",
destination_address_prefix="*",
resource_group_name=example_resource_group.name,
network_security_group_name=example_network_security_group.name)
allow_misubnet_outbound = azure.network.NetworkSecurityRule("allowMisubnetOutbound",
priority=200,
direction="Outbound",
access="Allow",
protocol="*",
source_port_range="*",
destination_port_range="*",
source_address_prefix="10.0.0.0/24",
destination_address_prefix="*",
resource_group_name=example_resource_group.name,
network_security_group_name=example_network_security_group.name)
deny_all_outbound = azure.network.NetworkSecurityRule("denyAllOutbound",
priority=4096,
direction="Outbound",
access="Deny",
protocol="*",
source_port_range="*",
destination_port_range="*",
source_address_prefix="*",
destination_address_prefix="*",
resource_group_name=example_resource_group.name,
network_security_group_name=example_network_security_group.name)
example_virtual_network = azure.network.VirtualNetwork("exampleVirtualNetwork",
resource_group_name=example_resource_group.name,
address_spaces=["10.0.0.0/16"],
location=example_resource_group.location)
example_subnet = azure.network.Subnet("exampleSubnet",
resource_group_name=example_resource_group.name,
virtual_network_name=example_virtual_network.name,
address_prefixes=["10.0.0.0/24"],
delegations=[azure.network.SubnetDelegationArgs(
name="managedinstancedelegation",
service_delegation=azure.network.SubnetDelegationServiceDelegationArgs(
name="Microsoft.Sql/managedInstances",
actions=[
"Microsoft.Network/virtualNetworks/subnets/join/action",
"Microsoft.Network/virtualNetworks/subnets/prepareNetworkPolicies/action",
"Microsoft.Network/virtualNetworks/subnets/unprepareNetworkPolicies/action",
],
),
)])
example_subnet_network_security_group_association = azure.network.SubnetNetworkSecurityGroupAssociation("exampleSubnetNetworkSecurityGroupAssociation",
subnet_id=example_subnet.id,
network_security_group_id=example_network_security_group.id)
example_route_table = azure.network.RouteTable("exampleRouteTable",
location=example_resource_group.location,
resource_group_name=example_resource_group.name,
disable_bgp_route_propagation=False,
opts=pulumi.ResourceOptions(depends_on=[example_subnet]))
example_subnet_route_table_association = azure.network.SubnetRouteTableAssociation("exampleSubnetRouteTableAssociation",
subnet_id=example_subnet.id,
route_table_id=example_route_table.id)
example_managed_instance = azure.mssql.ManagedInstance("exampleManagedInstance",
resource_group_name=example_resource_group.name,
location=example_resource_group.location,
license_type="BasePrice",
sku_name="GP_Gen5",
storage_size_in_gb=32,
subnet_id=example_subnet.id,
vcores=4,
administrator_login="mradministrator",
administrator_login_password="thisIsDog11",
opts=pulumi.ResourceOptions(depends_on=[
example_subnet_network_security_group_association,
example_subnet_route_table_association,
]))
import * as pulumi from "@pulumi/pulumi";
import * as azure from "@pulumi/azure";
const exampleResourceGroup = new azure.core.ResourceGroup("exampleResourceGroup", {location: "West Europe"});
const exampleNetworkSecurityGroup = new azure.network.NetworkSecurityGroup("exampleNetworkSecurityGroup", {
location: exampleResourceGroup.location,
resourceGroupName: exampleResourceGroup.name,
});
const allowManagementInbound = new azure.network.NetworkSecurityRule("allowManagementInbound", {
priority: 106,
direction: "Inbound",
access: "Allow",
protocol: "Tcp",
sourcePortRange: "*",
destinationPortRanges: [
"9000",
"9003",
"1438",
"1440",
"1452",
],
sourceAddressPrefix: "*",
destinationAddressPrefix: "*",
resourceGroupName: exampleResourceGroup.name,
networkSecurityGroupName: exampleNetworkSecurityGroup.name,
});
const allowMisubnetInbound = new azure.network.NetworkSecurityRule("allowMisubnetInbound", {
priority: 200,
direction: "Inbound",
access: "Allow",
protocol: "*",
sourcePortRange: "*",
destinationPortRange: "*",
sourceAddressPrefix: "10.0.0.0/24",
destinationAddressPrefix: "*",
resourceGroupName: exampleResourceGroup.name,
networkSecurityGroupName: exampleNetworkSecurityGroup.name,
});
const allowHealthProbeInbound = new azure.network.NetworkSecurityRule("allowHealthProbeInbound", {
priority: 300,
direction: "Inbound",
access: "Allow",
protocol: "*",
sourcePortRange: "*",
destinationPortRange: "*",
sourceAddressPrefix: "AzureLoadBalancer",
destinationAddressPrefix: "*",
resourceGroupName: exampleResourceGroup.name,
networkSecurityGroupName: exampleNetworkSecurityGroup.name,
});
const allowTdsInbound = new azure.network.NetworkSecurityRule("allowTdsInbound", {
priority: 1000,
direction: "Inbound",
access: "Allow",
protocol: "Tcp",
sourcePortRange: "*",
destinationPortRange: "1433",
sourceAddressPrefix: "VirtualNetwork",
destinationAddressPrefix: "*",
resourceGroupName: exampleResourceGroup.name,
networkSecurityGroupName: exampleNetworkSecurityGroup.name,
});
const denyAllInbound = new azure.network.NetworkSecurityRule("denyAllInbound", {
priority: 4096,
direction: "Inbound",
access: "Deny",
protocol: "*",
sourcePortRange: "*",
destinationPortRange: "*",
sourceAddressPrefix: "*",
destinationAddressPrefix: "*",
resourceGroupName: exampleResourceGroup.name,
networkSecurityGroupName: exampleNetworkSecurityGroup.name,
});
const allowManagementOutbound = new azure.network.NetworkSecurityRule("allowManagementOutbound", {
priority: 102,
direction: "Outbound",
access: "Allow",
protocol: "Tcp",
sourcePortRange: "*",
destinationPortRanges: [
"80",
"443",
"12000",
],
sourceAddressPrefix: "*",
destinationAddressPrefix: "*",
resourceGroupName: exampleResourceGroup.name,
networkSecurityGroupName: exampleNetworkSecurityGroup.name,
});
const allowMisubnetOutbound = new azure.network.NetworkSecurityRule("allowMisubnetOutbound", {
priority: 200,
direction: "Outbound",
access: "Allow",
protocol: "*",
sourcePortRange: "*",
destinationPortRange: "*",
sourceAddressPrefix: "10.0.0.0/24",
destinationAddressPrefix: "*",
resourceGroupName: exampleResourceGroup.name,
networkSecurityGroupName: exampleNetworkSecurityGroup.name,
});
const denyAllOutbound = new azure.network.NetworkSecurityRule("denyAllOutbound", {
priority: 4096,
direction: "Outbound",
access: "Deny",
protocol: "*",
sourcePortRange: "*",
destinationPortRange: "*",
sourceAddressPrefix: "*",
destinationAddressPrefix: "*",
resourceGroupName: exampleResourceGroup.name,
networkSecurityGroupName: exampleNetworkSecurityGroup.name,
});
const exampleVirtualNetwork = new azure.network.VirtualNetwork("exampleVirtualNetwork", {
resourceGroupName: exampleResourceGroup.name,
addressSpaces: ["10.0.0.0/16"],
location: exampleResourceGroup.location,
});
const exampleSubnet = new azure.network.Subnet("exampleSubnet", {
resourceGroupName: exampleResourceGroup.name,
virtualNetworkName: exampleVirtualNetwork.name,
addressPrefixes: ["10.0.0.0/24"],
delegations: [{
name: "managedinstancedelegation",
serviceDelegation: {
name: "Microsoft.Sql/managedInstances",
actions: [
"Microsoft.Network/virtualNetworks/subnets/join/action",
"Microsoft.Network/virtualNetworks/subnets/prepareNetworkPolicies/action",
"Microsoft.Network/virtualNetworks/subnets/unprepareNetworkPolicies/action",
],
},
}],
});
const exampleSubnetNetworkSecurityGroupAssociation = new azure.network.SubnetNetworkSecurityGroupAssociation("exampleSubnetNetworkSecurityGroupAssociation", {
subnetId: exampleSubnet.id,
networkSecurityGroupId: exampleNetworkSecurityGroup.id,
});
const exampleRouteTable = new azure.network.RouteTable("exampleRouteTable", {
location: exampleResourceGroup.location,
resourceGroupName: exampleResourceGroup.name,
disableBgpRoutePropagation: false,
}, {
dependsOn: [exampleSubnet],
});
const exampleSubnetRouteTableAssociation = new azure.network.SubnetRouteTableAssociation("exampleSubnetRouteTableAssociation", {
subnetId: exampleSubnet.id,
routeTableId: exampleRouteTable.id,
});
const exampleManagedInstance = new azure.mssql.ManagedInstance("exampleManagedInstance", {
resourceGroupName: exampleResourceGroup.name,
location: exampleResourceGroup.location,
licenseType: "BasePrice",
skuName: "GP_Gen5",
storageSizeInGb: 32,
subnetId: exampleSubnet.id,
vcores: 4,
administratorLogin: "mradministrator",
administratorLoginPassword: "thisIsDog11",
}, {
dependsOn: [
exampleSubnetNetworkSecurityGroupAssociation,
exampleSubnetRouteTableAssociation,
],
});
resources:
exampleResourceGroup:
type: azure:core:ResourceGroup
properties:
location: West Europe
exampleNetworkSecurityGroup:
type: azure:network:NetworkSecurityGroup
properties:
location: ${exampleResourceGroup.location}
resourceGroupName: ${exampleResourceGroup.name}
allowManagementInbound:
type: azure:network:NetworkSecurityRule
properties:
priority: 106
direction: Inbound
access: Allow
protocol: Tcp
sourcePortRange: '*'
destinationPortRanges:
- '9000'
- '9003'
- '1438'
- '1440'
- '1452'
sourceAddressPrefix: '*'
destinationAddressPrefix: '*'
resourceGroupName: ${exampleResourceGroup.name}
networkSecurityGroupName: ${exampleNetworkSecurityGroup.name}
allowMisubnetInbound:
type: azure:network:NetworkSecurityRule
properties:
priority: 200
direction: Inbound
access: Allow
protocol: '*'
sourcePortRange: '*'
destinationPortRange: '*'
sourceAddressPrefix: 10.0.0.0/24
destinationAddressPrefix: '*'
resourceGroupName: ${exampleResourceGroup.name}
networkSecurityGroupName: ${exampleNetworkSecurityGroup.name}
allowHealthProbeInbound:
type: azure:network:NetworkSecurityRule
properties:
priority: 300
direction: Inbound
access: Allow
protocol: '*'
sourcePortRange: '*'
destinationPortRange: '*'
sourceAddressPrefix: AzureLoadBalancer
destinationAddressPrefix: '*'
resourceGroupName: ${exampleResourceGroup.name}
networkSecurityGroupName: ${exampleNetworkSecurityGroup.name}
allowTdsInbound:
type: azure:network:NetworkSecurityRule
properties:
priority: 1000
direction: Inbound
access: Allow
protocol: Tcp
sourcePortRange: '*'
destinationPortRange: '1433'
sourceAddressPrefix: VirtualNetwork
destinationAddressPrefix: '*'
resourceGroupName: ${exampleResourceGroup.name}
networkSecurityGroupName: ${exampleNetworkSecurityGroup.name}
denyAllInbound:
type: azure:network:NetworkSecurityRule
properties:
priority: 4096
direction: Inbound
access: Deny
protocol: '*'
sourcePortRange: '*'
destinationPortRange: '*'
sourceAddressPrefix: '*'
destinationAddressPrefix: '*'
resourceGroupName: ${exampleResourceGroup.name}
networkSecurityGroupName: ${exampleNetworkSecurityGroup.name}
allowManagementOutbound:
type: azure:network:NetworkSecurityRule
properties:
priority: 102
direction: Outbound
access: Allow
protocol: Tcp
sourcePortRange: '*'
destinationPortRanges:
- '80'
- '443'
- '12000'
sourceAddressPrefix: '*'
destinationAddressPrefix: '*'
resourceGroupName: ${exampleResourceGroup.name}
networkSecurityGroupName: ${exampleNetworkSecurityGroup.name}
allowMisubnetOutbound:
type: azure:network:NetworkSecurityRule
properties:
priority: 200
direction: Outbound
access: Allow
protocol: '*'
sourcePortRange: '*'
destinationPortRange: '*'
sourceAddressPrefix: 10.0.0.0/24
destinationAddressPrefix: '*'
resourceGroupName: ${exampleResourceGroup.name}
networkSecurityGroupName: ${exampleNetworkSecurityGroup.name}
denyAllOutbound:
type: azure:network:NetworkSecurityRule
properties:
priority: 4096
direction: Outbound
access: Deny
protocol: '*'
sourcePortRange: '*'
destinationPortRange: '*'
sourceAddressPrefix: '*'
destinationAddressPrefix: '*'
resourceGroupName: ${exampleResourceGroup.name}
networkSecurityGroupName: ${exampleNetworkSecurityGroup.name}
exampleVirtualNetwork:
type: azure:network:VirtualNetwork
properties:
resourceGroupName: ${exampleResourceGroup.name}
addressSpaces:
- 10.0.0.0/16
location: ${exampleResourceGroup.location}
exampleSubnet:
type: azure:network:Subnet
properties:
resourceGroupName: ${exampleResourceGroup.name}
virtualNetworkName: ${exampleVirtualNetwork.name}
addressPrefixes:
- 10.0.0.0/24
delegations:
- name: managedinstancedelegation
serviceDelegation:
name: Microsoft.Sql/managedInstances
actions:
- Microsoft.Network/virtualNetworks/subnets/join/action
- Microsoft.Network/virtualNetworks/subnets/prepareNetworkPolicies/action
- Microsoft.Network/virtualNetworks/subnets/unprepareNetworkPolicies/action
exampleSubnetNetworkSecurityGroupAssociation:
type: azure:network:SubnetNetworkSecurityGroupAssociation
properties:
subnetId: ${exampleSubnet.id}
networkSecurityGroupId: ${exampleNetworkSecurityGroup.id}
exampleRouteTable:
type: azure:network:RouteTable
properties:
location: ${exampleResourceGroup.location}
resourceGroupName: ${exampleResourceGroup.name}
disableBgpRoutePropagation: false
options:
dependson:
- ${exampleSubnet}
exampleSubnetRouteTableAssociation:
type: azure:network:SubnetRouteTableAssociation
properties:
subnetId: ${exampleSubnet.id}
routeTableId: ${exampleRouteTable.id}
exampleManagedInstance:
type: azure:mssql:ManagedInstance
properties:
resourceGroupName: ${exampleResourceGroup.name}
location: ${exampleResourceGroup.location}
licenseType: BasePrice
skuName: GP_Gen5
storageSizeInGb: 32
subnetId: ${exampleSubnet.id}
vcores: 4
administratorLogin: mradministrator
administratorLoginPassword: thisIsDog11
options:
dependson:
- ${exampleSubnetNetworkSecurityGroupAssociation}
- ${exampleSubnetRouteTableAssociation}
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,
collation: Optional[str] = None,
dns_zone_partner_id: Optional[str] = None,
identity: Optional[ManagedInstanceIdentityArgs] = None,
license_type: Optional[str] = None,
location: Optional[str] = None,
maintenance_configuration_name: Optional[str] = None,
minimum_tls_version: Optional[str] = None,
name: Optional[str] = None,
proxy_override: Optional[str] = None,
public_data_endpoint_enabled: Optional[bool] = None,
resource_group_name: Optional[str] = None,
sku_name: Optional[str] = None,
storage_account_type: Optional[str] = None,
storage_size_in_gb: Optional[int] = None,
subnet_id: Optional[str] = None,
tags: Optional[Mapping[str, str]] = None,
timezone_id: Optional[str] = None,
vcores: Optional[int] = None)
@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:mssql: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:
- Administrator
Login string The administrator login name for the new SQL Managed Instance. Changing this forces a new resource to be created.
- Administrator
Login stringPassword The password associated with the
administrator_login
user. Needs to comply with Azure's Password Policy- License
Type string What type of license the Managed Instance will use. Possible values are
LicenseIncluded
andBasePrice
.- Resource
Group stringName The name of the resource group in which to create the SQL Managed Instance. Changing this forces a new resource to be created.
- Sku
Name string Specifies the SKU Name for the SQL Managed Instance. Valid values include
GP_Gen4
,GP_Gen5
,GP_Gen8IM
,GP_Gen8IH
,BC_Gen4
,BC_Gen5
,BC_Gen8IM
orBC_Gen8IH
.- Storage
Size intIn Gb Maximum storage space for the SQL Managed instance. This should be a multiple of 32 (GB).
- Subnet
Id string The subnet resource id that the SQL Managed Instance will be associated with. Changing this forces a new resource to be created.
- Vcores int
Number of cores that should be assigned to the SQL Managed Instance. Values can be
8
,16
, or24
for Gen4 SKUs, or4
,8
,16
,24
,32
,40
,64
, or80
for Gen5 SKUs.- Collation string
Specifies how the SQL Managed Instance will be collated. Default value is
SQL_Latin1_General_CP1_CI_AS
. Changing this forces a new resource to be created.- Dns
Zone stringPartner Id The ID of the SQL Managed Instance which will share the DNS zone. This is a prerequisite for creating an
azure.sql.ManagedInstanceFailoverGroup
. Setting this after creation forces a new resource to be created.- Identity
Managed
Instance Identity An
identity
block as defined below.- Location string
Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- Maintenance
Configuration stringName The name of the Public Maintenance Configuration window to apply to the SQL Managed Instance. Valid values include
SQL_Default
or an Azure Location in the formatSQL_{Location}_MI_{Size}
(for exampleSQL_EastUS_MI_1
). Defaults toSQL_Default
.- Minimum
Tls stringVersion The Minimum TLS Version. Default value is
1.2
Valid values include1.0
,1.1
,1.2
.- Name string
The name of the SQL Managed Instance. This needs to be globally unique within Azure. Changing this forces a new resource to be created.
- Proxy
Override string Specifies how the SQL Managed Instance will be accessed. Default value is
Default
. Valid values includeDefault
,Proxy
, andRedirect
.- Public
Data boolEndpoint Enabled Is the public data endpoint enabled? Default value is
false
.- Storage
Account stringType Specifies the storage account type used to store backups for this database. Changing this forces a new resource to be created. Possible values are
GRS
,LRS
andZRS
. The default value isGRS
.- Dictionary<string, string>
A mapping of tags to assign to the resource.
- Timezone
Id string The TimeZone ID that the SQL Managed Instance will be operating in. Default value is
UTC
. Changing this forces a new resource to be created.
- Administrator
Login string The administrator login name for the new SQL Managed Instance. Changing this forces a new resource to be created.
- Administrator
Login stringPassword The password associated with the
administrator_login
user. Needs to comply with Azure's Password Policy- License
Type string What type of license the Managed Instance will use. Possible values are
LicenseIncluded
andBasePrice
.- Resource
Group stringName The name of the resource group in which to create the SQL Managed Instance. Changing this forces a new resource to be created.
- Sku
Name string Specifies the SKU Name for the SQL Managed Instance. Valid values include
GP_Gen4
,GP_Gen5
,GP_Gen8IM
,GP_Gen8IH
,BC_Gen4
,BC_Gen5
,BC_Gen8IM
orBC_Gen8IH
.- Storage
Size intIn Gb Maximum storage space for the SQL Managed instance. This should be a multiple of 32 (GB).
- Subnet
Id string The subnet resource id that the SQL Managed Instance will be associated with. Changing this forces a new resource to be created.
- Vcores int
Number of cores that should be assigned to the SQL Managed Instance. Values can be
8
,16
, or24
for Gen4 SKUs, or4
,8
,16
,24
,32
,40
,64
, or80
for Gen5 SKUs.- Collation string
Specifies how the SQL Managed Instance will be collated. Default value is
SQL_Latin1_General_CP1_CI_AS
. Changing this forces a new resource to be created.- Dns
Zone stringPartner Id The ID of the SQL Managed Instance which will share the DNS zone. This is a prerequisite for creating an
azure.sql.ManagedInstanceFailoverGroup
. Setting this after creation forces a new resource to be created.- Identity
Managed
Instance Identity Args An
identity
block as defined below.- Location string
Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- Maintenance
Configuration stringName The name of the Public Maintenance Configuration window to apply to the SQL Managed Instance. Valid values include
SQL_Default
or an Azure Location in the formatSQL_{Location}_MI_{Size}
(for exampleSQL_EastUS_MI_1
). Defaults toSQL_Default
.- Minimum
Tls stringVersion The Minimum TLS Version. Default value is
1.2
Valid values include1.0
,1.1
,1.2
.- Name string
The name of the SQL Managed Instance. This needs to be globally unique within Azure. Changing this forces a new resource to be created.
- Proxy
Override string Specifies how the SQL Managed Instance will be accessed. Default value is
Default
. Valid values includeDefault
,Proxy
, andRedirect
.- Public
Data boolEndpoint Enabled Is the public data endpoint enabled? Default value is
false
.- Storage
Account stringType Specifies the storage account type used to store backups for this database. Changing this forces a new resource to be created. Possible values are
GRS
,LRS
andZRS
. The default value isGRS
.- map[string]string
A mapping of tags to assign to the resource.
- Timezone
Id string The TimeZone ID that the SQL Managed Instance will be operating in. Default value is
UTC
. Changing this forces a new resource to be created.
- administrator
Login String The administrator login name for the new SQL Managed Instance. Changing this forces a new resource to be created.
- administrator
Login StringPassword The password associated with the
administrator_login
user. Needs to comply with Azure's Password Policy- license
Type String What type of license the Managed Instance will use. Possible values are
LicenseIncluded
andBasePrice
.- resource
Group StringName The name of the resource group in which to create the SQL Managed Instance. Changing this forces a new resource to be created.
- sku
Name String Specifies the SKU Name for the SQL Managed Instance. Valid values include
GP_Gen4
,GP_Gen5
,GP_Gen8IM
,GP_Gen8IH
,BC_Gen4
,BC_Gen5
,BC_Gen8IM
orBC_Gen8IH
.- storage
Size IntegerIn Gb Maximum storage space for the SQL Managed instance. This should be a multiple of 32 (GB).
- subnet
Id String The subnet resource id that the SQL Managed Instance will be associated with. Changing this forces a new resource to be created.
- vcores Integer
Number of cores that should be assigned to the SQL Managed Instance. Values can be
8
,16
, or24
for Gen4 SKUs, or4
,8
,16
,24
,32
,40
,64
, or80
for Gen5 SKUs.- collation String
Specifies how the SQL Managed Instance will be collated. Default value is
SQL_Latin1_General_CP1_CI_AS
. Changing this forces a new resource to be created.- dns
Zone StringPartner Id The ID of the SQL Managed Instance which will share the DNS zone. This is a prerequisite for creating an
azure.sql.ManagedInstanceFailoverGroup
. Setting this after creation forces a new resource to be created.- identity
Managed
Instance Identity An
identity
block as defined below.- location String
Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- maintenance
Configuration StringName The name of the Public Maintenance Configuration window to apply to the SQL Managed Instance. Valid values include
SQL_Default
or an Azure Location in the formatSQL_{Location}_MI_{Size}
(for exampleSQL_EastUS_MI_1
). Defaults toSQL_Default
.- minimum
Tls StringVersion The Minimum TLS Version. Default value is
1.2
Valid values include1.0
,1.1
,1.2
.- name String
The name of the SQL Managed Instance. This needs to be globally unique within Azure. Changing this forces a new resource to be created.
- proxy
Override String Specifies how the SQL Managed Instance will be accessed. Default value is
Default
. Valid values includeDefault
,Proxy
, andRedirect
.- public
Data BooleanEndpoint Enabled Is the public data endpoint enabled? Default value is
false
.- storage
Account StringType Specifies the storage account type used to store backups for this database. Changing this forces a new resource to be created. Possible values are
GRS
,LRS
andZRS
. The default value isGRS
.- Map<String,String>
A mapping of tags to assign to the resource.
- timezone
Id String The TimeZone ID that the SQL Managed Instance will be operating in. Default value is
UTC
. Changing this forces a new resource to be created.
- administrator
Login string The administrator login name for the new SQL Managed Instance. Changing this forces a new resource to be created.
- administrator
Login stringPassword The password associated with the
administrator_login
user. Needs to comply with Azure's Password Policy- license
Type string What type of license the Managed Instance will use. Possible values are
LicenseIncluded
andBasePrice
.- resource
Group stringName The name of the resource group in which to create the SQL Managed Instance. Changing this forces a new resource to be created.
- sku
Name string Specifies the SKU Name for the SQL Managed Instance. Valid values include
GP_Gen4
,GP_Gen5
,GP_Gen8IM
,GP_Gen8IH
,BC_Gen4
,BC_Gen5
,BC_Gen8IM
orBC_Gen8IH
.- storage
Size numberIn Gb Maximum storage space for the SQL Managed instance. This should be a multiple of 32 (GB).
- subnet
Id string The subnet resource id that the SQL Managed Instance will be associated with. Changing this forces a new resource to be created.
- vcores number
Number of cores that should be assigned to the SQL Managed Instance. Values can be
8
,16
, or24
for Gen4 SKUs, or4
,8
,16
,24
,32
,40
,64
, or80
for Gen5 SKUs.- collation string
Specifies how the SQL Managed Instance will be collated. Default value is
SQL_Latin1_General_CP1_CI_AS
. Changing this forces a new resource to be created.- dns
Zone stringPartner Id The ID of the SQL Managed Instance which will share the DNS zone. This is a prerequisite for creating an
azure.sql.ManagedInstanceFailoverGroup
. Setting this after creation forces a new resource to be created.- identity
Managed
Instance Identity An
identity
block as defined below.- location string
Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- maintenance
Configuration stringName The name of the Public Maintenance Configuration window to apply to the SQL Managed Instance. Valid values include
SQL_Default
or an Azure Location in the formatSQL_{Location}_MI_{Size}
(for exampleSQL_EastUS_MI_1
). Defaults toSQL_Default
.- minimum
Tls stringVersion The Minimum TLS Version. Default value is
1.2
Valid values include1.0
,1.1
,1.2
.- name string
The name of the SQL Managed Instance. This needs to be globally unique within Azure. Changing this forces a new resource to be created.
- proxy
Override string Specifies how the SQL Managed Instance will be accessed. Default value is
Default
. Valid values includeDefault
,Proxy
, andRedirect
.- public
Data booleanEndpoint Enabled Is the public data endpoint enabled? Default value is
false
.- storage
Account stringType Specifies the storage account type used to store backups for this database. Changing this forces a new resource to be created. Possible values are
GRS
,LRS
andZRS
. The default value isGRS
.- {[key: string]: string}
A mapping of tags to assign to the resource.
- timezone
Id string The TimeZone ID that the SQL Managed Instance will be operating in. Default value is
UTC
. Changing this forces a new resource to be created.
- administrator_
login str The administrator login name for the new SQL Managed Instance. Changing this forces a new resource to be created.
- administrator_
login_ strpassword The password associated with the
administrator_login
user. Needs to comply with Azure's Password Policy- license_
type str What type of license the Managed Instance will use. Possible values are
LicenseIncluded
andBasePrice
.- resource_
group_ strname The name of the resource group in which to create the SQL Managed Instance. Changing this forces a new resource to be created.
- sku_
name str Specifies the SKU Name for the SQL Managed Instance. Valid values include
GP_Gen4
,GP_Gen5
,GP_Gen8IM
,GP_Gen8IH
,BC_Gen4
,BC_Gen5
,BC_Gen8IM
orBC_Gen8IH
.- storage_
size_ intin_ gb Maximum storage space for the SQL Managed instance. This should be a multiple of 32 (GB).
- subnet_
id str The subnet resource id that the SQL Managed Instance will be associated with. Changing this forces a new resource to be created.
- vcores int
Number of cores that should be assigned to the SQL Managed Instance. Values can be
8
,16
, or24
for Gen4 SKUs, or4
,8
,16
,24
,32
,40
,64
, or80
for Gen5 SKUs.- collation str
Specifies how the SQL Managed Instance will be collated. Default value is
SQL_Latin1_General_CP1_CI_AS
. Changing this forces a new resource to be created.- dns_
zone_ strpartner_ id The ID of the SQL Managed Instance which will share the DNS zone. This is a prerequisite for creating an
azure.sql.ManagedInstanceFailoverGroup
. Setting this after creation forces a new resource to be created.- identity
Managed
Instance Identity Args An
identity
block as defined below.- location str
Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- maintenance_
configuration_ strname The name of the Public Maintenance Configuration window to apply to the SQL Managed Instance. Valid values include
SQL_Default
or an Azure Location in the formatSQL_{Location}_MI_{Size}
(for exampleSQL_EastUS_MI_1
). Defaults toSQL_Default
.- minimum_
tls_ strversion The Minimum TLS Version. Default value is
1.2
Valid values include1.0
,1.1
,1.2
.- name str
The name of the SQL Managed Instance. This needs to be globally unique within Azure. Changing this forces a new resource to be created.
- proxy_
override str Specifies how the SQL Managed Instance will be accessed. Default value is
Default
. Valid values includeDefault
,Proxy
, andRedirect
.- public_
data_ boolendpoint_ enabled Is the public data endpoint enabled? Default value is
false
.- storage_
account_ strtype Specifies the storage account type used to store backups for this database. Changing this forces a new resource to be created. Possible values are
GRS
,LRS
andZRS
. The default value isGRS
.- Mapping[str, str]
A mapping of tags to assign to the resource.
- timezone_
id str The TimeZone ID that the SQL Managed Instance will be operating in. Default value is
UTC
. Changing this forces a new resource to be created.
- administrator
Login String The administrator login name for the new SQL Managed Instance. Changing this forces a new resource to be created.
- administrator
Login StringPassword The password associated with the
administrator_login
user. Needs to comply with Azure's Password Policy- license
Type String What type of license the Managed Instance will use. Possible values are
LicenseIncluded
andBasePrice
.- resource
Group StringName The name of the resource group in which to create the SQL Managed Instance. Changing this forces a new resource to be created.
- sku
Name String Specifies the SKU Name for the SQL Managed Instance. Valid values include
GP_Gen4
,GP_Gen5
,GP_Gen8IM
,GP_Gen8IH
,BC_Gen4
,BC_Gen5
,BC_Gen8IM
orBC_Gen8IH
.- storage
Size NumberIn Gb Maximum storage space for the SQL Managed instance. This should be a multiple of 32 (GB).
- subnet
Id String The subnet resource id that the SQL Managed Instance will be associated with. Changing this forces a new resource to be created.
- vcores Number
Number of cores that should be assigned to the SQL Managed Instance. Values can be
8
,16
, or24
for Gen4 SKUs, or4
,8
,16
,24
,32
,40
,64
, or80
for Gen5 SKUs.- collation String
Specifies how the SQL Managed Instance will be collated. Default value is
SQL_Latin1_General_CP1_CI_AS
. Changing this forces a new resource to be created.- dns
Zone StringPartner Id The ID of the SQL Managed Instance which will share the DNS zone. This is a prerequisite for creating an
azure.sql.ManagedInstanceFailoverGroup
. Setting this after creation forces a new resource to be created.- identity Property Map
An
identity
block as defined below.- location String
Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- maintenance
Configuration StringName The name of the Public Maintenance Configuration window to apply to the SQL Managed Instance. Valid values include
SQL_Default
or an Azure Location in the formatSQL_{Location}_MI_{Size}
(for exampleSQL_EastUS_MI_1
). Defaults toSQL_Default
.- minimum
Tls StringVersion The Minimum TLS Version. Default value is
1.2
Valid values include1.0
,1.1
,1.2
.- name String
The name of the SQL Managed Instance. This needs to be globally unique within Azure. Changing this forces a new resource to be created.
- proxy
Override String Specifies how the SQL Managed Instance will be accessed. Default value is
Default
. Valid values includeDefault
,Proxy
, andRedirect
.- public
Data BooleanEndpoint Enabled Is the public data endpoint enabled? Default value is
false
.- storage
Account StringType Specifies the storage account type used to store backups for this database. Changing this forces a new resource to be created. Possible values are
GRS
,LRS
andZRS
. The default value isGRS
.- Map<String>
A mapping of tags to assign to the resource.
- timezone
Id String The TimeZone ID that the SQL Managed Instance will be operating in. Default value is
UTC
. Changing this forces a new resource to be created.
Outputs
All input properties are implicitly available as output properties. Additionally, the ManagedInstance resource produces the following output properties:
Look up Existing ManagedInstance Resource
Get an existing ManagedInstance resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.
public static get(name: string, id: Input<ID>, state?: ManagedInstanceState, opts?: CustomResourceOptions): ManagedInstance
@staticmethod
def get(resource_name: str,
id: str,
opts: Optional[ResourceOptions] = None,
administrator_login: Optional[str] = None,
administrator_login_password: Optional[str] = None,
collation: Optional[str] = None,
dns_zone_partner_id: Optional[str] = None,
fqdn: Optional[str] = None,
identity: Optional[ManagedInstanceIdentityArgs] = None,
license_type: Optional[str] = None,
location: Optional[str] = None,
maintenance_configuration_name: Optional[str] = None,
minimum_tls_version: Optional[str] = None,
name: Optional[str] = None,
proxy_override: Optional[str] = None,
public_data_endpoint_enabled: Optional[bool] = None,
resource_group_name: Optional[str] = None,
sku_name: Optional[str] = None,
storage_account_type: Optional[str] = None,
storage_size_in_gb: Optional[int] = None,
subnet_id: Optional[str] = None,
tags: Optional[Mapping[str, str]] = None,
timezone_id: Optional[str] = None,
vcores: Optional[int] = None) -> ManagedInstance
func GetManagedInstance(ctx *Context, name string, id IDInput, state *ManagedInstanceState, opts ...ResourceOption) (*ManagedInstance, error)
public static ManagedInstance Get(string name, Input<string> id, ManagedInstanceState? state, CustomResourceOptions? opts = null)
public static ManagedInstance get(String name, Output<String> id, ManagedInstanceState state, CustomResourceOptions options)
Resource lookup is not supported in YAML
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- resource_name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- name
- The unique name of the resulting resource.
- id
- The unique provider ID of the resource to lookup.
- state
- Any extra arguments used during the lookup.
- opts
- A bag of options that control this resource's behavior.
- Administrator
Login string The administrator login name for the new SQL Managed Instance. Changing this forces a new resource to be created.
- Administrator
Login stringPassword The password associated with the
administrator_login
user. Needs to comply with Azure's Password Policy- Collation string
Specifies how the SQL Managed Instance will be collated. Default value is
SQL_Latin1_General_CP1_CI_AS
. Changing this forces a new resource to be created.- Dns
Zone stringPartner Id The ID of the SQL Managed Instance which will share the DNS zone. This is a prerequisite for creating an
azure.sql.ManagedInstanceFailoverGroup
. Setting this after creation forces a new resource to be created.- Fqdn string
The fully qualified domain name of the Azure Managed SQL Instance
- Identity
Managed
Instance Identity An
identity
block as defined below.- License
Type string What type of license the Managed Instance will use. Possible values are
LicenseIncluded
andBasePrice
.- Location string
Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- Maintenance
Configuration stringName The name of the Public Maintenance Configuration window to apply to the SQL Managed Instance. Valid values include
SQL_Default
or an Azure Location in the formatSQL_{Location}_MI_{Size}
(for exampleSQL_EastUS_MI_1
). Defaults toSQL_Default
.- Minimum
Tls stringVersion The Minimum TLS Version. Default value is
1.2
Valid values include1.0
,1.1
,1.2
.- Name string
The name of the SQL Managed Instance. This needs to be globally unique within Azure. Changing this forces a new resource to be created.
- Proxy
Override string Specifies how the SQL Managed Instance will be accessed. Default value is
Default
. Valid values includeDefault
,Proxy
, andRedirect
.- Public
Data boolEndpoint Enabled Is the public data endpoint enabled? Default value is
false
.- Resource
Group stringName The name of the resource group in which to create the SQL Managed Instance. Changing this forces a new resource to be created.
- Sku
Name string Specifies the SKU Name for the SQL Managed Instance. Valid values include
GP_Gen4
,GP_Gen5
,GP_Gen8IM
,GP_Gen8IH
,BC_Gen4
,BC_Gen5
,BC_Gen8IM
orBC_Gen8IH
.- Storage
Account stringType Specifies the storage account type used to store backups for this database. Changing this forces a new resource to be created. Possible values are
GRS
,LRS
andZRS
. The default value isGRS
.- Storage
Size intIn Gb Maximum storage space for the SQL Managed instance. This should be a multiple of 32 (GB).
- Subnet
Id string The subnet resource id that the SQL Managed Instance will be associated with. Changing this forces a new resource to be created.
- Dictionary<string, string>
A mapping of tags to assign to the resource.
- Timezone
Id string The TimeZone ID that the SQL Managed Instance will be operating in. Default value is
UTC
. Changing this forces a new resource to be created.- Vcores int
Number of cores that should be assigned to the SQL Managed Instance. Values can be
8
,16
, or24
for Gen4 SKUs, or4
,8
,16
,24
,32
,40
,64
, or80
for Gen5 SKUs.
- Administrator
Login string The administrator login name for the new SQL Managed Instance. Changing this forces a new resource to be created.
- Administrator
Login stringPassword The password associated with the
administrator_login
user. Needs to comply with Azure's Password Policy- Collation string
Specifies how the SQL Managed Instance will be collated. Default value is
SQL_Latin1_General_CP1_CI_AS
. Changing this forces a new resource to be created.- Dns
Zone stringPartner Id The ID of the SQL Managed Instance which will share the DNS zone. This is a prerequisite for creating an
azure.sql.ManagedInstanceFailoverGroup
. Setting this after creation forces a new resource to be created.- Fqdn string
The fully qualified domain name of the Azure Managed SQL Instance
- Identity
Managed
Instance Identity Args An
identity
block as defined below.- License
Type string What type of license the Managed Instance will use. Possible values are
LicenseIncluded
andBasePrice
.- Location string
Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- Maintenance
Configuration stringName The name of the Public Maintenance Configuration window to apply to the SQL Managed Instance. Valid values include
SQL_Default
or an Azure Location in the formatSQL_{Location}_MI_{Size}
(for exampleSQL_EastUS_MI_1
). Defaults toSQL_Default
.- Minimum
Tls stringVersion The Minimum TLS Version. Default value is
1.2
Valid values include1.0
,1.1
,1.2
.- Name string
The name of the SQL Managed Instance. This needs to be globally unique within Azure. Changing this forces a new resource to be created.
- Proxy
Override string Specifies how the SQL Managed Instance will be accessed. Default value is
Default
. Valid values includeDefault
,Proxy
, andRedirect
.- Public
Data boolEndpoint Enabled Is the public data endpoint enabled? Default value is
false
.- Resource
Group stringName The name of the resource group in which to create the SQL Managed Instance. Changing this forces a new resource to be created.
- Sku
Name string Specifies the SKU Name for the SQL Managed Instance. Valid values include
GP_Gen4
,GP_Gen5
,GP_Gen8IM
,GP_Gen8IH
,BC_Gen4
,BC_Gen5
,BC_Gen8IM
orBC_Gen8IH
.- Storage
Account stringType Specifies the storage account type used to store backups for this database. Changing this forces a new resource to be created. Possible values are
GRS
,LRS
andZRS
. The default value isGRS
.- Storage
Size intIn Gb Maximum storage space for the SQL Managed instance. This should be a multiple of 32 (GB).
- Subnet
Id string The subnet resource id that the SQL Managed Instance will be associated with. Changing this forces a new resource to be created.
- map[string]string
A mapping of tags to assign to the resource.
- Timezone
Id string The TimeZone ID that the SQL Managed Instance will be operating in. Default value is
UTC
. Changing this forces a new resource to be created.- Vcores int
Number of cores that should be assigned to the SQL Managed Instance. Values can be
8
,16
, or24
for Gen4 SKUs, or4
,8
,16
,24
,32
,40
,64
, or80
for Gen5 SKUs.
- administrator
Login String The administrator login name for the new SQL Managed Instance. Changing this forces a new resource to be created.
- administrator
Login StringPassword The password associated with the
administrator_login
user. Needs to comply with Azure's Password Policy- collation String
Specifies how the SQL Managed Instance will be collated. Default value is
SQL_Latin1_General_CP1_CI_AS
. Changing this forces a new resource to be created.- dns
Zone StringPartner Id The ID of the SQL Managed Instance which will share the DNS zone. This is a prerequisite for creating an
azure.sql.ManagedInstanceFailoverGroup
. Setting this after creation forces a new resource to be created.- fqdn String
The fully qualified domain name of the Azure Managed SQL Instance
- identity
Managed
Instance Identity An
identity
block as defined below.- license
Type String What type of license the Managed Instance will use. Possible values are
LicenseIncluded
andBasePrice
.- location String
Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- maintenance
Configuration StringName The name of the Public Maintenance Configuration window to apply to the SQL Managed Instance. Valid values include
SQL_Default
or an Azure Location in the formatSQL_{Location}_MI_{Size}
(for exampleSQL_EastUS_MI_1
). Defaults toSQL_Default
.- minimum
Tls StringVersion The Minimum TLS Version. Default value is
1.2
Valid values include1.0
,1.1
,1.2
.- name String
The name of the SQL Managed Instance. This needs to be globally unique within Azure. Changing this forces a new resource to be created.
- proxy
Override String Specifies how the SQL Managed Instance will be accessed. Default value is
Default
. Valid values includeDefault
,Proxy
, andRedirect
.- public
Data BooleanEndpoint Enabled Is the public data endpoint enabled? Default value is
false
.- resource
Group StringName The name of the resource group in which to create the SQL Managed Instance. Changing this forces a new resource to be created.
- sku
Name String Specifies the SKU Name for the SQL Managed Instance. Valid values include
GP_Gen4
,GP_Gen5
,GP_Gen8IM
,GP_Gen8IH
,BC_Gen4
,BC_Gen5
,BC_Gen8IM
orBC_Gen8IH
.- storage
Account StringType Specifies the storage account type used to store backups for this database. Changing this forces a new resource to be created. Possible values are
GRS
,LRS
andZRS
. The default value isGRS
.- storage
Size IntegerIn Gb Maximum storage space for the SQL Managed instance. This should be a multiple of 32 (GB).
- subnet
Id String The subnet resource id that the SQL Managed Instance will be associated with. Changing this forces a new resource to be created.
- Map<String,String>
A mapping of tags to assign to the resource.
- timezone
Id String The TimeZone ID that the SQL Managed Instance will be operating in. Default value is
UTC
. Changing this forces a new resource to be created.- vcores Integer
Number of cores that should be assigned to the SQL Managed Instance. Values can be
8
,16
, or24
for Gen4 SKUs, or4
,8
,16
,24
,32
,40
,64
, or80
for Gen5 SKUs.
- administrator
Login string The administrator login name for the new SQL Managed Instance. Changing this forces a new resource to be created.
- administrator
Login stringPassword The password associated with the
administrator_login
user. Needs to comply with Azure's Password Policy- collation string
Specifies how the SQL Managed Instance will be collated. Default value is
SQL_Latin1_General_CP1_CI_AS
. Changing this forces a new resource to be created.- dns
Zone stringPartner Id The ID of the SQL Managed Instance which will share the DNS zone. This is a prerequisite for creating an
azure.sql.ManagedInstanceFailoverGroup
. Setting this after creation forces a new resource to be created.- fqdn string
The fully qualified domain name of the Azure Managed SQL Instance
- identity
Managed
Instance Identity An
identity
block as defined below.- license
Type string What type of license the Managed Instance will use. Possible values are
LicenseIncluded
andBasePrice
.- location string
Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- maintenance
Configuration stringName The name of the Public Maintenance Configuration window to apply to the SQL Managed Instance. Valid values include
SQL_Default
or an Azure Location in the formatSQL_{Location}_MI_{Size}
(for exampleSQL_EastUS_MI_1
). Defaults toSQL_Default
.- minimum
Tls stringVersion The Minimum TLS Version. Default value is
1.2
Valid values include1.0
,1.1
,1.2
.- name string
The name of the SQL Managed Instance. This needs to be globally unique within Azure. Changing this forces a new resource to be created.
- proxy
Override string Specifies how the SQL Managed Instance will be accessed. Default value is
Default
. Valid values includeDefault
,Proxy
, andRedirect
.- public
Data booleanEndpoint Enabled Is the public data endpoint enabled? Default value is
false
.- resource
Group stringName The name of the resource group in which to create the SQL Managed Instance. Changing this forces a new resource to be created.
- sku
Name string Specifies the SKU Name for the SQL Managed Instance. Valid values include
GP_Gen4
,GP_Gen5
,GP_Gen8IM
,GP_Gen8IH
,BC_Gen4
,BC_Gen5
,BC_Gen8IM
orBC_Gen8IH
.- storage
Account stringType Specifies the storage account type used to store backups for this database. Changing this forces a new resource to be created. Possible values are
GRS
,LRS
andZRS
. The default value isGRS
.- storage
Size numberIn Gb Maximum storage space for the SQL Managed instance. This should be a multiple of 32 (GB).
- subnet
Id string The subnet resource id that the SQL Managed Instance will be associated with. Changing this forces a new resource to be created.
- {[key: string]: string}
A mapping of tags to assign to the resource.
- timezone
Id string The TimeZone ID that the SQL Managed Instance will be operating in. Default value is
UTC
. Changing this forces a new resource to be created.- vcores number
Number of cores that should be assigned to the SQL Managed Instance. Values can be
8
,16
, or24
for Gen4 SKUs, or4
,8
,16
,24
,32
,40
,64
, or80
for Gen5 SKUs.
- administrator_
login str The administrator login name for the new SQL Managed Instance. Changing this forces a new resource to be created.
- administrator_
login_ strpassword The password associated with the
administrator_login
user. Needs to comply with Azure's Password Policy- collation str
Specifies how the SQL Managed Instance will be collated. Default value is
SQL_Latin1_General_CP1_CI_AS
. Changing this forces a new resource to be created.- dns_
zone_ strpartner_ id The ID of the SQL Managed Instance which will share the DNS zone. This is a prerequisite for creating an
azure.sql.ManagedInstanceFailoverGroup
. Setting this after creation forces a new resource to be created.- fqdn str
The fully qualified domain name of the Azure Managed SQL Instance
- identity
Managed
Instance Identity Args An
identity
block as defined below.- license_
type str What type of license the Managed Instance will use. Possible values are
LicenseIncluded
andBasePrice
.- location str
Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- maintenance_
configuration_ strname The name of the Public Maintenance Configuration window to apply to the SQL Managed Instance. Valid values include
SQL_Default
or an Azure Location in the formatSQL_{Location}_MI_{Size}
(for exampleSQL_EastUS_MI_1
). Defaults toSQL_Default
.- minimum_
tls_ strversion The Minimum TLS Version. Default value is
1.2
Valid values include1.0
,1.1
,1.2
.- name str
The name of the SQL Managed Instance. This needs to be globally unique within Azure. Changing this forces a new resource to be created.
- proxy_
override str Specifies how the SQL Managed Instance will be accessed. Default value is
Default
. Valid values includeDefault
,Proxy
, andRedirect
.- public_
data_ boolendpoint_ enabled Is the public data endpoint enabled? Default value is
false
.- resource_
group_ strname The name of the resource group in which to create the SQL Managed Instance. Changing this forces a new resource to be created.
- sku_
name str Specifies the SKU Name for the SQL Managed Instance. Valid values include
GP_Gen4
,GP_Gen5
,GP_Gen8IM
,GP_Gen8IH
,BC_Gen4
,BC_Gen5
,BC_Gen8IM
orBC_Gen8IH
.- storage_
account_ strtype Specifies the storage account type used to store backups for this database. Changing this forces a new resource to be created. Possible values are
GRS
,LRS
andZRS
. The default value isGRS
.- storage_
size_ intin_ gb Maximum storage space for the SQL Managed instance. This should be a multiple of 32 (GB).
- subnet_
id str The subnet resource id that the SQL Managed Instance will be associated with. Changing this forces a new resource to be created.
- Mapping[str, str]
A mapping of tags to assign to the resource.
- timezone_
id str The TimeZone ID that the SQL Managed Instance will be operating in. Default value is
UTC
. Changing this forces a new resource to be created.- vcores int
Number of cores that should be assigned to the SQL Managed Instance. Values can be
8
,16
, or24
for Gen4 SKUs, or4
,8
,16
,24
,32
,40
,64
, or80
for Gen5 SKUs.
- administrator
Login String The administrator login name for the new SQL Managed Instance. Changing this forces a new resource to be created.
- administrator
Login StringPassword The password associated with the
administrator_login
user. Needs to comply with Azure's Password Policy- collation String
Specifies how the SQL Managed Instance will be collated. Default value is
SQL_Latin1_General_CP1_CI_AS
. Changing this forces a new resource to be created.- dns
Zone StringPartner Id The ID of the SQL Managed Instance which will share the DNS zone. This is a prerequisite for creating an
azure.sql.ManagedInstanceFailoverGroup
. Setting this after creation forces a new resource to be created.- fqdn String
The fully qualified domain name of the Azure Managed SQL Instance
- identity Property Map
An
identity
block as defined below.- license
Type String What type of license the Managed Instance will use. Possible values are
LicenseIncluded
andBasePrice
.- location String
Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
- maintenance
Configuration StringName The name of the Public Maintenance Configuration window to apply to the SQL Managed Instance. Valid values include
SQL_Default
or an Azure Location in the formatSQL_{Location}_MI_{Size}
(for exampleSQL_EastUS_MI_1
). Defaults toSQL_Default
.- minimum
Tls StringVersion The Minimum TLS Version. Default value is
1.2
Valid values include1.0
,1.1
,1.2
.- name String
The name of the SQL Managed Instance. This needs to be globally unique within Azure. Changing this forces a new resource to be created.
- proxy
Override String Specifies how the SQL Managed Instance will be accessed. Default value is
Default
. Valid values includeDefault
,Proxy
, andRedirect
.- public
Data BooleanEndpoint Enabled Is the public data endpoint enabled? Default value is
false
.- resource
Group StringName The name of the resource group in which to create the SQL Managed Instance. Changing this forces a new resource to be created.
- sku
Name String Specifies the SKU Name for the SQL Managed Instance. Valid values include
GP_Gen4
,GP_Gen5
,GP_Gen8IM
,GP_Gen8IH
,BC_Gen4
,BC_Gen5
,BC_Gen8IM
orBC_Gen8IH
.- storage
Account StringType Specifies the storage account type used to store backups for this database. Changing this forces a new resource to be created. Possible values are
GRS
,LRS
andZRS
. The default value isGRS
.- storage
Size NumberIn Gb Maximum storage space for the SQL Managed instance. This should be a multiple of 32 (GB).
- subnet
Id String The subnet resource id that the SQL Managed Instance will be associated with. Changing this forces a new resource to be created.
- Map<String>
A mapping of tags to assign to the resource.
- timezone
Id String The TimeZone ID that the SQL Managed Instance will be operating in. Default value is
UTC
. Changing this forces a new resource to be created.- vcores Number
Number of cores that should be assigned to the SQL Managed Instance. Values can be
8
,16
, or24
for Gen4 SKUs, or4
,8
,16
,24
,32
,40
,64
, or80
for Gen5 SKUs.
Supporting Types
ManagedInstanceIdentity, ManagedInstanceIdentityArgs
- Type string
Specifies the type of Managed Service Identity that should be configured on this SQL Managed Instance. Possible values are
SystemAssigned
,UserAssigned
.- Identity
Ids List<string> Specifies a list of User Assigned Managed Identity IDs to be assigned to this SQL Managed Instance. Required when
type
is set toUserAssigned
.The assigned
principal_id
andtenant_id
can be retrieved after the identitytype
has been set toSystemAssigned
and SQL Managed Instance has been created.- Principal
Id string The Principal ID for the Service Principal associated with the Identity of this SQL Managed Instance.
- Tenant
Id string The Tenant ID for the Service Principal associated with the Identity of this SQL Managed Instance.
- Type string
Specifies the type of Managed Service Identity that should be configured on this SQL Managed Instance. Possible values are
SystemAssigned
,UserAssigned
.- Identity
Ids []string Specifies a list of User Assigned Managed Identity IDs to be assigned to this SQL Managed Instance. Required when
type
is set toUserAssigned
.The assigned
principal_id
andtenant_id
can be retrieved after the identitytype
has been set toSystemAssigned
and SQL Managed Instance has been created.- Principal
Id string The Principal ID for the Service Principal associated with the Identity of this SQL Managed Instance.
- Tenant
Id string The Tenant ID for the Service Principal associated with the Identity of this SQL Managed Instance.
- type String
Specifies the type of Managed Service Identity that should be configured on this SQL Managed Instance. Possible values are
SystemAssigned
,UserAssigned
.- identity
Ids List<String> Specifies a list of User Assigned Managed Identity IDs to be assigned to this SQL Managed Instance. Required when
type
is set toUserAssigned
.The assigned
principal_id
andtenant_id
can be retrieved after the identitytype
has been set toSystemAssigned
and SQL Managed Instance has been created.- principal
Id String The Principal ID for the Service Principal associated with the Identity of this SQL Managed Instance.
- tenant
Id String The Tenant ID for the Service Principal associated with the Identity of this SQL Managed Instance.
- type string
Specifies the type of Managed Service Identity that should be configured on this SQL Managed Instance. Possible values are
SystemAssigned
,UserAssigned
.- identity
Ids string[] Specifies a list of User Assigned Managed Identity IDs to be assigned to this SQL Managed Instance. Required when
type
is set toUserAssigned
.The assigned
principal_id
andtenant_id
can be retrieved after the identitytype
has been set toSystemAssigned
and SQL Managed Instance has been created.- principal
Id string The Principal ID for the Service Principal associated with the Identity of this SQL Managed Instance.
- tenant
Id string The Tenant ID for the Service Principal associated with the Identity of this SQL Managed Instance.
- type str
Specifies the type of Managed Service Identity that should be configured on this SQL Managed Instance. Possible values are
SystemAssigned
,UserAssigned
.- identity_
ids Sequence[str] Specifies a list of User Assigned Managed Identity IDs to be assigned to this SQL Managed Instance. Required when
type
is set toUserAssigned
.The assigned
principal_id
andtenant_id
can be retrieved after the identitytype
has been set toSystemAssigned
and SQL Managed Instance has been created.- principal_
id str The Principal ID for the Service Principal associated with the Identity of this SQL Managed Instance.
- tenant_
id str The Tenant ID for the Service Principal associated with the Identity of this SQL Managed Instance.
- type String
Specifies the type of Managed Service Identity that should be configured on this SQL Managed Instance. Possible values are
SystemAssigned
,UserAssigned
.- identity
Ids List<String> Specifies a list of User Assigned Managed Identity IDs to be assigned to this SQL Managed Instance. Required when
type
is set toUserAssigned
.The assigned
principal_id
andtenant_id
can be retrieved after the identitytype
has been set toSystemAssigned
and SQL Managed Instance has been created.- principal
Id String The Principal ID for the Service Principal associated with the Identity of this SQL Managed Instance.
- tenant
Id String The Tenant ID for the Service Principal associated with the Identity of this SQL Managed Instance.
Import
Microsoft SQL Managed Instances can be imported using the resource id
, e.g.
$ pulumi import azure:mssql/managedInstance:ManagedInstance example /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/myresourcegroup/providers/Microsoft.Sql/managedInstances/myserver
Package Details
- Repository
- Azure Classic pulumi/pulumi-azure
- License
- Apache-2.0
- Notes
This Pulumi package is based on the
azurerm
Terraform Provider.