Azure Native

v1.88.1 published on Thursday, Dec 1, 2022 by Pulumi

SqlVirtualMachine

A SQL virtual machine. API Version: 2017-03-01-preview.

Example Usage

Creates or updates a SQL virtual machine and joins it to a SQL virtual machine group.

using System.Collections.Generic;
using Pulumi;
using AzureNative = Pulumi.AzureNative;

return await Deployment.RunAsync(() => 
{
    var sqlVirtualMachine = new AzureNative.SqlVirtualMachine.SqlVirtualMachine("sqlVirtualMachine", new()
    {
        Location = "northeurope",
        ResourceGroupName = "testrg",
        SqlVirtualMachineGroupResourceId = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachineGroups/testvmgroup",
        SqlVirtualMachineName = "testvm",
        VirtualMachineResourceId = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm2",
        WsfcDomainCredentials = new AzureNative.SqlVirtualMachine.Inputs.WsfcDomainCredentialsArgs
        {
            ClusterBootstrapAccountPassword = "<Password>",
            ClusterOperatorAccountPassword = "<Password>",
            SqlServiceAccountPassword = "<Password>",
        },
    });

});
package main

import (
	sqlvirtualmachine "github.com/pulumi/pulumi-azure-native/sdk/go/azure/sqlvirtualmachine"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := sqlvirtualmachine.NewSqlVirtualMachine(ctx, "sqlVirtualMachine", &sqlvirtualmachine.SqlVirtualMachineArgs{
			Location:                         pulumi.String("northeurope"),
			ResourceGroupName:                pulumi.String("testrg"),
			SqlVirtualMachineGroupResourceId: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachineGroups/testvmgroup"),
			SqlVirtualMachineName:            pulumi.String("testvm"),
			VirtualMachineResourceId:         pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm2"),
			WsfcDomainCredentials: &sqlvirtualmachine.WsfcDomainCredentialsArgs{
				ClusterBootstrapAccountPassword: pulumi.String("<Password>"),
				ClusterOperatorAccountPassword:  pulumi.String("<Password>"),
				SqlServiceAccountPassword:       pulumi.String("<Password>"),
			},
		})
		if err != nil {
			return err
		}
		return nil
	})
}
package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azurenative.sqlvirtualmachine.SqlVirtualMachine;
import com.pulumi.azurenative.sqlvirtualmachine.SqlVirtualMachineArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        var sqlVirtualMachine = new SqlVirtualMachine("sqlVirtualMachine", SqlVirtualMachineArgs.builder()        
            .location("northeurope")
            .resourceGroupName("testrg")
            .sqlVirtualMachineGroupResourceId("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachineGroups/testvmgroup")
            .sqlVirtualMachineName("testvm")
            .virtualMachineResourceId("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm2")
            .wsfcDomainCredentials(Map.ofEntries(
                Map.entry("clusterBootstrapAccountPassword", "<Password>"),
                Map.entry("clusterOperatorAccountPassword", "<Password>"),
                Map.entry("sqlServiceAccountPassword", "<Password>")
            ))
            .build());

    }
}
import pulumi
import pulumi_azure_native as azure_native

sql_virtual_machine = azure_native.sqlvirtualmachine.SqlVirtualMachine("sqlVirtualMachine",
    location="northeurope",
    resource_group_name="testrg",
    sql_virtual_machine_group_resource_id="/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachineGroups/testvmgroup",
    sql_virtual_machine_name="testvm",
    virtual_machine_resource_id="/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm2",
    wsfc_domain_credentials=azure_native.sqlvirtualmachine.WsfcDomainCredentialsArgs(
        cluster_bootstrap_account_password="<Password>",
        cluster_operator_account_password="<Password>",
        sql_service_account_password="<Password>",
    ))
import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";

const sqlVirtualMachine = new azure_native.sqlvirtualmachine.SqlVirtualMachine("sqlVirtualMachine", {
    location: "northeurope",
    resourceGroupName: "testrg",
    sqlVirtualMachineGroupResourceId: "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachineGroups/testvmgroup",
    sqlVirtualMachineName: "testvm",
    virtualMachineResourceId: "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm2",
    wsfcDomainCredentials: {
        clusterBootstrapAccountPassword: "<Password>",
        clusterOperatorAccountPassword: "<Password>",
        sqlServiceAccountPassword: "<Password>",
    },
});
resources:
  sqlVirtualMachine:
    type: azure-native:sqlvirtualmachine:SqlVirtualMachine
    properties:
      location: northeurope
      resourceGroupName: testrg
      sqlVirtualMachineGroupResourceId: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachineGroups/testvmgroup
      sqlVirtualMachineName: testvm
      virtualMachineResourceId: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm2
      wsfcDomainCredentials:
        clusterBootstrapAccountPassword: <Password>
        clusterOperatorAccountPassword: <Password>
        sqlServiceAccountPassword: <Password>

Creates or updates a SQL virtual machine for Storage Configuration Settings to EXTEND Data, Log or TempDB storage pool.

using System.Collections.Generic;
using Pulumi;
using AzureNative = Pulumi.AzureNative;

return await Deployment.RunAsync(() => 
{
    var sqlVirtualMachine = new AzureNative.SqlVirtualMachine.SqlVirtualMachine("sqlVirtualMachine", new()
    {
        Location = "northeurope",
        ResourceGroupName = "testrg",
        SqlVirtualMachineName = "testvm",
        StorageConfigurationSettings = new AzureNative.SqlVirtualMachine.Inputs.StorageConfigurationSettingsArgs
        {
            DiskConfigurationType = "EXTEND",
            SqlDataSettings = new AzureNative.SqlVirtualMachine.Inputs.SQLStorageSettingsArgs
            {
                Luns = new[]
                {
                    2,
                },
            },
        },
        VirtualMachineResourceId = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm",
    });

});
package main

import (
	sqlvirtualmachine "github.com/pulumi/pulumi-azure-native/sdk/go/azure/sqlvirtualmachine"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := sqlvirtualmachine.NewSqlVirtualMachine(ctx, "sqlVirtualMachine", &sqlvirtualmachine.SqlVirtualMachineArgs{
			Location:              pulumi.String("northeurope"),
			ResourceGroupName:     pulumi.String("testrg"),
			SqlVirtualMachineName: pulumi.String("testvm"),
			StorageConfigurationSettings: sqlvirtualmachine.StorageConfigurationSettingsResponse{
				DiskConfigurationType: pulumi.String("EXTEND"),
				SqlDataSettings: &sqlvirtualmachine.SQLStorageSettingsArgs{
					Luns: pulumi.IntArray{
						pulumi.Int(2),
					},
				},
			},
			VirtualMachineResourceId: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm"),
		})
		if err != nil {
			return err
		}
		return nil
	})
}
package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azurenative.sqlvirtualmachine.SqlVirtualMachine;
import com.pulumi.azurenative.sqlvirtualmachine.SqlVirtualMachineArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        var sqlVirtualMachine = new SqlVirtualMachine("sqlVirtualMachine", SqlVirtualMachineArgs.builder()        
            .location("northeurope")
            .resourceGroupName("testrg")
            .sqlVirtualMachineName("testvm")
            .storageConfigurationSettings(Map.ofEntries(
                Map.entry("diskConfigurationType", "EXTEND"),
                Map.entry("sqlDataSettings", Map.of("luns", 2))
            ))
            .virtualMachineResourceId("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm")
            .build());

    }
}
import pulumi
import pulumi_azure_native as azure_native

sql_virtual_machine = azure_native.sqlvirtualmachine.SqlVirtualMachine("sqlVirtualMachine",
    location="northeurope",
    resource_group_name="testrg",
    sql_virtual_machine_name="testvm",
    storage_configuration_settings=azure_native.sqlvirtualmachine.StorageConfigurationSettingsResponseArgs(
        disk_configuration_type="EXTEND",
        sql_data_settings=azure_native.sqlvirtualmachine.SQLStorageSettingsArgs(
            luns=[2],
        ),
    ),
    virtual_machine_resource_id="/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm")
import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";

const sqlVirtualMachine = new azure_native.sqlvirtualmachine.SqlVirtualMachine("sqlVirtualMachine", {
    location: "northeurope",
    resourceGroupName: "testrg",
    sqlVirtualMachineName: "testvm",
    storageConfigurationSettings: {
        diskConfigurationType: "EXTEND",
        sqlDataSettings: {
            luns: [2],
        },
    },
    virtualMachineResourceId: "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm",
});
resources:
  sqlVirtualMachine:
    type: azure-native:sqlvirtualmachine:SqlVirtualMachine
    properties:
      location: northeurope
      resourceGroupName: testrg
      sqlVirtualMachineName: testvm
      storageConfigurationSettings:
        diskConfigurationType: EXTEND
        sqlDataSettings:
          luns:
            - 2
      virtualMachineResourceId: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm

Creates or updates a SQL virtual machine for Storage Configuration Settings to NEW Data, Log and TempDB storage pool.

using System.Collections.Generic;
using Pulumi;
using AzureNative = Pulumi.AzureNative;

return await Deployment.RunAsync(() => 
{
    var sqlVirtualMachine = new AzureNative.SqlVirtualMachine.SqlVirtualMachine("sqlVirtualMachine", new()
    {
        Location = "northeurope",
        ResourceGroupName = "testrg",
        SqlVirtualMachineName = "testvm",
        StorageConfigurationSettings = new AzureNative.SqlVirtualMachine.Inputs.StorageConfigurationSettingsArgs
        {
            DiskConfigurationType = "NEW",
            SqlDataSettings = new AzureNative.SqlVirtualMachine.Inputs.SQLStorageSettingsArgs
            {
                DefaultFilePath = "F:\\folderpath\\",
                Luns = new[]
                {
                    0,
                },
            },
            SqlLogSettings = new AzureNative.SqlVirtualMachine.Inputs.SQLStorageSettingsArgs
            {
                DefaultFilePath = "G:\\folderpath\\",
                Luns = new[]
                {
                    1,
                },
            },
            SqlTempDbSettings = new AzureNative.SqlVirtualMachine.Inputs.SQLStorageSettingsArgs
            {
                DefaultFilePath = "D:\\TEMP",
            },
            StorageWorkloadType = "OLTP",
        },
        VirtualMachineResourceId = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm",
    });

});
package main

