Docs Packages
  1. Packages
  2. Azure Classic
  3. API Docs
  4. mssql
  5. VirtualMachine

We recommend using Azure Native.

Azure Classic v5.49.0 published on Tuesday, Aug 29, 2023 by Pulumi
pulumi/pulumi-azure

azure.mssql.VirtualMachine

Explore with Pulumi AI

azure logo

We recommend using Azure Native.

Azure Classic v5.49.0 published on Tuesday, Aug 29, 2023 by Pulumi
pulumi/pulumi-azure

    Manages a Microsoft SQL Virtual Machine

    Example Usage

    This example provisions a brief Managed Microsoft SQL Virtual Machine.

    using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Azure = Pulumi.Azure;

return await Deployment.RunAsync(() => 
{
    var exampleVirtualMachine = Azure.Compute.GetVirtualMachine.Invoke(new()
    {
        Name = "example-vm",
        ResourceGroupName = "example-resources",
    });

    var exampleMssql_virtualMachineVirtualMachine = new Azure.MSSql.VirtualMachine("exampleMssql/virtualMachineVirtualMachine", new()
    {
        VirtualMachineId = exampleVirtualMachine.Apply(getVirtualMachineResult => getVirtualMachineResult.Id),
        SqlLicenseType = "PAYG",
        RServicesEnabled = true,
        SqlConnectivityPort = 1433,
        SqlConnectivityType = "PRIVATE",
        SqlConnectivityUpdatePassword = "Password1234!",
        SqlConnectivityUpdateUsername = "sqllogin",
        AutoPatching = new Azure.MSSql.Inputs.VirtualMachineAutoPatchingArgs
        {
            DayOfWeek = "Sunday",
            MaintenanceWindowDurationInMinutes = 60,
            MaintenanceWindowStartingHour = 2,
        },
    });

});

    package main

import (
	"github.com/pulumi/pulumi-azure/sdk/v5/go/azure/compute"
	"github.com/pulumi/pulumi-azure/sdk/v5/go/azure/mssql"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		exampleVirtualMachine, err := compute.LookupVirtualMachine(ctx, &compute.LookupVirtualMachineArgs{
			Name:              "example-vm",
			ResourceGroupName: "example-resources",
		}, nil)
		if err != nil {
			return err
		}
		_, err = mssql.NewVirtualMachine(ctx, "exampleMssql/virtualMachineVirtualMachine", &mssql.VirtualMachineArgs{
			VirtualMachineId:              *pulumi.String(exampleVirtualMachine.Id),
			SqlLicenseType:                pulumi.String("PAYG"),
			RServicesEnabled:              pulumi.Bool(true),
			SqlConnectivityPort:           pulumi.Int(1433),
			SqlConnectivityType:           pulumi.String("PRIVATE"),
			SqlConnectivityUpdatePassword: pulumi.String("Password1234!"),
			SqlConnectivityUpdateUsername: pulumi.String("sqllogin"),
			AutoPatching: &mssql.VirtualMachineAutoPatchingArgs{
				DayOfWeek:                          pulumi.String("Sunday"),
				MaintenanceWindowDurationInMinutes: pulumi.Int(60),
				MaintenanceWindowStartingHour:      pulumi.Int(2),
			},
		})
		if err != nil {
			return err
		}
		return nil
	})
}

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azure.compute.ComputeFunctions;
import com.pulumi.azure.compute.inputs.GetVirtualMachineArgs;
import com.pulumi.azure.mssql.VirtualMachine;
import com.pulumi.azure.mssql.VirtualMachineArgs;
import com.pulumi.azure.mssql.inputs.VirtualMachineAutoPatchingArgs;
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) {
        final var exampleVirtualMachine = ComputeFunctions.getVirtualMachine(GetVirtualMachineArgs.builder()
            .name("example-vm")
            .resourceGroupName("example-resources")
            .build());

        var exampleMssql_virtualMachineVirtualMachine = new VirtualMachine("exampleMssql/virtualMachineVirtualMachine", VirtualMachineArgs.builder()        
            .virtualMachineId(exampleVirtualMachine.applyValue(getVirtualMachineResult -> getVirtualMachineResult.id()))
            .sqlLicenseType("PAYG")
            .rServicesEnabled(true)
            .sqlConnectivityPort(1433)
            .sqlConnectivityType("PRIVATE")
            .sqlConnectivityUpdatePassword("Password1234!")
            .sqlConnectivityUpdateUsername("sqllogin")
            .autoPatching(VirtualMachineAutoPatchingArgs.builder()
                .dayOfWeek("Sunday")
                .maintenanceWindowDurationInMinutes(60)
                .maintenanceWindowStartingHour(2)
                .build())
            .build());

    }
}

    import pulumi
import pulumi_azure as azure

example_virtual_machine = azure.compute.get_virtual_machine(name="example-vm",
    resource_group_name="example-resources")
example_mssql_virtual_machine_virtual_machine = azure.mssql.VirtualMachine("exampleMssql/virtualMachineVirtualMachine",
    virtual_machine_id=example_virtual_machine.id,
    sql_license_type="PAYG",
    r_services_enabled=True,
    sql_connectivity_port=1433,
    sql_connectivity_type="PRIVATE",
    sql_connectivity_update_password="Password1234!",
    sql_connectivity_update_username="sqllogin",
    auto_patching=azure.mssql.VirtualMachineAutoPatchingArgs(
        day_of_week="Sunday",
        maintenance_window_duration_in_minutes=60,
        maintenance_window_starting_hour=2,
    ))

    import * as pulumi from "@pulumi/pulumi";
import * as azure from "@pulumi/azure";

const exampleVirtualMachine = azure.compute.getVirtualMachine({
    name: "example-vm",
    resourceGroupName: "example-resources",
});
const exampleMssql_virtualMachineVirtualMachine = new azure.mssql.VirtualMachine("exampleMssql/virtualMachineVirtualMachine", {
    virtualMachineId: exampleVirtualMachine.then(exampleVirtualMachine => exampleVirtualMachine.id),
    sqlLicenseType: "PAYG",
    rServicesEnabled: true,
    sqlConnectivityPort: 1433,
    sqlConnectivityType: "PRIVATE",
    sqlConnectivityUpdatePassword: "Password1234!",
    sqlConnectivityUpdateUsername: "sqllogin",
    autoPatching: {
        dayOfWeek: "Sunday",
        maintenanceWindowDurationInMinutes: 60,
        maintenanceWindowStartingHour: 2,
    },
});

    resources:
  exampleMssql/virtualMachineVirtualMachine:
    type: azure:mssql:VirtualMachine
    properties:
      virtualMachineId: ${exampleVirtualMachine.id}
      sqlLicenseType: PAYG
      rServicesEnabled: true
      sqlConnectivityPort: 1433
      sqlConnectivityType: PRIVATE
      sqlConnectivityUpdatePassword: Password1234!
      sqlConnectivityUpdateUsername: sqllogin
      autoPatching:
        dayOfWeek: Sunday
        maintenanceWindowDurationInMinutes: 60
        maintenanceWindowStartingHour: 2
variables:
  exampleVirtualMachine:
    fn::invoke:
      Function: azure:compute:getVirtualMachine
      Arguments:
        name: example-vm
        resourceGroupName: example-resources

    Create VirtualMachine Resource

    new VirtualMachine(name: string, args: VirtualMachineArgs, opts?: CustomResourceOptions);
    @overload
def VirtualMachine(resource_name: str,
                   opts: Optional[ResourceOptions] = None,
                   assessment: Optional[VirtualMachineAssessmentArgs] = None,
                   auto_backup: Optional[VirtualMachineAutoBackupArgs] = None,
                   auto_patching: Optional[VirtualMachineAutoPatchingArgs] = None,
                   key_vault_credential: Optional[VirtualMachineKeyVaultCredentialArgs] = None,
                   r_services_enabled: Optional[bool] = None,
                   sql_connectivity_port: Optional[int] = None,
                   sql_connectivity_type: Optional[str] = None,
                   sql_connectivity_update_password: Optional[str] = None,
                   sql_connectivity_update_username: Optional[str] = None,
                   sql_instance: Optional[VirtualMachineSqlInstanceArgs] = None,
                   sql_license_type: Optional[str] = None,
                   sql_virtual_machine_group_id: Optional[str] = None,
                   storage_configuration: Optional[VirtualMachineStorageConfigurationArgs] = None,
                   tags: Optional[Mapping[str, str]] = None,
                   virtual_machine_id: Optional[str] = None,
                   wsfc_domain_credential: Optional[VirtualMachineWsfcDomainCredentialArgs] = None)
