azure-native.azurearcdata.SqlServerInstance
Explore with Pulumi AI
A SqlServerInstance. Azure REST API version: 2023-01-15-preview. Prior API version in Azure Native 1.x: 2021-06-01-preview.
Other available API versions: 2024-01-01, 2024-05-01-preview.
Example Usage
Updates a SQL Server Instance tags.
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using AzureNative = Pulumi.AzureNative;
return await Deployment.RunAsync(() => 
{
    var sqlServerInstance = new AzureNative.AzureArcData.SqlServerInstance("sqlServerInstance", new()
    {
        Location = "northeurope",
        Properties = new AzureNative.AzureArcData.Inputs.SqlServerInstancePropertiesArgs
        {
            AzureDefenderStatus = AzureNative.AzureArcData.DefenderStatus.Protected,
            AzureDefenderStatusLastUpdated = "2020-01-02T17:18:19.1234567Z",
            Collation = "collation",
            ContainerResourceId = "Resource id of hosting Arc Machine",
            Cores = "4",
            CurrentVersion = "2012",
            Edition = AzureNative.AzureArcData.EditionType.Developer,
            HostType = AzureNative.AzureArcData.HostType.Physical_Server,
            InstanceName = "name of instance",
            LicenseType = AzureNative.AzureArcData.ArcSqlServerLicenseType.Free,
            PatchLevel = "patchlevel",
            ProductId = "sql id",
            Status = AzureNative.AzureArcData.ConnectionStatus.Registered,
            TcpDynamicPorts = "1433",
            TcpStaticPorts = "1433",
            VCore = "4",
            Version = AzureNative.AzureArcData.SqlVersion.SQL_Server_2012,
        },
        ResourceGroupName = "testrg",
        SqlServerInstanceName = "testsqlServerInstance",
        Tags = 
        {
            { "mytag", "myval" },
        },
    });
});
package main
import (
	azurearcdata "github.com/pulumi/pulumi-azure-native-sdk/azurearcdata/v2"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := azurearcdata.NewSqlServerInstance(ctx, "sqlServerInstance", &azurearcdata.SqlServerInstanceArgs{
			Location: pulumi.String("northeurope"),
			Properties: &azurearcdata.SqlServerInstancePropertiesArgs{
				AzureDefenderStatus:            pulumi.String(azurearcdata.DefenderStatusProtected),
				AzureDefenderStatusLastUpdated: pulumi.String("2020-01-02T17:18:19.1234567Z"),
				Collation:                      pulumi.String("collation"),
				ContainerResourceId:            pulumi.String("Resource id of hosting Arc Machine"),
				Cores:                          pulumi.String("4"),
				CurrentVersion:                 pulumi.String("2012"),
				Edition:                        pulumi.String(azurearcdata.EditionTypeDeveloper),
				HostType:                       pulumi.String(azurearcdata.HostType_Physical_Server),
				InstanceName:                   pulumi.String("name of instance"),
				LicenseType:                    pulumi.String(azurearcdata.ArcSqlServerLicenseTypeFree),
				PatchLevel:                     pulumi.String("patchlevel"),
				ProductId:                      pulumi.String("sql id"),
				Status:                         pulumi.String(azurearcdata.ConnectionStatusRegistered),
				TcpDynamicPorts:                pulumi.String("1433"),
				TcpStaticPorts:                 pulumi.String("1433"),
				VCore:                          pulumi.String("4"),
				Version:                        pulumi.String(azurearcdata.SqlVersion_SQL_Server_2012),
			},
			ResourceGroupName:     pulumi.String("testrg"),
			SqlServerInstanceName: pulumi.String("testsqlServerInstance"),
			Tags: pulumi.StringMap{
				"mytag": pulumi.String("myval"),
			},
		})
		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.azurearcdata.SqlServerInstance;
import com.pulumi.azurenative.azurearcdata.SqlServerInstanceArgs;
import com.pulumi.azurenative.azurearcdata.inputs.SqlServerInstancePropertiesArgs;
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 sqlServerInstance = new SqlServerInstance("sqlServerInstance", SqlServerInstanceArgs.builder()
            .location("northeurope")
            .properties(SqlServerInstancePropertiesArgs.builder()
                .azureDefenderStatus("Protected")
                .azureDefenderStatusLastUpdated("2020-01-02T17:18:19.1234567Z")
                .collation("collation")
                .containerResourceId("Resource id of hosting Arc Machine")
                .cores("4")
                .currentVersion("2012")
                .edition("Developer")
                .hostType("Physical Server")
                .instanceName("name of instance")
                .licenseType("Free")
                .patchLevel("patchlevel")
                .productId("sql id")
                .status("Registered")
                .tcpDynamicPorts("1433")
                .tcpStaticPorts("1433")
                .vCore("4")
                .version("SQL Server 2012")
                .build())
            .resourceGroupName("testrg")
            .sqlServerInstanceName("testsqlServerInstance")
            .tags(Map.of("mytag", "myval"))
            .build());
    }
}
import * as pulumi from "@pulumi/pulumi";
import * as azure_native from "@pulumi/azure-native";
const sqlServerInstance = new azure_native.azurearcdata.SqlServerInstance("sqlServerInstance", {
    location: "northeurope",
    properties: {
        azureDefenderStatus: azure_native.azurearcdata.DefenderStatus.Protected,
        azureDefenderStatusLastUpdated: "2020-01-02T17:18:19.1234567Z",
        collation: "collation",
        containerResourceId: "Resource id of hosting Arc Machine",
        cores: "4",
        currentVersion: "2012",
        edition: azure_native.azurearcdata.EditionType.Developer,
        hostType: azure_native.azurearcdata.HostType.Physical_Server,
        instanceName: "name of instance",
        licenseType: azure_native.azurearcdata.ArcSqlServerLicenseType.Free,
        patchLevel: "patchlevel",
        productId: "sql id",
        status: azure_native.azurearcdata.ConnectionStatus.Registered,
        tcpDynamicPorts: "1433",
        tcpStaticPorts: "1433",
        vCore: "4",
        version: azure_native.azurearcdata.SqlVersion.SQL_Server_2012,
    },
    resourceGroupName: "testrg",
    sqlServerInstanceName: "testsqlServerInstance",
    tags: {
        mytag: "myval",
    },
});
import pulumi
import pulumi_azure_native as azure_native
sql_server_instance = azure_native.azurearcdata.SqlServerInstance("sqlServerInstance",
    location="northeurope",
    properties={
        "azure_defender_status": azure_native.azurearcdata.DefenderStatus.PROTECTED,
        "azure_defender_status_last_updated": "2020-01-02T17:18:19.1234567Z",
        "collation": "collation",
        "container_resource_id": "Resource id of hosting Arc Machine",
        "cores": "4",
        "current_version": "2012",
        "edition": azure_native.azurearcdata.EditionType.DEVELOPER,
        "host_type": azure_native.azurearcdata.HostType.PHYSICAL_SERVER,
        "instance_name": "name of instance",
        "license_type": azure_native.azurearcdata.ArcSqlServerLicenseType.FREE,
        "patch_level": "patchlevel",
        "product_id": "sql id",
        "status": azure_native.azurearcdata.ConnectionStatus.REGISTERED,
        "tcp_dynamic_ports": "1433",
        "tcp_static_ports": "1433",
        "v_core": "4",
        "version": azure_native.azurearcdata.SqlVersion.SQ_L_SERVER_2012,
    },
    resource_group_name="testrg",
    sql_server_instance_name="testsqlServerInstance",
    tags={
        "mytag": "myval",
    })