import (
	sqlvirtualmachine "github.com/pulumi/pulumi-azure-native/sdk/go/azure/sqlvirtualmachine"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := sqlvirtualmachine.NewSqlVirtualMachine(ctx, "sqlVirtualMachine", &sqlvirtualmachine.SqlVirtualMachineArgs{
			Location:              pulumi.String("northeurope"),
			ResourceGroupName:     pulumi.String("testrg"),
			SqlVirtualMachineName: pulumi.String("testvm"),
			StorageConfigurationSettings: sqlvirtualmachine.StorageConfigurationSettingsResponse{
				DiskConfigurationType: pulumi.String("NEW"),
				SqlDataSettings: &sqlvirtualmachine.SQLStorageSettingsArgs{
					DefaultFilePath: pulumi.String("F:\\folderpath\\"),
					Luns: pulumi.IntArray{
						pulumi.Int(0),
					},
				},
				SqlLogSettings: &sqlvirtualmachine.SQLStorageSettingsArgs{
					DefaultFilePath: pulumi.String("G:\\folderpath\\"),
					Luns: pulumi.IntArray{
						pulumi.Int(1),
					},
				},
				SqlTempDbSettings: &sqlvirtualmachine.SQLStorageSettingsArgs{
					DefaultFilePath: pulumi.String("D:\\TEMP"),
				},
				StorageWorkloadType: pulumi.String("OLTP"),
			},
			VirtualMachineResourceId: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm"),
		})
		if err != nil {
			return err
		}
		return nil
	})
}
package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azurenative.sqlvirtualmachine.SqlVirtualMachine;
import com.pulumi.azurenative.sqlvirtualmachine.SqlVirtualMachineArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        var sqlVirtualMachine = new SqlVirtualMachine("sqlVirtualMachine", SqlVirtualMachineArgs.builder()        
            .location("northeurope")
            .resourceGroupName("testrg")
            .sqlVirtualMachineName("testvm")
            .storageConfigurationSettings(Map.ofEntries(
                Map.entry("diskConfigurationType", "NEW"),
                Map.entry("sqlDataSettings", Map.ofEntries(
                    Map.entry("defaultFilePath", "F:\\folderpath\\"),
                    Map.entry("luns", 0)
                )),
                Map.entry("sqlLogSettings", Map.ofEntries(
                    Map.entry("defaultFilePath", "G:\\folderpath\\"),
                    Map.entry("luns", 1)
                )),
                Map.entry("sqlTempDbSettings", Map.of("defaultFilePath", "D:\\TEMP")),
                Map.entry("storageWorkloadType", "OLTP")
            ))
            .virtualMachineResourceId("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm")
            .build());

    }
}
import pulumi
import pulumi_azure_native as azure_native

sql_virtual_machine = azure_native.sqlvirtualmachine.SqlVirtualMachine("sqlVirtualMachine",
    location="northeurope",
    resource_group_name="testrg",
    sql_virtual_machine_name="testvm",
    storage_configuration_settings=azure_native.sqlvirtualmachine.StorageConfigurationSettingsResponseArgs(
        disk_configuration_type="NEW",
        sql_data_settings=azure_native.sqlvirtualmachine.SQLStorageSettingsArgs(
            default_file_path="F:\\folderpath\\",
            luns=[0],
        ),
        sql_log_settings=azure_native.sqlvirtualmachine.SQLStorageSettingsArgs(
            default_file_path="G:\\folderpath\\",
            luns=[1],
        ),
        sql_temp_db_settings=azure_native.sqlvirtualmachine.SQLStorageSettingsArgs(
            default_file_path="D:\\TEMP",
        ),
        storage_workload_type="OLTP",
    ),
    virtual_machine_resource_id="/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm")
import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";

const sqlVirtualMachine = new azure_native.sqlvirtualmachine.SqlVirtualMachine("sqlVirtualMachine", {
    location: "northeurope",
    resourceGroupName: "testrg",
    sqlVirtualMachineName: "testvm",
    storageConfigurationSettings: {
        diskConfigurationType: "NEW",
        sqlDataSettings: {
            defaultFilePath: "F:\\folderpath\\",
            luns: [0],
        },
        sqlLogSettings: {
            defaultFilePath: "G:\\folderpath\\",
            luns: [1],
        },
        sqlTempDbSettings: {
            defaultFilePath: "D:\\TEMP",
        },
        storageWorkloadType: "OLTP",
    },
    virtualMachineResourceId: "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm",
});
resources:
  sqlVirtualMachine:
    type: azure-native:sqlvirtualmachine:SqlVirtualMachine
    properties:
      location: northeurope
      resourceGroupName: testrg
      sqlVirtualMachineName: testvm
      storageConfigurationSettings:
        diskConfigurationType: NEW
        sqlDataSettings:
          defaultFilePath: F:\folderpath\
          luns:
            - 0
        sqlLogSettings:
          defaultFilePath: G:\folderpath\
          luns:
            - 1
        sqlTempDbSettings:
          defaultFilePath: D:\TEMP
        storageWorkloadType: OLTP
      virtualMachineResourceId: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm

Creates or updates a SQL virtual machine with max parameters.

using System.Collections.Generic;
using Pulumi;
using AzureNative = Pulumi.AzureNative;

return await Deployment.RunAsync(() => 
{
    var sqlVirtualMachine = new AzureNative.SqlVirtualMachine.SqlVirtualMachine("sqlVirtualMachine", new()
    {
        AutoBackupSettings = new AzureNative.SqlVirtualMachine.Inputs.AutoBackupSettingsArgs
        {
            BackupScheduleType = "Manual",
            BackupSystemDbs = true,
            Enable = true,
            EnableEncryption = true,
            FullBackupFrequency = "Daily",
            FullBackupStartTime = 6,
            FullBackupWindowHours = 11,
            LogBackupFrequency = 10,
            Password = "<Password>",
            RetentionPeriod = 17,
            StorageAccessKey = "<primary storage access key>",
            StorageAccountUrl = "https://teststorage.blob.core.windows.net/",
        },
        AutoPatchingSettings = new AzureNative.SqlVirtualMachine.Inputs.AutoPatchingSettingsArgs
        {
            DayOfWeek = AzureNative.SqlVirtualMachine.DayOfWeek.Sunday,
            Enable = true,
            MaintenanceWindowDuration = 60,
            MaintenanceWindowStartingHour = 2,
        },
        KeyVaultCredentialSettings = new AzureNative.SqlVirtualMachine.Inputs.KeyVaultCredentialSettingsArgs
        {
            Enable = false,
        },
        Location = "northeurope",
        ResourceGroupName = "testrg",
        ServerConfigurationsManagementSettings = new AzureNative.SqlVirtualMachine.Inputs.ServerConfigurationsManagementSettingsArgs
        {
            AdditionalFeaturesServerConfigurations = new AzureNative.SqlVirtualMachine.Inputs.AdditionalFeaturesServerConfigurationsArgs
            {
                IsRServicesEnabled = false,
            },
            SqlConnectivityUpdateSettings = new AzureNative.SqlVirtualMachine.Inputs.SqlConnectivityUpdateSettingsArgs
            {
                ConnectivityType = "PRIVATE",
                Port = 1433,
                SqlAuthUpdatePassword = "<password>",
                SqlAuthUpdateUserName = "sqllogin",
            },
            SqlStorageUpdateSettings = new AzureNative.SqlVirtualMachine.Inputs.SqlStorageUpdateSettingsArgs
            {
                DiskConfigurationType = "NEW",
                DiskCount = 1,
                StartingDeviceId = 2,
            },
            SqlWorkloadTypeUpdateSettings = new AzureNative.SqlVirtualMachine.Inputs.SqlWorkloadTypeUpdateSettingsArgs
            {
                SqlWorkloadType = "OLTP",
            },
        },
        SqlImageSku = "Enterprise",
        SqlManagement = "Full",
        SqlServerLicenseType = "PAYG",
        SqlVirtualMachineName = "testvm",
        VirtualMachineResourceId = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm",
    });

});
package main