@overload
def VirtualMachine(resource_name: str,
                   args: VirtualMachineArgs,
                   opts: Optional[ResourceOptions] = None)
    func NewVirtualMachine(ctx *Context, name string, args VirtualMachineArgs, opts ...ResourceOption) (*VirtualMachine, error)
    public VirtualMachine(string name, VirtualMachineArgs args, CustomResourceOptions? opts = null)
    public VirtualMachine(String name, VirtualMachineArgs args)
public VirtualMachine(String name, VirtualMachineArgs args, CustomResourceOptions options)

    type: azure:mssql:VirtualMachine
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args VirtualMachineArgs
    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 VirtualMachineArgs
    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 VirtualMachineArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args VirtualMachineArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args VirtualMachineArgs
    The arguments to resource properties.
    options CustomResourceOptions
    Bag of options to control resource's behavior.

    VirtualMachine 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 VirtualMachine resource accepts the following input properties:

    VirtualMachineId string

    The ID of the Virtual Machine. Changing this forces a new resource to be created.

    Assessment VirtualMachineAssessment

    An assessment block as defined below.

    AutoBackup VirtualMachineAutoBackup

    An auto_backup block as defined below. This block can be added to an existing resource, but removing this block forces a new resource to be created.

    AutoPatching VirtualMachineAutoPatching

    An auto_patching block as defined below.

    KeyVaultCredential VirtualMachineKeyVaultCredential

    An key_vault_credential block as defined below.

    RServicesEnabled bool

    Should R Services be enabled?

    SqlConnectivityPort int

    The SQL Server port. Defaults to 1433.

    SqlConnectivityType string

    The connectivity type used for this SQL Server. Possible values are LOCAL, PRIVATE and PUBLIC. Defaults to PRIVATE.

    SqlConnectivityUpdatePassword string

    The SQL Server sysadmin login password.

    SqlConnectivityUpdateUsername string

    The SQL Server sysadmin login to create.

    SqlInstance VirtualMachineSqlInstance

    A sql_instance block as defined below.

    SqlLicenseType string

    The SQL Server license type. Possible values are AHUB (Azure Hybrid Benefit), DR (Disaster Recovery), and PAYG (Pay-As-You-Go). Changing this forces a new resource to be created.

    SqlVirtualMachineGroupId string

    The ID of the SQL Virtual Machine Group that the SQL Virtual Machine belongs to.

    StorageConfiguration VirtualMachineStorageConfiguration

    An storage_configuration block as defined below.

    Tags Dictionary<string, string>

    A mapping of tags to assign to the resource.

    WsfcDomainCredential VirtualMachineWsfcDomainCredential

    A wsfc_domain_credential block as defined below

    VirtualMachineId string

    The ID of the Virtual Machine. Changing this forces a new resource to be created.

    Assessment VirtualMachineAssessmentArgs

    An assessment block as defined below.

    AutoBackup VirtualMachineAutoBackupArgs

    An auto_backup block as defined below. This block can be added to an existing resource, but removing this block forces a new resource to be created.

    AutoPatching VirtualMachineAutoPatchingArgs

    An auto_patching block as defined below.

    KeyVaultCredential VirtualMachineKeyVaultCredentialArgs

    An key_vault_credential block as defined below.

    RServicesEnabled bool

    Should R Services be enabled?

    SqlConnectivityPort int

    The SQL Server port. Defaults to 1433.

    SqlConnectivityType string

    The connectivity type used for this SQL Server. Possible values are LOCAL, PRIVATE and PUBLIC. Defaults to PRIVATE.

    SqlConnectivityUpdatePassword string

    The SQL Server sysadmin login password.

    SqlConnectivityUpdateUsername string

    The SQL Server sysadmin login to create.

    SqlInstance VirtualMachineSqlInstanceArgs

    A sql_instance block as defined below.

    SqlLicenseType string

    The SQL Server license type. Possible values are AHUB (Azure Hybrid Benefit), DR (Disaster Recovery), and PAYG (Pay-As-You-Go). Changing this forces a new resource to be created.

    SqlVirtualMachineGroupId string

    The ID of the SQL Virtual Machine Group that the SQL Virtual Machine belongs to.

    StorageConfiguration VirtualMachineStorageConfigurationArgs

    An storage_configuration block as defined below.

    Tags map[string]string

    A mapping of tags to assign to the resource.

    WsfcDomainCredential VirtualMachineWsfcDomainCredentialArgs

    A wsfc_domain_credential block as defined below

    virtualMachineId String

    The ID of the Virtual Machine. Changing this forces a new resource to be created.

    assessment VirtualMachineAssessment

    An assessment block as defined below.

    autoBackup VirtualMachineAutoBackup

    An auto_backup block as defined below. This block can be added to an existing resource, but removing this block forces a new resource to be created.

    autoPatching VirtualMachineAutoPatching

    An auto_patching block as defined below.

    keyVaultCredential VirtualMachineKeyVaultCredential

    An key_vault_credential block as defined below.

    rServicesEnabled Boolean

    Should R Services be enabled?

    sqlConnectivityPort Integer

    The SQL Server port. Defaults to 1433.

    sqlConnectivityType String

    The connectivity type used for this SQL Server. Possible values are LOCAL, PRIVATE and PUBLIC. Defaults to PRIVATE.

    sqlConnectivityUpdatePassword String

    The SQL Server sysadmin login password.

    sqlConnectivityUpdateUsername String

    The SQL Server sysadmin login to create.

    sqlInstance VirtualMachineSqlInstance

    A sql_instance block as defined below.

    sqlLicenseType String

    The SQL Server license type. Possible values are AHUB (Azure Hybrid Benefit), DR (Disaster Recovery), and PAYG (Pay-As-You-Go). Changing this forces a new resource to be created.

    sqlVirtualMachineGroupId String

    The ID of the SQL Virtual Machine Group that the SQL Virtual Machine belongs to.

    storageConfiguration VirtualMachineStorageConfiguration

    An storage_configuration block as defined below.

    tags Map<String,String>

    A mapping of tags to assign to the resource.

    wsfcDomainCredential VirtualMachineWsfcDomainCredential

    A wsfc_domain_credential block as defined below

    virtualMachineId string

    The ID of the Virtual Machine. Changing this forces a new resource to be created.

    assessment VirtualMachineAssessment

    An assessment block as defined below.

    autoBackup VirtualMachineAutoBackup

    An auto_backup block as defined below. This block can be added to an existing resource, but removing this block forces a new resource to be created.

    autoPatching VirtualMachineAutoPatching

    An auto_patching block as defined below.

    keyVaultCredential VirtualMachineKeyVaultCredential

    An key_vault_credential block as defined below.

    rServicesEnabled boolean

    Should R Services be enabled?

    sqlConnectivityPort number

    The SQL Server port. Defaults to 1433.

    sqlConnectivityType string

    The connectivity type used for this SQL Server. Possible values are LOCAL, PRIVATE and PUBLIC. Defaults to PRIVATE.

    sqlConnectivityUpdatePassword string

    The SQL Server sysadmin login password.

    sqlConnectivityUpdateUsername string

    The SQL Server sysadmin login to create.

    sqlInstance VirtualMachineSqlInstance

    A sql_instance block as defined below.

    sqlLicenseType string

    The SQL Server license type. Possible values are AHUB (Azure Hybrid Benefit), DR (Disaster Recovery), and PAYG (Pay-As-You-Go). Changing this forces a new resource to be created.

    sqlVirtualMachineGroupId string

    The ID of the SQL Virtual Machine Group that the SQL Virtual Machine belongs to.

    storageConfiguration VirtualMachineStorageConfiguration

    An storage_configuration block as defined below.

    tags {[key: string]: string}

    A mapping of tags to assign to the resource.

    wsfcDomainCredential VirtualMachineWsfcDomainCredential

    A wsfc_domain_credential block as defined below

    virtual_machine_id str

    The ID of the Virtual Machine. Changing this forces a new resource to be created.

    assessment VirtualMachineAssessmentArgs

    An assessment block as defined below.

    auto_backup VirtualMachineAutoBackupArgs

    An auto_backup block as defined below. This block can be added to an existing resource, but removing this block forces a new resource to be created.

    auto_patching VirtualMachineAutoPatchingArgs

    An auto_patching block as defined below.

    key_vault_credential VirtualMachineKeyVaultCredentialArgs

    An key_vault_credential block as defined below.

    r_services_enabled bool

    Should R Services be enabled?

    sql_connectivity_port int

    The SQL Server port. Defaults to 1433.

    sql_connectivity_type str

    The connectivity type used for this SQL Server. Possible values are LOCAL, PRIVATE and PUBLIC. Defaults to PRIVATE.

    sql_connectivity_update_password str

    The SQL Server sysadmin login password.

    sql_connectivity_update_username str

    The SQL Server sysadmin login to create.

    sql_instance VirtualMachineSqlInstanceArgs

    A sql_instance block as defined below.

    sql_license_type str

    The SQL Server license type. Possible values are AHUB (Azure Hybrid Benefit), DR (Disaster Recovery), and PAYG (Pay-As-You-Go). Changing this forces a new resource to be created.

    sql_virtual_machine_group_id str

    The ID of the SQL Virtual Machine Group that the SQL Virtual Machine belongs to.

    storage_configuration VirtualMachineStorageConfigurationArgs

    An storage_configuration block as defined below.

    tags Mapping[str, str]

    A mapping of tags to assign to the resource.

    wsfc_domain_credential VirtualMachineWsfcDomainCredentialArgs

    A wsfc_domain_credential block as defined below

    virtualMachineId String

    The ID of the Virtual Machine. Changing this forces a new resource to be created.

    assessment Property Map

    An assessment block as defined below.

    autoBackup Property Map

    An auto_backup block as defined below. This block can be added to an existing resource, but removing this block forces a new resource to be created.

    autoPatching Property Map

    An auto_patching block as defined below.

    keyVaultCredential Property Map

    An key_vault_credential block as defined below.

    rServicesEnabled Boolean

    Should R Services be enabled?

    sqlConnectivityPort Number

    The SQL Server port. Defaults to 1433.

    sqlConnectivityType String

    The connectivity type used for this SQL Server. Possible values are LOCAL, PRIVATE and PUBLIC. Defaults to PRIVATE.

    sqlConnectivityUpdatePassword String

    The SQL Server sysadmin login password.

    sqlConnectivityUpdateUsername String

    The SQL Server sysadmin login to create.

    sqlInstance Property Map

    A sql_instance block as defined below.

    sqlLicenseType String

    The SQL Server license type. Possible values are AHUB (Azure Hybrid Benefit), DR (Disaster Recovery), and PAYG (Pay-As-You-Go). Changing this forces a new resource to be created.

    sqlVirtualMachineGroupId String

    The ID of the SQL Virtual Machine Group that the SQL Virtual Machine belongs to.

    storageConfiguration Property Map

    An storage_configuration block as defined below.

    tags Map<String>

    A mapping of tags to assign to the resource.

    wsfcDomainCredential Property Map

    A wsfc_domain_credential block as defined below

    Outputs

    All input properties are implicitly available as output properties. Additionally, the VirtualMachine resource produces the following output properties:

    Id string

    The provider-assigned unique ID for this managed resource.

    Id string

    The provider-assigned unique ID for this managed resource.

    id String

    The provider-assigned unique ID for this managed resource.

    id string

    The provider-assigned unique ID for this managed resource.

    id str

    The provider-assigned unique ID for this managed resource.

    id String

    The provider-assigned unique ID for this managed resource.

    Look up Existing VirtualMachine Resource

    Get an existing VirtualMachine resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.

    public static get(name: string, id: Input<ID>, state?: VirtualMachineState, opts?: CustomResourceOptions): VirtualMachine
    @staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        assessment: Optional[VirtualMachineAssessmentArgs] = None,
        auto_backup: Optional[VirtualMachineAutoBackupArgs] = None,
        auto_patching: Optional[VirtualMachineAutoPatchingArgs] = None,
        key_vault_credential: Optional[VirtualMachineKeyVaultCredentialArgs] = None,
        r_services_enabled: Optional[bool] = None,
        sql_connectivity_port: Optional[int] = None,
        sql_connectivity_type: Optional[str] = None,
        sql_connectivity_update_password: Optional[str] = None,
        sql_connectivity_update_username: Optional[str] = None,
        sql_instance: Optional[VirtualMachineSqlInstanceArgs] = None,
        sql_license_type: Optional[str] = None,
        sql_virtual_machine_group_id: Optional[str] = None,
        storage_configuration: Optional[VirtualMachineStorageConfigurationArgs] = None,
        tags: Optional[Mapping[str, str]] = None,
        virtual_machine_id: Optional[str] = None,
        wsfc_domain_credential: Optional[VirtualMachineWsfcDomainCredentialArgs] = None) -> VirtualMachine
    func GetVirtualMachine(ctx *Context, name string, id IDInput, state *VirtualMachineState, opts ...ResourceOption) (*VirtualMachine, error)
    public static VirtualMachine Get(string name, Input<string> id, VirtualMachineState? state, CustomResourceOptions? opts = null)
    public static VirtualMachine get(String name, Output<String> id, VirtualMachineState state, CustomResourceOptions options)
    Resource lookup is not supported in YAML
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    resource_name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    The following state arguments are supported:
    Assessment VirtualMachineAssessment

    An assessment block as defined below.

    AutoBackup VirtualMachineAutoBackup

    An auto_backup block as defined below. This block can be added to an existing resource, but removing this block forces a new resource to be created.

    AutoPatching VirtualMachineAutoPatching

    An auto_patching block as defined below.

    KeyVaultCredential VirtualMachineKeyVaultCredential

    An key_vault_credential block as defined below.

    RServicesEnabled bool

    Should R Services be enabled?

    SqlConnectivityPort int

    The SQL Server port. Defaults to 1433.

    SqlConnectivityType string

    The connectivity type used for this SQL Server. Possible values are LOCAL, PRIVATE and PUBLIC. Defaults to PRIVATE.

    SqlConnectivityUpdatePassword string

    The SQL Server sysadmin login password.

    SqlConnectivityUpdateUsername string

    The SQL Server sysadmin login to create.

    SqlInstance VirtualMachineSqlInstance

    A sql_instance block as defined below.

    SqlLicenseType string

    The SQL Server license type. Possible values are AHUB (Azure Hybrid Benefit), DR (Disaster Recovery), and PAYG (Pay-As-You-Go). Changing this forces a new resource to be created.

    SqlVirtualMachineGroupId string

    The ID of the SQL Virtual Machine Group that the SQL Virtual Machine belongs to.

    StorageConfiguration VirtualMachineStorageConfiguration

    An storage_configuration block as defined below.

    Tags Dictionary<string, string>

    A mapping of tags to assign to the resource.

    VirtualMachineId string

    The ID of the Virtual Machine. Changing this forces a new resource to be created.

    WsfcDomainCredential VirtualMachineWsfcDomainCredential

    A wsfc_domain_credential block as defined below

    Assessment VirtualMachineAssessmentArgs

    An assessment block as defined below.

    AutoBackup VirtualMachineAutoBackupArgs

    An auto_backup block as defined below. This block can be added to an existing resource, but removing this block forces a new resource to be created.

    AutoPatching VirtualMachineAutoPatchingArgs

    An auto_patching block as defined below.

    KeyVaultCredential VirtualMachineKeyVaultCredentialArgs

    An key_vault_credential block as defined below.

    RServicesEnabled bool

    Should R Services be enabled?

    SqlConnectivityPort int

    The SQL Server port. Defaults to 1433.

    SqlConnectivityType string

    The connectivity type used for this SQL Server. Possible values are LOCAL, PRIVATE and PUBLIC. Defaults to PRIVATE.

    SqlConnectivityUpdatePassword string

    The SQL Server sysadmin login password.

    SqlConnectivityUpdateUsername string

    The SQL Server sysadmin login to create.

    SqlInstance VirtualMachineSqlInstanceArgs

    A sql_instance block as defined below.

    SqlLicenseType string

    The SQL Server license type. Possible values are AHUB (Azure Hybrid Benefit), DR (Disaster Recovery), and PAYG (Pay-As-You-Go). Changing this forces a new resource to be created.

    SqlVirtualMachineGroupId string

    The ID of the SQL Virtual Machine Group that the SQL Virtual Machine belongs to.

    StorageConfiguration VirtualMachineStorageConfigurationArgs

    An storage_configuration block as defined below.

    Tags map[string]string

    A mapping of tags to assign to the resource.

    VirtualMachineId string

    The ID of the Virtual Machine. Changing this forces a new resource to be created.

    WsfcDomainCredential VirtualMachineWsfcDomainCredentialArgs

    A wsfc_domain_credential block as defined below

    assessment VirtualMachineAssessment

    An assessment block as defined below.

    autoBackup VirtualMachineAutoBackup

    An auto_backup block as defined below. This block can be added to an existing resource, but removing this block forces a new resource to be created.

    autoPatching VirtualMachineAutoPatching

    An auto_patching block as defined below.

    keyVaultCredential VirtualMachineKeyVaultCredential

    An key_vault_credential block as defined below.

    rServicesEnabled Boolean

    Should R Services be enabled?

    sqlConnectivityPort Integer

    The SQL Server port. Defaults to 1433.

    sqlConnectivityType String

    The connectivity type used for this SQL Server. Possible values are LOCAL, PRIVATE and PUBLIC. Defaults to PRIVATE.

    sqlConnectivityUpdatePassword String

    The SQL Server sysadmin login password.

    sqlConnectivityUpdateUsername String

    The SQL Server sysadmin login to create.

    sqlInstance VirtualMachineSqlInstance

    A sql_instance block as defined below.

    sqlLicenseType String

    The SQL Server license type. Possible values are AHUB (Azure Hybrid Benefit), DR (Disaster Recovery), and PAYG (Pay-As-You-Go). Changing this forces a new resource to be created.

    sqlVirtualMachineGroupId String

    The ID of the SQL Virtual Machine Group that the SQL Virtual Machine belongs to.

    storageConfiguration VirtualMachineStorageConfiguration

    An storage_configuration block as defined below.

    tags Map<String,String>

    A mapping of tags to assign to the resource.

    virtualMachineId String

    The ID of the Virtual Machine. Changing this forces a new resource to be created.

    wsfcDomainCredential VirtualMachineWsfcDomainCredential

    A wsfc_domain_credential block as defined below

    assessment VirtualMachineAssessment

    An assessment block as defined below.

    autoBackup VirtualMachineAutoBackup

    An auto_backup block as defined below. This block can be added to an existing resource, but removing this block forces a new resource to be created.

    autoPatching VirtualMachineAutoPatching

    An auto_patching block as defined below.

    keyVaultCredential VirtualMachineKeyVaultCredential

    An key_vault_credential block as defined below.

    rServicesEnabled boolean

    Should R Services be enabled?

    sqlConnectivityPort number

    The SQL Server port. Defaults to 1433.

    sqlConnectivityType string

    The connectivity type used for this SQL Server. Possible values are LOCAL, PRIVATE and PUBLIC. Defaults to PRIVATE.

    sqlConnectivityUpdatePassword string

    The SQL Server sysadmin login password.

    sqlConnectivityUpdateUsername string

    The SQL Server sysadmin login to create.

    sqlInstance VirtualMachineSqlInstance

    A sql_instance block as defined below.

    sqlLicenseType string

    The SQL Server license type. Possible values are AHUB (Azure Hybrid Benefit), DR (Disaster Recovery), and PAYG (Pay-As-You-Go). Changing this forces a new resource to be created.

    sqlVirtualMachineGroupId string

    The ID of the SQL Virtual Machine Group that the SQL Virtual Machine belongs to.

    storageConfiguration VirtualMachineStorageConfiguration

    An storage_configuration block as defined below.

    tags {[key: string]: string}

    A mapping of tags to assign to the resource.

    virtualMachineId string

    The ID of the Virtual Machine. Changing this forces a new resource to be created.

    wsfcDomainCredential VirtualMachineWsfcDomainCredential

    A wsfc_domain_credential block as defined below

    assessment VirtualMachineAssessmentArgs

    An assessment block as defined below.

    auto_backup VirtualMachineAutoBackupArgs

    An auto_backup block as defined below. This block can be added to an existing resource, but removing this block forces a new resource to be created.

    auto_patching VirtualMachineAutoPatchingArgs

    An auto_patching block as defined below.

    key_vault_credential VirtualMachineKeyVaultCredentialArgs

    An key_vault_credential block as defined below.

    r_services_enabled bool

    Should R Services be enabled?

    sql_connectivity_port int

    The SQL Server port. Defaults to 1433.

    sql_connectivity_type str

    The connectivity type used for this SQL Server. Possible values are LOCAL, PRIVATE and PUBLIC. Defaults to PRIVATE.

    sql_connectivity_update_password str

    The SQL Server sysadmin login password.

    sql_connectivity_update_username str

    The SQL Server sysadmin login to create.

    sql_instance VirtualMachineSqlInstanceArgs

    A sql_instance block as defined below.

    sql_license_type str

    The SQL Server license type. Possible values are AHUB (Azure Hybrid Benefit), DR (Disaster Recovery), and PAYG (Pay-As-You-Go). Changing this forces a new resource to be created.

    sql_virtual_machine_group_id str

    The ID of the SQL Virtual Machine Group that the SQL Virtual Machine belongs to.

    storage_configuration VirtualMachineStorageConfigurationArgs

    An storage_configuration block as defined below.

    tags Mapping[str, str]

    A mapping of tags to assign to the resource.

    virtual_machine_id str

    The ID of the Virtual Machine. Changing this forces a new resource to be created.

    wsfc_domain_credential VirtualMachineWsfcDomainCredentialArgs

    A wsfc_domain_credential block as defined below

    assessment Property Map

    An assessment block as defined below.

    autoBackup Property Map

    An auto_backup block as defined below. This block can be added to an existing resource, but removing this block forces a new resource to be created.

    autoPatching Property Map

    An auto_patching block as defined below.

    keyVaultCredential Property Map

    An key_vault_credential block as defined below.

    rServicesEnabled Boolean

    Should R Services be enabled?

    sqlConnectivityPort Number

    The SQL Server port. Defaults to 1433.

    sqlConnectivityType String

    The connectivity type used for this SQL Server. Possible values are LOCAL, PRIVATE and PUBLIC. Defaults to PRIVATE.

    sqlConnectivityUpdatePassword String

    The SQL Server sysadmin login password.

    sqlConnectivityUpdateUsername String

    The SQL Server sysadmin login to create.

    sqlInstance Property Map

    A sql_instance block as defined below.

    sqlLicenseType String

    The SQL Server license type. Possible values are AHUB (Azure Hybrid Benefit), DR (Disaster Recovery), and PAYG (Pay-As-You-Go). Changing this forces a new resource to be created.

    sqlVirtualMachineGroupId String

    The ID of the SQL Virtual Machine Group that the SQL Virtual Machine belongs to.

    storageConfiguration Property Map

    An storage_configuration block as defined below.

    tags Map<String>

    A mapping of tags to assign to the resource.

    virtualMachineId String

    The ID of the Virtual Machine. Changing this forces a new resource to be created.

    wsfcDomainCredential Property Map

    A wsfc_domain_credential block as defined below

    Supporting Types

    VirtualMachineAssessment, VirtualMachineAssessmentArgs

    Enabled bool

    Should Assessment be enabled? Defaults to true.

    RunImmediately bool

    Should Assessment be run immediately? Defaults to false.

    Schedule VirtualMachineAssessmentSchedule

    An schedule block as defined below.

    Enabled bool

    Should Assessment be enabled? Defaults to true.

    RunImmediately bool

    Should Assessment be run immediately? Defaults to false.

    Schedule VirtualMachineAssessmentSchedule

    An schedule block as defined below.

    enabled Boolean

    Should Assessment be enabled? Defaults to true.

    runImmediately Boolean

    Should Assessment be run immediately? Defaults to false.

    schedule VirtualMachineAssessmentSchedule

    An schedule block as defined below.

    enabled boolean

    Should Assessment be enabled? Defaults to true.

    runImmediately boolean

    Should Assessment be run immediately? Defaults to false.

    schedule VirtualMachineAssessmentSchedule

    An schedule block as defined below.

    enabled bool

    Should Assessment be enabled? Defaults to true.

    run_immediately bool

    Should Assessment be run immediately? Defaults to false.

    schedule VirtualMachineAssessmentSchedule

    An schedule block as defined below.

    enabled Boolean

    Should Assessment be enabled? Defaults to true.

    runImmediately Boolean

    Should Assessment be run immediately? Defaults to false.

    schedule Property Map

    An schedule block as defined below.

    VirtualMachineAssessmentSchedule, VirtualMachineAssessmentScheduleArgs

    DayOfWeek string

    What day of the week the assessment will be run. Default value is Monday. Possible values are Friday, Monday, Saturday, Sunday, Thursday, Tuesday and Wednesday.

    StartTime string

    What time the assessment will be run. Must be in the format HH:mm.

    MonthlyOccurrence int

    How many months between assessment runs. Valid values are between 1 and 5.

    NOTE: Either one of weekly_interval or monthly_occurrence must be specified.

    WeeklyInterval int

    How many weeks between assessment runs. Valid values are between 1 and 6.

    DayOfWeek string

    What day of the week the assessment will be run. Default value is Monday. Possible values are Friday, Monday, Saturday, Sunday, Thursday, Tuesday and Wednesday.

    StartTime string

    What time the assessment will be run. Must be in the format HH:mm.

    MonthlyOccurrence int

    How many months between assessment runs. Valid values are between 1 and 5.

    NOTE: Either one of weekly_interval or monthly_occurrence must be specified.

    WeeklyInterval int

    How many weeks between assessment runs. Valid values are between 1 and 6.

    dayOfWeek String

    What day of the week the assessment will be run. Default value is Monday. Possible values are Friday, Monday, Saturday, Sunday, Thursday, Tuesday and Wednesday.

    startTime String

    What time the assessment will be run. Must be in the format HH:mm.

    monthlyOccurrence Integer

    How many months between assessment runs. Valid values are between 1 and 5.

    NOTE: Either one of weekly_interval or monthly_occurrence must be specified.

    weeklyInterval Integer

    How many weeks between assessment runs. Valid values are between 1 and 6.

    dayOfWeek string

    What day of the week the assessment will be run. Default value is Monday. Possible values are Friday, Monday, Saturday, Sunday, Thursday, Tuesday and Wednesday.

    startTime string

    What time the assessment will be run. Must be in the format HH:mm.

    monthlyOccurrence number

    How many months between assessment runs. Valid values are between 1 and 5.

    NOTE: Either one of weekly_interval or monthly_occurrence must be specified.

    weeklyInterval number

    How many weeks between assessment runs. Valid values are between 1 and 6.

    day_of_week str

    What day of the week the assessment will be run. Default value is Monday. Possible values are Friday, Monday, Saturday, Sunday, Thursday, Tuesday and Wednesday.

    start_time str

    What time the assessment will be run. Must be in the format HH:mm.

    monthly_occurrence int

    How many months between assessment runs. Valid values are between 1 and 5.

    NOTE: Either one of weekly_interval or monthly_occurrence must be specified.

    weekly_interval int

    How many weeks between assessment runs. Valid values are between 1 and 6.

    dayOfWeek String

    What day of the week the assessment will be run. Default value is Monday. Possible values are Friday, Monday, Saturday, Sunday, Thursday, Tuesday and Wednesday.

    startTime String

    What time the assessment will be run. Must be in the format HH:mm.

    monthlyOccurrence Number

    How many months between assessment runs. Valid values are between 1 and 5.

    NOTE: Either one of weekly_interval or monthly_occurrence must be specified.

    weeklyInterval Number

    How many weeks between assessment runs. Valid values are between 1 and 6.

    VirtualMachineAutoBackup, VirtualMachineAutoBackupArgs

    RetentionPeriodInDays int

    Retention period of backups, in days. Valid values are from 1 to 30.

    StorageAccountAccessKey string

    Access key for the storage account where backups will be kept.

    StorageBlobEndpoint string

    Blob endpoint for the storage account where backups will be kept.

    EncryptionEnabled bool

    Enable or disable encryption for backups. Defaults to false.

    EncryptionPassword string

    Encryption password to use. Must be specified when encryption is enabled.

    ManualSchedule VirtualMachineAutoBackupManualSchedule

    A manual_schedule block as documented below. When this block is present, the schedule type is set to Manual. Without this block, the schedule type is set to Automated.

    SystemDatabasesBackupEnabled bool

    Include or exclude system databases from auto backup.

    RetentionPeriodInDays int

    Retention period of backups, in days. Valid values are from 1 to 30.

    StorageAccountAccessKey string

    Access key for the storage account where backups will be kept.

    StorageBlobEndpoint string

    Blob endpoint for the storage account where backups will be kept.

    EncryptionEnabled bool

    Enable or disable encryption for backups. Defaults to false.

    EncryptionPassword string

    Encryption password to use. Must be specified when encryption is enabled.

    ManualSchedule VirtualMachineAutoBackupManualSchedule

    A manual_schedule block as documented below. When this block is present, the schedule type is set to Manual. Without this block, the schedule type is set to Automated.

    SystemDatabasesBackupEnabled bool

    Include or exclude system databases from auto backup.

    retentionPeriodInDays Integer

    Retention period of backups, in days. Valid values are from 1 to 30.

    storageAccountAccessKey String

    Access key for the storage account where backups will be kept.

    storageBlobEndpoint String

    Blob endpoint for the storage account where backups will be kept.

    encryptionEnabled Boolean

    Enable or disable encryption for backups. Defaults to false.

    encryptionPassword String

    Encryption password to use. Must be specified when encryption is enabled.

    manualSchedule VirtualMachineAutoBackupManualSchedule

    A manual_schedule block as documented below. When this block is present, the schedule type is set to Manual. Without this block, the schedule type is set to Automated.

    systemDatabasesBackupEnabled Boolean

    Include or exclude system databases from auto backup.

    retentionPeriodInDays number

    Retention period of backups, in days. Valid values are from 1 to 30.

    storageAccountAccessKey string

    Access key for the storage account where backups will be kept.

    storageBlobEndpoint string

    Blob endpoint for the storage account where backups will be kept.

    encryptionEnabled boolean

    Enable or disable encryption for backups. Defaults to false.

    encryptionPassword string

    Encryption password to use. Must be specified when encryption is enabled.

    manualSchedule VirtualMachineAutoBackupManualSchedule

    A manual_schedule block as documented below. When this block is present, the schedule type is set to Manual. Without this block, the schedule type is set to Automated.

    systemDatabasesBackupEnabled boolean

    Include or exclude system databases from auto backup.

    retention_period_in_days int

    Retention period of backups, in days. Valid values are from 1 to 30.

    storage_account_access_key str

    Access key for the storage account where backups will be kept.

    storage_blob_endpoint str

    Blob endpoint for the storage account where backups will be kept.

    encryption_enabled bool

    Enable or disable encryption for backups. Defaults to false.

    encryption_password str

    Encryption password to use. Must be specified when encryption is enabled.

    manual_schedule VirtualMachineAutoBackupManualSchedule

    A manual_schedule block as documented below. When this block is present, the schedule type is set to Manual. Without this block, the schedule type is set to Automated.

    system_databases_backup_enabled bool

    Include or exclude system databases from auto backup.

    retentionPeriodInDays Number

    Retention period of backups, in days. Valid values are from 1 to 30.

    storageAccountAccessKey String

    Access key for the storage account where backups will be kept.

    storageBlobEndpoint String

    Blob endpoint for the storage account where backups will be kept.

    encryptionEnabled Boolean

    Enable or disable encryption for backups. Defaults to false.

    encryptionPassword String

    Encryption password to use. Must be specified when encryption is enabled.

    manualSchedule Property Map

    A manual_schedule block as documented below. When this block is present, the schedule type is set to Manual. Without this block, the schedule type is set to Automated.

    systemDatabasesBackupEnabled Boolean

    Include or exclude system databases from auto backup.

    VirtualMachineAutoBackupManualSchedule, VirtualMachineAutoBackupManualScheduleArgs

    FullBackupFrequency string

    Frequency of full backups. Valid values include Daily or Weekly.

    FullBackupStartHour int

    Start hour of a given day during which full backups can take place. Valid values are from 0 to 23.

    FullBackupWindowInHours int

    Duration of the time window of a given day during which full backups can take place, in hours. Valid values are between 1 and 23.

    LogBackupFrequencyInMinutes int

    Frequency of log backups, in minutes. Valid values are from 5 to 60.

    DaysOfWeeks List<string>

    A list of days on which backup can take place. Possible values are Monday, Tuesday, Wednesday, Thursday, Friday, Saturday and Sunday

    NOTE: days_of_week can only be specified when manual_schedule is set to Weekly

    FullBackupFrequency string

    Frequency of full backups. Valid values include Daily or Weekly.

    FullBackupStartHour int

    Start hour of a given day during which full backups can take place. Valid values are from 0 to 23.

    FullBackupWindowInHours int

    Duration of the time window of a given day during which full backups can take place, in hours. Valid values are between 1 and 23.

    LogBackupFrequencyInMinutes int

    Frequency of log backups, in minutes. Valid values are from 5 to 60.

    DaysOfWeeks []string

    A list of days on which backup can take place. Possible values are Monday, Tuesday, Wednesday, Thursday, Friday, Saturday and Sunday

    NOTE: days_of_week can only be specified when manual_schedule is set to Weekly

    fullBackupFrequency String

    Frequency of full backups. Valid values include Daily or Weekly.

    fullBackupStartHour Integer

    Start hour of a given day during which full backups can take place. Valid values are from 0 to 23.

    fullBackupWindowInHours Integer

    Duration of the time window of a given day during which full backups can take place, in hours. Valid values are between 1 and 23.

    logBackupFrequencyInMinutes Integer

    Frequency of log backups, in minutes. Valid values are from 5 to 60.

    daysOfWeeks List<String>

    A list of days on which backup can take place. Possible values are Monday, Tuesday, Wednesday, Thursday, Friday, Saturday and Sunday

    NOTE: days_of_week can only be specified when manual_schedule is set to Weekly

    fullBackupFrequency string

    Frequency of full backups. Valid values include Daily or Weekly.

    fullBackupStartHour number

    Start hour of a given day during which full backups can take place. Valid values are from 0 to 23.

    fullBackupWindowInHours number

    Duration of the time window of a given day during which full backups can take place, in hours. Valid values are between 1 and 23.

    logBackupFrequencyInMinutes number

    Frequency of log backups, in minutes. Valid values are from 5 to 60.

    daysOfWeeks string[]

    A list of days on which backup can take place. Possible values are Monday, Tuesday, Wednesday, Thursday, Friday, Saturday and Sunday

    NOTE: days_of_week can only be specified when manual_schedule is set to Weekly

    full_backup_frequency str

    Frequency of full backups. Valid values include Daily or Weekly.

    full_backup_start_hour int

    Start hour of a given day during which full backups can take place. Valid values are from 0 to 23.

    full_backup_window_in_hours int

    Duration of the time window of a given day during which full backups can take place, in hours. Valid values are between 1 and 23.

    log_backup_frequency_in_minutes int

    Frequency of log backups, in minutes. Valid values are from 5 to 60.

    days_of_weeks Sequence[str]

    A list of days on which backup can take place. Possible values are Monday, Tuesday, Wednesday, Thursday, Friday, Saturday and Sunday

    NOTE: days_of_week can only be specified when manual_schedule is set to Weekly

    fullBackupFrequency String

    Frequency of full backups. Valid values include Daily or Weekly.

    fullBackupStartHour Number

    Start hour of a given day during which full backups can take place. Valid values are from 0 to 23.

    fullBackupWindowInHours Number

    Duration of the time window of a given day during which full backups can take place, in hours. Valid values are between 1 and 23.

    logBackupFrequencyInMinutes Number

    Frequency of log backups, in minutes. Valid values are from 5 to 60.

    daysOfWeeks List<String>

    A list of days on which backup can take place. Possible values are Monday, Tuesday, Wednesday, Thursday, Friday, Saturday and Sunday

    NOTE: days_of_week can only be specified when manual_schedule is set to Weekly

    VirtualMachineAutoPatching, VirtualMachineAutoPatchingArgs

    DayOfWeek string

    The day of week to apply the patch on. Possible values are Monday, Tuesday, Wednesday, Thursday, Friday, Saturday and Sunday.

    MaintenanceWindowDurationInMinutes int

    The size of the Maintenance Window in minutes.

    MaintenanceWindowStartingHour int

    The Hour, in the Virtual Machine Time-Zone when the patching maintenance window should begin.

    DayOfWeek string

    The day of week to apply the patch on. Possible values are Monday, Tuesday, Wednesday, Thursday, Friday, Saturday and Sunday.

    MaintenanceWindowDurationInMinutes int

    The size of the Maintenance Window in minutes.

    MaintenanceWindowStartingHour int

    The Hour, in the Virtual Machine Time-Zone when the patching maintenance window should begin.

    dayOfWeek String

    The day of week to apply the patch on. Possible values are Monday, Tuesday, Wednesday, Thursday, Friday, Saturday and Sunday.

    maintenanceWindowDurationInMinutes Integer

    The size of the Maintenance Window in minutes.

    maintenanceWindowStartingHour Integer

    The Hour, in the Virtual Machine Time-Zone when the patching maintenance window should begin.

    dayOfWeek string

    The day of week to apply the patch on. Possible values are Monday, Tuesday, Wednesday, Thursday, Friday, Saturday and Sunday.

    maintenanceWindowDurationInMinutes number

    The size of the Maintenance Window in minutes.

    maintenanceWindowStartingHour number

    The Hour, in the Virtual Machine Time-Zone when the patching maintenance window should begin.

    day_of_week str

    The day of week to apply the patch on. Possible values are Monday, Tuesday, Wednesday, Thursday, Friday, Saturday and Sunday.

    maintenance_window_duration_in_minutes int

    The size of the Maintenance Window in minutes.

    maintenance_window_starting_hour int

    The Hour, in the Virtual Machine Time-Zone when the patching maintenance window should begin.

    dayOfWeek String

    The day of week to apply the patch on. Possible values are Monday, Tuesday, Wednesday, Thursday, Friday, Saturday and Sunday.

    maintenanceWindowDurationInMinutes Number

    The size of the Maintenance Window in minutes.

    maintenanceWindowStartingHour Number

    The Hour, in the Virtual Machine Time-Zone when the patching maintenance window should begin.

    VirtualMachineKeyVaultCredential, VirtualMachineKeyVaultCredentialArgs

    KeyVaultUrl string

    The Azure Key Vault url. Changing this forces a new resource to be created.

    Name string

    The credential name.

    ServicePrincipalName string

    The service principal name to access key vault. Changing this forces a new resource to be created.

    ServicePrincipalSecret string

    The service principal name secret to access key vault. Changing this forces a new resource to be created.

    KeyVaultUrl string

    The Azure Key Vault url. Changing this forces a new resource to be created.

    Name string

    The credential name.

    ServicePrincipalName string

    The service principal name to access key vault. Changing this forces a new resource to be created.

    ServicePrincipalSecret string

    The service principal name secret to access key vault. Changing this forces a new resource to be created.

    keyVaultUrl String

    The Azure Key Vault url. Changing this forces a new resource to be created.

    name String

    The credential name.

    servicePrincipalName String

    The service principal name to access key vault. Changing this forces a new resource to be created.

    servicePrincipalSecret String

    The service principal name secret to access key vault. Changing this forces a new resource to be created.

    keyVaultUrl string

    The Azure Key Vault url. Changing this forces a new resource to be created.

    name string

    The credential name.

    servicePrincipalName string

    The service principal name to access key vault. Changing this forces a new resource to be created.

    servicePrincipalSecret string

    The service principal name secret to access key vault. Changing this forces a new resource to be created.

    key_vault_url str

    The Azure Key Vault url. Changing this forces a new resource to be created.

    name str

    The credential name.

    service_principal_name str

    The service principal name to access key vault. Changing this forces a new resource to be created.

    service_principal_secret str

    The service principal name secret to access key vault. Changing this forces a new resource to be created.

    keyVaultUrl String

    The Azure Key Vault url. Changing this forces a new resource to be created.

    name String

    The credential name.

    servicePrincipalName String

    The service principal name to access key vault. Changing this forces a new resource to be created.

    servicePrincipalSecret String

    The service principal name secret to access key vault. Changing this forces a new resource to be created.

    VirtualMachineSqlInstance, VirtualMachineSqlInstanceArgs

    AdhocWorkloadsOptimizationEnabled bool

    Specifies if the SQL Server is optimized for adhoc workloads. Possible values are true and false. Defaults to false.

    Collation string

    Collation of the SQL Server. Defaults to SQL_Latin1_General_CP1_CI_AS. Changing this forces a new resource to be created.

    InstantFileInitializationEnabled bool

    Specifies if Instant File Initialization is enabled for the SQL Server. Possible values are true and false. Defaults to false. Changing this forces a new resource to be created.

    LockPagesInMemoryEnabled bool

    Specifies if Lock Pages in Memory is enabled for the SQL Server. Possible values are true and false. Defaults to false. Changing this forces a new resource to be created.

    MaxDop int

    Maximum Degree of Parallelism of the SQL Server. Possible values are between 0 and 32767. Defaults to 0.

    MaxServerMemoryMb int

    Maximum amount memory that SQL Server Memory Manager can allocate to the SQL Server process. Possible values are between 128 and 2147483647 Defaults to 2147483647.

    MinServerMemoryMb int

    Minimum amount memory that SQL Server Memory Manager can allocate to the SQL Server process. Possible values are between 0 and 2147483647 Defaults to 0.

    NOTE: max_server_memory_mb must be greater than or equal to min_server_memory_mb

    AdhocWorkloadsOptimizationEnabled bool

    Specifies if the SQL Server is optimized for adhoc workloads. Possible values are true and false. Defaults to false.

    Collation string

    Collation of the SQL Server. Defaults to SQL_Latin1_General_CP1_CI_AS. Changing this forces a new resource to be created.

    InstantFileInitializationEnabled bool

    Specifies if Instant File Initialization is enabled for the SQL Server. Possible values are true and false. Defaults to false. Changing this forces a new resource to be created.

    LockPagesInMemoryEnabled bool

    Specifies if Lock Pages in Memory is enabled for the SQL Server. Possible values are true and false. Defaults to false. Changing this forces a new resource to be created.

    MaxDop int

    Maximum Degree of Parallelism of the SQL Server. Possible values are between 0 and 32767. Defaults to 0.

    MaxServerMemoryMb int

    Maximum amount memory that SQL Server Memory Manager can allocate to the SQL Server process. Possible values are between 128 and 2147483647 Defaults to 2147483647.

    MinServerMemoryMb int

    Minimum amount memory that SQL Server Memory Manager can allocate to the SQL Server process. Possible values are between 0 and 2147483647 Defaults to 0.

    NOTE: max_server_memory_mb must be greater than or equal to min_server_memory_mb

    adhocWorkloadsOptimizationEnabled Boolean

    Specifies if the SQL Server is optimized for adhoc workloads. Possible values are true and false. Defaults to false.

    collation String

    Collation of the SQL Server. Defaults to SQL_Latin1_General_CP1_CI_AS. Changing this forces a new resource to be created.

    instantFileInitializationEnabled Boolean

    Specifies if Instant File Initialization is enabled for the SQL Server. Possible values are true and false. Defaults to false. Changing this forces a new resource to be created.

    lockPagesInMemoryEnabled Boolean

    Specifies if Lock Pages in Memory is enabled for the SQL Server. Possible values are true and false. Defaults to false. Changing this forces a new resource to be created.

    maxDop Integer

    Maximum Degree of Parallelism of the SQL Server. Possible values are between 0 and 32767. Defaults to 0.

    maxServerMemoryMb Integer

    Maximum amount memory that SQL Server Memory Manager can allocate to the SQL Server process. Possible values are between 128 and 2147483647 Defaults to 2147483647.

    minServerMemoryMb Integer

    Minimum amount memory that SQL Server Memory Manager can allocate to the SQL Server process. Possible values are between 0 and 2147483647 Defaults to 0.

    NOTE: max_server_memory_mb must be greater than or equal to min_server_memory_mb

    adhocWorkloadsOptimizationEnabled boolean

    Specifies if the SQL Server is optimized for adhoc workloads. Possible values are true and false. Defaults to false.

    collation string

    Collation of the SQL Server. Defaults to SQL_Latin1_General_CP1_CI_AS. Changing this forces a new resource to be created.

    instantFileInitializationEnabled boolean

    Specifies if Instant File Initialization is enabled for the SQL Server. Possible values are true and false. Defaults to false. Changing this forces a new resource to be created.

    lockPagesInMemoryEnabled boolean

    Specifies if Lock Pages in Memory is enabled for the SQL Server. Possible values are true and false. Defaults to false. Changing this forces a new resource to be created.

    maxDop number

    Maximum Degree of Parallelism of the SQL Server. Possible values are between 0 and 32767. Defaults to 0.

    maxServerMemoryMb number

    Maximum amount memory that SQL Server Memory Manager can allocate to the SQL Server process. Possible values are between 128 and 2147483647 Defaults to 2147483647.

    minServerMemoryMb number

    Minimum amount memory that SQL Server Memory Manager can allocate to the SQL Server process. Possible values are between 0 and 2147483647 Defaults to 0.

    NOTE: max_server_memory_mb must be greater than or equal to min_server_memory_mb

    adhoc_workloads_optimization_enabled bool

    Specifies if the SQL Server is optimized for adhoc workloads. Possible values are true and false. Defaults to false.

    collation str

    Collation of the SQL Server. Defaults to SQL_Latin1_General_CP1_CI_AS. Changing this forces a new resource to be created.

    instant_file_initialization_enabled bool

    Specifies if Instant File Initialization is enabled for the SQL Server. Possible values are true and false. Defaults to false. Changing this forces a new resource to be created.

    lock_pages_in_memory_enabled bool

    Specifies if Lock Pages in Memory is enabled for the SQL Server. Possible values are true and false. Defaults to false. Changing this forces a new resource to be created.

    max_dop int

    Maximum Degree of Parallelism of the SQL Server. Possible values are between 0 and 32767. Defaults to 0.

    max_server_memory_mb int

    Maximum amount memory that SQL Server Memory Manager can allocate to the SQL Server process. Possible values are between 128 and 2147483647 Defaults to 2147483647.

    min_server_memory_mb int

    Minimum amount memory that SQL Server Memory Manager can allocate to the SQL Server process. Possible values are between 0 and 2147483647 Defaults to 0.

    NOTE: max_server_memory_mb must be greater than or equal to min_server_memory_mb

    adhocWorkloadsOptimizationEnabled Boolean

    Specifies if the SQL Server is optimized for adhoc workloads. Possible values are true and false. Defaults to false.

    collation String

    Collation of the SQL Server. Defaults to SQL_Latin1_General_CP1_CI_AS. Changing this forces a new resource to be created.

    instantFileInitializationEnabled Boolean

    Specifies if Instant File Initialization is enabled for the SQL Server. Possible values are true and false. Defaults to false. Changing this forces a new resource to be created.

    lockPagesInMemoryEnabled Boolean

    Specifies if Lock Pages in Memory is enabled for the SQL Server. Possible values are true and false. Defaults to false. Changing this forces a new resource to be created.

    maxDop Number

    Maximum Degree of Parallelism of the SQL Server. Possible values are between 0 and 32767. Defaults to 0.

    maxServerMemoryMb Number

    Maximum amount memory that SQL Server Memory Manager can allocate to the SQL Server process. Possible values are between 128 and 2147483647 Defaults to 2147483647.

    minServerMemoryMb Number

    Minimum amount memory that SQL Server Memory Manager can allocate to the SQL Server process. Possible values are between 0 and 2147483647 Defaults to 0.

    NOTE: max_server_memory_mb must be greater than or equal to min_server_memory_mb

    VirtualMachineStorageConfiguration, VirtualMachineStorageConfigurationArgs

    DiskType string

    The type of disk configuration to apply to the SQL Server. Valid values include NEW, EXTEND, or ADD.

    StorageWorkloadType string

    The type of storage workload. Valid values include GENERAL, OLTP, or DW.

    DataSettings VirtualMachineStorageConfigurationDataSettings

    A storage_settings block as defined below.

    LogSettings VirtualMachineStorageConfigurationLogSettings

    A storage_settings block as defined below.

    SystemDbOnDataDiskEnabled bool

    Specifies whether to set system databases (except tempDb) location to newly created data storage. Possible values are true and false. Defaults to false.

    TempDbSettings VirtualMachineStorageConfigurationTempDbSettings

    An temp_db_settings as defined below.

    DiskType string

    The type of disk configuration to apply to the SQL Server. Valid values include NEW, EXTEND, or ADD.

    StorageWorkloadType string

    The type of storage workload. Valid values include GENERAL, OLTP, or DW.

    DataSettings VirtualMachineStorageConfigurationDataSettings

    A storage_settings block as defined below.

    LogSettings VirtualMachineStorageConfigurationLogSettings

    A storage_settings block as defined below.

    SystemDbOnDataDiskEnabled bool

    Specifies whether to set system databases (except tempDb) location to newly created data storage. Possible values are true and false. Defaults to false.

    TempDbSettings VirtualMachineStorageConfigurationTempDbSettings

    An temp_db_settings as defined below.

    diskType String

    The type of disk configuration to apply to the SQL Server. Valid values include NEW, EXTEND, or ADD.

    storageWorkloadType String

    The type of storage workload. Valid values include GENERAL, OLTP, or DW.

    dataSettings VirtualMachineStorageConfigurationDataSettings

    A storage_settings block as defined below.

    logSettings VirtualMachineStorageConfigurationLogSettings

    A storage_settings block as defined below.

    systemDbOnDataDiskEnabled Boolean

    Specifies whether to set system databases (except tempDb) location to newly created data storage. Possible values are true and false. Defaults to false.

    tempDbSettings VirtualMachineStorageConfigurationTempDbSettings

    An temp_db_settings as defined below.

    diskType string

    The type of disk configuration to apply to the SQL Server. Valid values include NEW, EXTEND, or ADD.

    storageWorkloadType string

    The type of storage workload. Valid values include GENERAL, OLTP, or DW.

    dataSettings VirtualMachineStorageConfigurationDataSettings

    A storage_settings block as defined below.

    logSettings VirtualMachineStorageConfigurationLogSettings

    A storage_settings block as defined below.

    systemDbOnDataDiskEnabled boolean

    Specifies whether to set system databases (except tempDb) location to newly created data storage. Possible values are true and false. Defaults to false.

    tempDbSettings VirtualMachineStorageConfigurationTempDbSettings

    An temp_db_settings as defined below.

    disk_type str

    The type of disk configuration to apply to the SQL Server. Valid values include NEW, EXTEND, or ADD.

    storage_workload_type str

    The type of storage workload. Valid values include GENERAL, OLTP, or DW.

    data_settings VirtualMachineStorageConfigurationDataSettings

    A storage_settings block as defined below.

    log_settings VirtualMachineStorageConfigurationLogSettings

    A storage_settings block as defined below.

    system_db_on_data_disk_enabled bool

    Specifies whether to set system databases (except tempDb) location to newly created data storage. Possible values are true and false. Defaults to false.

    temp_db_settings VirtualMachineStorageConfigurationTempDbSettings

    An temp_db_settings as defined below.

    diskType String

    The type of disk configuration to apply to the SQL Server. Valid values include NEW, EXTEND, or ADD.

    storageWorkloadType String

    The type of storage workload. Valid values include GENERAL, OLTP, or DW.

    dataSettings Property Map

    A storage_settings block as defined below.

    logSettings Property Map

    A storage_settings block as defined below.

    systemDbOnDataDiskEnabled Boolean

    Specifies whether to set system databases (except tempDb) location to newly created data storage. Possible values are true and false. Defaults to false.

    tempDbSettings Property Map

    An temp_db_settings as defined below.

    VirtualMachineStorageConfigurationDataSettings, VirtualMachineStorageConfigurationDataSettingsArgs

    DefaultFilePath string

    The SQL Server default path

    Luns List<int>

    A list of Logical Unit Numbers for the disks.

    DefaultFilePath string

    The SQL Server default path

    Luns []int

    A list of Logical Unit Numbers for the disks.

    defaultFilePath String

    The SQL Server default path

    luns List<Integer>

    A list of Logical Unit Numbers for the disks.

    defaultFilePath string

    The SQL Server default path

    luns number[]

    A list of Logical Unit Numbers for the disks.

    default_file_path str

    The SQL Server default path

    luns Sequence[int]

    A list of Logical Unit Numbers for the disks.

    defaultFilePath String

    The SQL Server default path

    luns List<Number>

    A list of Logical Unit Numbers for the disks.

    VirtualMachineStorageConfigurationLogSettings, VirtualMachineStorageConfigurationLogSettingsArgs

    DefaultFilePath string

    The SQL Server default path

    Luns List<int>

    A list of Logical Unit Numbers for the disks.

    DefaultFilePath string

    The SQL Server default path

    Luns []int

    A list of Logical Unit Numbers for the disks.

    defaultFilePath String

    The SQL Server default path

    luns List<Integer>

    A list of Logical Unit Numbers for the disks.

    defaultFilePath string

    The SQL Server default path

    luns number[]

    A list of Logical Unit Numbers for the disks.

    default_file_path str

    The SQL Server default path

    luns Sequence[int]

    A list of Logical Unit Numbers for the disks.

    defaultFilePath String

    The SQL Server default path

    luns List<Number>

    A list of Logical Unit Numbers for the disks.

    VirtualMachineStorageConfigurationTempDbSettings, VirtualMachineStorageConfigurationTempDbSettingsArgs

    DefaultFilePath string

    The SQL Server default path

    Luns List<int>

    A list of Logical Unit Numbers for the disks.

    DataFileCount int

    The SQL Server default file count. This value defaults to 8

    DataFileGrowthInMb int

    The SQL Server default file size - This value defaults to 512

    DataFileSizeMb int

    The SQL Server default file size - This value defaults to 256

    LogFileGrowthMb int

    The SQL Server default file size - This value defaults to 512

    LogFileSizeMb int

    The SQL Server default file size - This value defaults to 256

    DefaultFilePath string

    The SQL Server default path

    Luns []int

    A list of Logical Unit Numbers for the disks.

    DataFileCount int

    The SQL Server default file count. This value defaults to 8

    DataFileGrowthInMb int

    The SQL Server default file size - This value defaults to 512

    DataFileSizeMb int

    The SQL Server default file size - This value defaults to 256

    LogFileGrowthMb int

    The SQL Server default file size - This value defaults to 512

    LogFileSizeMb int

    The SQL Server default file size - This value defaults to 256

    defaultFilePath String

    The SQL Server default path

    luns List<Integer>

    A list of Logical Unit Numbers for the disks.

    dataFileCount Integer

    The SQL Server default file count. This value defaults to 8

    dataFileGrowthInMb Integer

    The SQL Server default file size - This value defaults to 512

    dataFileSizeMb Integer

    The SQL Server default file size - This value defaults to 256

    logFileGrowthMb Integer

    The SQL Server default file size - This value defaults to 512

    logFileSizeMb Integer

    The SQL Server default file size - This value defaults to 256

    defaultFilePath string

    The SQL Server default path

    luns number[]

    A list of Logical Unit Numbers for the disks.

    dataFileCount number

    The SQL Server default file count. This value defaults to 8

    dataFileGrowthInMb number

    The SQL Server default file size - This value defaults to 512

    dataFileSizeMb number

    The SQL Server default file size - This value defaults to 256

    logFileGrowthMb number

    The SQL Server default file size - This value defaults to 512

    logFileSizeMb number

    The SQL Server default file size - This value defaults to 256

    default_file_path str

    The SQL Server default path

    luns Sequence[int]

    A list of Logical Unit Numbers for the disks.

    data_file_count int

    The SQL Server default file count. This value defaults to 8

    data_file_growth_in_mb int

    The SQL Server default file size - This value defaults to 512

    data_file_size_mb int

    The SQL Server default file size - This value defaults to 256

    log_file_growth_mb int

    The SQL Server default file size - This value defaults to 512

    log_file_size_mb int

    The SQL Server default file size - This value defaults to 256

    defaultFilePath String

    The SQL Server default path

    luns List<Number>

    A list of Logical Unit Numbers for the disks.

    dataFileCount Number

    The SQL Server default file count. This value defaults to 8

    dataFileGrowthInMb Number

    The SQL Server default file size - This value defaults to 512

    dataFileSizeMb Number

    The SQL Server default file size - This value defaults to 256

    logFileGrowthMb Number

    The SQL Server default file size - This value defaults to 512

    logFileSizeMb Number

    The SQL Server default file size - This value defaults to 256

    VirtualMachineWsfcDomainCredential, VirtualMachineWsfcDomainCredentialArgs

    ClusterBootstrapAccountPassword string

    The account password used for creating cluster.

    ClusterOperatorAccountPassword string

    The account password used for operating cluster.

    SqlServiceAccountPassword string

    The account password under which SQL service will run on all participating SQL virtual machines in the cluster.

    ClusterBootstrapAccountPassword string

    The account password used for creating cluster.

    ClusterOperatorAccountPassword string

    The account password used for operating cluster.

    SqlServiceAccountPassword string

    The account password under which SQL service will run on all participating SQL virtual machines in the cluster.

    clusterBootstrapAccountPassword String

    The account password used for creating cluster.

    clusterOperatorAccountPassword String

    The account password used for operating cluster.

    sqlServiceAccountPassword String

    The account password under which SQL service will run on all participating SQL virtual machines in the cluster.

    clusterBootstrapAccountPassword string

    The account password used for creating cluster.

    clusterOperatorAccountPassword string

    The account password used for operating cluster.

    sqlServiceAccountPassword string

    The account password under which SQL service will run on all participating SQL virtual machines in the cluster.

    cluster_bootstrap_account_password str

    The account password used for creating cluster.

    cluster_operator_account_password str

    The account password used for operating cluster.

    sql_service_account_password str

    The account password under which SQL service will run on all participating SQL virtual machines in the cluster.

    clusterBootstrapAccountPassword String

    The account password used for creating cluster.

    clusterOperatorAccountPassword String

    The account password used for operating cluster.

    sqlServiceAccountPassword String

    The account password under which SQL service will run on all participating SQL virtual machines in the cluster.

    Import

    Microsoft SQL Virtual Machines can be imported using the resource id, e.g.

     $ pulumi import azure:mssql/virtualMachine:VirtualMachine example /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/group1/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachines/example1

    Package Details

    Repository
    Azure Classic pulumi/pulumi-azure
    License
    Apache-2.0
    Notes

    This Pulumi package is based on the azurerm Terraform Provider.

    azure logo

    We recommend using Azure Native.

    Azure Classic v5.49.0 published on Tuesday, Aug 29, 2023 by Pulumi
    pulumi/pulumi-azure