1. Packages
  2. Azure Native
  3. API Docs
  4. azurearcdata
  5. SqlServerInstance
This is the latest version of Azure Native. Use the Azure Native v1 docs if using the v1 version of this package.
Azure Native v2.34.0 published on Thursday, Mar 28, 2024 by Pulumi

azure-native.azurearcdata.SqlServerInstance

Explore with Pulumi AI

azure-native logo
This is the latest version of Azure Native. Use the Azure Native v1 docs if using the v1 version of this package.
Azure Native v2.34.0 published on Thursday, Mar 28, 2024 by Pulumi

    A SqlServerInstance. Azure REST API version: 2023-01-15-preview. Prior API version in Azure Native 1.x: 2021-06-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 (
    	"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 pulumi
    import pulumi_azure_native as azure_native
    
    sql_server_instance = azure_native.azurearcdata.SqlServerInstance("sqlServerInstance",
        location="northeurope",
        properties=azure_native.azurearcdata.SqlServerInstancePropertiesArgs(
            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",
        })
    
    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",
        },
    });
    
    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

    new SqlServerInstance(name: string, args: SqlServerInstanceArgs, opts?: CustomResourceOptions);
    @overload
    def SqlServerInstance(resource_name: str,
                          opts: Optional[ResourceOptions] = None,
                          location: Optional[str] = None,
                          properties: Optional[SqlServerInstancePropertiesArgs] = None,
                          resource_group_name: Optional[str] = None,
                          sql_server_instance_name: Optional[str] = None,
                          tags: Optional[Mapping[str, str]] = None)
    @overload
    def SqlServerInstance(resource_name: str,
                          args: SqlServerInstanceArgs,
                          opts: Optional[ResourceOptions] = 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.
    
    
    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.

    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

    The SqlServerInstance resource accepts the following input properties:

    ResourceGroupName string
    The name of the Azure resource group
    Location string
    The geo-location where the resource lives
    Properties Pulumi.AzureNative.AzureArcData.Inputs.SqlServerInstanceProperties
    null
    SqlServerInstanceName string
    Name of SQL Server Instance
    Tags Dictionary<string, string>
    Resource tags.
    ResourceGroupName string
    The name of the Azure resource group
    Location string
    The geo-location where the resource lives
    Properties SqlServerInstancePropertiesArgs
    null
    SqlServerInstanceName string
    Name of SQL Server Instance
    Tags map[string]string
    Resource tags.
    resourceGroupName String
    The name of the Azure resource group
    location String
    The geo-location where the resource lives
    properties SqlServerInstanceProperties
    null
    sqlServerInstanceName String
    Name of SQL Server Instance
    tags Map<String,String>
    Resource tags.
    resourceGroupName string
    The name of the Azure resource group
    location string
    The geo-location where the resource lives
    properties SqlServerInstanceProperties
    null
    sqlServerInstanceName string
    Name of SQL Server Instance
    tags {[key: string]: string}
    Resource tags.
    resource_group_name str
    The name of the Azure resource group
    location str
    The geo-location where the resource lives
    properties SqlServerInstancePropertiesArgs
    null
    sql_server_instance_name str
    Name of SQL Server Instance
    tags Mapping[str, str]
    Resource tags.
    resourceGroupName String
    The name of the Azure resource group
    location String
    The geo-location where the resource lives
    properties Property Map
    null
    sqlServerInstanceName String
    Name of SQL Server Instance
    tags 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.AzureNative.AzureArcData.Outputs.SystemDataResponse
    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 SystemDataResponse
    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 SystemDataResponse
    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 SystemDataResponse
    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 SystemDataResponse
    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
    ArcSqlServerLicenseTypeUndefined
    Undefined
    ArcSqlServerLicenseTypeFree
    Free
    ArcSqlServerLicenseTypeHADR
    HADR
    ArcSqlServerLicenseTypeServerCAL
    ServerCAL
    ArcSqlServerLicenseTypeLicenseOnly
    LicenseOnly
    ArcSqlServerLicenseTypePAYG
    PAYG
    ArcSqlServerLicenseTypePaid
    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
    ConnectionStatusConnected
    Connected
    ConnectionStatusDisconnected
    Disconnected
    ConnectionStatusRegistered
    Registered
    ConnectionStatusUnknown
    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
    DefenderStatusProtected
    Protected
    DefenderStatusUnprotected
    Unprotected
    DefenderStatusUnknown
    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
    EditionTypeEvaluation
    Evaluation
    EditionTypeEnterprise
    Enterprise
    EditionTypeStandard
    Standard
    EditionTypeWeb
    Web
    EditionTypeDeveloper
    Developer
    EditionTypeExpress
    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
    HostTypeContainer
    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
    HostTypeOther
    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

    ContainerResourceId string
    ARM Resource id of the container resource (Azure Arc for Servers).
    Status string | Pulumi.AzureNative.AzureArcData.ConnectionStatus
    The cloud connectivity status.
    AzureDefenderStatus string | Pulumi.AzureNative.AzureArcData.DefenderStatus
    Status of Azure Defender.
    AzureDefenderStatusLastUpdated string
    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.AzureNative.AzureArcData.EditionType
    SQL Server edition.
    HostType string | Pulumi.AzureNative.AzureArcData.HostType
    Type of host for Azure Arc SQL Server
    InstanceName string
    SQL Server instance name.
    LicenseType string | Pulumi.AzureNative.AzureArcData.ArcSqlServerLicenseType
    SQL Server license type.
    PatchLevel string
    SQL Server update level.
    ProductId string
    SQL Server product ID.
    TcpDynamicPorts string
    Dynamic TCP ports used by SQL Server.
    TcpStaticPorts string
    Static TCP ports used by SQL Server.
    VCore string
    The number of logical processors used by the SQL Server instance.
    Version string | Pulumi.AzureNative.AzureArcData.SqlVersion
    SQL Server version.
    ContainerResourceId string
    ARM Resource id of the container resource (Azure Arc for Servers).
    Status string | ConnectionStatus
    The cloud connectivity status.
    AzureDefenderStatus string | DefenderStatus
    Status of Azure Defender.
    AzureDefenderStatusLastUpdated string
    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 | ArcSqlServerLicenseType
    SQL Server license type.
    PatchLevel string
    SQL Server update level.
    ProductId string
    SQL Server product ID.
    TcpDynamicPorts string
    Dynamic TCP ports used by SQL Server.
    TcpStaticPorts string
    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.
    containerResourceId String
    ARM Resource id of the container resource (Azure Arc for Servers).
    status String | ConnectionStatus
    The cloud connectivity status.
    azureDefenderStatus String | DefenderStatus
    Status of Azure Defender.
    azureDefenderStatusLastUpdated String
    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 | ArcSqlServerLicenseType
    SQL Server license type.
    patchLevel String
    SQL Server update level.
    productId String
    SQL Server product ID.
    tcpDynamicPorts String
    Dynamic TCP ports used by SQL Server.
    tcpStaticPorts String
    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.
    containerResourceId string
    ARM Resource id of the container resource (Azure Arc for Servers).
    status string | ConnectionStatus
    The cloud connectivity status.
    azureDefenderStatus string | DefenderStatus
    Status of Azure Defender.
    azureDefenderStatusLastUpdated string
    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 | ArcSqlServerLicenseType
    SQL Server license type.
    patchLevel string
    SQL Server update level.
    productId string
    SQL Server product ID.
    tcpDynamicPorts string
    Dynamic TCP ports used by SQL Server.
    tcpStaticPorts string
    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_id str
    ARM Resource id of the container resource (Azure Arc for Servers).
    status str | ConnectionStatus
    The cloud connectivity status.
    azure_defender_status str | DefenderStatus
    Status of Azure Defender.
    azure_defender_status_last_updated str
    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 | ArcSqlServerLicenseType
    SQL Server license type.
    patch_level str
    SQL Server update level.
    product_id str
    SQL Server product ID.
    tcp_dynamic_ports str
    Dynamic TCP ports used by SQL Server.
    tcp_static_ports str
    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.
    containerResourceId String
    ARM Resource id of the container resource (Azure Arc for Servers).
    status String | "Connected" | "Disconnected" | "Registered" | "Unknown"
    The cloud connectivity status.
    azureDefenderStatus String | "Protected" | "Unprotected" | "Unknown"
    Status of Azure Defender.
    azureDefenderStatusLastUpdated String
    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" | "LicenseOnly" | "PAYG" | "Paid"
    SQL Server license type.
    patchLevel String
    SQL Server update level.
    productId String
    SQL Server product ID.
    tcpDynamicPorts String
    Dynamic TCP ports used by SQL Server.
    tcpStaticPorts String
    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

    ContainerResourceId string
    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.
    AzureDefenderStatus string
    Status of Azure Defender.
    AzureDefenderStatusLastUpdated string
    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.
    TcpDynamicPorts string
    Dynamic TCP ports used by SQL Server.
    TcpStaticPorts string
    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.
    ContainerResourceId string
    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.
    AzureDefenderStatus string
    Status of Azure Defender.
    AzureDefenderStatusLastUpdated string
    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.
    TcpDynamicPorts string
    Dynamic TCP ports used by SQL Server.
    TcpStaticPorts string
    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.
    containerResourceId String
    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.
    azureDefenderStatus String
    Status of Azure Defender.
    azureDefenderStatusLastUpdated String
    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.
    tcpDynamicPorts String
    Dynamic TCP ports used by SQL Server.
    tcpStaticPorts String
    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.
    containerResourceId string
    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.
    azureDefenderStatus string
    Status of Azure Defender.
    azureDefenderStatusLastUpdated string
    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.
    tcpDynamicPorts string
    Dynamic TCP ports used by SQL Server.
    tcpStaticPorts string
    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_id str
    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_status str
    Status of Azure Defender.
    azure_defender_status_last_updated str
    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_ports str
    Dynamic TCP ports used by SQL Server.
    tcp_static_ports str
    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.
    containerResourceId String
    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.
    azureDefenderStatus String
    Status of Azure Defender.
    azureDefenderStatusLastUpdated String
    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.
    tcpDynamicPorts String
    Dynamic TCP ports used by SQL Server.
    tcpStaticPorts String
    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
    SqlVersionUnknown
    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.
    CreatedByType string
    The type of identity that created the resource.
    LastModifiedAt string
    The timestamp of resource last modification (UTC)
    LastModifiedBy string
    The identity that last modified the resource.
    LastModifiedByType string
    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.
    CreatedByType string
    The type of identity that created the resource.
    LastModifiedAt string
    The timestamp of resource last modification (UTC)
    LastModifiedBy string
    The identity that last modified the resource.
    LastModifiedByType string
    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.
    createdByType String
    The type of identity that created the resource.
    lastModifiedAt String
    The timestamp of resource last modification (UTC)
    lastModifiedBy String
    The identity that last modified the resource.
    lastModifiedByType String
    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.
    createdByType string
    The type of identity that created the resource.
    lastModifiedAt string
    The timestamp of resource last modification (UTC)
    lastModifiedBy string
    The identity that last modified the resource.
    lastModifiedByType string
    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_type str
    The type of identity that created the resource.
    last_modified_at str
    The timestamp of resource last modification (UTC)
    last_modified_by str
    The identity that last modified the resource.
    last_modified_by_type str
    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.
    createdByType String
    The type of identity that created the resource.
    lastModifiedAt String
    The timestamp of resource last modification (UTC)
    lastModifiedBy String
    The identity that last modified the resource.
    lastModifiedByType String
    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} 
    

    Package Details

    Repository
    Azure Native pulumi/pulumi-azure-native
    License
    Apache-2.0
    azure-native logo
    This is the latest version of Azure Native. Use the Azure Native v1 docs if using the v1 version of this package.
    Azure Native v2.34.0 published on Thursday, Mar 28, 2024 by Pulumi