azure-native.sqlvirtualmachine.SqlVirtualMachine
A SQL virtual machine. API Version: 2017-03-01-preview.
Example Usage
Creates or updates a SQL virtual machine and joins it to a SQL virtual machine group.
using System.Collections.Generic;
using Pulumi;
using AzureNative = Pulumi.AzureNative;
return await Deployment.RunAsync(() =>
{
var sqlVirtualMachine = new AzureNative.SqlVirtualMachine.SqlVirtualMachine("sqlVirtualMachine", new()
{
Location = "northeurope",
ResourceGroupName = "testrg",
SqlVirtualMachineGroupResourceId = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachineGroups/testvmgroup",
SqlVirtualMachineName = "testvm",
VirtualMachineResourceId = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm2",
WsfcDomainCredentials = new AzureNative.SqlVirtualMachine.Inputs.WsfcDomainCredentialsArgs
{
ClusterBootstrapAccountPassword = "<Password>",
ClusterOperatorAccountPassword = "<Password>",
SqlServiceAccountPassword = "<Password>",
},
});
});
package main
import (
sqlvirtualmachine "github.com/pulumi/pulumi-azure-native/sdk/go/azure/sqlvirtualmachine"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := sqlvirtualmachine.NewSqlVirtualMachine(ctx, "sqlVirtualMachine", &sqlvirtualmachine.SqlVirtualMachineArgs{
Location: pulumi.String("northeurope"),
ResourceGroupName: pulumi.String("testrg"),
SqlVirtualMachineGroupResourceId: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachineGroups/testvmgroup"),
SqlVirtualMachineName: pulumi.String("testvm"),
VirtualMachineResourceId: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm2"),
WsfcDomainCredentials: &sqlvirtualmachine.WsfcDomainCredentialsArgs{
ClusterBootstrapAccountPassword: pulumi.String("<Password>"),
ClusterOperatorAccountPassword: pulumi.String("<Password>"),
SqlServiceAccountPassword: pulumi.String("<Password>"),
},
})
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.sqlvirtualmachine.SqlVirtualMachine;
import com.pulumi.azurenative.sqlvirtualmachine.SqlVirtualMachineArgs;
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 sqlVirtualMachine = new SqlVirtualMachine("sqlVirtualMachine", SqlVirtualMachineArgs.builder()
.location("northeurope")
.resourceGroupName("testrg")
.sqlVirtualMachineGroupResourceId("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachineGroups/testvmgroup")
.sqlVirtualMachineName("testvm")
.virtualMachineResourceId("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm2")
.wsfcDomainCredentials(Map.ofEntries(
Map.entry("clusterBootstrapAccountPassword", "<Password>"),
Map.entry("clusterOperatorAccountPassword", "<Password>"),
Map.entry("sqlServiceAccountPassword", "<Password>")
))
.build());
}
}
import pulumi
import pulumi_azure_native as azure_native
sql_virtual_machine = azure_native.sqlvirtualmachine.SqlVirtualMachine("sqlVirtualMachine",
location="northeurope",
resource_group_name="testrg",
sql_virtual_machine_group_resource_id="/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachineGroups/testvmgroup",
sql_virtual_machine_name="testvm",
virtual_machine_resource_id="/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm2",
wsfc_domain_credentials=azure_native.sqlvirtualmachine.WsfcDomainCredentialsArgs(
cluster_bootstrap_account_password="<Password>",
cluster_operator_account_password="<Password>",
sql_service_account_password="<Password>",
))
import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";
const sqlVirtualMachine = new azure_native.sqlvirtualmachine.SqlVirtualMachine("sqlVirtualMachine", {
location: "northeurope",
resourceGroupName: "testrg",
sqlVirtualMachineGroupResourceId: "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachineGroups/testvmgroup",
sqlVirtualMachineName: "testvm",
virtualMachineResourceId: "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm2",
wsfcDomainCredentials: {
clusterBootstrapAccountPassword: "<Password>",
clusterOperatorAccountPassword: "<Password>",
sqlServiceAccountPassword: "<Password>",
},
});
resources:
sqlVirtualMachine:
type: azure-native:sqlvirtualmachine:SqlVirtualMachine
properties:
location: northeurope
resourceGroupName: testrg
sqlVirtualMachineGroupResourceId: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachineGroups/testvmgroup
sqlVirtualMachineName: testvm
virtualMachineResourceId: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm2
wsfcDomainCredentials:
clusterBootstrapAccountPassword: <Password>
clusterOperatorAccountPassword: <Password>
sqlServiceAccountPassword: <Password>
Creates or updates a SQL virtual machine for Storage Configuration Settings to EXTEND Data, Log or TempDB storage pool.
using System.Collections.Generic;
using Pulumi;
using AzureNative = Pulumi.AzureNative;
return await Deployment.RunAsync(() =>
{
var sqlVirtualMachine = new AzureNative.SqlVirtualMachine.SqlVirtualMachine("sqlVirtualMachine", new()
{
Location = "northeurope",
ResourceGroupName = "testrg",
SqlVirtualMachineName = "testvm",
StorageConfigurationSettings = new AzureNative.SqlVirtualMachine.Inputs.StorageConfigurationSettingsArgs
{
DiskConfigurationType = "EXTEND",
SqlDataSettings = new AzureNative.SqlVirtualMachine.Inputs.SQLStorageSettingsArgs
{
Luns = new[]
{
2,
},
},
},
VirtualMachineResourceId = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm",
});
});
package main
import (
sqlvirtualmachine "github.com/pulumi/pulumi-azure-native/sdk/go/azure/sqlvirtualmachine"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := sqlvirtualmachine.NewSqlVirtualMachine(ctx, "sqlVirtualMachine", &sqlvirtualmachine.SqlVirtualMachineArgs{
Location: pulumi.String("northeurope"),
ResourceGroupName: pulumi.String("testrg"),
SqlVirtualMachineName: pulumi.String("testvm"),
StorageConfigurationSettings: sqlvirtualmachine.StorageConfigurationSettingsResponse{
DiskConfigurationType: pulumi.String("EXTEND"),
SqlDataSettings: &sqlvirtualmachine.SQLStorageSettingsArgs{
Luns: pulumi.IntArray{
pulumi.Int(2),
},
},
},
VirtualMachineResourceId: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm"),
})
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.sqlvirtualmachine.SqlVirtualMachine;
import com.pulumi.azurenative.sqlvirtualmachine.SqlVirtualMachineArgs;
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 sqlVirtualMachine = new SqlVirtualMachine("sqlVirtualMachine", SqlVirtualMachineArgs.builder()
.location("northeurope")
.resourceGroupName("testrg")
.sqlVirtualMachineName("testvm")
.storageConfigurationSettings(Map.ofEntries(
Map.entry("diskConfigurationType", "EXTEND"),
Map.entry("sqlDataSettings", Map.of("luns", 2))
))
.virtualMachineResourceId("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm")
.build());
}
}
import pulumi
import pulumi_azure_native as azure_native
sql_virtual_machine = azure_native.sqlvirtualmachine.SqlVirtualMachine("sqlVirtualMachine",
location="northeurope",
resource_group_name="testrg",
sql_virtual_machine_name="testvm",
storage_configuration_settings=azure_native.sqlvirtualmachine.StorageConfigurationSettingsResponseArgs(
disk_configuration_type="EXTEND",
sql_data_settings=azure_native.sqlvirtualmachine.SQLStorageSettingsArgs(
luns=[2],
),
),
virtual_machine_resource_id="/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm")
import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";
const sqlVirtualMachine = new azure_native.sqlvirtualmachine.SqlVirtualMachine("sqlVirtualMachine", {
location: "northeurope",
resourceGroupName: "testrg",
sqlVirtualMachineName: "testvm",
storageConfigurationSettings: {
diskConfigurationType: "EXTEND",
sqlDataSettings: {
luns: [2],
},
},
virtualMachineResourceId: "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm",
});
resources:
sqlVirtualMachine:
type: azure-native:sqlvirtualmachine:SqlVirtualMachine
properties:
location: northeurope
resourceGroupName: testrg
sqlVirtualMachineName: testvm
storageConfigurationSettings:
diskConfigurationType: EXTEND
sqlDataSettings:
luns:
- 2
virtualMachineResourceId: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm
Creates or updates a SQL virtual machine for Storage Configuration Settings to NEW Data, Log and TempDB storage pool.
using System.Collections.Generic;
using Pulumi;
using AzureNative = Pulumi.AzureNative;
return await Deployment.RunAsync(() =>
{
var sqlVirtualMachine = new AzureNative.SqlVirtualMachine.SqlVirtualMachine("sqlVirtualMachine", new()
{
Location = "northeurope",
ResourceGroupName = "testrg",
SqlVirtualMachineName = "testvm",
StorageConfigurationSettings = new AzureNative.SqlVirtualMachine.Inputs.StorageConfigurationSettingsArgs
{
DiskConfigurationType = "NEW",
SqlDataSettings = new AzureNative.SqlVirtualMachine.Inputs.SQLStorageSettingsArgs
{
DefaultFilePath = "F:\\folderpath\\",
Luns = new[]
{
0,
},
},
SqlLogSettings = new AzureNative.SqlVirtualMachine.Inputs.SQLStorageSettingsArgs
{
DefaultFilePath = "G:\\folderpath\\",
Luns = new[]
{
1,
},
},
SqlTempDbSettings = new AzureNative.SqlVirtualMachine.Inputs.SQLStorageSettingsArgs
{
DefaultFilePath = "D:\\TEMP",
},
StorageWorkloadType = "OLTP",
},
VirtualMachineResourceId = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm",
});
});
package main
import (
sqlvirtualmachine "github.com/pulumi/pulumi-azure-native/sdk/go/azure/sqlvirtualmachine"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := sqlvirtualmachine.NewSqlVirtualMachine(ctx, "sqlVirtualMachine", &sqlvirtualmachine.SqlVirtualMachineArgs{
Location: pulumi.String("northeurope"),
ResourceGroupName: pulumi.String("testrg"),
SqlVirtualMachineName: pulumi.String("testvm"),
StorageConfigurationSettings: sqlvirtualmachine.StorageConfigurationSettingsResponse{
DiskConfigurationType: pulumi.String("NEW"),
SqlDataSettings: &sqlvirtualmachine.SQLStorageSettingsArgs{
DefaultFilePath: pulumi.String("F:\\folderpath\\"),
Luns: pulumi.IntArray{
pulumi.Int(0),
},
},
SqlLogSettings: &sqlvirtualmachine.SQLStorageSettingsArgs{
DefaultFilePath: pulumi.String("G:\\folderpath\\"),
Luns: pulumi.IntArray{
pulumi.Int(1),
},
},
SqlTempDbSettings: &sqlvirtualmachine.SQLStorageSettingsArgs{
DefaultFilePath: pulumi.String("D:\\TEMP"),
},
StorageWorkloadType: pulumi.String("OLTP"),
},
VirtualMachineResourceId: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm"),
})
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.sqlvirtualmachine.SqlVirtualMachine;
import com.pulumi.azurenative.sqlvirtualmachine.SqlVirtualMachineArgs;
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 sqlVirtualMachine = new SqlVirtualMachine("sqlVirtualMachine", SqlVirtualMachineArgs.builder()
.location("northeurope")
.resourceGroupName("testrg")
.sqlVirtualMachineName("testvm")
.storageConfigurationSettings(Map.ofEntries(
Map.entry("diskConfigurationType", "NEW"),
Map.entry("sqlDataSettings", Map.ofEntries(
Map.entry("defaultFilePath", "F:\\folderpath\\"),
Map.entry("luns", 0)
)),
Map.entry("sqlLogSettings", Map.ofEntries(
Map.entry("defaultFilePath", "G:\\folderpath\\"),
Map.entry("luns", 1)
)),
Map.entry("sqlTempDbSettings", Map.of("defaultFilePath", "D:\\TEMP")),
Map.entry("storageWorkloadType", "OLTP")
))
.virtualMachineResourceId("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm")
.build());
}
}
import pulumi
import pulumi_azure_native as azure_native
sql_virtual_machine = azure_native.sqlvirtualmachine.SqlVirtualMachine("sqlVirtualMachine",
location="northeurope",
resource_group_name="testrg",
sql_virtual_machine_name="testvm",
storage_configuration_settings=azure_native.sqlvirtualmachine.StorageConfigurationSettingsResponseArgs(
disk_configuration_type="NEW",
sql_data_settings=azure_native.sqlvirtualmachine.SQLStorageSettingsArgs(
default_file_path="F:\\folderpath\\",
luns=[0],
),
sql_log_settings=azure_native.sqlvirtualmachine.SQLStorageSettingsArgs(
default_file_path="G:\\folderpath\\",
luns=[1],
),
sql_temp_db_settings=azure_native.sqlvirtualmachine.SQLStorageSettingsArgs(
default_file_path="D:\\TEMP",
),
storage_workload_type="OLTP",
),
virtual_machine_resource_id="/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm")
import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";
const sqlVirtualMachine = new azure_native.sqlvirtualmachine.SqlVirtualMachine("sqlVirtualMachine", {
location: "northeurope",
resourceGroupName: "testrg",
sqlVirtualMachineName: "testvm",
storageConfigurationSettings: {
diskConfigurationType: "NEW",
sqlDataSettings: {
defaultFilePath: "F:\\folderpath\\",
luns: [0],
},
sqlLogSettings: {
defaultFilePath: "G:\\folderpath\\",
luns: [1],
},
sqlTempDbSettings: {
defaultFilePath: "D:\\TEMP",
},
storageWorkloadType: "OLTP",
},
virtualMachineResourceId: "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm",
});
resources:
sqlVirtualMachine:
type: azure-native:sqlvirtualmachine:SqlVirtualMachine
properties:
location: northeurope
resourceGroupName: testrg
sqlVirtualMachineName: testvm
storageConfigurationSettings:
diskConfigurationType: NEW
sqlDataSettings:
defaultFilePath: F:\folderpath\
luns:
- 0
sqlLogSettings:
defaultFilePath: G:\folderpath\
luns:
- 1
sqlTempDbSettings:
defaultFilePath: D:\TEMP
storageWorkloadType: OLTP
virtualMachineResourceId: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm
Creates or updates a SQL virtual machine with max parameters.
using System.Collections.Generic;
using Pulumi;
using AzureNative = Pulumi.AzureNative;
return await Deployment.RunAsync(() =>
{
var sqlVirtualMachine = new AzureNative.SqlVirtualMachine.SqlVirtualMachine("sqlVirtualMachine", new()
{
AutoBackupSettings = new AzureNative.SqlVirtualMachine.Inputs.AutoBackupSettingsArgs
{
BackupScheduleType = "Manual",
BackupSystemDbs = true,
Enable = true,
EnableEncryption = true,
FullBackupFrequency = "Daily",
FullBackupStartTime = 6,
FullBackupWindowHours = 11,
LogBackupFrequency = 10,
Password = "<Password>",
RetentionPeriod = 17,
StorageAccessKey = "<primary storage access key>",
StorageAccountUrl = "https://teststorage.blob.core.windows.net/",
},
AutoPatchingSettings = new AzureNative.SqlVirtualMachine.Inputs.AutoPatchingSettingsArgs
{
DayOfWeek = AzureNative.SqlVirtualMachine.DayOfWeek.Sunday,
Enable = true,
MaintenanceWindowDuration = 60,
MaintenanceWindowStartingHour = 2,
},
KeyVaultCredentialSettings = new AzureNative.SqlVirtualMachine.Inputs.KeyVaultCredentialSettingsArgs
{
Enable = false,
},
Location = "northeurope",
ResourceGroupName = "testrg",
ServerConfigurationsManagementSettings = new AzureNative.SqlVirtualMachine.Inputs.ServerConfigurationsManagementSettingsArgs
{
AdditionalFeaturesServerConfigurations = new AzureNative.SqlVirtualMachine.Inputs.AdditionalFeaturesServerConfigurationsArgs
{
IsRServicesEnabled = false,
},
SqlConnectivityUpdateSettings = new AzureNative.SqlVirtualMachine.Inputs.SqlConnectivityUpdateSettingsArgs
{
ConnectivityType = "PRIVATE",
Port = 1433,
SqlAuthUpdatePassword = "<password>",
SqlAuthUpdateUserName = "sqllogin",
},
SqlStorageUpdateSettings = new AzureNative.SqlVirtualMachine.Inputs.SqlStorageUpdateSettingsArgs
{
DiskConfigurationType = "NEW",
DiskCount = 1,
StartingDeviceId = 2,
},
SqlWorkloadTypeUpdateSettings = new AzureNative.SqlVirtualMachine.Inputs.SqlWorkloadTypeUpdateSettingsArgs
{
SqlWorkloadType = "OLTP",
},
},
SqlImageSku = "Enterprise",
SqlManagement = "Full",
SqlServerLicenseType = "PAYG",
SqlVirtualMachineName = "testvm",
VirtualMachineResourceId = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm",
});
});
package main
import (
sqlvirtualmachine "github.com/pulumi/pulumi-azure-native/sdk/go/azure/sqlvirtualmachine"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := sqlvirtualmachine.NewSqlVirtualMachine(ctx, "sqlVirtualMachine", &sqlvirtualmachine.SqlVirtualMachineArgs{
AutoBackupSettings: &sqlvirtualmachine.AutoBackupSettingsArgs{
BackupScheduleType: pulumi.String("Manual"),
BackupSystemDbs: pulumi.Bool(true),
Enable: pulumi.Bool(true),
EnableEncryption: pulumi.Bool(true),
FullBackupFrequency: pulumi.String("Daily"),
FullBackupStartTime: pulumi.Int(6),
FullBackupWindowHours: pulumi.Int(11),
LogBackupFrequency: pulumi.Int(10),
Password: pulumi.String("<Password>"),
RetentionPeriod: pulumi.Int(17),
StorageAccessKey: pulumi.String("<primary storage access key>"),
StorageAccountUrl: pulumi.String("https://teststorage.blob.core.windows.net/"),
},
AutoPatchingSettings: &sqlvirtualmachine.AutoPatchingSettingsArgs{
DayOfWeek: sqlvirtualmachine.DayOfWeekSunday,
Enable: pulumi.Bool(true),
MaintenanceWindowDuration: pulumi.Int(60),
MaintenanceWindowStartingHour: pulumi.Int(2),
},
KeyVaultCredentialSettings: &sqlvirtualmachine.KeyVaultCredentialSettingsArgs{
Enable: pulumi.Bool(false),
},
Location: pulumi.String("northeurope"),
ResourceGroupName: pulumi.String("testrg"),
ServerConfigurationsManagementSettings: sqlvirtualmachine.ServerConfigurationsManagementSettingsResponse{
AdditionalFeaturesServerConfigurations: &sqlvirtualmachine.AdditionalFeaturesServerConfigurationsArgs{
IsRServicesEnabled: pulumi.Bool(false),
},
SqlConnectivityUpdateSettings: &sqlvirtualmachine.SqlConnectivityUpdateSettingsArgs{
ConnectivityType: pulumi.String("PRIVATE"),
Port: pulumi.Int(1433),
SqlAuthUpdatePassword: pulumi.String("<password>"),
SqlAuthUpdateUserName: pulumi.String("sqllogin"),
},
SqlStorageUpdateSettings: &sqlvirtualmachine.SqlStorageUpdateSettingsArgs{
DiskConfigurationType: pulumi.String("NEW"),
DiskCount: pulumi.Int(1),
StartingDeviceId: pulumi.Int(2),
},
SqlWorkloadTypeUpdateSettings: &sqlvirtualmachine.SqlWorkloadTypeUpdateSettingsArgs{
SqlWorkloadType: pulumi.String("OLTP"),
},
},
SqlImageSku: pulumi.String("Enterprise"),
SqlManagement: pulumi.String("Full"),
SqlServerLicenseType: pulumi.String("PAYG"),
SqlVirtualMachineName: pulumi.String("testvm"),
VirtualMachineResourceId: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm"),
})
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.sqlvirtualmachine.SqlVirtualMachine;
import com.pulumi.azurenative.sqlvirtualmachine.SqlVirtualMachineArgs;
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 sqlVirtualMachine = new SqlVirtualMachine("sqlVirtualMachine", SqlVirtualMachineArgs.builder()
.autoBackupSettings(Map.ofEntries(
Map.entry("backupScheduleType", "Manual"),
Map.entry("backupSystemDbs", true),
Map.entry("enable", true),
Map.entry("enableEncryption", true),
Map.entry("fullBackupFrequency", "Daily"),
Map.entry("fullBackupStartTime", 6),
Map.entry("fullBackupWindowHours", 11),
Map.entry("logBackupFrequency", 10),
Map.entry("password", "<Password>"),
Map.entry("retentionPeriod", 17),
Map.entry("storageAccessKey", "<primary storage access key>"),
Map.entry("storageAccountUrl", "https://teststorage.blob.core.windows.net/")
))
.autoPatchingSettings(Map.ofEntries(
Map.entry("dayOfWeek", "Sunday"),
Map.entry("enable", true),
Map.entry("maintenanceWindowDuration", 60),
Map.entry("maintenanceWindowStartingHour", 2)
))
.keyVaultCredentialSettings(Map.of("enable", false))
.location("northeurope")
.resourceGroupName("testrg")
.serverConfigurationsManagementSettings(Map.ofEntries(
Map.entry("additionalFeaturesServerConfigurations", Map.of("isRServicesEnabled", false)),
Map.entry("sqlConnectivityUpdateSettings", Map.ofEntries(
Map.entry("connectivityType", "PRIVATE"),
Map.entry("port", 1433),
Map.entry("sqlAuthUpdatePassword", "<password>"),
Map.entry("sqlAuthUpdateUserName", "sqllogin")
)),
Map.entry("sqlStorageUpdateSettings", Map.ofEntries(
Map.entry("diskConfigurationType", "NEW"),
Map.entry("diskCount", 1),
Map.entry("startingDeviceId", 2)
)),
Map.entry("sqlWorkloadTypeUpdateSettings", Map.of("sqlWorkloadType", "OLTP"))
))
.sqlImageSku("Enterprise")
.sqlManagement("Full")
.sqlServerLicenseType("PAYG")
.sqlVirtualMachineName("testvm")
.virtualMachineResourceId("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm")
.build());
}
}
import pulumi
import pulumi_azure_native as azure_native
sql_virtual_machine = azure_native.sqlvirtualmachine.SqlVirtualMachine("sqlVirtualMachine",
auto_backup_settings=azure_native.sqlvirtualmachine.AutoBackupSettingsArgs(
backup_schedule_type="Manual",
backup_system_dbs=True,
enable=True,
enable_encryption=True,
full_backup_frequency="Daily",
full_backup_start_time=6,
full_backup_window_hours=11,
log_backup_frequency=10,
password="<Password>",
retention_period=17,
storage_access_key="<primary storage access key>",
storage_account_url="https://teststorage.blob.core.windows.net/",
),
auto_patching_settings=azure_native.sqlvirtualmachine.AutoPatchingSettingsArgs(
day_of_week=azure_native.sqlvirtualmachine.DayOfWeek.SUNDAY,
enable=True,
maintenance_window_duration=60,
maintenance_window_starting_hour=2,
),
key_vault_credential_settings=azure_native.sqlvirtualmachine.KeyVaultCredentialSettingsArgs(
enable=False,
),
location="northeurope",
resource_group_name="testrg",
server_configurations_management_settings=azure_native.sqlvirtualmachine.ServerConfigurationsManagementSettingsResponseArgs(
additional_features_server_configurations=azure_native.sqlvirtualmachine.AdditionalFeaturesServerConfigurationsArgs(
is_r_services_enabled=False,
),
sql_connectivity_update_settings=azure_native.sqlvirtualmachine.SqlConnectivityUpdateSettingsArgs(
connectivity_type="PRIVATE",
port=1433,
sql_auth_update_password="<password>",
sql_auth_update_user_name="sqllogin",
),
sql_storage_update_settings=azure_native.sqlvirtualmachine.SqlStorageUpdateSettingsArgs(
disk_configuration_type="NEW",
disk_count=1,
starting_device_id=2,
),
sql_workload_type_update_settings=azure_native.sqlvirtualmachine.SqlWorkloadTypeUpdateSettingsArgs(
sql_workload_type="OLTP",
),
),
sql_image_sku="Enterprise",
sql_management="Full",
sql_server_license_type="PAYG",
sql_virtual_machine_name="testvm",
virtual_machine_resource_id="/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm")
import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";
const sqlVirtualMachine = new azure_native.sqlvirtualmachine.SqlVirtualMachine("sqlVirtualMachine", {
autoBackupSettings: {
backupScheduleType: "Manual",
backupSystemDbs: true,
enable: true,
enableEncryption: true,
fullBackupFrequency: "Daily",
fullBackupStartTime: 6,
fullBackupWindowHours: 11,
logBackupFrequency: 10,
password: "<Password>",
retentionPeriod: 17,
storageAccessKey: "<primary storage access key>",
storageAccountUrl: "https://teststorage.blob.core.windows.net/",
},
autoPatchingSettings: {
dayOfWeek: azure_native.sqlvirtualmachine.DayOfWeek.Sunday,
enable: true,
maintenanceWindowDuration: 60,
maintenanceWindowStartingHour: 2,
},
keyVaultCredentialSettings: {
enable: false,
},
location: "northeurope",
resourceGroupName: "testrg",
serverConfigurationsManagementSettings: {
additionalFeaturesServerConfigurations: {
isRServicesEnabled: false,
},
sqlConnectivityUpdateSettings: {
connectivityType: "PRIVATE",
port: 1433,
sqlAuthUpdatePassword: "<password>",
sqlAuthUpdateUserName: "sqllogin",
},
sqlStorageUpdateSettings: {
diskConfigurationType: "NEW",
diskCount: 1,
startingDeviceId: 2,
},
sqlWorkloadTypeUpdateSettings: {
sqlWorkloadType: "OLTP",
},
},
sqlImageSku: "Enterprise",
sqlManagement: "Full",
sqlServerLicenseType: "PAYG",
sqlVirtualMachineName: "testvm",
virtualMachineResourceId: "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm",
});
resources:
sqlVirtualMachine:
type: azure-native:sqlvirtualmachine:SqlVirtualMachine
properties:
autoBackupSettings:
backupScheduleType: Manual
backupSystemDbs: true
enable: true
enableEncryption: true
fullBackupFrequency: Daily
fullBackupStartTime: 6
fullBackupWindowHours: 11
logBackupFrequency: 10
password: <Password>
retentionPeriod: 17
storageAccessKey: <primary storage access key>
storageAccountUrl: https://teststorage.blob.core.windows.net/
autoPatchingSettings:
dayOfWeek: Sunday
enable: true
maintenanceWindowDuration: 60
maintenanceWindowStartingHour: 2
keyVaultCredentialSettings:
enable: false
location: northeurope
resourceGroupName: testrg
serverConfigurationsManagementSettings:
additionalFeaturesServerConfigurations:
isRServicesEnabled: false
sqlConnectivityUpdateSettings:
connectivityType: PRIVATE
port: 1433
sqlAuthUpdatePassword: <password>
sqlAuthUpdateUserName: sqllogin
sqlStorageUpdateSettings:
diskConfigurationType: NEW
diskCount: 1
startingDeviceId: 2
sqlWorkloadTypeUpdateSettings:
sqlWorkloadType: OLTP
sqlImageSku: Enterprise
sqlManagement: Full
sqlServerLicenseType: PAYG
sqlVirtualMachineName: testvm
virtualMachineResourceId: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm
Creates or updates a SQL virtual machine with min parameters.
using System.Collections.Generic;
using Pulumi;
using AzureNative = Pulumi.AzureNative;
return await Deployment.RunAsync(() =>
{
var sqlVirtualMachine = new AzureNative.SqlVirtualMachine.SqlVirtualMachine("sqlVirtualMachine", new()
{
Location = "northeurope",
ResourceGroupName = "testrg",
SqlVirtualMachineName = "testvm",
VirtualMachineResourceId = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm",
});
});
package main
import (
sqlvirtualmachine "github.com/pulumi/pulumi-azure-native/sdk/go/azure/sqlvirtualmachine"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := sqlvirtualmachine.NewSqlVirtualMachine(ctx, "sqlVirtualMachine", &sqlvirtualmachine.SqlVirtualMachineArgs{
Location: pulumi.String("northeurope"),
ResourceGroupName: pulumi.String("testrg"),
SqlVirtualMachineName: pulumi.String("testvm"),
VirtualMachineResourceId: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm"),
})
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.sqlvirtualmachine.SqlVirtualMachine;
import com.pulumi.azurenative.sqlvirtualmachine.SqlVirtualMachineArgs;
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 sqlVirtualMachine = new SqlVirtualMachine("sqlVirtualMachine", SqlVirtualMachineArgs.builder()
.location("northeurope")
.resourceGroupName("testrg")
.sqlVirtualMachineName("testvm")
.virtualMachineResourceId("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm")
.build());
}
}
import pulumi
import pulumi_azure_native as azure_native
sql_virtual_machine = azure_native.sqlvirtualmachine.SqlVirtualMachine("sqlVirtualMachine",
location="northeurope",
resource_group_name="testrg",
sql_virtual_machine_name="testvm",
virtual_machine_resource_id="/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm")
import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";
const sqlVirtualMachine = new azure_native.sqlvirtualmachine.SqlVirtualMachine("sqlVirtualMachine", {
location: "northeurope",
resourceGroupName: "testrg",
sqlVirtualMachineName: "testvm",
virtualMachineResourceId: "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm",
});
resources:
sqlVirtualMachine:
type: azure-native:sqlvirtualmachine:SqlVirtualMachine
properties:
location: northeurope
resourceGroupName: testrg
sqlVirtualMachineName: testvm
virtualMachineResourceId: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm
Create SqlVirtualMachine Resource
new SqlVirtualMachine(name: string, args: SqlVirtualMachineArgs, opts?: CustomResourceOptions);
@overload
def SqlVirtualMachine(resource_name: str,
opts: Optional[ResourceOptions] = None,
auto_backup_settings: Optional[AutoBackupSettingsArgs] = None,
auto_patching_settings: Optional[AutoPatchingSettingsArgs] = None,
identity: Optional[ResourceIdentityArgs] = None,
key_vault_credential_settings: Optional[KeyVaultCredentialSettingsArgs] = None,
location: Optional[str] = None,
resource_group_name: Optional[str] = None,
server_configurations_management_settings: Optional[ServerConfigurationsManagementSettingsArgs] = None,
sql_image_offer: Optional[str] = None,
sql_image_sku: Optional[Union[str, SqlImageSku]] = None,
sql_management: Optional[Union[str, SqlManagementMode]] = None,
sql_server_license_type: Optional[Union[str, SqlServerLicenseType]] = None,
sql_virtual_machine_group_resource_id: Optional[str] = None,
sql_virtual_machine_name: Optional[str] = None,
storage_configuration_settings: Optional[StorageConfigurationSettingsArgs] = None,
tags: Optional[Mapping[str, str]] = None,
virtual_machine_resource_id: Optional[str] = None,
wsfc_domain_credentials: Optional[WsfcDomainCredentialsArgs] = None)
@overload
def SqlVirtualMachine(resource_name: str,
args: SqlVirtualMachineArgs,
opts: Optional[ResourceOptions] = None)
func NewSqlVirtualMachine(ctx *Context, name string, args SqlVirtualMachineArgs, opts ...ResourceOption) (*SqlVirtualMachine, error)
public SqlVirtualMachine(string name, SqlVirtualMachineArgs args, CustomResourceOptions? opts = null)
public SqlVirtualMachine(String name, SqlVirtualMachineArgs args)
public SqlVirtualMachine(String name, SqlVirtualMachineArgs args, CustomResourceOptions options)
type: azure-native:sqlvirtualmachine:SqlVirtualMachine
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.
- name string
- The unique name of the resource.
- args SqlVirtualMachineArgs
- 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 SqlVirtualMachineArgs
- 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 SqlVirtualMachineArgs
- The arguments to resource properties.
- opts ResourceOption
- Bag of options to control resource's behavior.
- name string
- The unique name of the resource.
- args SqlVirtualMachineArgs
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- name String
- The unique name of the resource.
- args SqlVirtualMachineArgs
- The arguments to resource properties.
- options CustomResourceOptions
- Bag of options to control resource's behavior.
SqlVirtualMachine 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 SqlVirtualMachine resource accepts the following input properties:
- Resource
Group stringName Name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
- Auto
Backup Pulumi.Settings Azure Native. Sql Virtual Machine. Inputs. Auto Backup Settings Args Auto backup settings for SQL Server.
- Auto
Patching Pulumi.Settings Azure Native. Sql Virtual Machine. Inputs. Auto Patching Settings Args Auto patching settings for applying critical security updates to SQL virtual machine.
- Identity
Pulumi.
Azure Native. Sql Virtual Machine. Inputs. Resource Identity Args Azure Active Directory identity of the server.
- Key
Vault Pulumi.Credential Settings Azure Native. Sql Virtual Machine. Inputs. Key Vault Credential Settings Args Key vault credential settings.
- Location string
Resource location.
- Server
Configurations Pulumi.Management Settings Azure Native. Sql Virtual Machine. Inputs. Server Configurations Management Settings Args SQL Server configuration management settings.
- Sql
Image stringOffer SQL image offer. Examples include SQL2016-WS2016, SQL2017-WS2016.
- Sql
Image string | Pulumi.Sku Azure Native. Sql Virtual Machine. Sql Image Sku SQL Server edition type.
- Sql
Management string | Pulumi.Azure Native. Sql Virtual Machine. Sql Management Mode SQL Server Management type.
- Sql
Server string | Pulumi.License Type Azure Native. Sql Virtual Machine. Sql Server License Type SQL Server license type.
- Sql
Virtual stringMachine Group Resource Id ARM resource id of the SQL virtual machine group this SQL virtual machine is or will be part of.
- Sql
Virtual stringMachine Name Name of the SQL virtual machine.
- Storage
Configuration Pulumi.Settings Azure Native. Sql Virtual Machine. Inputs. Storage Configuration Settings Args Storage Configuration Settings.
- Dictionary<string, string>
Resource tags.
- Virtual
Machine stringResource Id ARM Resource id of underlying virtual machine created from SQL marketplace image.
- Wsfc
Domain Pulumi.Credentials Azure Native. Sql Virtual Machine. Inputs. Wsfc Domain Credentials Args Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.
- Resource
Group stringName Name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
- Auto
Backup AutoSettings Backup Settings Args Auto backup settings for SQL Server.
- Auto
Patching AutoSettings Patching Settings Args Auto patching settings for applying critical security updates to SQL virtual machine.
- Identity
Resource
Identity Args Azure Active Directory identity of the server.
- Key
Vault KeyCredential Settings Vault Credential Settings Args Key vault credential settings.
- Location string
Resource location.
- Server
Configurations ServerManagement Settings Configurations Management Settings Args SQL Server configuration management settings.
- Sql
Image stringOffer SQL image offer. Examples include SQL2016-WS2016, SQL2017-WS2016.
- Sql
Image string | SqlSku Image Sku SQL Server edition type.
- Sql
Management string | SqlManagement Mode SQL Server Management type.
- Sql
Server string | SqlLicense Type Server License Type SQL Server license type.
- Sql
Virtual stringMachine Group Resource Id ARM resource id of the SQL virtual machine group this SQL virtual machine is or will be part of.
- Sql
Virtual stringMachine Name Name of the SQL virtual machine.
- Storage
Configuration StorageSettings Configuration Settings Args Storage Configuration Settings.
- map[string]string
Resource tags.
- Virtual
Machine stringResource Id ARM Resource id of underlying virtual machine created from SQL marketplace image.
- Wsfc
Domain WsfcCredentials Domain Credentials Args Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.
- resource
Group StringName Name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
- auto
Backup AutoSettings Backup Settings Args Auto backup settings for SQL Server.
- auto
Patching AutoSettings Patching Settings Args Auto patching settings for applying critical security updates to SQL virtual machine.
- identity
Resource
Identity Args Azure Active Directory identity of the server.
- key
Vault KeyCredential Settings Vault Credential Settings Args Key vault credential settings.
- location String
Resource location.
- server
Configurations ServerManagement Settings Configurations Management Settings Args SQL Server configuration management settings.
- sql
Image StringOffer SQL image offer. Examples include SQL2016-WS2016, SQL2017-WS2016.
- sql
Image String | SqlSku Image Sku SQL Server edition type.
- sql
Management String | SqlManagement Mode SQL Server Management type.
- sql
Server String | SqlLicense Type Server License Type SQL Server license type.
- sql
Virtual StringMachine Group Resource Id ARM resource id of the SQL virtual machine group this SQL virtual machine is or will be part of.
- sql
Virtual StringMachine Name Name of the SQL virtual machine.
- storage
Configuration StorageSettings Configuration Settings Args Storage Configuration Settings.
- Map<String,String>
Resource tags.
- virtual
Machine StringResource Id ARM Resource id of underlying virtual machine created from SQL marketplace image.
- wsfc
Domain WsfcCredentials Domain Credentials Args Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.
- resource
Group stringName Name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
- auto
Backup AutoSettings Backup Settings Args Auto backup settings for SQL Server.
- auto
Patching AutoSettings Patching Settings Args Auto patching settings for applying critical security updates to SQL virtual machine.
- identity
Resource
Identity Args Azure Active Directory identity of the server.
- key
Vault KeyCredential Settings Vault Credential Settings Args Key vault credential settings.
- location string
Resource location.
- server
Configurations ServerManagement Settings Configurations Management Settings Args SQL Server configuration management settings.
- sql
Image stringOffer SQL image offer. Examples include SQL2016-WS2016, SQL2017-WS2016.
- sql
Image string | SqlSku Image Sku SQL Server edition type.
- sql
Management string | SqlManagement Mode SQL Server Management type.
- sql
Server string | SqlLicense Type Server License Type SQL Server license type.
- sql
Virtual stringMachine Group Resource Id ARM resource id of the SQL virtual machine group this SQL virtual machine is or will be part of.
- sql
Virtual stringMachine Name Name of the SQL virtual machine.
- storage
Configuration StorageSettings Configuration Settings Args Storage Configuration Settings.
- {[key: string]: string}
Resource tags.
- virtual
Machine stringResource Id ARM Resource id of underlying virtual machine created from SQL marketplace image.
- wsfc
Domain WsfcCredentials Domain Credentials Args Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.
- resource_
group_ strname Name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
- auto_
backup_ Autosettings Backup Settings Args Auto backup settings for SQL Server.
- auto_
patching_ Autosettings Patching Settings Args Auto patching settings for applying critical security updates to SQL virtual machine.
- identity
Resource
Identity Args Azure Active Directory identity of the server.
- key_
vault_ Keycredential_ settings Vault Credential Settings Args Key vault credential settings.
- location str
Resource location.
- server_
configurations_ Servermanagement_ settings Configurations Management Settings Args SQL Server configuration management settings.
- sql_
image_ stroffer SQL image offer. Examples include SQL2016-WS2016, SQL2017-WS2016.
- sql_
image_ str | Sqlsku Image Sku SQL Server edition type.
- sql_
management str | SqlManagement Mode SQL Server Management type.
- sql_
server_ str | Sqllicense_ type Server License Type SQL Server license type.
- sql_
virtual_ strmachine_ group_ resource_ id ARM resource id of the SQL virtual machine group this SQL virtual machine is or will be part of.
- sql_
virtual_ strmachine_ name Name of the SQL virtual machine.
- storage_
configuration_ Storagesettings Configuration Settings Args Storage Configuration Settings.
- Mapping[str, str]
Resource tags.
- virtual_
machine_ strresource_ id ARM Resource id of underlying virtual machine created from SQL marketplace image.
- wsfc_
domain_ Wsfccredentials Domain Credentials Args Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.
- resource
Group StringName Name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
- auto
Backup Property MapSettings Auto backup settings for SQL Server.
- auto
Patching Property MapSettings Auto patching settings for applying critical security updates to SQL virtual machine.
- identity Property Map
Azure Active Directory identity of the server.
- key
Vault Property MapCredential Settings Key vault credential settings.
- location String
Resource location.
- server
Configurations Property MapManagement Settings SQL Server configuration management settings.
- sql
Image StringOffer SQL image offer. Examples include SQL2016-WS2016, SQL2017-WS2016.
- sql
Image String | "Developer" | "Express" | "Standard" | "Enterprise" | "Web"Sku SQL Server edition type.
- sql
Management String | "Full" | "LightWeight" | "No Agent" SQL Server Management type.
- sql
Server String | "PAYG" | "AHUB" | "DR"License Type SQL Server license type.
- sql
Virtual StringMachine Group Resource Id ARM resource id of the SQL virtual machine group this SQL virtual machine is or will be part of.
- sql
Virtual StringMachine Name Name of the SQL virtual machine.
- storage
Configuration Property MapSettings Storage Configuration Settings.
- Map<String>
Resource tags.
- virtual
Machine StringResource Id ARM Resource id of underlying virtual machine created from SQL marketplace image.
- wsfc
Domain Property MapCredentials Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.
Outputs
All input properties are implicitly available as output properties. Additionally, the SqlVirtualMachine resource produces the following output properties:
- Id string
The provider-assigned unique ID for this managed resource.
- Name string
Resource name.
- Provisioning
State string Provisioning state to track the async operation status.
- Type string
Resource type.
- Id string
The provider-assigned unique ID for this managed resource.
- Name string
Resource name.
- Provisioning
State string Provisioning state to track the async operation status.
- Type string
Resource type.
- id String
The provider-assigned unique ID for this managed resource.
- name String
Resource name.
- provisioning
State String Provisioning state to track the async operation status.
- type String
Resource type.
- id string
The provider-assigned unique ID for this managed resource.
- name string
Resource name.
- provisioning
State string Provisioning state to track the async operation status.
- type string
Resource type.
- id str
The provider-assigned unique ID for this managed resource.
- name str
Resource name.
- provisioning_
state str Provisioning state to track the async operation status.
- type str
Resource type.
- id String
The provider-assigned unique ID for this managed resource.
- name String
Resource name.
- provisioning
State String Provisioning state to track the async operation status.
- type String
Resource type.
Supporting Types
AdditionalFeaturesServerConfigurations
- Is
RServices boolEnabled Enable or disable R services (SQL 2016 onwards).
- Is
RServices boolEnabled Enable or disable R services (SQL 2016 onwards).
- is
RServices BooleanEnabled Enable or disable R services (SQL 2016 onwards).
- is
RServices booleanEnabled Enable or disable R services (SQL 2016 onwards).
- is_
r_ boolservices_ enabled Enable or disable R services (SQL 2016 onwards).
- is
RServices BooleanEnabled Enable or disable R services (SQL 2016 onwards).
AdditionalFeaturesServerConfigurationsResponse
- Is
RServices boolEnabled Enable or disable R services (SQL 2016 onwards).
- Is
RServices boolEnabled Enable or disable R services (SQL 2016 onwards).
- is
RServices BooleanEnabled Enable or disable R services (SQL 2016 onwards).
- is
RServices booleanEnabled Enable or disable R services (SQL 2016 onwards).
- is_
r_ boolservices_ enabled Enable or disable R services (SQL 2016 onwards).
- is
RServices BooleanEnabled Enable or disable R services (SQL 2016 onwards).
AutoBackupSettings
- Backup
Schedule string | Pulumi.Type Azure Native. Sql Virtual Machine. Backup Schedule Type Backup schedule type.
- Backup
System boolDbs Include or exclude system databases from auto backup.
- Enable bool
Enable or disable autobackup on SQL virtual machine.
- Enable
Encryption bool Enable or disable encryption for backup on SQL virtual machine.
- Full
Backup string | Pulumi.Frequency Azure Native. Sql Virtual Machine. Full Backup Frequency Type Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
- Full
Backup intStart Time Start time of a given day during which full backups can take place. 0-23 hours.
- Full
Backup intWindow Hours Duration of the time window of a given day during which full backups can take place. 1-23 hours.
- Log
Backup intFrequency Frequency of log backups. 5-60 minutes.
- Password string
Password for encryption on backup.
- Retention
Period int Retention period of backup: 1-30 days.
- Storage
Access stringKey Storage account key where backup will be taken to.
- Storage
Account stringUrl Storage account url where backup will be taken to.
- Backup
Schedule string | BackupType Schedule Type Backup schedule type.
- Backup
System boolDbs Include or exclude system databases from auto backup.
- Enable bool
Enable or disable autobackup on SQL virtual machine.
- Enable
Encryption bool Enable or disable encryption for backup on SQL virtual machine.
- Full
Backup string | FullFrequency Backup Frequency Type Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
- Full
Backup intStart Time Start time of a given day during which full backups can take place. 0-23 hours.
- Full
Backup intWindow Hours Duration of the time window of a given day during which full backups can take place. 1-23 hours.
- Log
Backup intFrequency Frequency of log backups. 5-60 minutes.
- Password string
Password for encryption on backup.
- Retention
Period int Retention period of backup: 1-30 days.
- Storage
Access stringKey Storage account key where backup will be taken to.
- Storage
Account stringUrl Storage account url where backup will be taken to.
- backup
Schedule String | BackupType Schedule Type Backup schedule type.
- backup
System BooleanDbs Include or exclude system databases from auto backup.
- enable Boolean
Enable or disable autobackup on SQL virtual machine.
- enable
Encryption Boolean Enable or disable encryption for backup on SQL virtual machine.
- full
Backup String | FullFrequency Backup Frequency Type Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
- full
Backup IntegerStart Time Start time of a given day during which full backups can take place. 0-23 hours.
- full
Backup IntegerWindow Hours Duration of the time window of a given day during which full backups can take place. 1-23 hours.
- log
Backup IntegerFrequency Frequency of log backups. 5-60 minutes.
- password String
Password for encryption on backup.
- retention
Period Integer Retention period of backup: 1-30 days.
- storage
Access StringKey Storage account key where backup will be taken to.
- storage
Account StringUrl Storage account url where backup will be taken to.
- backup
Schedule string | BackupType Schedule Type Backup schedule type.
- backup
System booleanDbs Include or exclude system databases from auto backup.
- enable boolean
Enable or disable autobackup on SQL virtual machine.
- enable
Encryption boolean Enable or disable encryption for backup on SQL virtual machine.
- full
Backup string | FullFrequency Backup Frequency Type Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
- full
Backup numberStart Time Start time of a given day during which full backups can take place. 0-23 hours.
- full
Backup numberWindow Hours Duration of the time window of a given day during which full backups can take place. 1-23 hours.
- log
Backup numberFrequency Frequency of log backups. 5-60 minutes.
- password string
Password for encryption on backup.
- retention
Period number Retention period of backup: 1-30 days.
- storage
Access stringKey Storage account key where backup will be taken to.
- storage
Account stringUrl Storage account url where backup will be taken to.
- backup_
schedule_ str | Backuptype Schedule Type Backup schedule type.
- backup_
system_ booldbs Include or exclude system databases from auto backup.
- enable bool
Enable or disable autobackup on SQL virtual machine.
- enable_
encryption bool Enable or disable encryption for backup on SQL virtual machine.
- full_
backup_ str | Fullfrequency Backup Frequency Type Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
- full_
backup_ intstart_ time Start time of a given day during which full backups can take place. 0-23 hours.
- full_
backup_ intwindow_ hours Duration of the time window of a given day during which full backups can take place. 1-23 hours.
- log_
backup_ intfrequency Frequency of log backups. 5-60 minutes.
- password str
Password for encryption on backup.
- retention_
period int Retention period of backup: 1-30 days.
- storage_
access_ strkey Storage account key where backup will be taken to.
- storage_
account_ strurl Storage account url where backup will be taken to.
- backup
Schedule String | "Manual" | "Automated"Type Backup schedule type.
- backup
System BooleanDbs Include or exclude system databases from auto backup.
- enable Boolean
Enable or disable autobackup on SQL virtual machine.
- enable
Encryption Boolean Enable or disable encryption for backup on SQL virtual machine.
- full
Backup String | "Daily" | "Weekly"Frequency Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
- full
Backup NumberStart Time Start time of a given day during which full backups can take place. 0-23 hours.
- full
Backup NumberWindow Hours Duration of the time window of a given day during which full backups can take place. 1-23 hours.
- log
Backup NumberFrequency Frequency of log backups. 5-60 minutes.
- password String
Password for encryption on backup.
- retention
Period Number Retention period of backup: 1-30 days.
- storage
Access StringKey Storage account key where backup will be taken to.
- storage
Account StringUrl Storage account url where backup will be taken to.
AutoBackupSettingsResponse
- Backup
Schedule stringType Backup schedule type.
- Backup
System boolDbs Include or exclude system databases from auto backup.
- Enable bool
Enable or disable autobackup on SQL virtual machine.
- Enable
Encryption bool Enable or disable encryption for backup on SQL virtual machine.
- Full
Backup stringFrequency Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
- Full
Backup intStart Time Start time of a given day during which full backups can take place. 0-23 hours.
- Full
Backup intWindow Hours Duration of the time window of a given day during which full backups can take place. 1-23 hours.
- Log
Backup intFrequency Frequency of log backups. 5-60 minutes.
- Retention
Period int Retention period of backup: 1-30 days.
- Storage
Account stringUrl Storage account url where backup will be taken to.
- Backup
Schedule stringType Backup schedule type.
- Backup
System boolDbs Include or exclude system databases from auto backup.
- Enable bool
Enable or disable autobackup on SQL virtual machine.
- Enable
Encryption bool Enable or disable encryption for backup on SQL virtual machine.
- Full
Backup stringFrequency Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
- Full
Backup intStart Time Start time of a given day during which full backups can take place. 0-23 hours.
- Full
Backup intWindow Hours Duration of the time window of a given day during which full backups can take place. 1-23 hours.
- Log
Backup intFrequency Frequency of log backups. 5-60 minutes.
- Retention
Period int Retention period of backup: 1-30 days.
- Storage
Account stringUrl Storage account url where backup will be taken to.
- backup
Schedule StringType Backup schedule type.
- backup
System BooleanDbs Include or exclude system databases from auto backup.
- enable Boolean
Enable or disable autobackup on SQL virtual machine.
- enable
Encryption Boolean Enable or disable encryption for backup on SQL virtual machine.
- full
Backup StringFrequency Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
- full
Backup IntegerStart Time Start time of a given day during which full backups can take place. 0-23 hours.
- full
Backup IntegerWindow Hours Duration of the time window of a given day during which full backups can take place. 1-23 hours.
- log
Backup IntegerFrequency Frequency of log backups. 5-60 minutes.
- retention
Period Integer Retention period of backup: 1-30 days.
- storage
Account StringUrl Storage account url where backup will be taken to.
- backup
Schedule stringType Backup schedule type.
- backup
System booleanDbs Include or exclude system databases from auto backup.
- enable boolean
Enable or disable autobackup on SQL virtual machine.
- enable
Encryption boolean Enable or disable encryption for backup on SQL virtual machine.
- full
Backup stringFrequency Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
- full
Backup numberStart Time Start time of a given day during which full backups can take place. 0-23 hours.
- full
Backup numberWindow Hours Duration of the time window of a given day during which full backups can take place. 1-23 hours.
- log
Backup numberFrequency Frequency of log backups. 5-60 minutes.
- retention
Period number Retention period of backup: 1-30 days.
- storage
Account stringUrl Storage account url where backup will be taken to.
- backup_
schedule_ strtype Backup schedule type.
- backup_
system_ booldbs Include or exclude system databases from auto backup.
- enable bool
Enable or disable autobackup on SQL virtual machine.
- enable_
encryption bool Enable or disable encryption for backup on SQL virtual machine.
- full_
backup_ strfrequency Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
- full_
backup_ intstart_ time Start time of a given day during which full backups can take place. 0-23 hours.
- full_
backup_ intwindow_ hours Duration of the time window of a given day during which full backups can take place. 1-23 hours.
- log_
backup_ intfrequency Frequency of log backups. 5-60 minutes.
- retention_
period int Retention period of backup: 1-30 days.
- storage_
account_ strurl Storage account url where backup will be taken to.
- backup
Schedule StringType Backup schedule type.
- backup
System BooleanDbs Include or exclude system databases from auto backup.
- enable Boolean
Enable or disable autobackup on SQL virtual machine.
- enable
Encryption Boolean Enable or disable encryption for backup on SQL virtual machine.
- full
Backup StringFrequency Frequency of full backups. In both cases, full backups begin during the next scheduled time window.
- full
Backup NumberStart Time Start time of a given day during which full backups can take place. 0-23 hours.
- full
Backup NumberWindow Hours Duration of the time window of a given day during which full backups can take place. 1-23 hours.
- log
Backup NumberFrequency Frequency of log backups. 5-60 minutes.
- retention
Period Number Retention period of backup: 1-30 days.
- storage
Account StringUrl Storage account url where backup will be taken to.
AutoPatchingSettings
- Day
Of Pulumi.Week Azure Native. Sql Virtual Machine. Day Of Week Day of week to apply the patch on.
- Enable bool
Enable or disable autopatching on SQL virtual machine.
- Maintenance
Window intDuration Duration of patching.
- Maintenance
Window intStarting Hour Hour of the day when patching is initiated. Local VM time.
- Day
Of DayWeek Of Week Day of week to apply the patch on.
- Enable bool
Enable or disable autopatching on SQL virtual machine.
- Maintenance
Window intDuration Duration of patching.
- Maintenance
Window intStarting Hour Hour of the day when patching is initiated. Local VM time.
- day
Of DayWeek Of Week Day of week to apply the patch on.
- enable Boolean
Enable or disable autopatching on SQL virtual machine.
- maintenance
Window IntegerDuration Duration of patching.
- maintenance
Window IntegerStarting Hour Hour of the day when patching is initiated. Local VM time.
- day
Of DayWeek Of Week Day of week to apply the patch on.
- enable boolean
Enable or disable autopatching on SQL virtual machine.
- maintenance
Window numberDuration Duration of patching.
- maintenance
Window numberStarting Hour Hour of the day when patching is initiated. Local VM time.
- day_
of_ Dayweek Of Week Day of week to apply the patch on.
- enable bool
Enable or disable autopatching on SQL virtual machine.
- maintenance_
window_ intduration Duration of patching.
- maintenance_
window_ intstarting_ hour Hour of the day when patching is initiated. Local VM time.
- day
Of "Monday" | "Tuesday" | "Wednesday" | "Thursday" | "Friday" | "Saturday" | "Sunday"Week Day of week to apply the patch on.
- enable Boolean
Enable or disable autopatching on SQL virtual machine.
- maintenance
Window NumberDuration Duration of patching.
- maintenance
Window NumberStarting Hour Hour of the day when patching is initiated. Local VM time.
AutoPatchingSettingsResponse
- Day
Of stringWeek Day of week to apply the patch on.
- Enable bool
Enable or disable autopatching on SQL virtual machine.
- Maintenance
Window intDuration Duration of patching.
- Maintenance
Window intStarting Hour Hour of the day when patching is initiated. Local VM time.
- Day
Of stringWeek Day of week to apply the patch on.
- Enable bool
Enable or disable autopatching on SQL virtual machine.
- Maintenance
Window intDuration Duration of patching.
- Maintenance
Window intStarting Hour Hour of the day when patching is initiated. Local VM time.
- day
Of StringWeek Day of week to apply the patch on.
- enable Boolean
Enable or disable autopatching on SQL virtual machine.
- maintenance
Window IntegerDuration Duration of patching.
- maintenance
Window IntegerStarting Hour Hour of the day when patching is initiated. Local VM time.
- day
Of stringWeek Day of week to apply the patch on.
- enable boolean
Enable or disable autopatching on SQL virtual machine.
- maintenance
Window numberDuration Duration of patching.
- maintenance
Window numberStarting Hour Hour of the day when patching is initiated. Local VM time.
- day_
of_ strweek Day of week to apply the patch on.
- enable bool
Enable or disable autopatching on SQL virtual machine.
- maintenance_
window_ intduration Duration of patching.
- maintenance_
window_ intstarting_ hour Hour of the day when patching is initiated. Local VM time.
- day
Of StringWeek Day of week to apply the patch on.
- enable Boolean
Enable or disable autopatching on SQL virtual machine.
- maintenance
Window NumberDuration Duration of patching.
- maintenance
Window NumberStarting Hour Hour of the day when patching is initiated. Local VM time.
BackupScheduleType
- Manual
- Manual
- Automated
- Automated
- Backup
Schedule Type Manual - Manual
- Backup
Schedule Type Automated - Automated
- Manual
- Manual
- Automated
- Automated
- Manual
- Manual
- Automated
- Automated
- MANUAL
- Manual
- AUTOMATED
- Automated
- "Manual"
- Manual
- "Automated"
- Automated
ConnectivityType
- LOCAL
- LOCAL
- PRIVATE
- PRIVATE
- PUBLIC
- PUBLIC
- Connectivity
Type LOCAL - LOCAL
- Connectivity
Type PRIVATE - PRIVATE
- Connectivity
Type PUBLIC - PUBLIC
- LOCAL
- LOCAL
- PRIVATE
- PRIVATE
- PUBLIC
- PUBLIC
- LOCAL
- LOCAL
- PRIVATE
- PRIVATE
- PUBLIC
- PUBLIC
- LOCAL
- LOCAL
- PRIVATE
- PRIVATE
- PUBLIC
- PUBLIC
- "LOCAL"
- LOCAL
- "PRIVATE"
- PRIVATE
- "PUBLIC"
- PUBLIC
DayOfWeek
- Monday
- Monday
- Tuesday
- Tuesday
- Wednesday
- Wednesday
- Thursday
- Thursday
- Friday
- Friday
- Saturday
- Saturday
- Sunday
- Sunday
- Day
Of Week Monday - Monday
- Day
Of Week Tuesday - Tuesday
- Day
Of Week Wednesday - Wednesday
- Day
Of Week Thursday - Thursday
- Day
Of Week Friday - Friday
- Day
Of Week Saturday - Saturday
- Day
Of Week Sunday - Sunday
- Monday
- Monday
- Tuesday
- Tuesday
- Wednesday
- Wednesday
- Thursday
- Thursday
- Friday
- Friday
- Saturday
- Saturday
- Sunday
- Sunday
- Monday
- Monday
- Tuesday
- Tuesday
- Wednesday
- Wednesday
- Thursday
- Thursday
- Friday
- Friday
- Saturday
- Saturday
- Sunday
- Sunday
- MONDAY
- Monday
- TUESDAY
- Tuesday
- WEDNESDAY
- Wednesday
- THURSDAY
- Thursday
- FRIDAY
- Friday
- SATURDAY
- Saturday
- SUNDAY
- Sunday
- "Monday"
- Monday
- "Tuesday"
- Tuesday
- "Wednesday"
- Wednesday
- "Thursday"
- Thursday
- "Friday"
- Friday
- "Saturday"
- Saturday
- "Sunday"
- Sunday
DiskConfigurationType
- NEW
- NEW
- EXTEND
- EXTEND
- ADD
- ADD
- Disk
Configuration Type NEW - NEW
- Disk
Configuration Type EXTEND - EXTEND
- Disk
Configuration Type ADD - ADD
- NEW
- NEW
- EXTEND
- EXTEND
- ADD
- ADD
- NEW
- NEW
- EXTEND
- EXTEND
- ADD
- ADD
- NEW
- NEW
- EXTEND
- EXTEND
- ADD
- ADD
- "NEW"
- NEW
- "EXTEND"
- EXTEND
- "ADD"
- ADD
FullBackupFrequencyType
- Daily
- Daily
- Weekly
- Weekly
- Full
Backup Frequency Type Daily - Daily
- Full
Backup Frequency Type Weekly - Weekly
- Daily
- Daily
- Weekly
- Weekly
- Daily
- Daily
- Weekly
- Weekly
- DAILY
- Daily
- WEEKLY
- Weekly
- "Daily"
- Daily
- "Weekly"
- Weekly
IdentityType
- System
Assigned - SystemAssigned
- Identity
Type System Assigned - SystemAssigned
- System
Assigned - SystemAssigned
- System
Assigned - SystemAssigned
- SYSTEM_ASSIGNED
- SystemAssigned
- "System
Assigned" - SystemAssigned
KeyVaultCredentialSettings
- Azure
Key stringVault Url Azure Key Vault url.
- Credential
Name string Credential name.
- Enable bool
Enable or disable key vault credential setting.
- Service
Principal stringName Service principal name to access key vault.
- Service
Principal stringSecret Service principal name secret to access key vault.
- Azure
Key stringVault Url Azure Key Vault url.
- Credential
Name string Credential name.
- Enable bool
Enable or disable key vault credential setting.
- Service
Principal stringName Service principal name to access key vault.
- Service
Principal stringSecret Service principal name secret to access key vault.
- azure
Key StringVault Url Azure Key Vault url.
- credential
Name String Credential name.
- enable Boolean
Enable or disable key vault credential setting.
- service
Principal StringName Service principal name to access key vault.
- service
Principal StringSecret Service principal name secret to access key vault.
- azure
Key stringVault Url Azure Key Vault url.
- credential
Name string Credential name.
- enable boolean
Enable or disable key vault credential setting.
- service
Principal stringName Service principal name to access key vault.
- service
Principal stringSecret Service principal name secret to access key vault.
- azure_
key_ strvault_ url Azure Key Vault url.
- credential_
name str Credential name.
- enable bool
Enable or disable key vault credential setting.
- service_
principal_ strname Service principal name to access key vault.
- service_
principal_ strsecret Service principal name secret to access key vault.
- azure
Key StringVault Url Azure Key Vault url.
- credential
Name String Credential name.
- enable Boolean
Enable or disable key vault credential setting.
- service
Principal StringName Service principal name to access key vault.
- service
Principal StringSecret Service principal name secret to access key vault.
KeyVaultCredentialSettingsResponse
- Azure
Key stringVault Url Azure Key Vault url.
- Credential
Name string Credential name.
- Enable bool
Enable or disable key vault credential setting.
- Service
Principal stringName Service principal name to access key vault.
- Azure
Key stringVault Url Azure Key Vault url.
- Credential
Name string Credential name.
- Enable bool
Enable or disable key vault credential setting.
- Service
Principal stringName Service principal name to access key vault.
- azure
Key StringVault Url Azure Key Vault url.
- credential
Name String Credential name.
- enable Boolean
Enable or disable key vault credential setting.
- service
Principal StringName Service principal name to access key vault.
- azure
Key stringVault Url Azure Key Vault url.
- credential
Name string Credential name.
- enable boolean
Enable or disable key vault credential setting.
- service
Principal stringName Service principal name to access key vault.
- azure_
key_ strvault_ url Azure Key Vault url.
- credential_
name str Credential name.
- enable bool
Enable or disable key vault credential setting.
- service_
principal_ strname Service principal name to access key vault.
- azure
Key StringVault Url Azure Key Vault url.
- credential
Name String Credential name.
- enable Boolean
Enable or disable key vault credential setting.
- service
Principal StringName Service principal name to access key vault.
ResourceIdentity
- Type
string | Pulumi.
Azure Native. Sql Virtual Machine. Identity Type The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
- 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.
- 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.
- 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.
- 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.
- type
String | "System
Assigned" The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
ResourceIdentityResponse
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
SQLStorageSettings
- Default
File stringPath SQL Server default file path
- Luns List<int>
Logical Unit Numbers for the disks.
- Default
File stringPath SQL Server default file path
- Luns []int
Logical Unit Numbers for the disks.
- default
File StringPath SQL Server default file path
- luns List<Integer>
Logical Unit Numbers for the disks.
- default
File stringPath SQL Server default file path
- luns number[]
Logical Unit Numbers for the disks.
- default_
file_ strpath SQL Server default file path
- luns Sequence[int]
Logical Unit Numbers for the disks.
- default
File StringPath SQL Server default file path
- luns List<Number>
Logical Unit Numbers for the disks.
SQLStorageSettingsResponse
- Default
File stringPath SQL Server default file path
- Luns List<int>
Logical Unit Numbers for the disks.
- Default
File stringPath SQL Server default file path
- Luns []int
Logical Unit Numbers for the disks.
- default
File StringPath SQL Server default file path
- luns List<Integer>
Logical Unit Numbers for the disks.
- default
File stringPath SQL Server default file path
- luns number[]
Logical Unit Numbers for the disks.
- default_
file_ strpath SQL Server default file path
- luns Sequence[int]
Logical Unit Numbers for the disks.
- default
File StringPath SQL Server default file path
- luns List<Number>
Logical Unit Numbers for the disks.
ServerConfigurationsManagementSettings
- Additional
Features Pulumi.Server Configurations Azure Native. Sql Virtual Machine. Inputs. Additional Features Server Configurations Additional SQL feature settings.
- Sql
Connectivity Pulumi.Update Settings Azure Native. Sql Virtual Machine. Inputs. Sql Connectivity Update Settings SQL connectivity type settings.
- Sql
Storage Pulumi.Update Settings Azure Native. Sql Virtual Machine. Inputs. Sql Storage Update Settings SQL storage update settings.
- Sql
Workload Pulumi.Type Update Settings Azure Native. Sql Virtual Machine. Inputs. Sql Workload Type Update Settings SQL workload type settings.
- Additional
Features AdditionalServer Configurations Features Server Configurations Additional SQL feature settings.
- Sql
Connectivity SqlUpdate Settings Connectivity Update Settings SQL connectivity type settings.
- Sql
Storage SqlUpdate Settings Storage Update Settings SQL storage update settings.
- Sql
Workload SqlType Update Settings Workload Type Update Settings SQL workload type settings.
- additional
Features AdditionalServer Configurations Features Server Configurations Additional SQL feature settings.
- sql
Connectivity SqlUpdate Settings Connectivity Update Settings SQL connectivity type settings.
- sql
Storage SqlUpdate Settings Storage Update Settings SQL storage update settings.
- sql
Workload SqlType Update Settings Workload Type Update Settings SQL workload type settings.
- additional
Features AdditionalServer Configurations Features Server Configurations Additional SQL feature settings.
- sql
Connectivity SqlUpdate Settings Connectivity Update Settings SQL connectivity type settings.
- sql
Storage SqlUpdate Settings Storage Update Settings SQL storage update settings.
- sql
Workload SqlType Update Settings Workload Type Update Settings SQL workload type settings.
- additional_
features_ Additionalserver_ configurations Features Server Configurations Additional SQL feature settings.
- sql_
connectivity_ Sqlupdate_ settings Connectivity Update Settings SQL connectivity type settings.
- sql_
storage_ Sqlupdate_ settings Storage Update Settings SQL storage update settings.
- sql_
workload_ Sqltype_ update_ settings Workload Type Update Settings SQL workload type settings.
- additional
Features Property MapServer Configurations Additional SQL feature settings.
- sql
Connectivity Property MapUpdate Settings SQL connectivity type settings.
- sql
Storage Property MapUpdate Settings SQL storage update settings.
- sql
Workload Property MapType Update Settings SQL workload type settings.
ServerConfigurationsManagementSettingsResponse
- Additional
Features Pulumi.Server Configurations Azure Native. Sql Virtual Machine. Inputs. Additional Features Server Configurations Response Additional SQL feature settings.
- Sql
Connectivity Pulumi.Update Settings Azure Native. Sql Virtual Machine. Inputs. Sql Connectivity Update Settings Response SQL connectivity type settings.
- Sql
Storage Pulumi.Update Settings Azure Native. Sql Virtual Machine. Inputs. Sql Storage Update Settings Response SQL storage update settings.
- Sql
Workload Pulumi.Type Update Settings Azure Native. Sql Virtual Machine. Inputs. Sql Workload Type Update Settings Response SQL workload type settings.
- Additional
Features AdditionalServer Configurations Features Server Configurations Response Additional SQL feature settings.
- Sql
Connectivity SqlUpdate Settings Connectivity Update Settings Response SQL connectivity type settings.
- Sql
Storage SqlUpdate Settings Storage Update Settings Response SQL storage update settings.
- Sql
Workload SqlType Update Settings Workload Type Update Settings Response SQL workload type settings.
- additional
Features AdditionalServer Configurations Features Server Configurations Response Additional SQL feature settings.
- sql
Connectivity SqlUpdate Settings Connectivity Update Settings Response SQL connectivity type settings.
- sql
Storage SqlUpdate Settings Storage Update Settings Response SQL storage update settings.
- sql
Workload SqlType Update Settings Workload Type Update Settings Response SQL workload type settings.
- additional
Features AdditionalServer Configurations Features Server Configurations Response Additional SQL feature settings.
- sql
Connectivity SqlUpdate Settings Connectivity Update Settings Response SQL connectivity type settings.
- sql
Storage SqlUpdate Settings Storage Update Settings Response SQL storage update settings.
- sql
Workload SqlType Update Settings Workload Type Update Settings Response SQL workload type settings.
- additional_
features_ Additionalserver_ configurations Features Server Configurations Response Additional SQL feature settings.
- sql_
connectivity_ Sqlupdate_ settings Connectivity Update Settings Response SQL connectivity type settings.
- sql_
storage_ Sqlupdate_ settings Storage Update Settings Response SQL storage update settings.
- sql_
workload_ Sqltype_ update_ settings Workload Type Update Settings Response SQL workload type settings.
- additional
Features Property MapServer Configurations Additional SQL feature settings.
- sql
Connectivity Property MapUpdate Settings SQL connectivity type settings.
- sql
Storage Property MapUpdate Settings SQL storage update settings.
- sql
Workload Property MapType Update Settings SQL workload type settings.
SqlConnectivityUpdateSettings
- Connectivity
Type string | Pulumi.Azure Native. Sql Virtual Machine. Connectivity Type SQL Server connectivity option.
- Port int
SQL Server port.
- Sql
Auth stringUpdate Password SQL Server sysadmin login password.
- Sql
Auth stringUpdate User Name SQL Server sysadmin login to create.
- Connectivity
Type string | ConnectivityType SQL Server connectivity option.
- Port int
SQL Server port.
- Sql
Auth stringUpdate Password SQL Server sysadmin login password.
- Sql
Auth stringUpdate User Name SQL Server sysadmin login to create.
- connectivity
Type String | ConnectivityType SQL Server connectivity option.
- port Integer
SQL Server port.
- sql
Auth StringUpdate Password SQL Server sysadmin login password.
- sql
Auth StringUpdate User Name SQL Server sysadmin login to create.
- connectivity
Type string | ConnectivityType SQL Server connectivity option.
- port number
SQL Server port.
- sql
Auth stringUpdate Password SQL Server sysadmin login password.
- sql
Auth stringUpdate User Name SQL Server sysadmin login to create.
- connectivity_
type str | ConnectivityType SQL Server connectivity option.
- port int
SQL Server port.
- sql_
auth_ strupdate_ password SQL Server sysadmin login password.
- sql_
auth_ strupdate_ user_ name SQL Server sysadmin login to create.
- connectivity
Type String | "LOCAL" | "PRIVATE" | "PUBLIC" SQL Server connectivity option.
- port Number
SQL Server port.
- sql
Auth StringUpdate Password SQL Server sysadmin login password.
- sql
Auth StringUpdate User Name SQL Server sysadmin login to create.
SqlConnectivityUpdateSettingsResponse
- Connectivity
Type string SQL Server connectivity option.
- Port int
SQL Server port.
- Connectivity
Type string SQL Server connectivity option.
- Port int
SQL Server port.
- connectivity
Type String SQL Server connectivity option.
- port Integer
SQL Server port.
- connectivity
Type string SQL Server connectivity option.
- port number
SQL Server port.
- connectivity_
type str SQL Server connectivity option.
- port int
SQL Server port.
- connectivity
Type String SQL Server connectivity option.
- port Number
SQL Server port.
SqlImageSku
- Developer
- Developer
- Express
- Express
- Standard
- Standard
- Enterprise
- Enterprise
- Web
- Web
- Sql
Image Sku Developer - Developer
- Sql
Image Sku Express - Express
- Sql
Image Sku Standard - Standard
- Sql
Image Sku Enterprise - Enterprise
- Sql
Image Sku Web - Web
- Developer
- Developer
- Express
- Express
- Standard
- Standard
- Enterprise
- Enterprise
- Web
- Web
- Developer
- Developer
- Express
- Express
- Standard
- Standard
- Enterprise
- Enterprise
- Web
- Web
- DEVELOPER
- Developer
- EXPRESS
- Express
- STANDARD
- Standard
- ENTERPRISE
- Enterprise
- WEB
- Web
- "Developer"
- Developer
- "Express"
- Express
- "Standard"
- Standard
- "Enterprise"
- Enterprise
- "Web"
- Web
SqlManagementMode
- Full
- Full
- Light
Weight - LightWeight
- No
Agent - NoAgent
- Sql
Management Mode Full - Full
- Sql
Management Mode Light Weight - LightWeight
- Sql
Management Mode No Agent - NoAgent
- Full
- Full
- Light
Weight - LightWeight
- No
Agent - NoAgent
- Full
- Full
- Light
Weight - LightWeight
- No
Agent - NoAgent
- FULL
- Full
- LIGHT_WEIGHT
- LightWeight
- NO_AGENT
- NoAgent
- "Full"
- Full
- "Light
Weight" - LightWeight
- "No
Agent" - NoAgent
SqlServerLicenseType
- PAYG
- PAYG
- AHUB
- AHUB
- DR
- DR
- Sql
Server License Type PAYG - PAYG
- Sql
Server License Type AHUB - AHUB
- Sql
Server License Type DR - DR
- PAYG
- PAYG
- AHUB
- AHUB
- DR
- DR
- PAYG
- PAYG
- AHUB
- AHUB
- DR
- DR
- PAYG
- PAYG
- AHUB
- AHUB
- DR
- DR
- "PAYG"
- PAYG
- "AHUB"
- AHUB
- "DR"
- DR
SqlStorageUpdateSettings
- Disk
Configuration string | Pulumi.Type Azure Native. Sql Virtual Machine. Disk Configuration Type Disk configuration to apply to SQL Server.
- Disk
Count int Virtual machine disk count.
- Starting
Device intId Device id of the first disk to be updated.
- Disk
Configuration string | DiskType Configuration Type Disk configuration to apply to SQL Server.
- Disk
Count int Virtual machine disk count.
- Starting
Device intId Device id of the first disk to be updated.
- disk
Configuration String | DiskType Configuration Type Disk configuration to apply to SQL Server.
- disk
Count Integer Virtual machine disk count.
- starting
Device IntegerId Device id of the first disk to be updated.
- disk
Configuration string | DiskType Configuration Type Disk configuration to apply to SQL Server.
- disk
Count number Virtual machine disk count.
- starting
Device numberId Device id of the first disk to be updated.
- disk_
configuration_ str | Disktype Configuration Type Disk configuration to apply to SQL Server.
- disk_
count int Virtual machine disk count.
- starting_
device_ intid Device id of the first disk to be updated.
- disk
Configuration String | "NEW" | "EXTEND" | "ADD"Type Disk configuration to apply to SQL Server.
- disk
Count Number Virtual machine disk count.
- starting
Device NumberId Device id of the first disk to be updated.
SqlStorageUpdateSettingsResponse
- Disk
Configuration stringType Disk configuration to apply to SQL Server.
- Disk
Count int Virtual machine disk count.
- Starting
Device intId Device id of the first disk to be updated.
- Disk
Configuration stringType Disk configuration to apply to SQL Server.
- Disk
Count int Virtual machine disk count.
- Starting
Device intId Device id of the first disk to be updated.
- disk
Configuration StringType Disk configuration to apply to SQL Server.
- disk
Count Integer Virtual machine disk count.
- starting
Device IntegerId Device id of the first disk to be updated.
- disk
Configuration stringType Disk configuration to apply to SQL Server.
- disk
Count number Virtual machine disk count.
- starting
Device numberId Device id of the first disk to be updated.
- disk_
configuration_ strtype Disk configuration to apply to SQL Server.
- disk_
count int Virtual machine disk count.
- starting_
device_ intid Device id of the first disk to be updated.
- disk
Configuration StringType Disk configuration to apply to SQL Server.
- disk
Count Number Virtual machine disk count.
- starting
Device NumberId Device id of the first disk to be updated.
SqlWorkloadType
- GENERAL
- GENERAL
- OLTP
- OLTP
- DW
- DW
- Sql
Workload Type GENERAL - GENERAL
- Sql
Workload Type OLTP - OLTP
- Sql
Workload Type DW - DW
- GENERAL
- GENERAL
- OLTP
- OLTP
- DW
- DW
- GENERAL
- GENERAL
- OLTP
- OLTP
- DW
- DW
- GENERAL
- GENERAL
- OLTP
- OLTP
- DW
- DW
- "GENERAL"
- GENERAL
- "OLTP"
- OLTP
- "DW"
- DW
SqlWorkloadTypeUpdateSettings
- Sql
Workload string | Pulumi.Type Azure Native. Sql Virtual Machine. Sql Workload Type SQL Server workload type.
- Sql
Workload string | SqlType Workload Type SQL Server workload type.
- sql
Workload String | SqlType Workload Type SQL Server workload type.
- sql
Workload string | SqlType Workload Type SQL Server workload type.
- sql_
workload_ str | Sqltype Workload Type SQL Server workload type.
- sql
Workload String | "GENERAL" | "OLTP" | "DW"Type SQL Server workload type.
SqlWorkloadTypeUpdateSettingsResponse
- Sql
Workload stringType SQL Server workload type.
- Sql
Workload stringType SQL Server workload type.
- sql
Workload StringType SQL Server workload type.
- sql
Workload stringType SQL Server workload type.
- sql_
workload_ strtype SQL Server workload type.
- sql
Workload StringType SQL Server workload type.
StorageConfigurationSettings
- Disk
Configuration string | Pulumi.Type Azure Native. Sql Virtual Machine. Disk Configuration Type Disk configuration to apply to SQL Server.
- Sql
Data Pulumi.Settings Azure Native. Sql Virtual Machine. Inputs. SQLStorage Settings SQL Server Data Storage Settings.
- Sql
Log Pulumi.Settings Azure Native. Sql Virtual Machine. Inputs. SQLStorage Settings SQL Server Log Storage Settings.
- Sql
Temp Pulumi.Db Settings Azure Native. Sql Virtual Machine. Inputs. SQLStorage Settings SQL Server TempDb Storage Settings.
- Storage
Workload string | Pulumi.Type Azure Native. Sql Virtual Machine. Storage Workload Type Storage workload type.
- Disk
Configuration string | DiskType Configuration Type Disk configuration to apply to SQL Server.
- Sql
Data SQLStorageSettings Settings SQL Server Data Storage Settings.
- Sql
Log SQLStorageSettings Settings SQL Server Log Storage Settings.
- Sql
Temp SQLStorageDb Settings Settings SQL Server TempDb Storage Settings.
- Storage
Workload string | StorageType Workload Type Storage workload type.
- disk
Configuration String | DiskType Configuration Type Disk configuration to apply to SQL Server.
- sql
Data SQLStorageSettings Settings SQL Server Data Storage Settings.
- sql
Log SQLStorageSettings Settings SQL Server Log Storage Settings.
- sql
Temp SQLStorageDb Settings Settings SQL Server TempDb Storage Settings.
- storage
Workload String | StorageType Workload Type Storage workload type.
- disk
Configuration string | DiskType Configuration Type Disk configuration to apply to SQL Server.
- sql
Data SQLStorageSettings Settings SQL Server Data Storage Settings.
- sql
Log SQLStorageSettings Settings SQL Server Log Storage Settings.
- sql
Temp SQLStorageDb Settings Settings SQL Server TempDb Storage Settings.
- storage
Workload string | StorageType Workload Type Storage workload type.
- disk_
configuration_ str | Disktype Configuration Type Disk configuration to apply to SQL Server.
- sql_
data_ SQLStoragesettings Settings SQL Server Data Storage Settings.
- sql_
log_ SQLStoragesettings Settings SQL Server Log Storage Settings.
- sql_
temp_ SQLStoragedb_ settings Settings SQL Server TempDb Storage Settings.
- storage_
workload_ str | Storagetype Workload Type Storage workload type.
- disk
Configuration String | "NEW" | "EXTEND" | "ADD"Type Disk configuration to apply to SQL Server.
- sql
Data Property MapSettings SQL Server Data Storage Settings.
- sql
Log Property MapSettings SQL Server Log Storage Settings.
- sql
Temp Property MapDb Settings SQL Server TempDb Storage Settings.
- storage
Workload String | "GENERAL" | "OLTP" | "DW"Type Storage workload type.
StorageConfigurationSettingsResponse
- Disk
Configuration stringType Disk configuration to apply to SQL Server.
- Sql
Data Pulumi.Settings Azure Native. Sql Virtual Machine. Inputs. SQLStorage Settings Response SQL Server Data Storage Settings.
- Sql
Log Pulumi.Settings Azure Native. Sql Virtual Machine. Inputs. SQLStorage Settings Response SQL Server Log Storage Settings.
- Sql
Temp Pulumi.Db Settings Azure Native. Sql Virtual Machine. Inputs. SQLStorage Settings Response SQL Server TempDb Storage Settings.
- Storage
Workload stringType Storage workload type.
- Disk
Configuration stringType Disk configuration to apply to SQL Server.
- Sql
Data SQLStorageSettings Settings Response SQL Server Data Storage Settings.
- Sql
Log SQLStorageSettings Settings Response SQL Server Log Storage Settings.
- Sql
Temp SQLStorageDb Settings Settings Response SQL Server TempDb Storage Settings.
- Storage
Workload stringType Storage workload type.
- disk
Configuration StringType Disk configuration to apply to SQL Server.
- sql
Data SQLStorageSettings Settings Response SQL Server Data Storage Settings.
- sql
Log SQLStorageSettings Settings Response SQL Server Log Storage Settings.
- sql
Temp SQLStorageDb Settings Settings Response SQL Server TempDb Storage Settings.
- storage
Workload StringType Storage workload type.
- disk
Configuration stringType Disk configuration to apply to SQL Server.
- sql
Data SQLStorageSettings Settings Response SQL Server Data Storage Settings.
- sql
Log SQLStorageSettings Settings Response SQL Server Log Storage Settings.
- sql
Temp SQLStorageDb Settings Settings Response SQL Server TempDb Storage Settings.
- storage
Workload stringType Storage workload type.
- disk_
configuration_ strtype Disk configuration to apply to SQL Server.
- sql_
data_ SQLStoragesettings Settings Response SQL Server Data Storage Settings.
- sql_
log_ SQLStoragesettings Settings Response SQL Server Log Storage Settings.
- sql_
temp_ SQLStoragedb_ settings Settings Response SQL Server TempDb Storage Settings.
- storage_
workload_ strtype Storage workload type.
- disk
Configuration StringType Disk configuration to apply to SQL Server.
- sql
Data Property MapSettings SQL Server Data Storage Settings.
- sql
Log Property MapSettings SQL Server Log Storage Settings.
- sql
Temp Property MapDb Settings SQL Server TempDb Storage Settings.
- storage
Workload StringType Storage workload type.
StorageWorkloadType
- GENERAL
- GENERAL
- OLTP
- OLTP
- DW
- DW
- Storage
Workload Type GENERAL - GENERAL
- Storage
Workload Type OLTP - OLTP
- Storage
Workload Type DW - DW
- GENERAL
- GENERAL
- OLTP
- OLTP
- DW
- DW
- GENERAL
- GENERAL
- OLTP
- OLTP
- DW
- DW
- GENERAL
- GENERAL
- OLTP
- OLTP
- DW
- DW
- "GENERAL"
- GENERAL
- "OLTP"
- OLTP
- "DW"
- DW
WsfcDomainCredentials
- Cluster
Bootstrap stringAccount Password Cluster bootstrap account password.
- Cluster
Operator stringAccount Password Cluster operator account password.
- Sql
Service stringAccount Password SQL service account password.
- Cluster
Bootstrap stringAccount Password Cluster bootstrap account password.
- Cluster
Operator stringAccount Password Cluster operator account password.
- Sql
Service stringAccount Password SQL service account password.
- cluster
Bootstrap StringAccount Password Cluster bootstrap account password.
- cluster
Operator StringAccount Password Cluster operator account password.
- sql
Service StringAccount Password SQL service account password.
- cluster
Bootstrap stringAccount Password Cluster bootstrap account password.
- cluster
Operator stringAccount Password Cluster operator account password.
- sql
Service stringAccount Password SQL service account password.
- cluster_
bootstrap_ straccount_ password Cluster bootstrap account password.
- cluster_
operator_ straccount_ password Cluster operator account password.
- sql_
service_ straccount_ password SQL service account password.
- cluster
Bootstrap StringAccount Password Cluster bootstrap account password.
- cluster
Operator StringAccount Password Cluster operator account password.
- sql
Service StringAccount Password SQL service account password.
WsfcDomainCredentialsResponse
- Cluster
Bootstrap stringAccount Password Cluster bootstrap account password.
- Cluster
Operator stringAccount Password Cluster operator account password.
- Sql
Service stringAccount Password SQL service account password.
- Cluster
Bootstrap stringAccount Password Cluster bootstrap account password.
- Cluster
Operator stringAccount Password Cluster operator account password.
- Sql
Service stringAccount Password SQL service account password.
- cluster
Bootstrap StringAccount Password Cluster bootstrap account password.
- cluster
Operator StringAccount Password Cluster operator account password.
- sql
Service StringAccount Password SQL service account password.
- cluster
Bootstrap stringAccount Password Cluster bootstrap account password.
- cluster
Operator stringAccount Password Cluster operator account password.
- sql
Service stringAccount Password SQL service account password.
- cluster_
bootstrap_ straccount_ password Cluster bootstrap account password.
- cluster_
operator_ straccount_ password Cluster operator account password.
- sql_
service_ straccount_ password SQL service account password.
- cluster
Bootstrap StringAccount Password Cluster bootstrap account password.
- cluster
Operator StringAccount Password Cluster operator account password.
- sql
Service StringAccount Password SQL service account password.
Import
An existing resource can be imported using its type token, name, and identifier, e.g.
$ pulumi import azure-native:sqlvirtualmachine:SqlVirtualMachine testvm /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachines/testvm
Package Details
- Repository
- Azure Native pulumi/pulumi-azure-native
- License
- Apache-2.0