published on Monday, Mar 9, 2026 by Pulumi
published on Monday, Mar 9, 2026 by Pulumi
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 System.Linq;
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/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 * 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>",
},
});
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>",
))
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 System.Linq;
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/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 * 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",
});
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")
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 System.Linq;
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/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 * 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",
});
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")
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 System.Linq;
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/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 * 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",
});
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")
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 System.Linq;
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/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 * 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",
});
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")
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
Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.
Constructor syntax
new SqlVirtualMachine(name: string, args: SqlVirtualMachineArgs, opts?: CustomResourceOptions);@overload
def SqlVirtualMachine(resource_name: str,
args: SqlVirtualMachineArgs,
opts: Optional[ResourceOptions] = None)
@overload
def SqlVirtualMachine(resource_name: str,
opts: Optional[ResourceOptions] = None,
resource_group_name: Optional[str] = None,
sql_image_sku: Optional[Union[str, SqlImageSku]] = None,
sql_server_license_type: Optional[Union[str, SqlServerLicenseType]] = None,
key_vault_credential_settings: Optional[KeyVaultCredentialSettingsArgs] = None,
location: Optional[str] = None,
auto_patching_settings: Optional[AutoPatchingSettingsArgs] = None,
server_configurations_management_settings: Optional[ServerConfigurationsManagementSettingsArgs] = None,
identity: Optional[ResourceIdentityArgs] = None,
sql_image_offer: Optional[str] = None,
sql_management: Optional[Union[str, SqlManagementMode]] = None,
auto_backup_settings: Optional[AutoBackupSettingsArgs] = 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)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.
Parameters
- 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.
Constructor example
The following reference example uses placeholder values for all input properties.
var sqlVirtualMachineResource = new AzureNative.SqlVirtualMachine.SqlVirtualMachine("sqlVirtualMachineResource", new()
{
ResourceGroupName = "string",
SqlImageSku = "string",
SqlServerLicenseType = "string",
KeyVaultCredentialSettings = new AzureNative.SqlVirtualMachine.Inputs.KeyVaultCredentialSettingsArgs
{
AzureKeyVaultUrl = "string",
CredentialName = "string",
Enable = false,
ServicePrincipalName = "string",
ServicePrincipalSecret = "string",
},
Location = "string",
AutoPatchingSettings = new AzureNative.SqlVirtualMachine.Inputs.AutoPatchingSettingsArgs
{
DayOfWeek = AzureNative.SqlVirtualMachine.DayOfWeek.Monday,
Enable = false,
MaintenanceWindowDuration = 0,
MaintenanceWindowStartingHour = 0,
},
ServerConfigurationsManagementSettings = new AzureNative.SqlVirtualMachine.Inputs.ServerConfigurationsManagementSettingsArgs
{
AdditionalFeaturesServerConfigurations = new AzureNative.SqlVirtualMachine.Inputs.AdditionalFeaturesServerConfigurationsArgs
{
IsRServicesEnabled = false,
},
SqlConnectivityUpdateSettings = new AzureNative.SqlVirtualMachine.Inputs.SqlConnectivityUpdateSettingsArgs
{
ConnectivityType = "string",
Port = 0,
SqlAuthUpdatePassword = "string",
SqlAuthUpdateUserName = "string",
},
SqlStorageUpdateSettings = new AzureNative.SqlVirtualMachine.Inputs.SqlStorageUpdateSettingsArgs
{
DiskConfigurationType = "string",
DiskCount = 0,
StartingDeviceId = 0,
},
SqlWorkloadTypeUpdateSettings = new AzureNative.SqlVirtualMachine.Inputs.SqlWorkloadTypeUpdateSettingsArgs
{
SqlWorkloadType = "string",
},
},
Identity = new AzureNative.SqlVirtualMachine.Inputs.ResourceIdentityArgs
{
Type = "string",
},
SqlImageOffer = "string",
SqlManagement = "string",
AutoBackupSettings = new AzureNative.SqlVirtualMachine.Inputs.AutoBackupSettingsArgs
{
BackupScheduleType = "string",
BackupSystemDbs = false,
Enable = false,
EnableEncryption = false,
FullBackupFrequency = "string",
FullBackupStartTime = 0,
FullBackupWindowHours = 0,
LogBackupFrequency = 0,
Password = "string",
RetentionPeriod = 0,
StorageAccessKey = "string",
StorageAccountUrl = "string",
},
SqlVirtualMachineGroupResourceId = "string",
SqlVirtualMachineName = "string",
StorageConfigurationSettings = new AzureNative.SqlVirtualMachine.Inputs.StorageConfigurationSettingsArgs
{
DiskConfigurationType = "string",
SqlDataSettings = new AzureNative.SqlVirtualMachine.Inputs.SQLStorageSettingsArgs
{
DefaultFilePath = "string",
Luns = new[]
{
0,
},
},
SqlLogSettings = new AzureNative.SqlVirtualMachine.Inputs.SQLStorageSettingsArgs
{
DefaultFilePath = "string",
Luns = new[]
{
0,
},
},
SqlTempDbSettings = new AzureNative.SqlVirtualMachine.Inputs.SQLStorageSettingsArgs
{
DefaultFilePath = "string",
Luns = new[]
{
0,
},
},
StorageWorkloadType = "string",
},
Tags =
{
{ "string", "string" },
},
VirtualMachineResourceId = "string",
WsfcDomainCredentials = new AzureNative.SqlVirtualMachine.Inputs.WsfcDomainCredentialsArgs
{
ClusterBootstrapAccountPassword = "string",
ClusterOperatorAccountPassword = "string",
SqlServiceAccountPassword = "string",
},
});
example, err := sqlvirtualmachine.NewSqlVirtualMachine(ctx, "sqlVirtualMachineResource", &sqlvirtualmachine.SqlVirtualMachineArgs{
ResourceGroupName: pulumi.String("string"),
SqlImageSku: pulumi.String("string"),
SqlServerLicenseType: pulumi.String("string"),
KeyVaultCredentialSettings: &sqlvirtualmachine.KeyVaultCredentialSettingsArgs{
AzureKeyVaultUrl: pulumi.String("string"),
CredentialName: pulumi.String("string"),
Enable: pulumi.Bool(false),
ServicePrincipalName: pulumi.String("string"),
ServicePrincipalSecret: pulumi.String("string"),
},
Location: pulumi.String("string"),
AutoPatchingSettings: &sqlvirtualmachine.AutoPatchingSettingsArgs{
DayOfWeek: sqlvirtualmachine.DayOfWeekMonday,
Enable: pulumi.Bool(false),
MaintenanceWindowDuration: pulumi.Int(0),
MaintenanceWindowStartingHour: pulumi.Int(0),
},
ServerConfigurationsManagementSettings: &sqlvirtualmachine.ServerConfigurationsManagementSettingsArgs{
AdditionalFeaturesServerConfigurations: &sqlvirtualmachine.AdditionalFeaturesServerConfigurationsArgs{
IsRServicesEnabled: pulumi.Bool(false),
},
SqlConnectivityUpdateSettings: &sqlvirtualmachine.SqlConnectivityUpdateSettingsArgs{
ConnectivityType: pulumi.String("string"),
Port: pulumi.Int(0),
SqlAuthUpdatePassword: pulumi.String("string"),
SqlAuthUpdateUserName: pulumi.String("string"),
},
SqlStorageUpdateSettings: &sqlvirtualmachine.SqlStorageUpdateSettingsArgs{
DiskConfigurationType: pulumi.String("string"),
DiskCount: pulumi.Int(0),
StartingDeviceId: pulumi.Int(0),
},
SqlWorkloadTypeUpdateSettings: &sqlvirtualmachine.SqlWorkloadTypeUpdateSettingsArgs{
SqlWorkloadType: pulumi.String("string"),
},
},
Identity: &sqlvirtualmachine.ResourceIdentityArgs{
Type: pulumi.String("string"),
},
SqlImageOffer: pulumi.String("string"),
SqlManagement: pulumi.String("string"),
AutoBackupSettings: &sqlvirtualmachine.AutoBackupSettingsArgs{
BackupScheduleType: pulumi.String("string"),
BackupSystemDbs: pulumi.Bool(false),
Enable: pulumi.Bool(false),
EnableEncryption: pulumi.Bool(false),
FullBackupFrequency: pulumi.String("string"),
FullBackupStartTime: pulumi.Int(0),
FullBackupWindowHours: pulumi.Int(0),
LogBackupFrequency: pulumi.Int(0),
Password: pulumi.String("string"),
RetentionPeriod: pulumi.Int(0),
StorageAccessKey: pulumi.String("string"),
StorageAccountUrl: pulumi.String("string"),
},
SqlVirtualMachineGroupResourceId: pulumi.String("string"),
SqlVirtualMachineName: pulumi.String("string"),
StorageConfigurationSettings: &sqlvirtualmachine.StorageConfigurationSettingsArgs{
DiskConfigurationType: pulumi.String("string"),
SqlDataSettings: &sqlvirtualmachine.SQLStorageSettingsArgs{
DefaultFilePath: pulumi.String("string"),
Luns: pulumi.IntArray{
pulumi.Int(0),
},
},
SqlLogSettings: &sqlvirtualmachine.SQLStorageSettingsArgs{
DefaultFilePath: pulumi.String("string"),
Luns: pulumi.IntArray{
pulumi.Int(0),
},
},
SqlTempDbSettings: &sqlvirtualmachine.SQLStorageSettingsArgs{
DefaultFilePath: pulumi.String("string"),
Luns: pulumi.IntArray{
pulumi.Int(0),
},
},
StorageWorkloadType: pulumi.String("string"),
},
Tags: pulumi.StringMap{
"string": pulumi.String("string"),
},
VirtualMachineResourceId: pulumi.String("string"),
WsfcDomainCredentials: &sqlvirtualmachine.WsfcDomainCredentialsArgs{
ClusterBootstrapAccountPassword: pulumi.String("string"),
ClusterOperatorAccountPassword: pulumi.String("string"),
SqlServiceAccountPassword: pulumi.String("string"),
},
})
var sqlVirtualMachineResource = new SqlVirtualMachine("sqlVirtualMachineResource", SqlVirtualMachineArgs.builder()
.resourceGroupName("string")
.sqlImageSku("string")
.sqlServerLicenseType("string")
.keyVaultCredentialSettings(KeyVaultCredentialSettingsArgs.builder()
.azureKeyVaultUrl("string")
.credentialName("string")
.enable(false)
.servicePrincipalName("string")
.servicePrincipalSecret("string")
.build())
.location("string")
.autoPatchingSettings(AutoPatchingSettingsArgs.builder()
.dayOfWeek("Monday")
.enable(false)
.maintenanceWindowDuration(0)
.maintenanceWindowStartingHour(0)
.build())
.serverConfigurationsManagementSettings(ServerConfigurationsManagementSettingsArgs.builder()
.additionalFeaturesServerConfigurations(AdditionalFeaturesServerConfigurationsArgs.builder()
.isRServicesEnabled(false)
.build())
.sqlConnectivityUpdateSettings(SqlConnectivityUpdateSettingsArgs.builder()
.connectivityType("string")
.port(0)
.sqlAuthUpdatePassword("string")
.sqlAuthUpdateUserName("string")
.build())
.sqlStorageUpdateSettings(SqlStorageUpdateSettingsArgs.builder()
.diskConfigurationType("string")
.diskCount(0)
.startingDeviceId(0)
.build())
.sqlWorkloadTypeUpdateSettings(SqlWorkloadTypeUpdateSettingsArgs.builder()
.sqlWorkloadType("string")
.build())
.build())
.identity(ResourceIdentityArgs.builder()
.type("string")
.build())
.sqlImageOffer("string")
.sqlManagement("string")
.autoBackupSettings(AutoBackupSettingsArgs.builder()
.backupScheduleType("string")
.backupSystemDbs(false)
.enable(false)
.enableEncryption(false)
.fullBackupFrequency("string")
.fullBackupStartTime(0)
.fullBackupWindowHours(0)
.logBackupFrequency(0)
.password("string")
.retentionPeriod(0)
.storageAccessKey("string")
.storageAccountUrl("string")
.build())
.sqlVirtualMachineGroupResourceId("string")
.sqlVirtualMachineName("string")
.storageConfigurationSettings(StorageConfigurationSettingsArgs.builder()
.diskConfigurationType("string")
.sqlDataSettings(SQLStorageSettingsArgs.builder()
.defaultFilePath("string")
.luns(0)
.build())
.sqlLogSettings(SQLStorageSettingsArgs.builder()
.defaultFilePath("string")
.luns(0)
.build())
.sqlTempDbSettings(SQLStorageSettingsArgs.builder()
.defaultFilePath("string")
.luns(0)
.build())
.storageWorkloadType("string")
.build())
.tags(Map.of("string", "string"))
.virtualMachineResourceId("string")
.wsfcDomainCredentials(WsfcDomainCredentialsArgs.builder()
.clusterBootstrapAccountPassword("string")
.clusterOperatorAccountPassword("string")
.sqlServiceAccountPassword("string")
.build())
.build());
sql_virtual_machine_resource = azure_native.sqlvirtualmachine.SqlVirtualMachine("sqlVirtualMachineResource",
resource_group_name="string",
sql_image_sku="string",
sql_server_license_type="string",
key_vault_credential_settings={
"azure_key_vault_url": "string",
"credential_name": "string",
"enable": False,
"service_principal_name": "string",
"service_principal_secret": "string",
},
location="string",
auto_patching_settings={
"day_of_week": azure_native.sqlvirtualmachine.DayOfWeek.MONDAY,
"enable": False,
"maintenance_window_duration": 0,
"maintenance_window_starting_hour": 0,
},
server_configurations_management_settings={
"additional_features_server_configurations": {
"is_r_services_enabled": False,
},
"sql_connectivity_update_settings": {
"connectivity_type": "string",
"port": 0,
"sql_auth_update_password": "string",
"sql_auth_update_user_name": "string",
},
"sql_storage_update_settings": {
"disk_configuration_type": "string",
"disk_count": 0,
"starting_device_id": 0,
},
"sql_workload_type_update_settings": {
"sql_workload_type": "string",
},
},
identity={
"type": "string",
},
sql_image_offer="string",
sql_management="string",
auto_backup_settings={
"backup_schedule_type": "string",
"backup_system_dbs": False,
"enable": False,
"enable_encryption": False,
"full_backup_frequency": "string",
"full_backup_start_time": 0,
"full_backup_window_hours": 0,
"log_backup_frequency": 0,
"password": "string",
"retention_period": 0,
"storage_access_key": "string",
"storage_account_url": "string",
},
sql_virtual_machine_group_resource_id="string",
sql_virtual_machine_name="string",
storage_configuration_settings={
"disk_configuration_type": "string",
"sql_data_settings": {
"default_file_path": "string",
"luns": [0],
},
"sql_log_settings": {
"default_file_path": "string",
"luns": [0],
},
"sql_temp_db_settings": {
"default_file_path": "string",
"luns": [0],
},
"storage_workload_type": "string",
},
tags={
"string": "string",
},
virtual_machine_resource_id="string",
wsfc_domain_credentials={
"cluster_bootstrap_account_password": "string",
"cluster_operator_account_password": "string",
"sql_service_account_password": "string",
})
const sqlVirtualMachineResource = new azure_native.sqlvirtualmachine.SqlVirtualMachine("sqlVirtualMachineResource", {
resourceGroupName: "string",
sqlImageSku: "string",
sqlServerLicenseType: "string",
keyVaultCredentialSettings: {
azureKeyVaultUrl: "string",
credentialName: "string",
enable: false,
servicePrincipalName: "string",
servicePrincipalSecret: "string",
},
location: "string",
autoPatchingSettings: {
dayOfWeek: azure_native.sqlvirtualmachine.DayOfWeek.Monday,
enable: false,
maintenanceWindowDuration: 0,
maintenanceWindowStartingHour: 0,
},
serverConfigurationsManagementSettings: {
additionalFeaturesServerConfigurations: {
isRServicesEnabled: false,
},
sqlConnectivityUpdateSettings: {
connectivityType: "string",
port: 0,
sqlAuthUpdatePassword: "string",
sqlAuthUpdateUserName: "string",
},
sqlStorageUpdateSettings: {
diskConfigurationType: "string",
diskCount: 0,
startingDeviceId: 0,
},
sqlWorkloadTypeUpdateSettings: {
sqlWorkloadType: "string",
},
},
identity: {
type: "string",
},
sqlImageOffer: "string",
sqlManagement: "string",
autoBackupSettings: {
backupScheduleType: "string",
backupSystemDbs: false,
enable: false,
enableEncryption: false,
fullBackupFrequency: "string",
fullBackupStartTime: 0,
fullBackupWindowHours: 0,
logBackupFrequency: 0,
password: "string",
retentionPeriod: 0,
storageAccessKey: "string",
storageAccountUrl: "string",
},
sqlVirtualMachineGroupResourceId: "string",
sqlVirtualMachineName: "string",
storageConfigurationSettings: {
diskConfigurationType: "string",
sqlDataSettings: {
defaultFilePath: "string",
luns: [0],
},
sqlLogSettings: {
defaultFilePath: "string",
luns: [0],
},
sqlTempDbSettings: {
defaultFilePath: "string",
luns: [0],
},
storageWorkloadType: "string",
},
tags: {
string: "string",
},
virtualMachineResourceId: "string",
wsfcDomainCredentials: {
clusterBootstrapAccountPassword: "string",
clusterOperatorAccountPassword: "string",
sqlServiceAccountPassword: "string",
},
});
type: azure-native:sqlvirtualmachine:SqlVirtualMachine
properties:
autoBackupSettings:
backupScheduleType: string
backupSystemDbs: false
enable: false
enableEncryption: false
fullBackupFrequency: string
fullBackupStartTime: 0
fullBackupWindowHours: 0
logBackupFrequency: 0
password: string
retentionPeriod: 0
storageAccessKey: string
storageAccountUrl: string
autoPatchingSettings:
dayOfWeek: Monday
enable: false
maintenanceWindowDuration: 0
maintenanceWindowStartingHour: 0
identity:
type: string
keyVaultCredentialSettings:
azureKeyVaultUrl: string
credentialName: string
enable: false
servicePrincipalName: string
servicePrincipalSecret: string
location: string
resourceGroupName: string
serverConfigurationsManagementSettings:
additionalFeaturesServerConfigurations:
isRServicesEnabled: false
sqlConnectivityUpdateSettings:
connectivityType: string
port: 0
sqlAuthUpdatePassword: string
sqlAuthUpdateUserName: string
sqlStorageUpdateSettings:
diskConfigurationType: string
diskCount: 0
startingDeviceId: 0
sqlWorkloadTypeUpdateSettings:
sqlWorkloadType: string
sqlImageOffer: string
sqlImageSku: string
sqlManagement: string
sqlServerLicenseType: string
sqlVirtualMachineGroupResourceId: string
sqlVirtualMachineName: string
storageConfigurationSettings:
diskConfigurationType: string
sqlDataSettings:
defaultFilePath: string
luns:
- 0
sqlLogSettings:
defaultFilePath: string
luns:
- 0
sqlTempDbSettings:
defaultFilePath: string
luns:
- 0
storageWorkloadType: string
tags:
string: string
virtualMachineResourceId: string
wsfcDomainCredentials:
clusterBootstrapAccountPassword: string
clusterOperatorAccountPassword: string
sqlServiceAccountPassword: string
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
In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.
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 - Auto backup settings for SQL Server.
- Auto
Patching Pulumi.Settings Azure Native. Sql Virtual Machine. Inputs. Auto Patching Settings - Auto patching settings for applying critical security updates to SQL virtual machine.
- Identity
Pulumi.
Azure Native. Sql Virtual Machine. Inputs. Resource Identity - Azure Active Directory identity of the server.
- Key
Vault Pulumi.Credential Settings Azure Native. Sql Virtual Machine. Inputs. Key Vault Credential Settings - Key vault credential settings.
- Location string
- Resource location.
- Server
Configurations Pulumi.Management Settings Azure Native. Sql Virtual Machine. Inputs. Server Configurations Management Settings - 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 - 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 - 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 - Auto backup settings for SQL Server.
- auto
Patching AutoSettings Patching Settings - Auto patching settings for applying critical security updates to SQL virtual machine.
- identity
Resource
Identity - Azure Active Directory identity of the server.
- key
Vault KeyCredential Settings Vault Credential Settings - Key vault credential settings.
- location String
- Resource location.
- server
Configurations ServerManagement Settings Configurations Management Settings - 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 - 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 - 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 - Auto backup settings for SQL Server.
- auto
Patching AutoSettings Patching Settings - Auto patching settings for applying critical security updates to SQL virtual machine.
- identity
Resource
Identity - Azure Active Directory identity of the server.
- key
Vault KeyCredential Settings Vault Credential Settings - Key vault credential settings.
- location string
- Resource location.
- server
Configurations ServerManagement Settings Configurations Management Settings - 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 - 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 - 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, AdditionalFeaturesServerConfigurationsArgs
Additional SQL Server feature settings.- 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, AdditionalFeaturesServerConfigurationsResponseArgs
Additional SQL Server feature settings.- 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, AutoBackupSettingsArgs
Configure backups for databases in your SQL virtual machine.- 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, AutoBackupSettingsResponseArgs
Configure backups for databases in your SQL virtual machine.- 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, AutoPatchingSettingsArgs
Set a patching window during which Windows and SQL patches will be applied.- 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, AutoPatchingSettingsResponseArgs
Set a patching window during which Windows and SQL patches will be applied.- 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, BackupScheduleTypeArgs
- 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, ConnectivityTypeArgs
- 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, DayOfWeekArgs
- 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, DiskConfigurationTypeArgs
- 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, FullBackupFrequencyTypeArgs
- 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, IdentityTypeArgs
- System
Assigned SystemAssigned
- Identity
Type System Assigned SystemAssigned
- System
Assigned SystemAssigned
- System
Assigned SystemAssigned
- SYSTEM_ASSIGNED
SystemAssigned
- "System
Assigned" SystemAssigned
KeyVaultCredentialSettings, KeyVaultCredentialSettingsArgs
Configure your SQL virtual machine to be able to connect to the Azure Key Vault service.- 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, KeyVaultCredentialSettingsResponseArgs
Configure your SQL virtual machine to be able to connect to the Azure Key Vault service.- 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, ResourceIdentityArgs
Azure Active Directory identity configuration for a resource.- 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, ResourceIdentityResponseArgs
Azure Active Directory identity configuration for a 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 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, SQLStorageSettingsArgs
Set disk storage settings for SQL Server.- 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, SQLStorageSettingsResponseArgs
Set disk storage settings for SQL Server.- 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, ServerConfigurationsManagementSettingsArgs
Set the connectivity, storage and workload settings.- 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, ServerConfigurationsManagementSettingsResponseArgs
Set the connectivity, storage and workload settings.- 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, SqlConnectivityUpdateSettingsArgs
Set the access level and network port settings for SQL Server.- 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, SqlConnectivityUpdateSettingsResponseArgs
Set the access level and network port settings for SQL Server.- 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, SqlImageSkuArgs
- 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, SqlManagementModeArgs
- 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, SqlServerLicenseTypeArgs
- 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, SqlStorageUpdateSettingsArgs
Set disk storage settings for SQL Server.- 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, SqlStorageUpdateSettingsResponseArgs
Set disk storage settings for SQL Server.- 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, SqlWorkloadTypeArgs
- 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, SqlWorkloadTypeUpdateSettingsArgs
Set workload type to optimize storage for SQL Server.- 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, SqlWorkloadTypeUpdateSettingsResponseArgs
Set workload type to optimize storage for SQL Server.- 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, StorageConfigurationSettingsArgs
Storage Configurations for SQL Data, Log and TempDb.- 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, StorageConfigurationSettingsResponseArgs
Storage Configurations for SQL Data, Log and TempDb.- 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, StorageWorkloadTypeArgs
- 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, WsfcDomainCredentialsArgs
Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.- 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, WsfcDomainCredentialsResponseArgs
Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.- 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
To learn more about importing existing cloud resources, see Importing resources.
Package Details
- Repository
- Azure Native pulumi/pulumi-azure-native
- License
- Apache-2.0
published on Monday, Mar 9, 2026 by Pulumi