import (
	sqlvirtualmachine "github.com/pulumi/pulumi-azure-native/sdk/go/azure/sqlvirtualmachine"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := sqlvirtualmachine.NewSqlVirtualMachine(ctx, "sqlVirtualMachine", &sqlvirtualmachine.SqlVirtualMachineArgs{
			AutoBackupSettings: &sqlvirtualmachine.AutoBackupSettingsArgs{
				BackupScheduleType:    pulumi.String("Manual"),
				BackupSystemDbs:       pulumi.Bool(true),
				Enable:                pulumi.Bool(true),
				EnableEncryption:      pulumi.Bool(true),
				FullBackupFrequency:   pulumi.String("Daily"),
				FullBackupStartTime:   pulumi.Int(6),
				FullBackupWindowHours: pulumi.Int(11),
				LogBackupFrequency:    pulumi.Int(10),
				Password:              pulumi.String("<Password>"),
				RetentionPeriod:       pulumi.Int(17),
				StorageAccessKey:      pulumi.String("<primary storage access key>"),
				StorageAccountUrl:     pulumi.String("https://teststorage.blob.core.windows.net/"),
			},
			AutoPatchingSettings: &sqlvirtualmachine.AutoPatchingSettingsArgs{
				DayOfWeek:                     sqlvirtualmachine.DayOfWeekSunday,
				Enable:                        pulumi.Bool(true),
				MaintenanceWindowDuration:     pulumi.Int(60),
				MaintenanceWindowStartingHour: pulumi.Int(2),
			},
			KeyVaultCredentialSettings: &sqlvirtualmachine.KeyVaultCredentialSettingsArgs{
				Enable: pulumi.Bool(false),
			},
			Location:          pulumi.String("northeurope"),
			ResourceGroupName: pulumi.String("testrg"),
			ServerConfigurationsManagementSettings: sqlvirtualmachine.ServerConfigurationsManagementSettingsResponse{
				AdditionalFeaturesServerConfigurations: &sqlvirtualmachine.AdditionalFeaturesServerConfigurationsArgs{
					IsRServicesEnabled: pulumi.Bool(false),
				},
				SqlConnectivityUpdateSettings: &sqlvirtualmachine.SqlConnectivityUpdateSettingsArgs{
					ConnectivityType:      pulumi.String("PRIVATE"),
					Port:                  pulumi.Int(1433),
					SqlAuthUpdatePassword: pulumi.String("<password>"),
					SqlAuthUpdateUserName: pulumi.String("sqllogin"),
				},
				SqlStorageUpdateSettings: &sqlvirtualmachine.SqlStorageUpdateSettingsArgs{
					DiskConfigurationType: pulumi.String("NEW"),
					DiskCount:             pulumi.Int(1),
					StartingDeviceId:      pulumi.Int(2),
				},
				SqlWorkloadTypeUpdateSettings: &sqlvirtualmachine.SqlWorkloadTypeUpdateSettingsArgs{
					SqlWorkloadType: pulumi.String("OLTP"),
				},
			},
			SqlImageSku:              pulumi.String("Enterprise"),
			SqlManagement:            pulumi.String("Full"),
			SqlServerLicenseType:     pulumi.String("PAYG"),
			SqlVirtualMachineName:    pulumi.String("testvm"),
			VirtualMachineResourceId: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm"),
		})
		if err != nil {
			return err
		}
		return nil
	})
}
package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azurenative.sqlvirtualmachine.SqlVirtualMachine;
import com.pulumi.azurenative.sqlvirtualmachine.SqlVirtualMachineArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        var sqlVirtualMachine = new SqlVirtualMachine("sqlVirtualMachine", SqlVirtualMachineArgs.builder()        
            .autoBackupSettings(Map.ofEntries(
                Map.entry("backupScheduleType", "Manual"),
                Map.entry("backupSystemDbs", true),
                Map.entry("enable", true),
                Map.entry("enableEncryption", true),
                Map.entry("fullBackupFrequency", "Daily"),
                Map.entry("fullBackupStartTime", 6),
                Map.entry("fullBackupWindowHours", 11),
                Map.entry("logBackupFrequency", 10),
                Map.entry("password", "<Password>"),
                Map.entry("retentionPeriod", 17),
                Map.entry("storageAccessKey", "<primary storage access key>"),
                Map.entry("storageAccountUrl", "https://teststorage.blob.core.windows.net/")
            ))
            .autoPatchingSettings(Map.ofEntries(
                Map.entry("dayOfWeek", "Sunday"),
                Map.entry("enable", true),
                Map.entry("maintenanceWindowDuration", 60),
                Map.entry("maintenanceWindowStartingHour", 2)
            ))
            .keyVaultCredentialSettings(Map.of("enable", false))
            .location("northeurope")
            .resourceGroupName("testrg")
            .serverConfigurationsManagementSettings(Map.ofEntries(
                Map.entry("additionalFeaturesServerConfigurations", Map.of("isRServicesEnabled", false)),
                Map.entry("sqlConnectivityUpdateSettings", Map.ofEntries(
                    Map.entry("connectivityType", "PRIVATE"),
                    Map.entry("port", 1433),
                    Map.entry("sqlAuthUpdatePassword", "<password>"),
                    Map.entry("sqlAuthUpdateUserName", "sqllogin")
                )),
                Map.entry("sqlStorageUpdateSettings", Map.ofEntries(
                    Map.entry("diskConfigurationType", "NEW"),
                    Map.entry("diskCount", 1),
                    Map.entry("startingDeviceId", 2)
                )),
                Map.entry("sqlWorkloadTypeUpdateSettings", Map.of("sqlWorkloadType", "OLTP"))
            ))
            .sqlImageSku("Enterprise")
            .sqlManagement("Full")
            .sqlServerLicenseType("PAYG")
            .sqlVirtualMachineName("testvm")
            .virtualMachineResourceId("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm")
            .build());

    }
}
import pulumi
import pulumi_azure_native as azure_native

sql_virtual_machine = azure_native.sqlvirtualmachine.SqlVirtualMachine("sqlVirtualMachine",
    auto_backup_settings=azure_native.sqlvirtualmachine.AutoBackupSettingsArgs(
        backup_schedule_type="Manual",
        backup_system_dbs=True,
        enable=True,
        enable_encryption=True,
        full_backup_frequency="Daily",
        full_backup_start_time=6,
        full_backup_window_hours=11,
        log_backup_frequency=10,
        password="<Password>",
        retention_period=17,
        storage_access_key="<primary storage access key>",
        storage_account_url="https://teststorage.blob.core.windows.net/",
    ),
    auto_patching_settings=azure_native.sqlvirtualmachine.AutoPatchingSettingsArgs(
        day_of_week=azure_native.sqlvirtualmachine.DayOfWeek.SUNDAY,
        enable=True,
        maintenance_window_duration=60,
        maintenance_window_starting_hour=2,
    ),
    key_vault_credential_settings=azure_native.sqlvirtualmachine.KeyVaultCredentialSettingsArgs(
        enable=False,
    ),
    location="northeurope",
    resource_group_name="testrg",
    server_configurations_management_settings=azure_native.sqlvirtualmachine.ServerConfigurationsManagementSettingsResponseArgs(
        additional_features_server_configurations=azure_native.sqlvirtualmachine.AdditionalFeaturesServerConfigurationsArgs(
            is_r_services_enabled=False,
        ),
        sql_connectivity_update_settings=azure_native.sqlvirtualmachine.SqlConnectivityUpdateSettingsArgs(
            connectivity_type="PRIVATE",
            port=1433,
            sql_auth_update_password="<password>",
            sql_auth_update_user_name="sqllogin",
        ),
        sql_storage_update_settings=azure_native.sqlvirtualmachine.SqlStorageUpdateSettingsArgs(
            disk_configuration_type="NEW",
            disk_count=1,
            starting_device_id=2,
        ),
        sql_workload_type_update_settings=azure_native.sqlvirtualmachine.SqlWorkloadTypeUpdateSettingsArgs(
            sql_workload_type="OLTP",
        ),
    ),
    sql_image_sku="Enterprise",
    sql_management="Full",
    sql_server_license_type="PAYG",
    sql_virtual_machine_name="testvm",
    virtual_machine_resource_id="/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm")
import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";

const sqlVirtualMachine = new azure_native.sqlvirtualmachine.SqlVirtualMachine("sqlVirtualMachine", {
    autoBackupSettings: {
        backupScheduleType: "Manual",
        backupSystemDbs: true,
        enable: true,
        enableEncryption: true,
        fullBackupFrequency: "Daily",
        fullBackupStartTime: 6,
        fullBackupWindowHours: 11,
        logBackupFrequency: 10,
        password: "<Password>",
        retentionPeriod: 17,
        storageAccessKey: "<primary storage access key>",
        storageAccountUrl: "https://teststorage.blob.core.windows.net/",
    },
    autoPatchingSettings: {
        dayOfWeek: azure_native.sqlvirtualmachine.DayOfWeek.Sunday,
        enable: true,
        maintenanceWindowDuration: 60,
        maintenanceWindowStartingHour: 2,
    },
    keyVaultCredentialSettings: {
        enable: false,
    },
    location: "northeurope",
    resourceGroupName: "testrg",
    serverConfigurationsManagementSettings: {
        additionalFeaturesServerConfigurations: {
            isRServicesEnabled: false,
        },
        sqlConnectivityUpdateSettings: {
            connectivityType: "PRIVATE",
            port: 1433,
            sqlAuthUpdatePassword: "<password>",
            sqlAuthUpdateUserName: "sqllogin",
        },
        sqlStorageUpdateSettings: {
            diskConfigurationType: "NEW",
            diskCount: 1,
            startingDeviceId: 2,
        },
        sqlWorkloadTypeUpdateSettings: {
            sqlWorkloadType: "OLTP",
        },
    },
    sqlImageSku: "Enterprise",
    sqlManagement: "Full",
    sqlServerLicenseType: "PAYG",
    sqlVirtualMachineName: "testvm",
    virtualMachineResourceId: "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm",
});
resources:
  sqlVirtualMachine:
    type: azure-native:sqlvirtualmachine:SqlVirtualMachine
    properties:
      autoBackupSettings:
        backupScheduleType: Manual
        backupSystemDbs: true
        enable: true
        enableEncryption: true
        fullBackupFrequency: Daily
        fullBackupStartTime: 6
        fullBackupWindowHours: 11
        logBackupFrequency: 10
        password: <Password>
        retentionPeriod: 17
        storageAccessKey: <primary storage access key>
        storageAccountUrl: https://teststorage.blob.core.windows.net/
      autoPatchingSettings:
        dayOfWeek: Sunday
        enable: true
        maintenanceWindowDuration: 60
        maintenanceWindowStartingHour: 2
      keyVaultCredentialSettings:
        enable: false
      location: northeurope
      resourceGroupName: testrg
      serverConfigurationsManagementSettings:
        additionalFeaturesServerConfigurations:
          isRServicesEnabled: false
        sqlConnectivityUpdateSettings:
          connectivityType: PRIVATE
          port: 1433
          sqlAuthUpdatePassword: <password>
          sqlAuthUpdateUserName: sqllogin
        sqlStorageUpdateSettings:
          diskConfigurationType: NEW
          diskCount: 1
          startingDeviceId: 2
        sqlWorkloadTypeUpdateSettings:
          sqlWorkloadType: OLTP
      sqlImageSku: Enterprise
      sqlManagement: Full
      sqlServerLicenseType: PAYG
      sqlVirtualMachineName: testvm
      virtualMachineResourceId: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm

Creates or updates a SQL virtual machine with min parameters.

using System.Collections.Generic;
using Pulumi;
using AzureNative = Pulumi.AzureNative;

return await Deployment.RunAsync(() => 
{
    var sqlVirtualMachine = new AzureNative.SqlVirtualMachine.SqlVirtualMachine("sqlVirtualMachine", new()
    {
        Location = "northeurope",
        ResourceGroupName = "testrg",
        SqlVirtualMachineName = "testvm",
        VirtualMachineResourceId = "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm",
    });

});
package main

