Azure Native

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

SqlVirtualMachineGroup

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

Example Usage

Creates or updates a SQL virtual machine group.

using System.Collections.Generic;
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 = "Enterprise",
        SqlVirtualMachineGroupName = "testvmgroup",
        Tags = 
        {
            { "mytag", "myval" },
        },
        WsfcDomainProfile = new AzureNative.SqlVirtualMachine.Inputs.WsfcDomainProfileArgs
        {
            ClusterBootstrapAccount = "testrpadmin",
            ClusterOperatorAccount = "testrp@testdomain.com",
            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/",
        },
    });

});
package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := sqlvirtualmachine.NewSqlVirtualMachineGroup(ctx, "sqlVirtualMachineGroup", &sqlvirtualmachine.SqlVirtualMachineGroupArgs{
			Location:                   pulumi.String("northeurope"),
			ResourceGroupName:          pulumi.String("testrg"),
			SqlImageOffer:              pulumi.String("SQL2016-WS2016"),
			SqlImageSku:                pulumi.String("Enterprise"),
			SqlVirtualMachineGroupName: pulumi.String("testvmgroup"),
			Tags: pulumi.StringMap{
				"mytag": pulumi.String("myval"),
			},
			WsfcDomainProfile: &sqlvirtualmachine.WsfcDomainProfileArgs{
				ClusterBootstrapAccount:  pulumi.String("testrpadmin"),
				ClusterOperatorAccount:   pulumi.String("testrp@testdomain.com"),
				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
	})
}
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 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(Map.ofEntries(
                Map.entry("clusterBootstrapAccount", "testrpadmin"),
                Map.entry("clusterOperatorAccount", "testrp@testdomain.com"),
                Map.entry("domainFqdn", "testdomain.com"),
                Map.entry("ouPath", "OU=WSCluster,DC=testdomain,DC=com"),
                Map.entry("sqlServiceAccount", "sqlservice@testdomain.com"),
                Map.entry("storageAccountPrimaryKey", "<primary storage access key>"),
                Map.entry("storageAccountUrl", "https://storgact.blob.core.windows.net/")
            ))
            .build());

    }
}
import pulumi
import pulumi_azure_native as azure_native

sql_virtual_machine_group = azure_native.sqlvirtualmachine.SqlVirtualMachineGroup("sqlVirtualMachineGroup",
    location="northeurope",
    resource_group_name="testrg",
    sql_image_offer="SQL2016-WS2016",
    sql_image_sku="Enterprise",
    sql_virtual_machine_group_name="testvmgroup",
    tags={
        "mytag": "myval",
    },
    wsfc_domain_profile=azure_native.sqlvirtualmachine.WsfcDomainProfileArgs(
        cluster_bootstrap_account="testrpadmin",
        cluster_operator_account="testrp@testdomain.com",
        domain_fqdn="testdomain.com",
        ou_path="OU=WSCluster,DC=testdomain,DC=com",
        sql_service_account="sqlservice@testdomain.com",
        storage_account_primary_key="<primary storage access key>",
        storage_account_url="https://storgact.blob.core.windows.net/",
    ))
import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";

const sqlVirtualMachineGroup = new azure_native.sqlvirtualmachine.SqlVirtualMachineGroup("sqlVirtualMachineGroup", {
    location: "northeurope",
    resourceGroupName: "testrg",
    sqlImageOffer: "SQL2016-WS2016",
    sqlImageSku: "Enterprise",
    sqlVirtualMachineGroupName: "testvmgroup",
    tags: {
        mytag: "myval",
    },
    wsfcDomainProfile: {
        clusterBootstrapAccount: "testrpadmin",
        clusterOperatorAccount: "testrp@testdomain.com",
        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/",
    },
});
resources:
  sqlVirtualMachineGroup:
    type: azure-native:sqlvirtualmachine:SqlVirtualMachineGroup
    properties:
      location: northeurope
      resourceGroupName: testrg
      sqlImageOffer: SQL2016-WS2016
      sqlImageSku: Enterprise
      sqlVirtualMachineGroupName: testvmgroup
      tags:
        mytag: myval
      wsfcDomainProfile:
        clusterBootstrapAccount: testrpadmin
        clusterOperatorAccount: testrp@testdomain.com
        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/

