Virtual Machine Args
Manages a Microsoft SQL Virtual Machine
Example Usage
This example provisions a brief Managed Microsoft SQL Virtual Machine.
import * as pulumi from "@pulumi/pulumi";
import * as azure from "@pulumi/azure";
const example = azure.compute.getVirtualMachine({
name: "example-vm",
resourceGroupName: "example-resources",
});
const exampleVirtualMachine = new azure.mssql.VirtualMachine("example", {
virtualMachineId: example.then(example => example.id),
sqlLicenseType: "PAYG",
rServicesEnabled: true,
sqlConnectivityPort: 1433,
sqlConnectivityType: "PRIVATE",
sqlConnectivityUpdatePassword: "Password1234!",
sqlConnectivityUpdateUsername: "sqllogin",
autoPatching: {
dayOfWeek: "Sunday",
maintenanceWindowDurationInMinutes: 60,
maintenanceWindowStartingHour: 2,
},
});
import pulumi
import pulumi_azure as azure
example = azure.compute.get_virtual_machine(name="example-vm",
resource_group_name="example-resources")
example_virtual_machine = azure.mssql.VirtualMachine("example",
virtual_machine_id=example.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={
"day_of_week": "Sunday",
"maintenance_window_duration_in_minutes": 60,
"maintenance_window_starting_hour": 2,
})
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Azure = Pulumi.Azure;
return await Deployment.RunAsync(() =>
{
var example = Azure.Compute.GetVirtualMachine.Invoke(new()
{
Name = "example-vm",
ResourceGroupName = "example-resources",
});
var exampleVirtualMachine = new Azure.MSSql.VirtualMachine("example", new()
{
VirtualMachineId = example.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/v6/go/azure/compute"
"github.com/pulumi/pulumi-azure/sdk/v6/go/azure/mssql"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
example, err := compute.LookupVirtualMachine(ctx, &compute.LookupVirtualMachineArgs{
Name: "example-vm",
ResourceGroupName: "example-resources",
}, nil)
if err != nil {
return err
}
_, err = mssql.NewVirtualMachine(ctx, "example", &mssql.VirtualMachineArgs{
VirtualMachineId: pulumi.String(example.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 example = ComputeFunctions.getVirtualMachine(GetVirtualMachineArgs.builder()
.name("example-vm")
.resourceGroupName("example-resources")
.build());
var exampleVirtualMachine = new VirtualMachine("exampleVirtualMachine", VirtualMachineArgs.builder()
.virtualMachineId(example.id())
.sqlLicenseType("PAYG")
.rServicesEnabled(true)
.sqlConnectivityPort(1433)
.sqlConnectivityType("PRIVATE")
.sqlConnectivityUpdatePassword("Password1234!")
.sqlConnectivityUpdateUsername("sqllogin")
.autoPatching(VirtualMachineAutoPatchingArgs.builder()
.dayOfWeek("Sunday")
.maintenanceWindowDurationInMinutes(60)
.maintenanceWindowStartingHour(2)
.build())
.build());
}
}
resources:
exampleVirtualMachine:
type: azure:mssql:VirtualMachine
name: example
properties:
virtualMachineId: ${example.id}
sqlLicenseType: PAYG
rServicesEnabled: true
sqlConnectivityPort: 1433
sqlConnectivityType: PRIVATE
sqlConnectivityUpdatePassword: Password1234!
sqlConnectivityUpdateUsername: sqllogin
autoPatching:
dayOfWeek: Sunday
maintenanceWindowDurationInMinutes: 60
maintenanceWindowStartingHour: 2
variables:
example:
fn::invoke:
function: azure:compute:getVirtualMachine
arguments:
name: example-vm
resourceGroupName: example-resources
API Providers
This resource uses the following Azure API Providers:
Microsoft.Compute
: 2024-03-01Microsoft.SqlVirtualMachine
: 2023-10-01
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
Constructors
Properties
An assessment
block as defined below.
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.
An auto_patching
block as defined below.
An key_vault_credential
block as defined below.
Should R Services be enabled?
The SQL Server port. Defaults to 1433
.
The connectivity type used for this SQL Server. Possible values are LOCAL
, PRIVATE
and PUBLIC
. Defaults to PRIVATE
.
The SQL Server sysadmin login password.
The SQL Server sysadmin login to create.
A sql_instance
block as defined below.
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.
The ID of the SQL Virtual Machine Group that the SQL Virtual Machine belongs to.
An storage_configuration
block as defined below.
The ID of the Virtual Machine. Changing this forces a new resource to be created.
A wsfc_domain_credential
block as defined below