import (
	sqlvirtualmachine "github.com/pulumi/pulumi-azure-native/sdk/go/azure/sqlvirtualmachine"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := sqlvirtualmachine.NewSqlVirtualMachine(ctx, "sqlVirtualMachine", &sqlvirtualmachine.SqlVirtualMachineArgs{
			Location:                 pulumi.String("northeurope"),
			ResourceGroupName:        pulumi.String("testrg"),
			SqlVirtualMachineName:    pulumi.String("testvm"),
			VirtualMachineResourceId: pulumi.String("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm"),
		})
		if err != nil {
			return err
		}
		return nil
	})
}
package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azurenative.sqlvirtualmachine.SqlVirtualMachine;
import com.pulumi.azurenative.sqlvirtualmachine.SqlVirtualMachineArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        var sqlVirtualMachine = new SqlVirtualMachine("sqlVirtualMachine", SqlVirtualMachineArgs.builder()        
            .location("northeurope")
            .resourceGroupName("testrg")
            .sqlVirtualMachineName("testvm")
            .virtualMachineResourceId("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm")
            .build());

    }
}
import pulumi
import pulumi_azure_native as azure_native

sql_virtual_machine = azure_native.sqlvirtualmachine.SqlVirtualMachine("sqlVirtualMachine",
    location="northeurope",
    resource_group_name="testrg",
    sql_virtual_machine_name="testvm",
    virtual_machine_resource_id="/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm")
import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";

const sqlVirtualMachine = new azure_native.sqlvirtualmachine.SqlVirtualMachine("sqlVirtualMachine", {
    location: "northeurope",
    resourceGroupName: "testrg",
    sqlVirtualMachineName: "testvm",
    virtualMachineResourceId: "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm",
});
resources:
  sqlVirtualMachine:
    type: azure-native:sqlvirtualmachine:SqlVirtualMachine
    properties:
      location: northeurope
      resourceGroupName: testrg
      sqlVirtualMachineName: testvm
      virtualMachineResourceId: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.Compute/virtualMachines/testvm

Create SqlVirtualMachine Resource

new SqlVirtualMachine(name: string, args: SqlVirtualMachineArgs, opts?: CustomResourceOptions);
@overload
def SqlVirtualMachine(resource_name: str,
                      opts: Optional[ResourceOptions] = None,
                      auto_backup_settings: Optional[AutoBackupSettingsArgs] = None,
                      auto_patching_settings: Optional[AutoPatchingSettingsArgs] = None,
                      identity: Optional[ResourceIdentityArgs] = None,
                      key_vault_credential_settings: Optional[KeyVaultCredentialSettingsArgs] = None,
                      location: Optional[str] = None,
                      resource_group_name: Optional[str] = None,
                      server_configurations_management_settings: Optional[ServerConfigurationsManagementSettingsArgs] = None,
                      sql_image_offer: Optional[str] = None,
                      sql_image_sku: Optional[Union[str, SqlImageSku]] = None,
                      sql_management: Optional[Union[str, SqlManagementMode]] = None,
                      sql_server_license_type: Optional[Union[str, SqlServerLicenseType]] = None,
                      sql_virtual_machine_group_resource_id: Optional[str] = None,
                      sql_virtual_machine_name: Optional[str] = None,
                      storage_configuration_settings: Optional[StorageConfigurationSettingsArgs] = None,
                      tags: Optional[Mapping[str, str]] = None,
                      virtual_machine_resource_id: Optional[str] = None,
                      wsfc_domain_credentials: Optional[WsfcDomainCredentialsArgs] = None)
@overload
def SqlVirtualMachine(resource_name: str,
                      args: SqlVirtualMachineArgs,
                      opts: Optional[ResourceOptions] = None)
func NewSqlVirtualMachine(ctx *Context, name string, args SqlVirtualMachineArgs, opts ...ResourceOption) (*SqlVirtualMachine, error)
public SqlVirtualMachine(string name, SqlVirtualMachineArgs args, CustomResourceOptions? opts = null)
public SqlVirtualMachine(String name, SqlVirtualMachineArgs args)
public SqlVirtualMachine(String name, SqlVirtualMachineArgs args, CustomResourceOptions options)
type: azure-native:sqlvirtualmachine:SqlVirtualMachine
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.

name string
The unique name of the resource.
args SqlVirtualMachineArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
resource_name str
The unique name of the resource.
args SqlVirtualMachineArgs
The arguments to resource properties.
opts ResourceOptions
Bag of options to control resource's behavior.
ctx Context
Context object for the current deployment.
name string
The unique name of the resource.
args SqlVirtualMachineArgs
The arguments to resource properties.
opts ResourceOption
Bag of options to control resource's behavior.
name string
The unique name of the resource.
args SqlVirtualMachineArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
name String
The unique name of the resource.
args SqlVirtualMachineArgs
The arguments to resource properties.
options CustomResourceOptions
Bag of options to control resource's behavior.

SqlVirtualMachine Resource Properties

To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

Inputs

The SqlVirtualMachine resource accepts the following input properties:

ResourceGroupName string

Name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

AutoBackupSettings Pulumi.AzureNative.SqlVirtualMachine.Inputs.AutoBackupSettingsArgs

Auto backup settings for SQL Server.

AutoPatchingSettings Pulumi.AzureNative.SqlVirtualMachine.Inputs.AutoPatchingSettingsArgs

Auto patching settings for applying critical security updates to SQL virtual machine.

Identity Pulumi.AzureNative.SqlVirtualMachine.Inputs.ResourceIdentityArgs

Azure Active Directory identity of the server.

KeyVaultCredentialSettings Pulumi.AzureNative.SqlVirtualMachine.Inputs.KeyVaultCredentialSettingsArgs

Key vault credential settings.

Location string

Resource location.

ServerConfigurationsManagementSettings Pulumi.AzureNative.SqlVirtualMachine.Inputs.ServerConfigurationsManagementSettingsArgs

SQL Server configuration management settings.

SqlImageOffer string

SQL image offer. Examples include SQL2016-WS2016, SQL2017-WS2016.

SqlImageSku string | Pulumi.AzureNative.SqlVirtualMachine.SqlImageSku

SQL Server edition type.

SqlManagement string | Pulumi.AzureNative.SqlVirtualMachine.SqlManagementMode

SQL Server Management type.

SqlServerLicenseType string | Pulumi.AzureNative.SqlVirtualMachine.SqlServerLicenseType

SQL Server license type.

SqlVirtualMachineGroupResourceId string

ARM resource id of the SQL virtual machine group this SQL virtual machine is or will be part of.

SqlVirtualMachineName string

Name of the SQL virtual machine.

StorageConfigurationSettings Pulumi.AzureNative.SqlVirtualMachine.Inputs.StorageConfigurationSettingsArgs

Storage Configuration Settings.

Tags Dictionary<string, string>

Resource tags.

VirtualMachineResourceId string

ARM Resource id of underlying virtual machine created from SQL marketplace image.

WsfcDomainCredentials Pulumi.AzureNative.SqlVirtualMachine.Inputs.WsfcDomainCredentialsArgs

Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.

ResourceGroupName string

Name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

AutoBackupSettings AutoBackupSettingsArgs

Auto backup settings for SQL Server.

AutoPatchingSettings AutoPatchingSettingsArgs

Auto patching settings for applying critical security updates to SQL virtual machine.

Identity ResourceIdentityArgs

Azure Active Directory identity of the server.

KeyVaultCredentialSettings KeyVaultCredentialSettingsArgs

Key vault credential settings.

Location string

Resource location.

ServerConfigurationsManagementSettings ServerConfigurationsManagementSettingsArgs

SQL Server configuration management settings.

SqlImageOffer string

SQL image offer. Examples include SQL2016-WS2016, SQL2017-WS2016.

SqlImageSku string | SqlImageSku

SQL Server edition type.

SqlManagement string | SqlManagementMode

SQL Server Management type.

SqlServerLicenseType string | SqlServerLicenseType

SQL Server license type.

SqlVirtualMachineGroupResourceId string

ARM resource id of the SQL virtual machine group this SQL virtual machine is or will be part of.

SqlVirtualMachineName string

Name of the SQL virtual machine.

StorageConfigurationSettings StorageConfigurationSettingsArgs

Storage Configuration Settings.

Tags map[string]string

Resource tags.

VirtualMachineResourceId string

ARM Resource id of underlying virtual machine created from SQL marketplace image.

WsfcDomainCredentials WsfcDomainCredentialsArgs

Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.

resourceGroupName String

Name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

autoBackupSettings AutoBackupSettingsArgs

Auto backup settings for SQL Server.

autoPatchingSettings AutoPatchingSettingsArgs

Auto patching settings for applying critical security updates to SQL virtual machine.

identity ResourceIdentityArgs

Azure Active Directory identity of the server.

keyVaultCredentialSettings KeyVaultCredentialSettingsArgs

Key vault credential settings.

location String

Resource location.

serverConfigurationsManagementSettings ServerConfigurationsManagementSettingsArgs

SQL Server configuration management settings.

sqlImageOffer String

SQL image offer. Examples include SQL2016-WS2016, SQL2017-WS2016.

sqlImageSku String | SqlImageSku

SQL Server edition type.

sqlManagement String | SqlManagementMode

SQL Server Management type.

sqlServerLicenseType String | SqlServerLicenseType

SQL Server license type.

sqlVirtualMachineGroupResourceId String

ARM resource id of the SQL virtual machine group this SQL virtual machine is or will be part of.

sqlVirtualMachineName String

Name of the SQL virtual machine.

storageConfigurationSettings StorageConfigurationSettingsArgs

Storage Configuration Settings.

tags Map<String,String>

Resource tags.

virtualMachineResourceId String

ARM Resource id of underlying virtual machine created from SQL marketplace image.

wsfcDomainCredentials WsfcDomainCredentialsArgs

Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.

resourceGroupName string

Name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

autoBackupSettings AutoBackupSettingsArgs

Auto backup settings for SQL Server.

autoPatchingSettings AutoPatchingSettingsArgs

Auto patching settings for applying critical security updates to SQL virtual machine.

identity ResourceIdentityArgs

Azure Active Directory identity of the server.

keyVaultCredentialSettings KeyVaultCredentialSettingsArgs

Key vault credential settings.

location string

Resource location.

serverConfigurationsManagementSettings ServerConfigurationsManagementSettingsArgs

SQL Server configuration management settings.

sqlImageOffer string

SQL image offer. Examples include SQL2016-WS2016, SQL2017-WS2016.

sqlImageSku string | SqlImageSku