Create SqlVirtualMachineGroup Resource

new SqlVirtualMachineGroup(name: string, args: SqlVirtualMachineGroupArgs, opts?: CustomResourceOptions);
@overload
def SqlVirtualMachineGroup(resource_name: str,
                           opts: Optional[ResourceOptions] = None,
                           location: Optional[str] = None,
                           resource_group_name: Optional[str] = None,
                           sql_image_offer: Optional[str] = None,
                           sql_image_sku: Optional[Union[str, SqlVmGroupImageSku]] = None,
                           sql_virtual_machine_group_name: Optional[str] = None,
                           tags: Optional[Mapping[str, str]] = None,
                           wsfc_domain_profile: Optional[WsfcDomainProfileArgs] = None)
@overload
def SqlVirtualMachineGroup(resource_name: str,
                           args: SqlVirtualMachineGroupArgs,
                           opts: Optional[ResourceOptions] = None)
func NewSqlVirtualMachineGroup(ctx *Context, name string, args SqlVirtualMachineGroupArgs, opts ...ResourceOption) (*SqlVirtualMachineGroup, error)
public SqlVirtualMachineGroup(string name, SqlVirtualMachineGroupArgs args, CustomResourceOptions? opts = null)
public SqlVirtualMachineGroup(String name, SqlVirtualMachineGroupArgs args)
public SqlVirtualMachineGroup(String name, SqlVirtualMachineGroupArgs args, CustomResourceOptions options)
type: azure-native:sqlvirtualmachine:SqlVirtualMachineGroup
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.

name string
The unique name of the resource.
args SqlVirtualMachineGroupArgs
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 SqlVirtualMachineGroupArgs
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 SqlVirtualMachineGroupArgs
The arguments to resource properties.
opts ResourceOption
Bag of options to control resource's behavior.
name string
The unique name of the resource.
args SqlVirtualMachineGroupArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
name String
The unique name of the resource.
args SqlVirtualMachineGroupArgs
The arguments to resource properties.
options CustomResourceOptions
Bag of options to control resource's behavior.

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

ResourceGroupName string

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

Location string

Resource location.

SqlImageOffer string

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

SqlImageSku string | Pulumi.AzureNative.SqlVirtualMachine.SqlVmGroupImageSku

SQL image sku.

SqlVirtualMachineGroupName string

Name of the SQL virtual machine group.

Tags Dictionary<string, string>

Resource tags.

WsfcDomainProfile Pulumi.AzureNative.SqlVirtualMachine.Inputs.WsfcDomainProfileArgs

Cluster Active Directory domain profile.

ResourceGroupName string

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

Location string

Resource location.

SqlImageOffer string

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

SqlImageSku string | SqlVmGroupImageSku

SQL image sku.

SqlVirtualMachineGroupName string

Name of the SQL virtual machine group.

Tags map[string]string

Resource tags.

WsfcDomainProfile WsfcDomainProfileArgs

Cluster Active Directory domain profile.

resourceGroupName String

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

location String

Resource location.

sqlImageOffer String

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

sqlImageSku String | SqlVmGroupImageSku

SQL image sku.

sqlVirtualMachineGroupName String

Name of the SQL virtual machine group.

tags Map<String,String>

Resource tags.

wsfcDomainProfile WsfcDomainProfileArgs

Cluster Active Directory domain profile.

resourceGroupName string

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

location string

Resource location.

sqlImageOffer string

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

sqlImageSku string | SqlVmGroupImageSku

SQL image sku.