resources:
  sqlServerInstance:
    type: azure-native:azurearcdata:SqlServerInstance
    properties:
      location: northeurope
      properties:
        azureDefenderStatus: Protected
        azureDefenderStatusLastUpdated: 2020-01-02T17:18:19.1234567Z
        collation: collation
        containerResourceId: Resource id of hosting Arc Machine
        cores: '4'
        currentVersion: '2012'
        edition: Developer
        hostType: Physical Server
        instanceName: name of instance
        licenseType: Free
        patchLevel: patchlevel
        productId: sql id
        status: Registered
        tcpDynamicPorts: '1433'
        tcpStaticPorts: '1433'
        vCore: '4'
        version: SQL Server 2012
      resourceGroupName: testrg
      sqlServerInstanceName: testsqlServerInstance
      tags:
        mytag: myval
Create SqlServerInstance Resource
Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.
Constructor syntax
new SqlServerInstance(name: string, args: SqlServerInstanceArgs, opts?: CustomResourceOptions);@overload
def SqlServerInstance(resource_name: str,
                      args: SqlServerInstanceArgs,
                      opts: Optional[ResourceOptions] = None)
@overload
def SqlServerInstance(resource_name: str,
                      opts: Optional[ResourceOptions] = None,
                      resource_group_name: Optional[str] = None,
                      location: Optional[str] = None,
                      properties: Optional[SqlServerInstancePropertiesArgs] = None,
                      sql_server_instance_name: Optional[str] = None,
                      tags: Optional[Mapping[str, str]] = None)func NewSqlServerInstance(ctx *Context, name string, args SqlServerInstanceArgs, opts ...ResourceOption) (*SqlServerInstance, error)public SqlServerInstance(string name, SqlServerInstanceArgs args, CustomResourceOptions? opts = null)
public SqlServerInstance(String name, SqlServerInstanceArgs args)
public SqlServerInstance(String name, SqlServerInstanceArgs args, CustomResourceOptions options)
type: azure-native:azurearcdata:SqlServerInstance
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.
Parameters
- name string
- The unique name of the resource.
- args SqlServerInstanceArgs
- 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 SqlServerInstanceArgs
- 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 SqlServerInstanceArgs
- The arguments to resource properties.
- opts ResourceOption
- Bag of options to control resource's behavior.
- name string
- The unique name of the resource.
- args SqlServerInstanceArgs
- The arguments to resource properties.
- opts CustomResourceOptions
- Bag of options to control resource's behavior.
- name String
- The unique name of the resource.
- args SqlServerInstanceArgs
- The arguments to resource properties.
- options CustomResourceOptions
- Bag of options to control resource's behavior.
Constructor example
The following reference example uses placeholder values for all input properties.
var sqlServerInstanceResource = new AzureNative.AzureArcData.SqlServerInstance("sqlServerInstanceResource", new()
{
    ResourceGroupName = "string",
    Location = "string",
    Properties = new AzureNative.AzureArcData.Inputs.SqlServerInstancePropertiesArgs
    {
        ContainerResourceId = "string",
        Status = "string",
        Cores = "string",
        LicenseType = "string",
        AzureDefenderStatus = "string",
        CurrentVersion = "string",
        Edition = "string",
        HostType = "string",
        InstanceName = "string",
        Collation = "string",
        PatchLevel = "string",
        ProductId = "string",
        AzureDefenderStatusLastUpdated = "string",
        TcpDynamicPorts = "string",
        TcpStaticPorts = "string",
        VCore = "string",
        Version = "string",
    },
    SqlServerInstanceName = "string",
    Tags = 
    {
        { "string", "string" },
    },
});
example, err := azurearcdata.NewSqlServerInstance(ctx, "sqlServerInstanceResource", &azurearcdata.SqlServerInstanceArgs{
	ResourceGroupName: pulumi.String("string"),
	Location:          pulumi.String("string"),
	Properties: &azurearcdata.SqlServerInstancePropertiesArgs{
		ContainerResourceId:            pulumi.String("string"),
		Status:                         pulumi.String("string"),
		Cores:                          pulumi.String("string"),
		LicenseType:                    pulumi.String("string"),
		AzureDefenderStatus:            pulumi.String("string"),
		CurrentVersion:                 pulumi.String("string"),
		Edition:                        pulumi.String("string"),
		HostType:                       pulumi.String("string"),
		InstanceName:                   pulumi.String("string"),
		Collation:                      pulumi.String("string"),
		PatchLevel:                     pulumi.String("string"),
		ProductId:                      pulumi.String("string"),
		AzureDefenderStatusLastUpdated: pulumi.String("string"),
		TcpDynamicPorts:                pulumi.String("string"),
		TcpStaticPorts:                 pulumi.String("string"),
		VCore:                          pulumi.String("string"),
		Version:                        pulumi.String("string"),
	},
	SqlServerInstanceName: pulumi.String("string"),
	Tags: pulumi.StringMap{
		"string": pulumi.String("string"),
	},
})
var sqlServerInstanceResource = new SqlServerInstance("sqlServerInstanceResource", SqlServerInstanceArgs.builder()
    .resourceGroupName("string")
    .location("string")
    .properties(SqlServerInstancePropertiesArgs.builder()
        .containerResourceId("string")
        .status("string")
        .cores("string")
        .licenseType("string")
        .azureDefenderStatus("string")
        .currentVersion("string")
        .edition("string")
        .hostType("string")
        .instanceName("string")
        .collation("string")
        .patchLevel("string")
        .productId("string")
        .azureDefenderStatusLastUpdated("string")
        .tcpDynamicPorts("string")
        .tcpStaticPorts("string")
        .vCore("string")
        .version("string")
        .build())
    .sqlServerInstanceName("string")
    .tags(Map.of("string", "string"))
    .build());