SQL Server edition type.

sqlManagement string | SqlManagementMode

SQL Server Management type.

sqlServerLicenseType string | SqlServerLicenseType

SQL Server license type.

sqlVirtualMachineGroupResourceId string

ARM resource id of the SQL virtual machine group this SQL virtual machine is or will be part of.

sqlVirtualMachineName string

Name of the SQL virtual machine.

storageConfigurationSettings StorageConfigurationSettingsArgs

Storage Configuration Settings.

tags {[key: string]: string}

Resource tags.

virtualMachineResourceId string

ARM Resource id of underlying virtual machine created from SQL marketplace image.

wsfcDomainCredentials WsfcDomainCredentialsArgs

Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.

resource_group_name str

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_settings AutoBackupSettingsArgs

Auto backup settings for SQL Server.

auto_patching_settings AutoPatchingSettingsArgs

Auto patching settings for applying critical security updates to SQL virtual machine.

identity ResourceIdentityArgs

Azure Active Directory identity of the server.

key_vault_credential_settings KeyVaultCredentialSettingsArgs

Key vault credential settings.

location str

Resource location.

server_configurations_management_settings ServerConfigurationsManagementSettingsArgs

SQL Server configuration management settings.

sql_image_offer str

SQL image offer. Examples include SQL2016-WS2016, SQL2017-WS2016.

sql_image_sku str | SqlImageSku

SQL Server edition type.

sql_management str | SqlManagementMode

SQL Server Management type.

sql_server_license_type str | SqlServerLicenseType

SQL Server license type.

sql_virtual_machine_group_resource_id str

ARM resource id of the SQL virtual machine group this SQL virtual machine is or will be part of.

sql_virtual_machine_name str

Name of the SQL virtual machine.

storage_configuration_settings StorageConfigurationSettingsArgs

Storage Configuration Settings.

tags Mapping[str, str]

Resource tags.

virtual_machine_resource_id str

ARM Resource id of underlying virtual machine created from SQL marketplace image.

wsfc_domain_credentials WsfcDomainCredentialsArgs

Domain credentials for setting up Windows Server Failover Cluster for SQL availability group.

resourceGroupName String

Name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

autoBackupSettings Property Map

Auto backup settings for SQL Server.

autoPatchingSettings Property Map

Auto patching settings for applying critical security updates to SQL virtual machine.

identity Property Map

Azure Active Directory identity of the server.

keyVaultCredentialSettings Property Map

Key vault credential settings.

location String

Resource location.

serverConfigurationsManagementSettings Property Map

SQL Server configuration management settings.

sqlImageOffer String

SQL image offer. Examples include SQL2016-WS2016, SQL2017-WS2016.

sqlImageSku String | "Developer" | "Express" | "Standard" | "Enterprise" | "Web"

SQL Server edition type.

sqlManagement String | "Full" | "LightWeight" | "NoAgent"

SQL Server Management type.

sqlServerLicenseType String | "PAYG" | "AHUB" | "DR"

SQL Server license type.

sqlVirtualMachineGroupResourceId String

ARM resource id of the SQL virtual machine group this SQL virtual machine is or will be part of.

sqlVirtualMachineName String

Name of the SQL virtual machine.

storageConfigurationSettings Property Map

Storage Configuration Settings.

tags Map<String>

Resource tags.

virtualMachineResourceId String

ARM Resource id of underlying virtual machine created from SQL marketplace image.

wsfcDomainCredentials Property Map

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.

ProvisioningState 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.

ProvisioningState 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.

provisioningState 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.

provisioningState 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.

provisioningState String

Provisioning state to track the async operation status.

type String

Resource type.

Supporting Types

AdditionalFeaturesServerConfigurations

IsRServicesEnabled bool

Enable or disable R services (SQL 2016 onwards).

IsRServicesEnabled bool

Enable or disable R services (SQL 2016 onwards).

isRServicesEnabled Boolean

Enable or disable R services (SQL 2016 onwards).

isRServicesEnabled boolean

Enable or disable R services (SQL 2016 onwards).

is_r_services_enabled bool

Enable or disable R services (SQL 2016 onwards).

isRServicesEnabled Boolean

Enable or disable R services (SQL 2016 onwards).

AdditionalFeaturesServerConfigurationsResponse

IsRServicesEnabled bool

Enable or disable R services (SQL 2016 onwards).

IsRServicesEnabled bool

Enable or disable R services (SQL 2016 onwards).

isRServicesEnabled Boolean

Enable or disable R services (SQL 2016 onwards).

isRServicesEnabled boolean

Enable or disable R services (SQL 2016 onwards).

is_r_services_enabled bool

Enable or disable R services (SQL 2016 onwards).

isRServicesEnabled Boolean

Enable or disable R services (SQL 2016 onwards).

AutoBackupSettings

BackupScheduleType string | Pulumi.AzureNative.SqlVirtualMachine.BackupScheduleType

Backup schedule type.

BackupSystemDbs bool

Include or exclude system databases from auto backup.

Enable bool

Enable or disable autobackup on SQL virtual machine.

EnableEncryption bool

Enable or disable encryption for backup on SQL virtual machine.

FullBackupFrequency string | Pulumi.AzureNative.SqlVirtualMachine.FullBackupFrequencyType

Frequency of full backups. In both cases, full backups begin during the next scheduled time window.

FullBackupStartTime int

Start time of a given day during which full backups can take place. 0-23 hours.

FullBackupWindowHours int

Duration of the time window of a given day during which full backups can take place. 1-23 hours.

LogBackupFrequency int

Frequency of log backups. 5-60 minutes.

Password string

Password for encryption on backup.

RetentionPeriod int

Retention period of backup: 1-30 days.

StorageAccessKey string

Storage account key where backup will be taken to.

StorageAccountUrl string

Storage account url where backup will be taken to.

BackupScheduleType string | BackupScheduleType

Backup schedule type.

BackupSystemDbs bool

Include or exclude system databases from auto backup.

Enable bool

Enable or disable autobackup on SQL virtual machine.

EnableEncryption bool

Enable or disable encryption for backup on SQL virtual machine.

FullBackupFrequency string | FullBackupFrequencyType

Frequency of full backups. In both cases, full backups begin during the next scheduled time window.

FullBackupStartTime int

Start time of a given day during which full backups can take place. 0-23 hours.

FullBackupWindowHours int

Duration of the time window of a given day during which full backups can take place. 1-23 hours.

LogBackupFrequency int

Frequency of log backups. 5-60 minutes.

Password string

Password for encryption on backup.

RetentionPeriod int

Retention period of backup: 1-30 days.

StorageAccessKey string

Storage account key where backup will be taken to.

StorageAccountUrl string

Storage account url where backup will be taken to.

backupScheduleType String | BackupScheduleType

Backup schedule type.

backupSystemDbs Boolean

Include or exclude system databases from auto backup.

enable Boolean

Enable or disable autobackup on SQL virtual machine.

enableEncryption Boolean

Enable or disable encryption for backup on SQL virtual machine.

fullBackupFrequency String | FullBackupFrequencyType

Frequency of full backups. In both cases, full backups begin during the next scheduled time window.

fullBackupStartTime Integer

Start time of a given day during which full backups can take place. 0-23 hours.

fullBackupWindowHours Integer

Duration of the time window of a given day during which full backups can take place. 1-23 hours.

logBackupFrequency Integer

Frequency of log backups. 5-60 minutes.

password String

Password for encryption on backup.

retentionPeriod Integer

Retention period of backup: 1-30 days.

storageAccessKey String

Storage account key where backup will be taken to.

storageAccountUrl String

Storage account url where backup will be taken to.

backupScheduleType string | BackupScheduleType

Backup schedule type.

backupSystemDbs boolean

Include or exclude system databases from auto backup.

enable boolean

Enable or disable autobackup on SQL virtual machine.

enableEncryption boolean

Enable or disable encryption for backup on SQL virtual machine.

fullBackupFrequency string | FullBackupFrequencyType

Frequency of full backups. In both cases, full backups begin during the next scheduled time window.

fullBackupStartTime number

Start time of a given day during which full backups can take place. 0-23 hours.

fullBackupWindowHours number

Duration of the time window of a given day during which full backups can take place. 1-23 hours.

logBackupFrequency number

Frequency of log backups. 5-60 minutes.

password string

Password for encryption on backup.

retentionPeriod number

Retention period of backup: 1-30 days.

storageAccessKey string

Storage account key where backup will be taken to.

storageAccountUrl string

Storage account url where backup will be taken to.

backup_schedule_type str | BackupScheduleType

Backup schedule type.

backup_system_dbs bool

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_frequency str | FullBackupFrequencyType

Frequency of full backups. In both cases, full backups begin during the next scheduled time window.

full_backup_start_time int

Start time of a given day during which full backups can take place. 0-23 hours.

full_backup_window_hours int

Duration of the time window of a given day during which full backups can take place. 1-23 hours.

log_backup_frequency int

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_key str

Storage account key where backup will be taken to.

storage_account_url str

Storage account url where backup will be taken to.

backupScheduleType String | "Manual" | "Automated"

Backup schedule type.

backupSystemDbs Boolean

Include or exclude system databases from auto backup.

enable Boolean

Enable or disable autobackup on SQL virtual machine.

enableEncryption Boolean

Enable or disable encryption for backup on SQL virtual machine.

fullBackupFrequency String | "Daily" | "Weekly"

Frequency of full backups. In both cases, full backups begin during the next scheduled time window.

fullBackupStartTime Number

Start time of a given day during which full backups can take place. 0-23 hours.

fullBackupWindowHours Number

Duration of the time window of a given day during which full backups can take place. 1-23 hours.

logBackupFrequency Number

Frequency of log backups. 5-60 minutes.

password String

Password for encryption on backup.

retentionPeriod Number

Retention period of backup: 1-30 days.

storageAccessKey String

Storage account key where backup will be taken to.

storageAccountUrl String

Storage account url where backup will be taken to.

AutoBackupSettingsResponse

BackupScheduleType string

Backup schedule type.

BackupSystemDbs bool

Include or exclude system databases from auto backup.

Enable bool

Enable or disable autobackup on SQL virtual machine.

EnableEncryption bool

Enable or disable encryption for backup on SQL virtual machine.