sqlVirtualMachineGroupName string

Name of the SQL virtual machine group.

tags {[key: string]: string}

Resource tags.

wsfcDomainProfile WsfcDomainProfileArgs

Cluster Active Directory domain profile.

resource_group_name str

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

location str

Resource location.

sql_image_offer str

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

sql_image_sku str | SqlVmGroupImageSku

SQL image sku.

sql_virtual_machine_group_name str

Name of the SQL virtual machine group.

tags Mapping[str, str]

Resource tags.

wsfc_domain_profile WsfcDomainProfileArgs

Cluster Active Directory domain profile.

resourceGroupName String

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

location String

Resource location.

sqlImageOffer String

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

sqlImageSku String | "Developer" | "Enterprise"

SQL image sku.

sqlVirtualMachineGroupName String

Name of the SQL virtual machine group.

tags Map<String>

Resource tags.

wsfcDomainProfile Property Map

Cluster Active Directory domain profile.

Outputs

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

ClusterConfiguration string

Cluster type.

ClusterManagerType string

Type of cluster manager: Windows Server Failover Cluster (WSFC), implied by the scale type of the group and the OS type.

Id string

The provider-assigned unique ID for this managed resource.

Name string

Resource name.

ProvisioningState string

Provisioning state to track the async operation status.

ScaleType string

Scale type.

Type string

Resource type.

ClusterConfiguration string

Cluster type.

ClusterManagerType string

Type of cluster manager: Windows Server Failover Cluster (WSFC), implied by the scale type of the group and the OS type.

Id string

The provider-assigned unique ID for this managed resource.

Name string

Resource name.

ProvisioningState string

Provisioning state to track the async operation status.

ScaleType string

Scale type.

Type string

Resource type.

clusterConfiguration String

Cluster type.

clusterManagerType String

Type of cluster manager: Windows Server Failover Cluster (WSFC), implied by the scale type of the group and the OS type.

id String

The provider-assigned unique ID for this managed resource.

name String

Resource name.

provisioningState String

Provisioning state to track the async operation status.

scaleType String

Scale type.

type String

Resource type.

clusterConfiguration string

Cluster type.

clusterManagerType string

Type of cluster manager: Windows Server Failover Cluster (WSFC), implied by the scale type of the group and the OS type.

id string

The provider-assigned unique ID for this managed resource.

name string

Resource name.

provisioningState string

Provisioning state to track the async operation status.

scaleType string

Scale type.

type string

Resource type.

cluster_configuration str

Cluster type.

cluster_manager_type str

Type of cluster manager: Windows Server Failover Cluster (WSFC), implied by the scale type of the group and the OS type.

id str

The provider-assigned unique ID for this managed resource.

name str

Resource name.

provisioning_state str

Provisioning state to track the async operation status.

scale_type str

Scale type.

type str

Resource type.

clusterConfiguration String

Cluster type.

clusterManagerType String

Type of cluster manager: Windows Server Failover Cluster (WSFC), implied by the scale type of the group and the OS type.

id String

The provider-assigned unique ID for this managed resource.

name String

Resource name.

provisioningState String

Provisioning state to track the async operation status.

scaleType String

Scale type.

type String

Resource type.

Supporting Types

SqlVmGroupImageSku

Developer
Developer
Enterprise
Enterprise
SqlVmGroupImageSkuDeveloper
Developer
SqlVmGroupImageSkuEnterprise
Enterprise
Developer
Developer
Enterprise
Enterprise
Developer
Developer
Enterprise
Enterprise
DEVELOPER
Developer
ENTERPRISE
Enterprise
"Developer"
Developer
"Enterprise"
Enterprise

WsfcDomainProfile

ClusterBootstrapAccount string

Account name used for creating cluster (at minimum needs permissions to 'Create Computer Objects' in domain).

ClusterOperatorAccount string

Account name used for operating cluster i.e. will be part of administrators group on all the participating virtual machines in the cluster.

