Sql Virtual Machine Group
A SQL virtual machine group. Uses Azure REST API version 2023-10-01. In version 2.x of the Azure Native provider, it used API version 2022-02-01. Other available API versions: 2022-02-01, 2022-07-01-preview, 2022-08-01-preview, 2023-01-01-preview. These can be accessed by generating a local SDK package using the CLI command pulumi package add azure-native sqlvirtualmachine [ApiVersion]
. See the ../../../version-guide/#accessing-any-api-version-via-local-packages for details.
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",
IsSqlServiceAccountGmsa = false,
OuPath = "OU=WSCluster,DC=testdomain,DC=com",
SqlServiceAccount = "sqlservice@testdomain.com",
StorageAccountPrimaryKey = "<primary storage access key>",
StorageAccountUrl = "https://storgact.blob.core.windows.net/",
},
});
});
package main
import (
sqlvirtualmachine "github.com/pulumi/pulumi-azure-native-sdk/sqlvirtualmachine/v3"
"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"),
IsSqlServiceAccountGmsa: pulumi.Bool(false),
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
})
}
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")
.isSqlServiceAccountGmsa(false)
.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());
}
}
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}
Properties
The Azure API version of the resource.
Cluster type.
Type of cluster manager: Windows Server Failover Cluster (WSFC), implied by the scale type of the group and the OS type.
Provisioning state to track the async operation status.
SQL image offer. Examples may include SQL2016-WS2016, SQL2017-WS2016.
SQL image sku.
Metadata pertaining to creation and last modification of the resource.
Cluster Active Directory domain profile.