FullBackupFrequency string

Frequency of full backups. In both cases, full backups begin during the next scheduled time window.

FullBackupStartTime int

Start time of a given day during which full backups can take place. 0-23 hours.

FullBackupWindowHours int

Duration of the time window of a given day during which full backups can take place. 1-23 hours.

LogBackupFrequency int

Frequency of log backups. 5-60 minutes.

RetentionPeriod int

Retention period of backup: 1-30 days.

StorageAccountUrl string

Storage account url where backup will be taken to.

BackupScheduleType string

Backup schedule type.

BackupSystemDbs bool

Include or exclude system databases from auto backup.

Enable bool

Enable or disable autobackup on SQL virtual machine.

EnableEncryption bool

Enable or disable encryption for backup on SQL virtual machine.

FullBackupFrequency string

Frequency of full backups. In both cases, full backups begin during the next scheduled time window.

FullBackupStartTime int

Start time of a given day during which full backups can take place. 0-23 hours.

FullBackupWindowHours int

Duration of the time window of a given day during which full backups can take place. 1-23 hours.

LogBackupFrequency int

Frequency of log backups. 5-60 minutes.

RetentionPeriod int

Retention period of backup: 1-30 days.

StorageAccountUrl string

Storage account url where backup will be taken to.

backupScheduleType String

Backup schedule type.

backupSystemDbs Boolean

Include or exclude system databases from auto backup.

enable Boolean

Enable or disable autobackup on SQL virtual machine.

enableEncryption Boolean

Enable or disable encryption for backup on SQL virtual machine.

fullBackupFrequency String

Frequency of full backups. In both cases, full backups begin during the next scheduled time window.

fullBackupStartTime Integer

Start time of a given day during which full backups can take place. 0-23 hours.

fullBackupWindowHours Integer

Duration of the time window of a given day during which full backups can take place. 1-23 hours.

logBackupFrequency Integer

Frequency of log backups. 5-60 minutes.

retentionPeriod Integer

Retention period of backup: 1-30 days.

storageAccountUrl String

Storage account url where backup will be taken to.

backupScheduleType string

Backup schedule type.

backupSystemDbs boolean

Include or exclude system databases from auto backup.

enable boolean

Enable or disable autobackup on SQL virtual machine.

enableEncryption boolean

Enable or disable encryption for backup on SQL virtual machine.

fullBackupFrequency string

Frequency of full backups. In both cases, full backups begin during the next scheduled time window.

fullBackupStartTime number

Start time of a given day during which full backups can take place. 0-23 hours.

fullBackupWindowHours number

Duration of the time window of a given day during which full backups can take place. 1-23 hours.

logBackupFrequency number

Frequency of log backups. 5-60 minutes.

retentionPeriod number

Retention period of backup: 1-30 days.

storageAccountUrl string

Storage account url where backup will be taken to.

backup_schedule_type str

Backup schedule type.

backup_system_dbs bool

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_frequency str

Frequency of full backups. In both cases, full backups begin during the next scheduled time window.

full_backup_start_time int

Start time of a given day during which full backups can take place. 0-23 hours.

full_backup_window_hours int

Duration of the time window of a given day during which full backups can take place. 1-23 hours.

log_backup_frequency int

Frequency of log backups. 5-60 minutes.

retention_period int

Retention period of backup: 1-30 days.

storage_account_url str

Storage account url where backup will be taken to.

backupScheduleType String

Backup schedule type.

backupSystemDbs Boolean

Include or exclude system databases from auto backup.

enable Boolean

Enable or disable autobackup on SQL virtual machine.

enableEncryption Boolean

Enable or disable encryption for backup on SQL virtual machine.

fullBackupFrequency String

Frequency of full backups. In both cases, full backups begin during the next scheduled time window.

fullBackupStartTime Number

Start time of a given day during which full backups can take place. 0-23 hours.

fullBackupWindowHours Number

Duration of the time window of a given day during which full backups can take place. 1-23 hours.

logBackupFrequency Number

Frequency of log backups. 5-60 minutes.

retentionPeriod Number

Retention period of backup: 1-30 days.

storageAccountUrl String

Storage account url where backup will be taken to.

AutoPatchingSettings

DayOfWeek Pulumi.AzureNative.SqlVirtualMachine.DayOfWeek

Day of week to apply the patch on.

Enable bool

Enable or disable autopatching on SQL virtual machine.

MaintenanceWindowDuration int

Duration of patching.

MaintenanceWindowStartingHour int

Hour of the day when patching is initiated. Local VM time.

DayOfWeek DayOfWeek

Day of week to apply the patch on.

Enable bool

Enable or disable autopatching on SQL virtual machine.

MaintenanceWindowDuration int

Duration of patching.

MaintenanceWindowStartingHour int

Hour of the day when patching is initiated. Local VM time.

dayOfWeek DayOfWeek

Day of week to apply the patch on.

enable Boolean

Enable or disable autopatching on SQL virtual machine.

maintenanceWindowDuration Integer

Duration of patching.

maintenanceWindowStartingHour Integer

Hour of the day when patching is initiated. Local VM time.

dayOfWeek DayOfWeek

Day of week to apply the patch on.

enable boolean

Enable or disable autopatching on SQL virtual machine.

maintenanceWindowDuration number

Duration of patching.

maintenanceWindowStartingHour number

Hour of the day when patching is initiated. Local VM time.

day_of_week DayOfWeek

Day of week to apply the patch on.

enable bool

Enable or disable autopatching on SQL virtual machine.

maintenance_window_duration int

Duration of patching.

maintenance_window_starting_hour int

Hour of the day when patching is initiated. Local VM time.

dayOfWeek "Monday" | "Tuesday" | "Wednesday" | "Thursday" | "Friday" | "Saturday" | "Sunday"

Day of week to apply the patch on.

enable Boolean

Enable or disable autopatching on SQL virtual machine.

maintenanceWindowDuration Number

Duration of patching.

maintenanceWindowStartingHour Number

Hour of the day when patching is initiated. Local VM time.

AutoPatchingSettingsResponse

DayOfWeek string

Day of week to apply the patch on.

Enable bool

Enable or disable autopatching on SQL virtual machine.

MaintenanceWindowDuration int

Duration of patching.

MaintenanceWindowStartingHour int

Hour of the day when patching is initiated. Local VM time.

DayOfWeek string

Day of week to apply the patch on.

Enable bool

Enable or disable autopatching on SQL virtual machine.

MaintenanceWindowDuration int

Duration of patching.

MaintenanceWindowStartingHour int

Hour of the day when patching is initiated. Local VM time.

dayOfWeek String

Day of week to apply the patch on.

enable Boolean

Enable or disable autopatching on SQL virtual machine.

maintenanceWindowDuration Integer

Duration of patching.

maintenanceWindowStartingHour Integer

Hour of the day when patching is initiated. Local VM time.

dayOfWeek string

Day of week to apply the patch on.

enable boolean

Enable or disable autopatching on SQL virtual machine.

maintenanceWindowDuration number

Duration of patching.

maintenanceWindowStartingHour number

Hour of the day when patching is initiated. Local VM time.

day_of_week str

Day of week to apply the patch on.

enable bool

Enable or disable autopatching on SQL virtual machine.

maintenance_window_duration int

Duration of patching.

maintenance_window_starting_hour int

Hour of the day when patching is initiated. Local VM time.

dayOfWeek String

Day of week to apply the patch on.

enable Boolean

Enable or disable autopatching on SQL virtual machine.

maintenanceWindowDuration Number

Duration of patching.

maintenanceWindowStartingHour Number

Hour of the day when patching is initiated. Local VM time.

BackupScheduleType

Manual
Manual
Automated
Automated
BackupScheduleTypeManual
Manual
BackupScheduleTypeAutomated
Automated
Manual
Manual
Automated
Automated
Manual
Manual
Automated
Automated
MANUAL
Manual
AUTOMATED
Automated
"Manual"
Manual
"Automated"
Automated

ConnectivityType

LOCAL
LOCAL
PRIVATE
PRIVATE
PUBLIC
PUBLIC
ConnectivityTypeLOCAL
LOCAL
ConnectivityTypePRIVATE
PRIVATE
ConnectivityTypePUBLIC
PUBLIC
LOCAL
LOCAL
PRIVATE
PRIVATE
PUBLIC
PUBLIC
LOCAL
LOCAL
PRIVATE
PRIVATE
PUBLIC
PUBLIC
LOCAL
LOCAL
PRIVATE
PRIVATE
PUBLIC
PUBLIC
"LOCAL"
LOCAL
"PRIVATE"
PRIVATE
"PUBLIC"
PUBLIC

DayOfWeek

Monday
Monday
Tuesday
Tuesday
Wednesday
Wednesday
Thursday
Thursday
Friday
Friday
Saturday
Saturday
Sunday
Sunday
DayOfWeekMonday
Monday
DayOfWeekTuesday
Tuesday
DayOfWeekWednesday
Wednesday
DayOfWeekThursday
Thursday
DayOfWeekFriday
Friday
DayOfWeekSaturday
Saturday
DayOfWeekSunday
Sunday
Monday
Monday
Tuesday
Tuesday
Wednesday
Wednesday
Thursday
Thursday
Friday
Friday
Saturday
Saturday
Sunday
Sunday
Monday
Monday
Tuesday
Tuesday
Wednesday
Wednesday
Thursday
Thursday
Friday
Friday
Saturday
Saturday
Sunday
Sunday
MONDAY
Monday
TUESDAY
Tuesday
WEDNESDAY
Wednesday
THURSDAY
Thursday
FRIDAY
Friday
SATURDAY
Saturday
SUNDAY
Sunday
"Monday"
Monday
"Tuesday"
Tuesday
"Wednesday"
Wednesday
"Thursday"
Thursday
"Friday"
Friday
"Saturday"
Saturday
"Sunday"
Sunday

DiskConfigurationType

NEW
NEW
EXTEND
EXTEND
ADD
ADD
DiskConfigurationTypeNEW
NEW
DiskConfigurationTypeEXTEND
EXTEND
DiskConfigurationTypeADD
ADD
NEW
NEW
EXTEND
EXTEND
ADD
ADD
NEW
NEW
EXTEND
EXTEND
ADD
ADD
NEW
NEW
EXTEND
EXTEND
ADD
ADD
"NEW"
NEW
"EXTEND"
EXTEND
"ADD"
ADD