DomainFqdn string

Fully qualified name of the domain.

FileShareWitnessPath string

Optional path for fileshare witness.

OuPath string

Organizational Unit path in which the nodes and cluster will be present.

SqlServiceAccount string

Account name under which SQL service will run on all participating SQL virtual machines in the cluster.

StorageAccountPrimaryKey string

Primary key of the witness storage account.

StorageAccountUrl string

Fully qualified ARM resource id of the witness storage account.

ClusterBootstrapAccount string

Account name used for creating cluster (at minimum needs permissions to 'Create Computer Objects' in domain).

ClusterOperatorAccount string

Account name used for operating cluster i.e. will be part of administrators group on all the participating virtual machines in the cluster.

DomainFqdn string

Fully qualified name of the domain.

FileShareWitnessPath string

Optional path for fileshare witness.

OuPath string

Organizational Unit path in which the nodes and cluster will be present.

SqlServiceAccount string

Account name under which SQL service will run on all participating SQL virtual machines in the cluster.

StorageAccountPrimaryKey string

Primary key of the witness storage account.

StorageAccountUrl string

Fully qualified ARM resource id of the witness storage account.

clusterBootstrapAccount String

Account name used for creating cluster (at minimum needs permissions to 'Create Computer Objects' in domain).

clusterOperatorAccount String

Account name used for operating cluster i.e. will be part of administrators group on all the participating virtual machines in the cluster.

domainFqdn String

Fully qualified name of the domain.

fileShareWitnessPath String

Optional path for fileshare witness.

ouPath String

Organizational Unit path in which the nodes and cluster will be present.

sqlServiceAccount String

Account name under which SQL service will run on all participating SQL virtual machines in the cluster.

storageAccountPrimaryKey String

Primary key of the witness storage account.

storageAccountUrl String

Fully qualified ARM resource id of the witness storage account.

clusterBootstrapAccount string

Account name used for creating cluster (at minimum needs permissions to 'Create Computer Objects' in domain).

clusterOperatorAccount string

Account name used for operating cluster i.e. will be part of administrators group on all the participating virtual machines in the cluster.

domainFqdn string

Fully qualified name of the domain.

fileShareWitnessPath string

Optional path for fileshare witness.

ouPath string

Organizational Unit path in which the nodes and cluster will be present.

sqlServiceAccount string

Account name under which SQL service will run on all participating SQL virtual machines in the cluster.

storageAccountPrimaryKey string

Primary key of the witness storage account.

storageAccountUrl string

Fully qualified ARM resource id of the witness storage account.

cluster_bootstrap_account str

Account name used for creating cluster (at minimum needs permissions to 'Create Computer Objects' in domain).

cluster_operator_account str

Account name used for operating cluster i.e. will be part of administrators group on all the participating virtual machines in the cluster.

domain_fqdn str

Fully qualified name of the domain.

file_share_witness_path str

Optional path for fileshare witness.

ou_path str

Organizational Unit path in which the nodes and cluster will be present.

sql_service_account str

Account name under which SQL service will run on all participating SQL virtual machines in the cluster.

storage_account_primary_key str

Primary key of the witness storage account.

storage_account_url str

Fully qualified ARM resource id of the witness storage account.

clusterBootstrapAccount String

Account name used for creating cluster (at minimum needs permissions to 'Create Computer Objects' in domain).

clusterOperatorAccount String

Account name used for operating cluster i.e. will be part of administrators group on all the participating virtual machines in the cluster.

domainFqdn String

Fully qualified name of the domain.

fileShareWitnessPath String

Optional path for fileshare witness.

ouPath String

Organizational Unit path in which the nodes and cluster will be present.

sqlServiceAccount String

Account name under which SQL service will run on all participating SQL virtual machines in the cluster.

storageAccountPrimaryKey String

Primary key of the witness storage account.

storageAccountUrl String