sql_server_instance_resource = azure_native.azurearcdata.SqlServerInstance("sqlServerInstanceResource",
    resource_group_name="string",
    location="string",
    properties={
        "container_resource_id": "string",
        "status": "string",
        "cores": "string",
        "license_type": "string",
        "azure_defender_status": "string",
        "current_version": "string",
        "edition": "string",
        "host_type": "string",
        "instance_name": "string",
        "collation": "string",
        "patch_level": "string",
        "product_id": "string",
        "azure_defender_status_last_updated": "string",
        "tcp_dynamic_ports": "string",
        "tcp_static_ports": "string",
        "v_core": "string",
        "version": "string",
    },
    sql_server_instance_name="string",
    tags={
        "string": "string",
    })
const sqlServerInstanceResource = new azure_native.azurearcdata.SqlServerInstance("sqlServerInstanceResource", {
    resourceGroupName: "string",
    location: "string",
    properties: {
        containerResourceId: "string",
        status: "string",
        cores: "string",
        licenseType: "string",
        azureDefenderStatus: "string",
        currentVersion: "string",
        edition: "string",
        hostType: "string",
        instanceName: "string",
        collation: "string",
        patchLevel: "string",
        productId: "string",
        azureDefenderStatusLastUpdated: "string",
        tcpDynamicPorts: "string",
        tcpStaticPorts: "string",
        vCore: "string",
        version: "string",
    },
    sqlServerInstanceName: "string",
    tags: {
        string: "string",
    },
});
type: azure-native:azurearcdata:SqlServerInstance
properties:
    location: string
    properties:
        azureDefenderStatus: string
        azureDefenderStatusLastUpdated: string
        collation: string
        containerResourceId: string
        cores: string
        currentVersion: string
        edition: string
        hostType: string
        instanceName: string
        licenseType: string
        patchLevel: string
        productId: string
        status: string
        tcpDynamicPorts: string
        tcpStaticPorts: string
        vCore: string
        version: string
    resourceGroupName: string
    sqlServerInstanceName: string
    tags:
        string: string