FullBackupFrequencyType

Daily
Daily
Weekly
Weekly
FullBackupFrequencyTypeDaily
Daily
FullBackupFrequencyTypeWeekly
Weekly
Daily
Daily
Weekly
Weekly
Daily
Daily
Weekly
Weekly
DAILY
Daily
WEEKLY
Weekly
"Daily"
Daily
"Weekly"
Weekly

IdentityType

SystemAssigned
SystemAssigned
IdentityTypeSystemAssigned
SystemAssigned
SystemAssigned
SystemAssigned
SystemAssigned
SystemAssigned
SYSTEM_ASSIGNED
SystemAssigned
"SystemAssigned"
SystemAssigned

KeyVaultCredentialSettings

AzureKeyVaultUrl string

Azure Key Vault url.

CredentialName string

Credential name.

Enable bool

Enable or disable key vault credential setting.

ServicePrincipalName string

Service principal name to access key vault.

ServicePrincipalSecret string

Service principal name secret to access key vault.

AzureKeyVaultUrl string

Azure Key Vault url.

CredentialName string

Credential name.

Enable bool

Enable or disable key vault credential setting.

ServicePrincipalName string

Service principal name to access key vault.

ServicePrincipalSecret string

Service principal name secret to access key vault.

azureKeyVaultUrl String

Azure Key Vault url.

credentialName String

Credential name.

enable Boolean

Enable or disable key vault credential setting.

servicePrincipalName String

Service principal name to access key vault.

servicePrincipalSecret String

Service principal name secret to access key vault.

azureKeyVaultUrl string

Azure Key Vault url.

credentialName string

Credential name.

enable boolean

Enable or disable key vault credential setting.

servicePrincipalName string

Service principal name to access key vault.

servicePrincipalSecret string

Service principal name secret to access key vault.

azure_key_vault_url str

Azure Key Vault url.

credential_name str

Credential name.

enable bool

Enable or disable key vault credential setting.

service_principal_name str

Service principal name to access key vault.

service_principal_secret str

Service principal name secret to access key vault.

azureKeyVaultUrl String

Azure Key Vault url.

credentialName String

Credential name.

enable Boolean

Enable or disable key vault credential setting.

servicePrincipalName String

Service principal name to access key vault.

servicePrincipalSecret String

Service principal name secret to access key vault.

KeyVaultCredentialSettingsResponse

AzureKeyVaultUrl string

Azure Key Vault url.

CredentialName string

Credential name.

Enable bool

Enable or disable key vault credential setting.

ServicePrincipalName string

Service principal name to access key vault.

AzureKeyVaultUrl string

Azure Key Vault url.

CredentialName string

Credential name.

Enable bool

Enable or disable key vault credential setting.

ServicePrincipalName string

Service principal name to access key vault.

azureKeyVaultUrl String

Azure Key Vault url.

credentialName String

Credential name.

enable Boolean

Enable or disable key vault credential setting.

servicePrincipalName String

Service principal name to access key vault.

azureKeyVaultUrl string

Azure Key Vault url.

credentialName string

Credential name.

enable boolean

Enable or disable key vault credential setting.

servicePrincipalName string

Service principal name to access key vault.

azure_key_vault_url str

Azure Key Vault url.

credential_name str

Credential name.

enable bool

Enable or disable key vault credential setting.

service_principal_name str

Service principal name to access key vault.

azureKeyVaultUrl String

Azure Key Vault url.

credentialName String

Credential name.

enable Boolean

Enable or disable key vault credential setting.

servicePrincipalName String

Service principal name to access key vault.

ResourceIdentity

Type string | Pulumi.AzureNative.SqlVirtualMachine.IdentityType

The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.

Type string | IdentityType

The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.

type String | IdentityType

The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.

type string | IdentityType

The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.

type str | IdentityType

The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.

type String | "SystemAssigned"

The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.

ResourceIdentityResponse

PrincipalId string

The Azure Active Directory principal id.

TenantId string

The Azure Active Directory tenant id.

Type string

The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.

PrincipalId string

The Azure Active Directory principal id.

TenantId string

The Azure Active Directory tenant id.

Type string

The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.

principalId String

The Azure Active Directory principal id.

tenantId String

The Azure Active Directory tenant id.

type String

The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.

principalId string

The Azure Active Directory principal id.

tenantId string

The Azure Active Directory tenant id.

type string

The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.

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.

principalId String

The Azure Active Directory principal id.

tenantId String

The Azure Active Directory tenant id.

type String

The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.

SQLStorageSettings

DefaultFilePath string

SQL Server default file path

Luns List<int>

Logical Unit Numbers for the disks.

DefaultFilePath string

SQL Server default file path

Luns []int

Logical Unit Numbers for the disks.

defaultFilePath String

SQL Server default file path

luns List<Integer>

Logical Unit Numbers for the disks.

defaultFilePath string

SQL Server default file path

luns number[]

Logical Unit Numbers for the disks.

default_file_path str

SQL Server default file path

luns Sequence[int]

Logical Unit Numbers for the disks.

defaultFilePath String

SQL Server default file path

luns List<Number>

Logical Unit Numbers for the disks.

SQLStorageSettingsResponse

DefaultFilePath string

SQL Server default file path

Luns List<int>

Logical Unit Numbers for the disks.

DefaultFilePath string

SQL Server default file path

Luns []int

Logical Unit Numbers for the disks.

defaultFilePath String

SQL Server default file path

luns List<Integer>

Logical Unit Numbers for the disks.

defaultFilePath string

SQL Server default file path

luns number[]

Logical Unit Numbers for the disks.

default_file_path str

SQL Server default file path

luns Sequence[int]

Logical Unit Numbers for the disks.

defaultFilePath String

SQL Server default file path

luns List<Number>

Logical Unit Numbers for the disks.

ServerConfigurationsManagementSettings

additionalFeaturesServerConfigurations Property Map

Additional SQL feature settings.

sqlConnectivityUpdateSettings Property Map

SQL connectivity type settings.

sqlStorageUpdateSettings Property Map

SQL storage update settings.

sqlWorkloadTypeUpdateSettings Property Map

SQL workload type settings.

ServerConfigurationsManagementSettingsResponse

additionalFeaturesServerConfigurations Property Map

Additional SQL feature settings.

sqlConnectivityUpdateSettings Property Map

SQL connectivity type settings.

sqlStorageUpdateSettings Property Map

SQL storage update settings.

sqlWorkloadTypeUpdateSettings Property Map

SQL workload type settings.

SqlConnectivityUpdateSettings

ConnectivityType string | Pulumi.AzureNative.SqlVirtualMachine.ConnectivityType

SQL Server connectivity option.

Port int

SQL Server port.

SqlAuthUpdatePassword string

SQL Server sysadmin login password.

SqlAuthUpdateUserName string

SQL Server sysadmin login to create.

ConnectivityType string | ConnectivityType

SQL Server connectivity option.

Port int

SQL Server port.

SqlAuthUpdatePassword string

SQL Server sysadmin login password.

SqlAuthUpdateUserName string

SQL Server sysadmin login to create.

connectivityType String | ConnectivityType

SQL Server connectivity option.

port Integer

SQL Server port.

sqlAuthUpdatePassword String

SQL Server sysadmin login password.

sqlAuthUpdateUserName String

SQL Server sysadmin login to create.

connectivityType string | ConnectivityType

SQL Server connectivity option.

port number

SQL Server port.

sqlAuthUpdatePassword string

SQL Server sysadmin login password.

sqlAuthUpdateUserName string

SQL Server sysadmin login to create.

connectivity_type str | ConnectivityType

SQL Server connectivity option.

port int

SQL Server port.

sql_auth_update_password str

SQL Server sysadmin login password.

sql_auth_update_user_name str

SQL Server sysadmin login to create.

connectivityType String | "LOCAL" | "PRIVATE" | "PUBLIC"

SQL Server connectivity option.

port Number

SQL Server port.

sqlAuthUpdatePassword String

SQL Server sysadmin login password.

sqlAuthUpdateUserName String

SQL Server sysadmin login to create.

SqlConnectivityUpdateSettingsResponse

ConnectivityType string

SQL Server connectivity option.

Port int

SQL Server port.

ConnectivityType string

SQL Server connectivity option.

Port int

SQL Server port.

connectivityType String

SQL Server connectivity option.

port Integer

SQL Server port.

connectivityType string

SQL Server connectivity option.

port number

SQL Server port.

connectivity_type str

SQL Server connectivity option.

port int

SQL Server port.

connectivityType String

SQL Server connectivity option.

port Number

SQL Server port.

SqlImageSku

Developer
Developer
Express
Express
Standard
Standard
Enterprise
Enterprise
Web
Web
SqlImageSkuDeveloper
Developer
SqlImageSkuExpress
Express
SqlImageSkuStandard
Standard
SqlImageSkuEnterprise
Enterprise
SqlImageSkuWeb
Web
Developer
Developer
Express
Express
Standard
Standard
Enterprise
Enterprise
Web
Web
Developer
Developer
Express
Express
Standard
Standard
Enterprise
Enterprise
Web
Web
DEVELOPER
Developer
EXPRESS
Express
STANDARD
Standard
ENTERPRISE
Enterprise
WEB
Web
"Developer"
Developer
"Express"
Express
"Standard"
Standard
"Enterprise"
Enterprise
"Web"
Web

SqlManagementMode

Full
Full
LightWeight
LightWeight
NoAgent
NoAgent
SqlManagementModeFull
Full
SqlManagementModeLightWeight
LightWeight
SqlManagementModeNoAgent
NoAgent
Full
Full
LightWeight
LightWeight
NoAgent
NoAgent
Full
Full
LightWeight
LightWeight
NoAgent
NoAgent
FULL
Full
LIGHT_WEIGHT
LightWeight
NO_AGENT
NoAgent
"Full"
Full
"LightWeight"
LightWeight
"NoAgent"
NoAgent

SqlServerLicenseType

PAYG
PAYG
AHUB
AHUB
DR
DR
SqlServerLicenseTypePAYG
PAYG
SqlServerLicenseTypeAHUB
AHUB
SqlServerLicenseTypeDR
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