Fully qualified ARM resource id of the witness storage account.

WsfcDomainProfileResponse

ClusterBootstrapAccount string

Account name used for creating cluster (at minimum needs permissions to 'Create Computer Objects' in domain).

ClusterOperatorAccount string

Account name used for operating cluster i.e. will be part of administrators group on all the participating virtual machines in the cluster.

DomainFqdn string

Fully qualified name of the domain.

FileShareWitnessPath string

Optional path for fileshare witness.

OuPath string

Organizational Unit path in which the nodes and cluster will be present.

SqlServiceAccount string

Account name under which SQL service will run on all participating SQL virtual machines in the cluster.

StorageAccountUrl string

Fully qualified ARM resource id of the witness storage account.

ClusterBootstrapAccount string

Account name used for creating cluster (at minimum needs permissions to 'Create Computer Objects' in domain).

ClusterOperatorAccount string

Account name used for operating cluster i.e. will be part of administrators group on all the participating virtual machines in the cluster.

DomainFqdn string

Fully qualified name of the domain.

FileShareWitnessPath string

Optional path for fileshare witness.

OuPath string

Organizational Unit path in which the nodes and cluster will be present.

SqlServiceAccount string

Account name under which SQL service will run on all participating SQL virtual machines in the cluster.

StorageAccountUrl string

Fully qualified ARM resource id of the witness storage account.

clusterBootstrapAccount String

Account name used for creating cluster (at minimum needs permissions to 'Create Computer Objects' in domain).

clusterOperatorAccount String

Account name used for operating cluster i.e. will be part of administrators group on all the participating virtual machines in the cluster.

domainFqdn String

Fully qualified name of the domain.

fileShareWitnessPath String

Optional path for fileshare witness.

ouPath String

Organizational Unit path in which the nodes and cluster will be present.

sqlServiceAccount String

Account name under which SQL service will run on all participating SQL virtual machines in the cluster.

storageAccountUrl String

Fully qualified ARM resource id of the witness storage account.

clusterBootstrapAccount string

Account name used for creating cluster (at minimum needs permissions to 'Create Computer Objects' in domain).

clusterOperatorAccount string

Account name used for operating cluster i.e. will be part of administrators group on all the participating virtual machines in the cluster.

domainFqdn string

Fully qualified name of the domain.

fileShareWitnessPath string

Optional path for fileshare witness.

ouPath string

Organizational Unit path in which the nodes and cluster will be present.

sqlServiceAccount string

Account name under which SQL service will run on all participating SQL virtual machines in the cluster.

storageAccountUrl string

Fully qualified ARM resource id of the witness storage account.

cluster_bootstrap_account str

Account name used for creating cluster (at minimum needs permissions to 'Create Computer Objects' in domain).

cluster_operator_account str

Account name used for operating cluster i.e. will be part of administrators group on all the participating virtual machines in the cluster.

domain_fqdn str

Fully qualified name of the domain.

file_share_witness_path str

Optional path for fileshare witness.

ou_path str

Organizational Unit path in which the nodes and cluster will be present.

sql_service_account str

Account name under which SQL service will run on all participating SQL virtual machines in the cluster.

storage_account_url str

Fully qualified ARM resource id of the witness storage account.

clusterBootstrapAccount String

Account name used for creating cluster (at minimum needs permissions to 'Create Computer Objects' in domain).

clusterOperatorAccount String

Account name used for operating cluster i.e. will be part of administrators group on all the participating virtual machines in the cluster.

domainFqdn String

Fully qualified name of the domain.

fileShareWitnessPath String

Optional path for fileshare witness.

ouPath String

Organizational Unit path in which the nodes and cluster will be present.

sqlServiceAccount String

Account name under which SQL service will run on all participating SQL virtual machines in the cluster.

storageAccountUrl String

Fully qualified ARM resource id of the witness storage account.

Import

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

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

Package Details

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