SqlServerInstance Resource Properties
To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.
Inputs
In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.
The SqlServerInstance resource accepts the following input properties:
- ResourceGroup stringName 
- The name of the Azure resource group
- Location string
- The geo-location where the resource lives
- Properties
Pulumi.Azure Native. Azure Arc Data. Inputs. Sql Server Instance Properties 
- null
- SqlServer stringInstance Name 
- Name of SQL Server Instance
- Dictionary<string, string>
- Resource tags.
- ResourceGroup stringName 
- The name of the Azure resource group
- Location string
- The geo-location where the resource lives
- Properties
SqlServer Instance Properties Args 
- null
- SqlServer stringInstance Name 
- Name of SQL Server Instance
- map[string]string
- Resource tags.
- resourceGroup StringName 
- The name of the Azure resource group
- location String
- The geo-location where the resource lives
- properties
SqlServer Instance Properties 
- null
- sqlServer StringInstance Name 
- Name of SQL Server Instance
- Map<String,String>
- Resource tags.
- resourceGroup stringName 
- The name of the Azure resource group
- location string
- The geo-location where the resource lives
- properties
SqlServer Instance Properties 
- null
- sqlServer stringInstance Name 
- Name of SQL Server Instance
- {[key: string]: string}
- Resource tags.
- resource_group_ strname 
- The name of the Azure resource group
- location str
- The geo-location where the resource lives
- properties
SqlServer Instance Properties Args 
- null
- sql_server_ strinstance_ name 
- Name of SQL Server Instance
- Mapping[str, str]
- Resource tags.
- resourceGroup StringName 
- The name of the Azure resource group
- location String
- The geo-location where the resource lives
- properties Property Map
- null
- sqlServer StringInstance Name 
- Name of SQL Server Instance
- Map<String>
- Resource tags.
Outputs
All input properties are implicitly available as output properties. Additionally, the SqlServerInstance resource produces the following output properties:
- Id string
- The provider-assigned unique ID for this managed resource.
- Name string
- The name of the resource
- SystemData Pulumi.Azure Native. Azure Arc Data. Outputs. System Data Response 
- Azure Resource Manager metadata containing createdBy and modifiedBy information.
- Type string
- The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"
- Id string
- The provider-assigned unique ID for this managed resource.
- Name string
- The name of the resource
- SystemData SystemData Response 
- Azure Resource Manager metadata containing createdBy and modifiedBy information.
- Type string
- The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"
- id String
- The provider-assigned unique ID for this managed resource.
- name String
- The name of the resource
- systemData SystemData Response 
- Azure Resource Manager metadata containing createdBy and modifiedBy information.
- type String
- The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"
- id string
- The provider-assigned unique ID for this managed resource.
- name string
- The name of the resource
- systemData SystemData Response 
- Azure Resource Manager metadata containing createdBy and modifiedBy information.
- type string
- The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"
- id str
- The provider-assigned unique ID for this managed resource.
- name str
- The name of the resource
- system_data SystemData Response 
- Azure Resource Manager metadata containing createdBy and modifiedBy information.
- type str
- The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"
- id String
- The provider-assigned unique ID for this managed resource.
- name String
- The name of the resource
- systemData Property Map
- Azure Resource Manager metadata containing createdBy and modifiedBy information.
- type String
- The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"
Supporting Types
ArcSqlServerLicenseType, ArcSqlServerLicenseTypeArgs          
- Undefined
- Undefined
- Free
- Free
- HADR
- HADR
- ServerCAL 
- ServerCAL
- LicenseOnly 
- LicenseOnly
- PAYG
- PAYG
- Paid
- Paid
- ArcSql Server License Type Undefined 
- Undefined
- ArcSql Server License Type Free 
- Free
- ArcSql Server License Type HADR 
- HADR
- ArcSql Server License Type Server CAL 
- ServerCAL
- ArcSql Server License Type License Only 
- LicenseOnly
- ArcSql Server License Type PAYG 
- PAYG
- ArcSql Server License Type Paid 
- Paid
- Undefined
- Undefined
- Free
- Free
- HADR
- HADR
- ServerCAL 
- ServerCAL
- LicenseOnly 
- LicenseOnly
- PAYG
- PAYG
- Paid
- Paid
- Undefined
- Undefined
- Free
- Free
- HADR
- HADR
- ServerCAL 
- ServerCAL
- LicenseOnly 
- LicenseOnly
- PAYG
- PAYG
- Paid
- Paid
- UNDEFINED
- Undefined
- FREE
- Free
- HADR
- HADR
- SERVER_CAL
- ServerCAL
- LICENSE_ONLY
- LicenseOnly
- PAYG
- PAYG
- PAID
- Paid
- "Undefined"
- Undefined
- "Free"
- Free
- "HADR"
- HADR
- "ServerCAL" 
- ServerCAL
- "LicenseOnly" 
- LicenseOnly
- "PAYG"
- PAYG
- "Paid"
- Paid
ConnectionStatus, ConnectionStatusArgs    
- Connected
- Connected
- Disconnected
- Disconnected
- Registered
- Registered
- Unknown
- Unknown
- ConnectionStatus Connected 
- Connected
- ConnectionStatus Disconnected 
- Disconnected
- ConnectionStatus Registered 
- Registered
- ConnectionStatus Unknown 
- Unknown
- Connected
- Connected
- Disconnected
- Disconnected
- Registered
- Registered
- Unknown
- Unknown
- Connected
- Connected
- Disconnected
- Disconnected
- Registered
- Registered
- Unknown
- Unknown
- CONNECTED
- Connected
- DISCONNECTED
- Disconnected
- REGISTERED
- Registered
- UNKNOWN
- Unknown
- "Connected"
- Connected
- "Disconnected"
- Disconnected
- "Registered"
- Registered
- "Unknown"
- Unknown
DefenderStatus, DefenderStatusArgs    
- Protected
- Protected
- Unprotected
- Unprotected
- Unknown
- Unknown
- DefenderStatus Protected 
- Protected
- DefenderStatus Unprotected 
- Unprotected
- DefenderStatus Unknown 
- Unknown
- Protected
- Protected
- Unprotected
- Unprotected
- Unknown
- Unknown
- Protected
- Protected
- Unprotected
- Unprotected
- Unknown
- Unknown
- PROTECTED
- Protected
- UNPROTECTED
- Unprotected
- UNKNOWN
- Unknown
- "Protected"
- Protected
- "Unprotected"
- Unprotected
- "Unknown"
- Unknown
EditionType, EditionTypeArgs    
- Evaluation
- Evaluation
- Enterprise
- Enterprise
- Standard
- Standard
- Web
- Web
- Developer
- Developer
- Express
- Express
- Business_Intelligence
- Business Intelligence
- EditionType Evaluation 
- Evaluation
- EditionType Enterprise 
- Enterprise
- EditionType Standard 
- Standard
- EditionType Web 
- Web
- EditionType Developer 
- Developer
- EditionType Express 
- Express
- EditionType_Business_Intelligence 
- Business Intelligence
- Evaluation
- Evaluation
- Enterprise
- Enterprise
- Standard
- Standard
- Web
- Web
- Developer
- Developer
- Express
- Express
- Business_Intelligence
- Business Intelligence
- Evaluation
- Evaluation
- Enterprise
- Enterprise
- Standard
- Standard
- Web
- Web
- Developer
- Developer
- Express
- Express
- Business_Intelligence
- Business Intelligence
- EVALUATION
- Evaluation
- ENTERPRISE
- Enterprise
- STANDARD
- Standard
- WEB
- Web
- DEVELOPER
- Developer
- EXPRESS
- Express
- BUSINESS_INTELLIGENCE
- Business Intelligence
- "Evaluation"
- Evaluation
- "Enterprise"
- Enterprise
- "Standard"
- Standard
- "Web"
- Web
- "Developer"
- Developer
- "Express"
- Express
- "Business Intelligence"
- Business Intelligence
HostType, HostTypeArgs    
- Azure_Virtual_Machine
- Azure Virtual Machine
- Azure_VMWare_Virtual_Machine
- Azure VMWare Virtual Machine
- Azure_Kubernetes_Service
- Azure Kubernetes Service
- AWS_VMWare_Virtual_Machine
- AWS VMWare Virtual Machine
- AWS_Kubernetes_Service
- AWS Kubernetes Service
- GCP_VMWare_Virtual_Machine
- GCP VMWare Virtual Machine
- GCP_Kubernetes_Service
- GCP Kubernetes Service
- Container
- Container
- Virtual_Machine
- Virtual Machine
- Physical_Server
- Physical Server
- AWS_Virtual_Machine
- AWS Virtual Machine
- GCP_Virtual_Machine
- GCP Virtual Machine
- Other
- Other
- HostType_Azure_Virtual_Machine 
- Azure Virtual Machine
- HostType_Azure_VMWare_Virtual_Machine 
- Azure VMWare Virtual Machine
- HostType_Azure_Kubernetes_Service 
- Azure Kubernetes Service
- HostType_AWS_VMWare_Virtual_Machine 
- AWS VMWare Virtual Machine
- HostType_AWS_Kubernetes_Service 
- AWS Kubernetes Service
- HostType_GCP_VMWare_Virtual_Machine 
- GCP VMWare Virtual Machine
- HostType_GCP_Kubernetes_Service 
- GCP Kubernetes Service
- HostType Container 
- Container
- HostType_Virtual_Machine 
- Virtual Machine
- HostType_Physical_Server 
- Physical Server
- HostType_AWS_Virtual_Machine 
- AWS Virtual Machine
- HostType_GCP_Virtual_Machine 
- GCP Virtual Machine
- HostType Other 
- Other
- Azure_Virtual_Machine
- Azure Virtual Machine
- Azure_VMWare_Virtual_Machine
- Azure VMWare Virtual Machine
- Azure_Kubernetes_Service
- Azure Kubernetes Service
- AWS_VMWare_Virtual_Machine
- AWS VMWare Virtual Machine
- AWS_Kubernetes_Service
- AWS Kubernetes Service
- GCP_VMWare_Virtual_Machine
- GCP VMWare Virtual Machine
- GCP_Kubernetes_Service
- GCP Kubernetes Service
- Container
- Container
- Virtual_Machine
- Virtual Machine
- Physical_Server
- Physical Server
- AWS_Virtual_Machine
- AWS Virtual Machine
- GCP_Virtual_Machine
- GCP Virtual Machine
- Other
- Other
- Azure_Virtual_Machine
- Azure Virtual Machine
- Azure_VMWare_Virtual_Machine
- Azure VMWare Virtual Machine
- Azure_Kubernetes_Service
- Azure Kubernetes Service
- AWS_VMWare_Virtual_Machine
- AWS VMWare Virtual Machine
- AWS_Kubernetes_Service
- AWS Kubernetes Service
- GCP_VMWare_Virtual_Machine
- GCP VMWare Virtual Machine
- GCP_Kubernetes_Service
- GCP Kubernetes Service
- Container
- Container
- Virtual_Machine
- Virtual Machine
- Physical_Server
- Physical Server
- AWS_Virtual_Machine
- AWS Virtual Machine
- GCP_Virtual_Machine
- GCP Virtual Machine
- Other
- Other
- AZURE_VIRTUAL_MACHINE
- Azure Virtual Machine
- AZURE_VM_WARE_VIRTUAL_MACHINE
- Azure VMWare Virtual Machine
- AZURE_KUBERNETES_SERVICE
- Azure Kubernetes Service
- AW_S_VM_WARE_VIRTUAL_MACHINE
- AWS VMWare Virtual Machine
- AW_S_KUBERNETES_SERVICE
- AWS Kubernetes Service
- GC_P_VM_WARE_VIRTUAL_MACHINE
- GCP VMWare Virtual Machine
- GC_P_KUBERNETES_SERVICE
- GCP Kubernetes Service
- CONTAINER
- Container
- VIRTUAL_MACHINE
- Virtual Machine
- PHYSICAL_SERVER
- Physical Server
- AW_S_VIRTUAL_MACHINE
- AWS Virtual Machine
- GC_P_VIRTUAL_MACHINE
- GCP Virtual Machine
- OTHER
- Other
- "Azure Virtual Machine"
- Azure Virtual Machine
- "Azure VMWare Virtual Machine"
- Azure VMWare Virtual Machine
- "Azure Kubernetes Service"
- Azure Kubernetes Service
- "AWS VMWare Virtual Machine"
- AWS VMWare Virtual Machine
- "AWS Kubernetes Service"
- AWS Kubernetes Service
- "GCP VMWare Virtual Machine"
- GCP VMWare Virtual Machine
- "GCP Kubernetes Service"
- GCP Kubernetes Service
- "Container"
- Container
- "Virtual Machine"
- Virtual Machine
- "Physical Server"
- Physical Server
- "AWS Virtual Machine"
- AWS Virtual Machine
- "GCP Virtual Machine"
- GCP Virtual Machine
- "Other"
- Other
SqlServerInstanceProperties, SqlServerInstancePropertiesArgs        
- ContainerResource stringId 
- ARM Resource id of the container resource (Azure Arc for Servers).
- Status
string | Pulumi.Azure Native. Azure Arc Data. Connection Status 
- The cloud connectivity status.
- AzureDefender string | Pulumi.Status Azure Native. Azure Arc Data. Defender Status 
- Status of Azure Defender.
- AzureDefender stringStatus Last Updated 
- Timestamp of last Azure Defender status update.
- Collation string
- SQL Server collation.
- Cores string
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- CurrentVersion string
- SQL Server current version.
- Edition
string | Pulumi.Azure Native. Azure Arc Data. Edition Type 
- SQL Server edition.
- HostType string | Pulumi.Azure Native. Azure Arc Data. Host Type 
- Type of host for Azure Arc SQL Server
- InstanceName string
- SQL Server instance name.
- LicenseType string | Pulumi.Azure Native. Azure Arc Data. Arc Sql Server License Type 
- SQL Server license type.
- PatchLevel string
- SQL Server update level.
- ProductId string
- SQL Server product ID.
- TcpDynamic stringPorts 
- Dynamic TCP ports used by SQL Server.
- TcpStatic stringPorts 
- Static TCP ports used by SQL Server.
- VCore string
- The number of logical processors used by the SQL Server instance.
- Version
string | Pulumi.Azure Native. Azure Arc Data. Sql Version 
- SQL Server version.
- ContainerResource stringId 
- ARM Resource id of the container resource (Azure Arc for Servers).
- Status
string | ConnectionStatus 
- The cloud connectivity status.
- AzureDefender string | DefenderStatus Status 
- Status of Azure Defender.
- AzureDefender stringStatus Last Updated 
- Timestamp of last Azure Defender status update.
- Collation string
- SQL Server collation.
- Cores string
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- CurrentVersion string
- SQL Server current version.
- Edition
string | EditionType 
- SQL Server edition.
- HostType string | HostType 
- Type of host for Azure Arc SQL Server
- InstanceName string
- SQL Server instance name.
- LicenseType string | ArcSql Server License Type 
- SQL Server license type.
- PatchLevel string
- SQL Server update level.
- ProductId string
- SQL Server product ID.
- TcpDynamic stringPorts 
- Dynamic TCP ports used by SQL Server.
- TcpStatic stringPorts 
- Static TCP ports used by SQL Server.
- VCore string
- The number of logical processors used by the SQL Server instance.
- Version
string | SqlVersion 
- SQL Server version.
- containerResource StringId 
- ARM Resource id of the container resource (Azure Arc for Servers).
- status
String | ConnectionStatus 
- The cloud connectivity status.
- azureDefender String | DefenderStatus Status 
- Status of Azure Defender.
- azureDefender StringStatus Last Updated 
- Timestamp of last Azure Defender status update.
- collation String
- SQL Server collation.
- cores String
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- currentVersion String
- SQL Server current version.
- edition
String | EditionType 
- SQL Server edition.
- hostType String | HostType 
- Type of host for Azure Arc SQL Server
- instanceName String
- SQL Server instance name.
- licenseType String | ArcSql Server License Type 
- SQL Server license type.
- patchLevel String
- SQL Server update level.
- productId String
- SQL Server product ID.
- tcpDynamic StringPorts 
- Dynamic TCP ports used by SQL Server.
- tcpStatic StringPorts 
- Static TCP ports used by SQL Server.
- vCore String
- The number of logical processors used by the SQL Server instance.
- version
String | SqlVersion 
- SQL Server version.
- containerResource stringId 
- ARM Resource id of the container resource (Azure Arc for Servers).
- status
string | ConnectionStatus 
- The cloud connectivity status.
- azureDefender string | DefenderStatus Status 
- Status of Azure Defender.
- azureDefender stringStatus Last Updated 
- Timestamp of last Azure Defender status update.
- collation string
- SQL Server collation.
- cores string
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- currentVersion string
- SQL Server current version.
- edition
string | EditionType 
- SQL Server edition.
- hostType string | HostType 
- Type of host for Azure Arc SQL Server
- instanceName string
- SQL Server instance name.
- licenseType string | ArcSql Server License Type 
- SQL Server license type.
- patchLevel string
- SQL Server update level.
- productId string
- SQL Server product ID.
- tcpDynamic stringPorts 
- Dynamic TCP ports used by SQL Server.
- tcpStatic stringPorts 
- Static TCP ports used by SQL Server.
- vCore string
- The number of logical processors used by the SQL Server instance.
- version
string | SqlVersion 
- SQL Server version.
- container_resource_ strid 
- ARM Resource id of the container resource (Azure Arc for Servers).
- status
str | ConnectionStatus 
- The cloud connectivity status.
- azure_defender_ str | Defenderstatus Status 
- Status of Azure Defender.
- azure_defender_ strstatus_ last_ updated 
- Timestamp of last Azure Defender status update.
- collation str
- SQL Server collation.
- cores str
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- current_version str
- SQL Server current version.
- edition
str | EditionType 
- SQL Server edition.
- host_type str | HostType 
- Type of host for Azure Arc SQL Server
- instance_name str
- SQL Server instance name.
- license_type str | ArcSql Server License Type 
- SQL Server license type.
- patch_level str
- SQL Server update level.
- product_id str
- SQL Server product ID.
- tcp_dynamic_ strports 
- Dynamic TCP ports used by SQL Server.
- tcp_static_ strports 
- Static TCP ports used by SQL Server.
- v_core str
- The number of logical processors used by the SQL Server instance.
- version
str | SqlVersion 
- SQL Server version.
- containerResource StringId 
- ARM Resource id of the container resource (Azure Arc for Servers).
- status String | "Connected" | "Disconnected" | "Registered" | "Unknown"
- The cloud connectivity status.
- azureDefender String | "Protected" | "Unprotected" | "Unknown"Status 
- Status of Azure Defender.
- azureDefender StringStatus Last Updated 
- Timestamp of last Azure Defender status update.
- collation String
- SQL Server collation.
- cores String
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- currentVersion String
- SQL Server current version.
- edition String | "Evaluation" | "Enterprise" | "Standard" | "Web" | "Developer" | "Express" | "Business Intelligence"
- SQL Server edition.
- hostType String | "Azure Virtual Machine" | "Azure VMWare Virtual Machine" | "Azure Kubernetes Service" | "AWS VMWare Virtual Machine" | "AWS Kubernetes Service" | "GCP VMWare Virtual Machine" | "GCP Kubernetes Service" | "Container" | "Virtual Machine" | "Physical Server" | "AWS Virtual Machine" | "GCP Virtual Machine" | "Other"
- Type of host for Azure Arc SQL Server
- instanceName String
- SQL Server instance name.
- licenseType String | "Undefined" | "Free" | "HADR" | "ServerCAL" | "License Only" | "PAYG" | "Paid" 
- SQL Server license type.
- patchLevel String
- SQL Server update level.
- productId String
- SQL Server product ID.
- tcpDynamic StringPorts 
- Dynamic TCP ports used by SQL Server.
- tcpStatic StringPorts 
- Static TCP ports used by SQL Server.
- vCore String
- The number of logical processors used by the SQL Server instance.
- version String | "SQL Server 2012" | "SQL Server 2014" | "SQL Server 2016" | "SQL Server 2017" | "SQL Server 2019" | "SQL Server 2022" | "Unknown"
- SQL Server version.
SqlServerInstancePropertiesResponse, SqlServerInstancePropertiesResponseArgs          
- ContainerResource stringId 
- ARM Resource id of the container resource (Azure Arc for Servers).
- CreateTime string
- The time when the resource was created.
- ProvisioningState string
- The provisioning state of the Arc-enabled SQL Server resource.
- Status string
- The cloud connectivity status.
- AzureDefender stringStatus 
- Status of Azure Defender.
- AzureDefender stringStatus Last Updated 
- Timestamp of last Azure Defender status update.
- Collation string
- SQL Server collation.
- Cores string
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- CurrentVersion string
- SQL Server current version.
- Edition string
- SQL Server edition.
- HostType string
- Type of host for Azure Arc SQL Server
- InstanceName string
- SQL Server instance name.
- LicenseType string
- SQL Server license type.
- PatchLevel string
- SQL Server update level.
- ProductId string
- SQL Server product ID.
- TcpDynamic stringPorts 
- Dynamic TCP ports used by SQL Server.
- TcpStatic stringPorts 
- Static TCP ports used by SQL Server.
- VCore string
- The number of logical processors used by the SQL Server instance.
- Version string
- SQL Server version.
- ContainerResource stringId 
- ARM Resource id of the container resource (Azure Arc for Servers).
- CreateTime string
- The time when the resource was created.
- ProvisioningState string
- The provisioning state of the Arc-enabled SQL Server resource.
- Status string
- The cloud connectivity status.
- AzureDefender stringStatus 
- Status of Azure Defender.
- AzureDefender stringStatus Last Updated 
- Timestamp of last Azure Defender status update.
- Collation string
- SQL Server collation.
- Cores string
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- CurrentVersion string
- SQL Server current version.
- Edition string
- SQL Server edition.
- HostType string
- Type of host for Azure Arc SQL Server
- InstanceName string
- SQL Server instance name.
- LicenseType string
- SQL Server license type.
- PatchLevel string
- SQL Server update level.
- ProductId string
- SQL Server product ID.
- TcpDynamic stringPorts 
- Dynamic TCP ports used by SQL Server.
- TcpStatic stringPorts 
- Static TCP ports used by SQL Server.
- VCore string
- The number of logical processors used by the SQL Server instance.
- Version string
- SQL Server version.
- containerResource StringId 
- ARM Resource id of the container resource (Azure Arc for Servers).
- createTime String
- The time when the resource was created.
- provisioningState String
- The provisioning state of the Arc-enabled SQL Server resource.
- status String
- The cloud connectivity status.
- azureDefender StringStatus 
- Status of Azure Defender.
- azureDefender StringStatus Last Updated 
- Timestamp of last Azure Defender status update.
- collation String
- SQL Server collation.
- cores String
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- currentVersion String
- SQL Server current version.
- edition String
- SQL Server edition.
- hostType String
- Type of host for Azure Arc SQL Server
- instanceName String
- SQL Server instance name.
- licenseType String
- SQL Server license type.
- patchLevel String
- SQL Server update level.
- productId String
- SQL Server product ID.
- tcpDynamic StringPorts 
- Dynamic TCP ports used by SQL Server.
- tcpStatic StringPorts 
- Static TCP ports used by SQL Server.
- vCore String
- The number of logical processors used by the SQL Server instance.
- version String
- SQL Server version.
- containerResource stringId 
- ARM Resource id of the container resource (Azure Arc for Servers).
- createTime string
- The time when the resource was created.
- provisioningState string
- The provisioning state of the Arc-enabled SQL Server resource.
- status string
- The cloud connectivity status.
- azureDefender stringStatus 
- Status of Azure Defender.
- azureDefender stringStatus Last Updated 
- Timestamp of last Azure Defender status update.
- collation string
- SQL Server collation.
- cores string
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- currentVersion string
- SQL Server current version.
- edition string
- SQL Server edition.
- hostType string
- Type of host for Azure Arc SQL Server
- instanceName string
- SQL Server instance name.
- licenseType string
- SQL Server license type.
- patchLevel string
- SQL Server update level.
- productId string
- SQL Server product ID.
- tcpDynamic stringPorts 
- Dynamic TCP ports used by SQL Server.
- tcpStatic stringPorts 
- Static TCP ports used by SQL Server.
- vCore string
- The number of logical processors used by the SQL Server instance.
- version string
- SQL Server version.
- container_resource_ strid 
- ARM Resource id of the container resource (Azure Arc for Servers).
- create_time str
- The time when the resource was created.
- provisioning_state str
- The provisioning state of the Arc-enabled SQL Server resource.
- status str
- The cloud connectivity status.
- azure_defender_ strstatus 
- Status of Azure Defender.
- azure_defender_ strstatus_ last_ updated 
- Timestamp of last Azure Defender status update.
- collation str
- SQL Server collation.
- cores str
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- current_version str
- SQL Server current version.
- edition str
- SQL Server edition.
- host_type str
- Type of host for Azure Arc SQL Server
- instance_name str
- SQL Server instance name.
- license_type str
- SQL Server license type.
- patch_level str
- SQL Server update level.
- product_id str
- SQL Server product ID.
- tcp_dynamic_ strports 
- Dynamic TCP ports used by SQL Server.
- tcp_static_ strports 
- Static TCP ports used by SQL Server.
- v_core str
- The number of logical processors used by the SQL Server instance.
- version str
- SQL Server version.
- containerResource StringId 
- ARM Resource id of the container resource (Azure Arc for Servers).
- createTime String
- The time when the resource was created.
- provisioningState String
- The provisioning state of the Arc-enabled SQL Server resource.
- status String
- The cloud connectivity status.
- azureDefender StringStatus 
- Status of Azure Defender.
- azureDefender StringStatus Last Updated 
- Timestamp of last Azure Defender status update.
- collation String
- SQL Server collation.
- cores String
- The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.
- currentVersion String
- SQL Server current version.
- edition String
- SQL Server edition.
- hostType String
- Type of host for Azure Arc SQL Server
- instanceName String
- SQL Server instance name.
- licenseType String
- SQL Server license type.
- patchLevel String
- SQL Server update level.
- productId String
- SQL Server product ID.
- tcpDynamic StringPorts 
- Dynamic TCP ports used by SQL Server.
- tcpStatic StringPorts 
- Static TCP ports used by SQL Server.
- vCore String
- The number of logical processors used by the SQL Server instance.
- version String
- SQL Server version.
SqlVersion, SqlVersionArgs    
- SQL_Server_2012
- SQL Server 2012
- SQL_Server_2014
- SQL Server 2014
- SQL_Server_2016
- SQL Server 2016
- SQL_Server_2017
- SQL Server 2017
- SQL_Server_2019
- SQL Server 2019
- SQL_Server_2022
- SQL Server 2022
- Unknown
- Unknown
- SqlVersion_SQL_Server_2012 
- SQL Server 2012
- SqlVersion_SQL_Server_2014 
- SQL Server 2014
- SqlVersion_SQL_Server_2016 
- SQL Server 2016
- SqlVersion_SQL_Server_2017 
- SQL Server 2017
- SqlVersion_SQL_Server_2019 
- SQL Server 2019
- SqlVersion_SQL_Server_2022 
- SQL Server 2022
- SqlVersion Unknown 
- Unknown
- SQL_Server_2012
- SQL Server 2012
- SQL_Server_2014
- SQL Server 2014
- SQL_Server_2016
- SQL Server 2016
- SQL_Server_2017
- SQL Server 2017
- SQL_Server_2019
- SQL Server 2019
- SQL_Server_2022
- SQL Server 2022
- Unknown
- Unknown
- SQL_Server_2012
- SQL Server 2012
- SQL_Server_2014
- SQL Server 2014
- SQL_Server_2016
- SQL Server 2016
- SQL_Server_2017
- SQL Server 2017
- SQL_Server_2019
- SQL Server 2019
- SQL_Server_2022
- SQL Server 2022
- Unknown
- Unknown
- SQ_L_SERVER_2012
- SQL Server 2012
- SQ_L_SERVER_2014
- SQL Server 2014
- SQ_L_SERVER_2016
- SQL Server 2016
- SQ_L_SERVER_2017
- SQL Server 2017
- SQ_L_SERVER_2019
- SQL Server 2019
- SQ_L_SERVER_2022
- SQL Server 2022
- UNKNOWN
- Unknown
- "SQL Server 2012"
- SQL Server 2012
- "SQL Server 2014"
- SQL Server 2014
- "SQL Server 2016"
- SQL Server 2016
- "SQL Server 2017"
- SQL Server 2017
- "SQL Server 2019"
- SQL Server 2019
- "SQL Server 2022"
- SQL Server 2022
- "Unknown"
- Unknown
SystemDataResponse, SystemDataResponseArgs      
- CreatedAt string
- The timestamp of resource creation (UTC).
- CreatedBy string
- The identity that created the resource.
- CreatedBy stringType 
- The type of identity that created the resource.
- LastModified stringAt 
- The timestamp of resource last modification (UTC)
- LastModified stringBy 
- The identity that last modified the resource.
- LastModified stringBy Type 
- The type of identity that last modified the resource.
- CreatedAt string
- The timestamp of resource creation (UTC).
- CreatedBy string
- The identity that created the resource.
- CreatedBy stringType 
- The type of identity that created the resource.
- LastModified stringAt 
- The timestamp of resource last modification (UTC)
- LastModified stringBy 
- The identity that last modified the resource.
- LastModified stringBy Type 
- The type of identity that last modified the resource.
- createdAt String
- The timestamp of resource creation (UTC).
- createdBy String
- The identity that created the resource.
- createdBy StringType 
- The type of identity that created the resource.
- lastModified StringAt 
- The timestamp of resource last modification (UTC)
- lastModified StringBy 
- The identity that last modified the resource.
- lastModified StringBy Type 
- The type of identity that last modified the resource.
- createdAt string
- The timestamp of resource creation (UTC).
- createdBy string
- The identity that created the resource.
- createdBy stringType 
- The type of identity that created the resource.
- lastModified stringAt 
- The timestamp of resource last modification (UTC)
- lastModified stringBy 
- The identity that last modified the resource.
- lastModified stringBy Type 
- The type of identity that last modified the resource.
- created_at str
- The timestamp of resource creation (UTC).
- created_by str
- The identity that created the resource.
- created_by_ strtype 
- The type of identity that created the resource.
- last_modified_ strat 
- The timestamp of resource last modification (UTC)
- last_modified_ strby 
- The identity that last modified the resource.
- last_modified_ strby_ type 
- The type of identity that last modified the resource.
- createdAt String
- The timestamp of resource creation (UTC).
- createdBy String
- The identity that created the resource.
- createdBy StringType 
- The type of identity that created the resource.
- lastModified StringAt 
- The timestamp of resource last modification (UTC)
- lastModified StringBy 
- The identity that last modified the resource.
- lastModified StringBy Type 
- The type of identity that last modified the resource.
Import
An existing resource can be imported using its type token, name, and identifier, e.g.
$ pulumi import azure-native:azurearcdata:SqlServerInstance testsqlServerInstance /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.AzureArcData/sqlServerInstances/{sqlServerInstanceName} 
To learn more about importing existing cloud resources, see Importing resources.
Package Details
- Repository
- Azure Native pulumi/pulumi-azure-native
- License
- Apache-2.0