DiskConfigurationType string | Pulumi.AzureNative.SqlVirtualMachine.DiskConfigurationType

Disk configuration to apply to SQL Server.

DiskCount int

Virtual machine disk count.

StartingDeviceId int

Device id of the first disk to be updated.

DiskConfigurationType string | DiskConfigurationType

Disk configuration to apply to SQL Server.

DiskCount int

Virtual machine disk count.

StartingDeviceId int

Device id of the first disk to be updated.

diskConfigurationType String | DiskConfigurationType

Disk configuration to apply to SQL Server.

diskCount Integer

Virtual machine disk count.

startingDeviceId Integer

Device id of the first disk to be updated.

diskConfigurationType string | DiskConfigurationType

Disk configuration to apply to SQL Server.

diskCount number

Virtual machine disk count.

startingDeviceId number

Device id of the first disk to be updated.

disk_configuration_type str | DiskConfigurationType

Disk configuration to apply to SQL Server.

disk_count int

Virtual machine disk count.

starting_device_id int

Device id of the first disk to be updated.

diskConfigurationType String | "NEW" | "EXTEND" | "ADD"

Disk configuration to apply to SQL Server.

diskCount Number

Virtual machine disk count.

startingDeviceId Number

Device id of the first disk to be updated.

SqlStorageUpdateSettingsResponse

DiskConfigurationType string

Disk configuration to apply to SQL Server.

DiskCount int

Virtual machine disk count.

StartingDeviceId int

Device id of the first disk to be updated.

DiskConfigurationType string

Disk configuration to apply to SQL Server.

DiskCount int

Virtual machine disk count.

StartingDeviceId int

Device id of the first disk to be updated.

diskConfigurationType String

Disk configuration to apply to SQL Server.

diskCount Integer

Virtual machine disk count.

startingDeviceId Integer

Device id of the first disk to be updated.

diskConfigurationType string

Disk configuration to apply to SQL Server.

diskCount number

Virtual machine disk count.

startingDeviceId number

Device id of the first disk to be updated.

disk_configuration_type str

Disk configuration to apply to SQL Server.

disk_count int

Virtual machine disk count.

starting_device_id int

Device id of the first disk to be updated.

diskConfigurationType String

Disk configuration to apply to SQL Server.

diskCount Number

Virtual machine disk count.

startingDeviceId Number

Device id of the first disk to be updated.

SqlWorkloadType

GENERAL
GENERAL
OLTP
OLTP
DW
DW
SqlWorkloadTypeGENERAL
GENERAL
SqlWorkloadTypeOLTP
OLTP
SqlWorkloadTypeDW
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

SqlWorkloadType string | SqlWorkloadType

SQL Server workload type.

sqlWorkloadType String | SqlWorkloadType

SQL Server workload type.

sqlWorkloadType string | SqlWorkloadType

SQL Server workload type.

sql_workload_type str | SqlWorkloadType

SQL Server workload type.

sqlWorkloadType String | "GENERAL" | "OLTP" | "DW"

SQL Server workload type.

SqlWorkloadTypeUpdateSettingsResponse

SqlWorkloadType string

SQL Server workload type.

SqlWorkloadType string

SQL Server workload type.

sqlWorkloadType String

SQL Server workload type.

sqlWorkloadType string

SQL Server workload type.

sql_workload_type str

SQL Server workload type.

sqlWorkloadType String

SQL Server workload type.

StorageConfigurationSettings

DiskConfigurationType string | DiskConfigurationType

Disk configuration to apply to SQL Server.

SqlDataSettings SQLStorageSettings

SQL Server Data Storage Settings.

SqlLogSettings SQLStorageSettings

SQL Server Log Storage Settings.

SqlTempDbSettings SQLStorageSettings

SQL Server TempDb Storage Settings.

StorageWorkloadType string | StorageWorkloadType

Storage workload type.

diskConfigurationType String | DiskConfigurationType

Disk configuration to apply to SQL Server.

sqlDataSettings SQLStorageSettings

SQL Server Data Storage Settings.

sqlLogSettings SQLStorageSettings

SQL Server Log Storage Settings.

sqlTempDbSettings SQLStorageSettings

SQL Server TempDb Storage Settings.

storageWorkloadType String | StorageWorkloadType

Storage workload type.

diskConfigurationType string | DiskConfigurationType

Disk configuration to apply to SQL Server.

sqlDataSettings SQLStorageSettings

SQL Server Data Storage Settings.

sqlLogSettings SQLStorageSettings

SQL Server Log Storage Settings.

sqlTempDbSettings SQLStorageSettings

SQL Server TempDb Storage Settings.

storageWorkloadType string | StorageWorkloadType

Storage workload type.

disk_configuration_type str | DiskConfigurationType

Disk configuration to apply to SQL Server.

sql_data_settings SQLStorageSettings

SQL Server Data Storage Settings.

sql_log_settings SQLStorageSettings

SQL Server Log Storage Settings.

sql_temp_db_settings SQLStorageSettings

SQL Server TempDb Storage Settings.

storage_workload_type str | StorageWorkloadType

Storage workload type.

diskConfigurationType String | "NEW" | "EXTEND" | "ADD"

Disk configuration to apply to SQL Server.

sqlDataSettings Property Map

SQL Server Data Storage Settings.

sqlLogSettings Property Map

SQL Server Log Storage Settings.

sqlTempDbSettings Property Map

SQL Server TempDb Storage Settings.

storageWorkloadType String | "GENERAL" | "OLTP" | "DW"

Storage workload type.

StorageConfigurationSettingsResponse

DiskConfigurationType string

Disk configuration to apply to SQL Server.

SqlDataSettings SQLStorageSettingsResponse

SQL Server Data Storage Settings.

SqlLogSettings SQLStorageSettingsResponse

SQL Server Log Storage Settings.

SqlTempDbSettings SQLStorageSettingsResponse

SQL Server TempDb Storage Settings.

StorageWorkloadType string

Storage workload type.

diskConfigurationType String

Disk configuration to apply to SQL Server.

sqlDataSettings SQLStorageSettingsResponse

SQL Server Data Storage Settings.

sqlLogSettings SQLStorageSettingsResponse

SQL Server Log Storage Settings.

sqlTempDbSettings SQLStorageSettingsResponse

SQL Server TempDb Storage Settings.

storageWorkloadType String

Storage workload type.

diskConfigurationType string

Disk configuration to apply to SQL Server.

sqlDataSettings SQLStorageSettingsResponse

SQL Server Data Storage Settings.

sqlLogSettings SQLStorageSettingsResponse

SQL Server Log Storage Settings.

sqlTempDbSettings SQLStorageSettingsResponse

SQL Server TempDb Storage Settings.

storageWorkloadType string

Storage workload type.

disk_configuration_type str

Disk configuration to apply to SQL Server.

sql_data_settings SQLStorageSettingsResponse

SQL Server Data Storage Settings.

sql_log_settings SQLStorageSettingsResponse

SQL Server Log Storage Settings.

sql_temp_db_settings SQLStorageSettingsResponse

SQL Server TempDb Storage Settings.

storage_workload_type str

Storage workload type.

diskConfigurationType String

Disk configuration to apply to SQL Server.

sqlDataSettings Property Map

SQL Server Data Storage Settings.

sqlLogSettings Property Map

SQL Server Log Storage Settings.

sqlTempDbSettings Property Map

SQL Server TempDb Storage Settings.

storageWorkloadType String

Storage workload type.

StorageWorkloadType

GENERAL
GENERAL
OLTP
OLTP
DW
DW
StorageWorkloadTypeGENERAL
GENERAL
StorageWorkloadTypeOLTP
OLTP
StorageWorkloadTypeDW
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

ClusterBootstrapAccountPassword string

Cluster bootstrap account password.

ClusterOperatorAccountPassword string

Cluster operator account password.

SqlServiceAccountPassword string

SQL service account password.

ClusterBootstrapAccountPassword string

Cluster bootstrap account password.

ClusterOperatorAccountPassword string

Cluster operator account password.

SqlServiceAccountPassword string

SQL service account password.

clusterBootstrapAccountPassword String

Cluster bootstrap account password.

clusterOperatorAccountPassword String

Cluster operator account password.

sqlServiceAccountPassword String

SQL service account password.

clusterBootstrapAccountPassword string

Cluster bootstrap account password.

clusterOperatorAccountPassword string

Cluster operator account password.

sqlServiceAccountPassword string

SQL service account password.

cluster_bootstrap_account_password str

Cluster bootstrap account password.

cluster_operator_account_password str

Cluster operator account password.

sql_service_account_password str

SQL service account password.

clusterBootstrapAccountPassword String

Cluster bootstrap account password.

clusterOperatorAccountPassword String

Cluster operator account password.

sqlServiceAccountPassword String

SQL service account password.

WsfcDomainCredentialsResponse

ClusterBootstrapAccountPassword string

Cluster bootstrap account password.

ClusterOperatorAccountPassword string

Cluster operator account password.

SqlServiceAccountPassword string

SQL service account password.

ClusterBootstrapAccountPassword string

Cluster bootstrap account password.

ClusterOperatorAccountPassword string

Cluster operator account password.

SqlServiceAccountPassword string

SQL service account password.

clusterBootstrapAccountPassword String

Cluster bootstrap account password.

clusterOperatorAccountPassword String

Cluster operator account password.

sqlServiceAccountPassword String

SQL service account password.

clusterBootstrapAccountPassword string

Cluster bootstrap account password.

clusterOperatorAccountPassword string

Cluster operator account password.

sqlServiceAccountPassword string

SQL service account password.

cluster_bootstrap_account_password str

Cluster bootstrap account password.

cluster_operator_account_password str

Cluster operator account password.

sql_service_account_password str

SQL service account password.

clusterBootstrapAccountPassword String

Cluster bootstrap account password.

clusterOperatorAccountPassword String

Cluster operator account password.

sqlServiceAccountPassword String

SQL service account password.

Import

An existing resource can be imported using its type token, name, and identifier, e.g.

$ pulumi import azure-native:sqlvirtualmachine:SqlVirtualMachine testvm /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachines/testvm 

Package Details

Repository
https://github.com/pulumi/pulumi-azure-native
License
Apache-2.0