Sql Virtual Machine Group
A SQL virtual machine group. Uses Azure REST API version 2022-02-01. In version 1.x of the Azure Native provider, it used API version 2017-03-01-preview. Other available API versions: 2023-01-01-preview, 2023-10-01.
Example Usage
Creates or updates a SQL virtual machine group.
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;
return await Deployment.RunAsync(() =>
{
var sqlVirtualMachineGroup = new AzureNative.SqlVirtualMachine.SqlVirtualMachineGroup("sqlVirtualMachineGroup", new()
{
Location = "northeurope",
ResourceGroupName = "testrg",
SqlImageOffer = "SQL2016-WS2016",
SqlImageSku = AzureNative.SqlVirtualMachine.SqlVmGroupImageSku.Enterprise,
SqlVirtualMachineGroupName = "testvmgroup",
Tags =
{
{ "mytag", "myval" },
},
WsfcDomainProfile = new AzureNative.SqlVirtualMachine.Inputs.WsfcDomainProfileArgs
{
ClusterBootstrapAccount = "testrpadmin",
ClusterOperatorAccount = "testrp@testdomain.com",
ClusterSubnetType = AzureNative.SqlVirtualMachine.ClusterSubnetType.MultiSubnet,
DomainFqdn = "testdomain.com",
OuPath = "OU=WSCluster,DC=testdomain,DC=com",
SqlServiceAccount = "sqlservice@testdomain.com",
StorageAccountPrimaryKey = "<primary storage access key>",
StorageAccountUrl = "https://storgact.blob.core.windows.net/",
},
});
});
Content copied to clipboard
package main
import (
sqlvirtualmachine "github.com/pulumi/pulumi-azure-native-sdk/sqlvirtualmachine/v2"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
pulumi.Run(func(ctx *pulumi.Context) error {
_, err := sqlvirtualmachine.NewSqlVirtualMachineGroup(ctx, "sqlVirtualMachineGroup", &sqlvirtualmachine.SqlVirtualMachineGroupArgs{
Location: pulumi.String("northeurope"),
ResourceGroupName: pulumi.String("testrg"),
SqlImageOffer: pulumi.String("SQL2016-WS2016"),
SqlImageSku: pulumi.String(sqlvirtualmachine.SqlVmGroupImageSkuEnterprise),
SqlVirtualMachineGroupName: pulumi.String("testvmgroup"),
Tags: pulumi.StringMap{
"mytag": pulumi.String("myval"),
},
WsfcDomainProfile: &sqlvirtualmachine.WsfcDomainProfileArgs{
ClusterBootstrapAccount: pulumi.String("testrpadmin"),
ClusterOperatorAccount: pulumi.String("testrp@testdomain.com"),
ClusterSubnetType: pulumi.String(sqlvirtualmachine.ClusterSubnetTypeMultiSubnet),
DomainFqdn: pulumi.String("testdomain.com"),
OuPath: pulumi.String("OU=WSCluster,DC=testdomain,DC=com"),
SqlServiceAccount: pulumi.String("sqlservice@testdomain.com"),
StorageAccountPrimaryKey: pulumi.String("<primary storage access key>"),
StorageAccountUrl: pulumi.String("https://storgact.blob.core.windows.net/"),
},
})
if err != nil {
return err
}
return nil
})
}
Content copied to clipboard
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.azurenative.sqlvirtualmachine.SqlVirtualMachineGroup;
import com.pulumi.azurenative.sqlvirtualmachine.SqlVirtualMachineGroupArgs;
import com.pulumi.azurenative.sqlvirtualmachine.inputs.WsfcDomainProfileArgs;
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 sqlVirtualMachineGroup = new SqlVirtualMachineGroup("sqlVirtualMachineGroup", SqlVirtualMachineGroupArgs.builder()
.location("northeurope")
.resourceGroupName("testrg")
.sqlImageOffer("SQL2016-WS2016")
.sqlImageSku("Enterprise")
.sqlVirtualMachineGroupName("testvmgroup")
.tags(Map.of("mytag", "myval"))
.wsfcDomainProfile(WsfcDomainProfileArgs.builder()
.clusterBootstrapAccount("testrpadmin")
.clusterOperatorAccount("testrp@testdomain.com")
.clusterSubnetType("MultiSubnet")
.domainFqdn("testdomain.com")
.ouPath("OU=WSCluster,DC=testdomain,DC=com")
.sqlServiceAccount("sqlservice@testdomain.com")
.storageAccountPrimaryKey("<primary storage access key>")
.storageAccountUrl("https://storgact.blob.core.windows.net/")
.build())
.build());
}
}
Content copied to clipboard
Import
An existing resource can be imported using its type token, name, and identifier, e.g.
$ pulumi import azure-native:sqlvirtualmachine:SqlVirtualMachineGroup testvmgroup /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachineGroups/{sqlVirtualMachineGroupName}
Content copied to clipboard
Properties
Link copied to clipboard
Cluster type.
Link copied to clipboard
Type of cluster manager: Windows Server Failover Cluster (WSFC), implied by the scale type of the group and the OS type.
Link copied to clipboard
Provisioning state to track the async operation status.
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
SQL image offer. Examples may include SQL2016-WS2016, SQL2017-WS2016.
Link copied to clipboard
SQL image sku.
Link copied to clipboard
Metadata pertaining to creation and last modification of the resource.
Link copied to clipboard
Cluster Active Directory domain profile.