1. Packages
  2. Azure Classic
  3. API Docs
  4. mssql
  5. Server

We recommend using Azure Native.

Viewing docs for Azure v4.42.0 (Older version)
published on Monday, Mar 9, 2026 by Pulumi
Go to latest version
Schema (JSON)
pulumi/pulumi-azure

azure.mssql.Server

azure logo

We recommend using Azure Native.

Viewing docs for Azure v4.42.0 (Older version)
published on Monday, Mar 9, 2026 by Pulumi
Go to latest version
Schema (JSON)
pulumi/pulumi-azure

    Manages a Microsoft SQL Azure Database Server.

    Example Usage

    using Pulumi;
using Azure = Pulumi.Azure;

class MyStack : Stack
{
    public MyStack()
    {
        var exampleResourceGroup = new Azure.Core.ResourceGroup("exampleResourceGroup", new Azure.Core.ResourceGroupArgs
        {
            Location = "West Europe",
        });
        var exampleAccount = new Azure.Storage.Account("exampleAccount", new Azure.Storage.AccountArgs
        {
            ResourceGroupName = exampleResourceGroup.Name,
            Location = exampleResourceGroup.Location,
            AccountTier = "Standard",
            AccountReplicationType = "LRS",
        });
        var exampleServer = new Azure.MSSql.Server("exampleServer", new Azure.MSSql.ServerArgs
        {
            ResourceGroupName = exampleResourceGroup.Name,
            Location = exampleResourceGroup.Location,
            Version = "12.0",
            AdministratorLogin = "missadministrator",
            AdministratorLoginPassword = "thisIsKat11",
            MinimumTlsVersion = "1.2",
            AzureadAdministrator = new Azure.MSSql.Inputs.ServerAzureadAdministratorArgs
            {
                LoginUsername = "AzureAD Admin",
                ObjectId = "00000000-0000-0000-0000-000000000000",
            },
            Tags = 
            {
                { "environment", "production" },
            },
        });
    }

}

    package main

import (
	"github.com/pulumi/pulumi-azure/sdk/v4/go/azure/core"
	"github.com/pulumi/pulumi-azure/sdk/v4/go/azure/mssql"
	"github.com/pulumi/pulumi-azure/sdk/v4/go/azure/storage"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		exampleResourceGroup, err := core.NewResourceGroup(ctx, "exampleResourceGroup", &core.ResourceGroupArgs{
			Location: pulumi.String("West Europe"),
		})
		if err != nil {
			return err
		}
		_, err = storage.NewAccount(ctx, "exampleAccount", &storage.AccountArgs{
			ResourceGroupName:      exampleResourceGroup.Name,
			Location:               exampleResourceGroup.Location,
			AccountTier:            pulumi.String("Standard"),
			AccountReplicationType: pulumi.String("LRS"),
		})
		if err != nil {
			return err
		}
		_, err = mssql.NewServer(ctx, "exampleServer", &mssql.ServerArgs{
			ResourceGroupName:          exampleResourceGroup.Name,
			Location:                   exampleResourceGroup.Location,
			Version:                    pulumi.String("12.0"),
			AdministratorLogin:         pulumi.String("missadministrator"),
			AdministratorLoginPassword: pulumi.String("thisIsKat11"),
			MinimumTlsVersion:          pulumi.String("1.2"),
			AzureadAdministrator: &mssql.ServerAzureadAdministratorArgs{
				LoginUsername: pulumi.String("AzureAD Admin"),
				ObjectId:      pulumi.String("00000000-0000-0000-0000-000000000000"),
			},
			Tags: pulumi.StringMap{
				"environment": pulumi.String("production"),
			},
		})
		if err != nil {
			return err
		}
		return nil
	})
}

    Example coming soon!

    import * as pulumi from "@pulumi/pulumi";
import * as azure from "@pulumi/azure";

const exampleResourceGroup = new azure.core.ResourceGroup("exampleResourceGroup", {location: "West Europe"});
const exampleAccount = new azure.storage.Account("exampleAccount", {
    resourceGroupName: exampleResourceGroup.name,
    location: exampleResourceGroup.location,
    accountTier: "Standard",
    accountReplicationType: "LRS",
});
const exampleServer = new azure.mssql.Server("exampleServer", {
    resourceGroupName: exampleResourceGroup.name,
    location: exampleResourceGroup.location,
    version: "12.0",
    administratorLogin: "missadministrator",
    administratorLoginPassword: "thisIsKat11",
    minimumTlsVersion: "1.2",
    azureadAdministrator: {
        loginUsername: "AzureAD Admin",
        objectId: "00000000-0000-0000-0000-000000000000",
    },
    tags: {
        environment: "production",
    },
});

    import pulumi
import pulumi_azure as azure

example_resource_group = azure.core.ResourceGroup("exampleResourceGroup", location="West Europe")
example_account = azure.storage.Account("exampleAccount",
    resource_group_name=example_resource_group.name,
    location=example_resource_group.location,
    account_tier="Standard",
    account_replication_type="LRS")
example_server = azure.mssql.Server("exampleServer",
    resource_group_name=example_resource_group.name,
    location=example_resource_group.location,
    version="12.0",
    administrator_login="missadministrator",
    administrator_login_password="thisIsKat11",
    minimum_tls_version="1.2",
    azuread_administrator=azure.mssql.ServerAzureadAdministratorArgs(
        login_username="AzureAD Admin",
        object_id="00000000-0000-0000-0000-000000000000",
    ),
    tags={
        "environment": "production",
    })

    Example coming soon!

    Create Server Resource

    Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.

    Constructor syntax

    new Server(name: string, args: ServerArgs, opts?: CustomResourceOptions);
    @overload
def Server(resource_name: str,
           args: ServerArgs,
           opts: Optional[ResourceOptions] = None)

@overload
def Server(resource_name: str,
           opts: Optional[ResourceOptions] = None,
           resource_group_name: Optional[str] = None,
           version: Optional[str] = None,
           minimum_tls_version: Optional[str] = None,
           name: Optional[str] = None,
           extended_auditing_policy: Optional[ServerExtendedAuditingPolicyArgs] = None,
           foo: Optional[ServerFooArgs] = None,
           identity: Optional[ServerIdentityArgs] = None,
           location: Optional[str] = None,
           administrator_login: Optional[str] = None,
           connection_policy: Optional[str] = None,
           outbound_network_restriction_enabled: Optional[bool] = None,
           primary_user_assigned_identity_id: Optional[str] = None,
           public_network_access_enabled: Optional[bool] = None,
           azuread_administrator: Optional[ServerAzureadAdministratorArgs] = None,
           tags: Optional[Mapping[str, str]] = None,
           administrator_login_password: Optional[str] = None)
    func NewServer(ctx *Context, name string, args ServerArgs, opts ...ResourceOption) (*Server, error)
    public Server(string name, ServerArgs args, CustomResourceOptions? opts = null)
    public Server(String name, ServerArgs args)
public Server(String name, ServerArgs args, CustomResourceOptions options)

    type: azure:mssql:Server
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 ServerArgs
    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 ServerArgs
    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 ServerArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args ServerArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args ServerArgs
    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 exampleserverResourceResourceFromMssqlserver = new Azure.MSSql.Server("exampleserverResourceResourceFromMssqlserver", new()
{
    ResourceGroupName = "string",
    Version = "string",
    MinimumTlsVersion = "string",
    Name = "string",
    Foo = new Azure.MSSql.Inputs.ServerFooArgs
    {
        Type = "string",
        IdentityIds = new[]
        {
            "string",
        },
        PrincipalId = "string",
        TenantId = "string",
    },
    Identity = new Azure.MSSql.Inputs.ServerIdentityArgs
    {
        Type = "string",
        PrincipalId = "string",
        TenantId = "string",
        UserAssignedIdentityIds = new[]
        {
            "string",
        },
    },
    Location = "string",
    AdministratorLogin = "string",
    ConnectionPolicy = "string",
    OutboundNetworkRestrictionEnabled = false,
    PrimaryUserAssignedIdentityId = "string",
    PublicNetworkAccessEnabled = false,
    AzureadAdministrator = new Azure.MSSql.Inputs.ServerAzureadAdministratorArgs
    {
        LoginUsername = "string",
        ObjectId = "string",
        AzureadAuthenticationOnly = false,
        TenantId = "string",
    },
    Tags = 
    {
        { "string", "string" },
    },
    AdministratorLoginPassword = "string",
});

    example, err := mssql.NewServer(ctx, "exampleserverResourceResourceFromMssqlserver", &mssql.ServerArgs{
	ResourceGroupName: pulumi.String("string"),
	Version:           pulumi.String("string"),
	MinimumTlsVersion: pulumi.String("string"),
	Name:              pulumi.String("string"),
	Foo: &mssql.ServerFooArgs{
		Type: pulumi.String("string"),
		IdentityIds: pulumi.StringArray{
			pulumi.String("string"),
		},
		PrincipalId: pulumi.String("string"),
		TenantId:    pulumi.String("string"),
	},
	Identity: &mssql.ServerIdentityArgs{
		Type:        pulumi.String("string"),
		PrincipalId: pulumi.String("string"),
		TenantId:    pulumi.String("string"),
		UserAssignedIdentityIds: pulumi.StringArray{
			pulumi.String("string"),
		},
	},
	Location:                          pulumi.String("string"),
	AdministratorLogin:                pulumi.String("string"),
	ConnectionPolicy:                  pulumi.String("string"),
	OutboundNetworkRestrictionEnabled: pulumi.Bool(false),
	PrimaryUserAssignedIdentityId:     pulumi.String("string"),
	PublicNetworkAccessEnabled:        pulumi.Bool(false),
	AzureadAdministrator: &mssql.ServerAzureadAdministratorArgs{
		LoginUsername:             pulumi.String("string"),
		ObjectId:                  pulumi.String("string"),
		AzureadAuthenticationOnly: pulumi.Bool(false),
		TenantId:                  pulumi.String("string"),
	},
	Tags: pulumi.StringMap{
		"string": pulumi.String("string"),
	},
	AdministratorLoginPassword: pulumi.String("string"),
})

    var exampleserverResourceResourceFromMssqlserver = new com.pulumi.azure.mssql.Server("exampleserverResourceResourceFromMssqlserver", com.pulumi.azure.mssql.ServerArgs.builder()
    .resourceGroupName("string")
    .version("string")
    .minimumTlsVersion("string")
    .name("string")
    .foo(ServerFooArgs.builder()
        .type("string")
        .identityIds("string")
        .principalId("string")
        .tenantId("string")
        .build())
    .identity(ServerIdentityArgs.builder()
        .type("string")
        .principalId("string")
        .tenantId("string")
        .userAssignedIdentityIds("string")
        .build())
    .location("string")
    .administratorLogin("string")
    .connectionPolicy("string")
    .outboundNetworkRestrictionEnabled(false)
    .primaryUserAssignedIdentityId("string")
    .publicNetworkAccessEnabled(false)
    .azureadAdministrator(ServerAzureadAdministratorArgs.builder()
        .loginUsername("string")
        .objectId("string")
        .azureadAuthenticationOnly(false)
        .tenantId("string")
        .build())
    .tags(Map.of("string", "string"))
    .administratorLoginPassword("string")
    .build());

    exampleserver_resource_resource_from_mssqlserver = azure.mssql.Server("exampleserverResourceResourceFromMssqlserver",
    resource_group_name="string",
    version="string",
    minimum_tls_version="string",
    name="string",
    foo={
        "type": "string",
        "identity_ids": ["string"],
        "principal_id": "string",
        "tenant_id": "string",
    },
    identity={
        "type": "string",
        "principal_id": "string",
        "tenant_id": "string",
        "user_assigned_identity_ids": ["string"],
    },
    location="string",
    administrator_login="string",
    connection_policy="string",
    outbound_network_restriction_enabled=False,
    primary_user_assigned_identity_id="string",
    public_network_access_enabled=False,
    azuread_administrator={
        "login_username": "string",
        "object_id": "string",
        "azuread_authentication_only": False,
        "tenant_id": "string",
    },
    tags={
        "string": "string",
    },
    administrator_login_password="string")

    const exampleserverResourceResourceFromMssqlserver = new azure.mssql.Server("exampleserverResourceResourceFromMssqlserver", {
    resourceGroupName: "string",
    version: "string",
    minimumTlsVersion: "string",
    name: "string",
    foo: {
        type: "string",
        identityIds: ["string"],
        principalId: "string",
        tenantId: "string",
    },
    identity: {
        type: "string",
        principalId: "string",
        tenantId: "string",
        userAssignedIdentityIds: ["string"],
    },
    location: "string",
    administratorLogin: "string",
    connectionPolicy: "string",
    outboundNetworkRestrictionEnabled: false,
    primaryUserAssignedIdentityId: "string",
    publicNetworkAccessEnabled: false,
    azureadAdministrator: {
        loginUsername: "string",
        objectId: "string",
        azureadAuthenticationOnly: false,
        tenantId: "string",
    },
    tags: {
        string: "string",
    },
    administratorLoginPassword: "string",
});

    type: azure:mssql:Server
properties:
    administratorLogin: string
    administratorLoginPassword: string
    azureadAdministrator:
        azureadAuthenticationOnly: false
        loginUsername: string
        objectId: string
        tenantId: string
    connectionPolicy: string
    foo:
        identityIds:
            - string
        principalId: string
        tenantId: string
        type: string
    identity:
        principalId: string
        tenantId: string
        type: string
        userAssignedIdentityIds:
            - string
    location: string
    minimumTlsVersion: string
    name: string
    outboundNetworkRestrictionEnabled: false
    primaryUserAssignedIdentityId: string
    publicNetworkAccessEnabled: false
    resourceGroupName: string
    tags:
        string: string
    version: string

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

    ResourceGroupName string
    The name of the resource group in which to create the Microsoft SQL Server.
    Version string
    The version for the new server. Valid values are: 2.0 (for v11 server) and 12.0 (for v12 server).
    AdministratorLogin string
    The administrator login name for the new server. Required unless azuread_authentication_only in the azuread_administrator block is true. When omitted, Azure will generate a default username which cannot be subsequently changed. Changing this forces a new resource to be created.
    AdministratorLoginPassword string
    The password associated with the administrator_login user. Needs to comply with Azure's Password Policy. Required unless azuread_authentication_only in the azuread_administrator block is true.
    AzureadAdministrator ServerAzureadAdministrator
    An azuread_administrator block as defined below.
    ConnectionPolicy string
    The connection policy the server will use. Possible values are Default, Proxy, and Redirect. Defaults to Default.
    ExtendedAuditingPolicy ServerExtendedAuditingPolicy

    Deprecated: the extended_auditing_policy block has been moved to azurerm_mssql_server_extended_auditing_policy and azurerm_mssql_database_extended_auditing_policy. This block will be removed in version 3.0 of the provider.

    Foo ServerFoo
    Identity ServerIdentity
    An identity block as defined below.
    Location string
    Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
    MinimumTlsVersion string
    The Minimum TLS Version for all SQL Database and SQL Data Warehouse databases associated with the server. Valid values are: 1.0, 1.1 and 1.2.
    Name string
    The name of the Microsoft SQL Server. This needs to be globally unique within Azure.
    OutboundNetworkRestrictionEnabled bool
    Whether outbound network traffic is restricted for this server. Defaults to false.
    PrimaryUserAssignedIdentityId string
    Specifies the primary user managed identity id. Required if type is UserAssigned and should be combined with user_assigned_identity_ids.
    PublicNetworkAccessEnabled bool
    Whether public network access is allowed for this server. Defaults to true.
    Tags Dictionary<string, string>
    A mapping of tags to assign to the resource.
    ResourceGroupName string
    The name of the resource group in which to create the Microsoft SQL Server.
    Version string
    The version for the new server. Valid values are: 2.0 (for v11 server) and 12.0 (for v12 server).
    AdministratorLogin string
    The administrator login name for the new server. Required unless azuread_authentication_only in the azuread_administrator block is true. When omitted, Azure will generate a default username which cannot be subsequently changed. Changing this forces a new resource to be created.
    AdministratorLoginPassword string
    The password associated with the administrator_login user. Needs to comply with Azure's Password Policy. Required unless azuread_authentication_only in the azuread_administrator block is true.
    AzureadAdministrator ServerAzureadAdministratorArgs
    An azuread_administrator block as defined below.
    ConnectionPolicy string
    The connection policy the server will use. Possible values are Default, Proxy, and Redirect. Defaults to Default.
    ExtendedAuditingPolicy ServerExtendedAuditingPolicyTypeArgs

    Deprecated: the extended_auditing_policy block has been moved to azurerm_mssql_server_extended_auditing_policy and azurerm_mssql_database_extended_auditing_policy. This block will be removed in version 3.0 of the provider.

    Foo ServerFooArgs
    Identity ServerIdentityArgs
    An identity block as defined below.
    Location string
    Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
    MinimumTlsVersion string
    The Minimum TLS Version for all SQL Database and SQL Data Warehouse databases associated with the server. Valid values are: 1.0, 1.1 and 1.2.
    Name string
    The name of the Microsoft SQL Server. This needs to be globally unique within Azure.
    OutboundNetworkRestrictionEnabled bool
    Whether outbound network traffic is restricted for this server. Defaults to false.
    PrimaryUserAssignedIdentityId string
    Specifies the primary user managed identity id. Required if type is UserAssigned and should be combined with user_assigned_identity_ids.
    PublicNetworkAccessEnabled bool
    Whether public network access is allowed for this server. Defaults to true.
    Tags map[string]string
    A mapping of tags to assign to the resource.
    resourceGroupName String
    The name of the resource group in which to create the Microsoft SQL Server.
    version String
    The version for the new server. Valid values are: 2.0 (for v11 server) and 12.0 (for v12 server).
    administratorLogin String
    The administrator login name for the new server. Required unless azuread_authentication_only in the azuread_administrator block is true. When omitted, Azure will generate a default username which cannot be subsequently changed. Changing this forces a new resource to be created.
    administratorLoginPassword String
    The password associated with the administrator_login user. Needs to comply with Azure's Password Policy. Required unless azuread_authentication_only in the azuread_administrator block is true.
    azureadAdministrator ServerAzureadAdministrator
    An azuread_administrator block as defined below.
    connectionPolicy String
    The connection policy the server will use. Possible values are Default, Proxy, and Redirect. Defaults to Default.
    extendedAuditingPolicy ServerExtendedAuditingPolicy

    Deprecated: the extended_auditing_policy block has been moved to azurerm_mssql_server_extended_auditing_policy and azurerm_mssql_database_extended_auditing_policy. This block will be removed in version 3.0 of the provider.

    foo ServerFoo
    identity ServerIdentity
    An identity block as defined below.
    location String
    Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
    minimumTlsVersion String
    The Minimum TLS Version for all SQL Database and SQL Data Warehouse databases associated with the server. Valid values are: 1.0, 1.1 and 1.2.
    name String
    The name of the Microsoft SQL Server. This needs to be globally unique within Azure.
    outboundNetworkRestrictionEnabled Boolean
    Whether outbound network traffic is restricted for this server. Defaults to false.
    primaryUserAssignedIdentityId String
    Specifies the primary user managed identity id. Required if type is UserAssigned and should be combined with user_assigned_identity_ids.
    publicNetworkAccessEnabled Boolean
    Whether public network access is allowed for this server. Defaults to true.
    tags Map<String,String>
    A mapping of tags to assign to the resource.
    resourceGroupName string
    The name of the resource group in which to create the Microsoft SQL Server.
    version string
    The version for the new server. Valid values are: 2.0 (for v11 server) and 12.0 (for v12 server).
    administratorLogin string
    The administrator login name for the new server. Required unless azuread_authentication_only in the azuread_administrator block is true. When omitted, Azure will generate a default username which cannot be subsequently changed. Changing this forces a new resource to be created.
    administratorLoginPassword string
    The password associated with the administrator_login user. Needs to comply with Azure's Password Policy. Required unless azuread_authentication_only in the azuread_administrator block is true.
    azureadAdministrator ServerAzureadAdministrator
    An azuread_administrator block as defined below.
    connectionPolicy string
    The connection policy the server will use. Possible values are Default, Proxy, and Redirect. Defaults to Default.
    extendedAuditingPolicy ServerExtendedAuditingPolicy

    Deprecated: the extended_auditing_policy block has been moved to azurerm_mssql_server_extended_auditing_policy and azurerm_mssql_database_extended_auditing_policy. This block will be removed in version 3.0 of the provider.

    foo ServerFoo
    identity ServerIdentity
    An identity block as defined below.
    location string
    Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
    minimumTlsVersion string
    The Minimum TLS Version for all SQL Database and SQL Data Warehouse databases associated with the server. Valid values are: 1.0, 1.1 and 1.2.
    name string
    The name of the Microsoft SQL Server. This needs to be globally unique within Azure.
    outboundNetworkRestrictionEnabled boolean
    Whether outbound network traffic is restricted for this server. Defaults to false.
    primaryUserAssignedIdentityId string
    Specifies the primary user managed identity id. Required if type is UserAssigned and should be combined with user_assigned_identity_ids.
    publicNetworkAccessEnabled boolean
    Whether public network access is allowed for this server. Defaults to true.
    tags {[key: string]: string}
    A mapping of tags to assign to the resource.
    resource_group_name str
    The name of the resource group in which to create the Microsoft SQL Server.
    version str
    The version for the new server. Valid values are: 2.0 (for v11 server) and 12.0 (for v12 server).
    administrator_login str
    The administrator login name for the new server. Required unless azuread_authentication_only in the azuread_administrator block is true. When omitted, Azure will generate a default username which cannot be subsequently changed. Changing this forces a new resource to be created.
    administrator_login_password str
    The password associated with the administrator_login user. Needs to comply with Azure's Password Policy. Required unless azuread_authentication_only in the azuread_administrator block is true.
    azuread_administrator ServerAzureadAdministratorArgs
    An azuread_administrator block as defined below.
    connection_policy str
    The connection policy the server will use. Possible values are Default, Proxy, and Redirect. Defaults to Default.
    extended_auditing_policy ServerExtendedAuditingPolicyArgs

    Deprecated: the extended_auditing_policy block has been moved to azurerm_mssql_server_extended_auditing_policy and azurerm_mssql_database_extended_auditing_policy. This block will be removed in version 3.0 of the provider.

    foo ServerFooArgs
    identity ServerIdentityArgs
    An identity block as defined below.
    location str
    Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
    minimum_tls_version str
    The Minimum TLS Version for all SQL Database and SQL Data Warehouse databases associated with the server. Valid values are: 1.0, 1.1 and 1.2.
    name str
    The name of the Microsoft SQL Server. This needs to be globally unique within Azure.
    outbound_network_restriction_enabled bool
    Whether outbound network traffic is restricted for this server. Defaults to false.
    primary_user_assigned_identity_id str
    Specifies the primary user managed identity id. Required if type is UserAssigned and should be combined with user_assigned_identity_ids.
    public_network_access_enabled bool
    Whether public network access is allowed for this server. Defaults to true.
    tags Mapping[str, str]
    A mapping of tags to assign to the resource.
    resourceGroupName String
    The name of the resource group in which to create the Microsoft SQL Server.
    version String
    The version for the new server. Valid values are: 2.0 (for v11 server) and 12.0 (for v12 server).
    administratorLogin String
    The administrator login name for the new server. Required unless azuread_authentication_only in the azuread_administrator block is true. When omitted, Azure will generate a default username which cannot be subsequently changed. Changing this forces a new resource to be created.
    administratorLoginPassword String
    The password associated with the administrator_login user. Needs to comply with Azure's Password Policy. Required unless azuread_authentication_only in the azuread_administrator block is true.
    azureadAdministrator Property Map
    An azuread_administrator block as defined below.
    connectionPolicy String
    The connection policy the server will use. Possible values are Default, Proxy, and Redirect. Defaults to Default.
    extendedAuditingPolicy Property Map

    Deprecated: the extended_auditing_policy block has been moved to azurerm_mssql_server_extended_auditing_policy and azurerm_mssql_database_extended_auditing_policy. This block will be removed in version 3.0 of the provider.

    foo Property Map
    identity Property Map
    An identity block as defined below.
    location String
    Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
    minimumTlsVersion String
    The Minimum TLS Version for all SQL Database and SQL Data Warehouse databases associated with the server. Valid values are: 1.0, 1.1 and 1.2.
    name String
    The name of the Microsoft SQL Server. This needs to be globally unique within Azure.
    outboundNetworkRestrictionEnabled Boolean
    Whether outbound network traffic is restricted for this server. Defaults to false.
    primaryUserAssignedIdentityId String
    Specifies the primary user managed identity id. Required if type is UserAssigned and should be combined with user_assigned_identity_ids.
    publicNetworkAccessEnabled Boolean
    Whether public network access is allowed for this server. Defaults to true.
    tags Map<String>
    A mapping of tags to assign to the resource.

    Outputs

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

    FullyQualifiedDomainName string
    The fully qualified domain name of the Azure SQL Server (e.g. myServerName.database.windows.net)
    Id string
    The provider-assigned unique ID for this managed resource.
    RestorableDroppedDatabaseIds List<string>
    A list of dropped restorable database IDs on the server.
    FullyQualifiedDomainName string
    The fully qualified domain name of the Azure SQL Server (e.g. myServerName.database.windows.net)
    Id string
    The provider-assigned unique ID for this managed resource.
    RestorableDroppedDatabaseIds []string
    A list of dropped restorable database IDs on the server.
    fullyQualifiedDomainName String
    The fully qualified domain name of the Azure SQL Server (e.g. myServerName.database.windows.net)
    id String
    The provider-assigned unique ID for this managed resource.
    restorableDroppedDatabaseIds List<String>
    A list of dropped restorable database IDs on the server.
    fullyQualifiedDomainName string
    The fully qualified domain name of the Azure SQL Server (e.g. myServerName.database.windows.net)
    id string
    The provider-assigned unique ID for this managed resource.
    restorableDroppedDatabaseIds string[]
    A list of dropped restorable database IDs on the server.
    fully_qualified_domain_name str
    The fully qualified domain name of the Azure SQL Server (e.g. myServerName.database.windows.net)
    id str
    The provider-assigned unique ID for this managed resource.
    restorable_dropped_database_ids Sequence[str]
    A list of dropped restorable database IDs on the server.
    fullyQualifiedDomainName String
    The fully qualified domain name of the Azure SQL Server (e.g. myServerName.database.windows.net)
    id String
    The provider-assigned unique ID for this managed resource.
    restorableDroppedDatabaseIds List<String>
    A list of dropped restorable database IDs on the server.

    Look up Existing Server Resource

    Get an existing Server resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.

    public static get(name: string, id: Input<ID>, state?: ServerState, opts?: CustomResourceOptions): Server
    @staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        administrator_login: Optional[str] = None,
        administrator_login_password: Optional[str] = None,
        azuread_administrator: Optional[ServerAzureadAdministratorArgs] = None,
        connection_policy: Optional[str] = None,
        extended_auditing_policy: Optional[ServerExtendedAuditingPolicyArgs] = None,
        foo: Optional[ServerFooArgs] = None,
        fully_qualified_domain_name: Optional[str] = None,
        identity: Optional[ServerIdentityArgs] = None,
        location: Optional[str] = None,
        minimum_tls_version: Optional[str] = None,
        name: Optional[str] = None,
        outbound_network_restriction_enabled: Optional[bool] = None,
        primary_user_assigned_identity_id: Optional[str] = None,
        public_network_access_enabled: Optional[bool] = None,
        resource_group_name: Optional[str] = None,
        restorable_dropped_database_ids: Optional[Sequence[str]] = None,
        tags: Optional[Mapping[str, str]] = None,
        version: Optional[str] = None) -> Server
    func GetServer(ctx *Context, name string, id IDInput, state *ServerState, opts ...ResourceOption) (*Server, error)
    public static Server Get(string name, Input<string> id, ServerState? state, CustomResourceOptions? opts = null)
    public static Server get(String name, Output<String> id, ServerState state, CustomResourceOptions options)
    resources:  _:    type: azure:mssql:Server    get:      id: ${id}
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    resource_name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    The following state arguments are supported:
    AdministratorLogin string
    The administrator login name for the new server. Required unless azuread_authentication_only in the azuread_administrator block is true. When omitted, Azure will generate a default username which cannot be subsequently changed. Changing this forces a new resource to be created.
    AdministratorLoginPassword string
    The password associated with the administrator_login user. Needs to comply with Azure's Password Policy. Required unless azuread_authentication_only in the azuread_administrator block is true.
    AzureadAdministrator ServerAzureadAdministrator
    An azuread_administrator block as defined below.
    ConnectionPolicy string
    The connection policy the server will use. Possible values are Default, Proxy, and Redirect. Defaults to Default.
    ExtendedAuditingPolicy ServerExtendedAuditingPolicy

    Deprecated: the extended_auditing_policy block has been moved to azurerm_mssql_server_extended_auditing_policy and azurerm_mssql_database_extended_auditing_policy. This block will be removed in version 3.0 of the provider.

    Foo ServerFoo
    FullyQualifiedDomainName string
    The fully qualified domain name of the Azure SQL Server (e.g. myServerName.database.windows.net)
    Identity ServerIdentity
    An identity block as defined below.
    Location string
    Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
    MinimumTlsVersion string
    The Minimum TLS Version for all SQL Database and SQL Data Warehouse databases associated with the server. Valid values are: 1.0, 1.1 and 1.2.
    Name string
    The name of the Microsoft SQL Server. This needs to be globally unique within Azure.
    OutboundNetworkRestrictionEnabled bool
    Whether outbound network traffic is restricted for this server. Defaults to false.
    PrimaryUserAssignedIdentityId string
    Specifies the primary user managed identity id. Required if type is UserAssigned and should be combined with user_assigned_identity_ids.
    PublicNetworkAccessEnabled bool
    Whether public network access is allowed for this server. Defaults to true.
    ResourceGroupName string
    The name of the resource group in which to create the Microsoft SQL Server.
    RestorableDroppedDatabaseIds List<string>
    A list of dropped restorable database IDs on the server.
    Tags Dictionary<string, string>
    A mapping of tags to assign to the resource.
    Version string
    The version for the new server. Valid values are: 2.0 (for v11 server) and 12.0 (for v12 server).
    AdministratorLogin string
    The administrator login name for the new server. Required unless azuread_authentication_only in the azuread_administrator block is true. When omitted, Azure will generate a default username which cannot be subsequently changed. Changing this forces a new resource to be created.
    AdministratorLoginPassword string
    The password associated with the administrator_login user. Needs to comply with Azure's Password Policy. Required unless azuread_authentication_only in the azuread_administrator block is true.
    AzureadAdministrator ServerAzureadAdministratorArgs
    An azuread_administrator block as defined below.
    ConnectionPolicy string
    The connection policy the server will use. Possible values are Default, Proxy, and Redirect. Defaults to Default.
    ExtendedAuditingPolicy ServerExtendedAuditingPolicyTypeArgs

    Deprecated: the extended_auditing_policy block has been moved to azurerm_mssql_server_extended_auditing_policy and azurerm_mssql_database_extended_auditing_policy. This block will be removed in version 3.0 of the provider.

    Foo ServerFooArgs
    FullyQualifiedDomainName string
    The fully qualified domain name of the Azure SQL Server (e.g. myServerName.database.windows.net)
    Identity ServerIdentityArgs
    An identity block as defined below.
    Location string
    Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
    MinimumTlsVersion string
    The Minimum TLS Version for all SQL Database and SQL Data Warehouse databases associated with the server. Valid values are: 1.0, 1.1 and 1.2.
    Name string
    The name of the Microsoft SQL Server. This needs to be globally unique within Azure.
    OutboundNetworkRestrictionEnabled bool
    Whether outbound network traffic is restricted for this server. Defaults to false.
    PrimaryUserAssignedIdentityId string
    Specifies the primary user managed identity id. Required if type is UserAssigned and should be combined with user_assigned_identity_ids.
    PublicNetworkAccessEnabled bool
    Whether public network access is allowed for this server. Defaults to true.
    ResourceGroupName string
    The name of the resource group in which to create the Microsoft SQL Server.
    RestorableDroppedDatabaseIds []string
    A list of dropped restorable database IDs on the server.
    Tags map[string]string
    A mapping of tags to assign to the resource.
    Version string
    The version for the new server. Valid values are: 2.0 (for v11 server) and 12.0 (for v12 server).
    administratorLogin String
    The administrator login name for the new server. Required unless azuread_authentication_only in the azuread_administrator block is true. When omitted, Azure will generate a default username which cannot be subsequently changed. Changing this forces a new resource to be created.
    administratorLoginPassword String
    The password associated with the administrator_login user. Needs to comply with Azure's Password Policy. Required unless azuread_authentication_only in the azuread_administrator block is true.
    azureadAdministrator ServerAzureadAdministrator
    An azuread_administrator block as defined below.
    connectionPolicy String
    The connection policy the server will use. Possible values are Default, Proxy, and Redirect. Defaults to Default.
    extendedAuditingPolicy ServerExtendedAuditingPolicy

    Deprecated: the extended_auditing_policy block has been moved to azurerm_mssql_server_extended_auditing_policy and azurerm_mssql_database_extended_auditing_policy. This block will be removed in version 3.0 of the provider.

    foo ServerFoo
    fullyQualifiedDomainName String
    The fully qualified domain name of the Azure SQL Server (e.g. myServerName.database.windows.net)
    identity ServerIdentity
    An identity block as defined below.
    location String
    Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
    minimumTlsVersion String
    The Minimum TLS Version for all SQL Database and SQL Data Warehouse databases associated with the server. Valid values are: 1.0, 1.1 and 1.2.
    name String
    The name of the Microsoft SQL Server. This needs to be globally unique within Azure.
    outboundNetworkRestrictionEnabled Boolean
    Whether outbound network traffic is restricted for this server. Defaults to false.
    primaryUserAssignedIdentityId String
    Specifies the primary user managed identity id. Required if type is UserAssigned and should be combined with user_assigned_identity_ids.
    publicNetworkAccessEnabled Boolean
    Whether public network access is allowed for this server. Defaults to true.
    resourceGroupName String
    The name of the resource group in which to create the Microsoft SQL Server.
    restorableDroppedDatabaseIds List<String>
    A list of dropped restorable database IDs on the server.
    tags Map<String,String>
    A mapping of tags to assign to the resource.
    version String
    The version for the new server. Valid values are: 2.0 (for v11 server) and 12.0 (for v12 server).
    administratorLogin string
    The administrator login name for the new server. Required unless azuread_authentication_only in the azuread_administrator block is true. When omitted, Azure will generate a default username which cannot be subsequently changed. Changing this forces a new resource to be created.
    administratorLoginPassword string
    The password associated with the administrator_login user. Needs to comply with Azure's Password Policy. Required unless azuread_authentication_only in the azuread_administrator block is true.
    azureadAdministrator ServerAzureadAdministrator
    An azuread_administrator block as defined below.
    connectionPolicy string
    The connection policy the server will use. Possible values are Default, Proxy, and Redirect. Defaults to Default.
    extendedAuditingPolicy ServerExtendedAuditingPolicy

    Deprecated: the extended_auditing_policy block has been moved to azurerm_mssql_server_extended_auditing_policy and azurerm_mssql_database_extended_auditing_policy. This block will be removed in version 3.0 of the provider.

    foo ServerFoo
    fullyQualifiedDomainName string
    The fully qualified domain name of the Azure SQL Server (e.g. myServerName.database.windows.net)
    identity ServerIdentity
    An identity block as defined below.
    location string
    Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
    minimumTlsVersion string
    The Minimum TLS Version for all SQL Database and SQL Data Warehouse databases associated with the server. Valid values are: 1.0, 1.1 and 1.2.
    name string
    The name of the Microsoft SQL Server. This needs to be globally unique within Azure.
    outboundNetworkRestrictionEnabled boolean
    Whether outbound network traffic is restricted for this server. Defaults to false.
    primaryUserAssignedIdentityId string
    Specifies the primary user managed identity id. Required if type is UserAssigned and should be combined with user_assigned_identity_ids.
    publicNetworkAccessEnabled boolean
    Whether public network access is allowed for this server. Defaults to true.
    resourceGroupName string
    The name of the resource group in which to create the Microsoft SQL Server.
    restorableDroppedDatabaseIds string[]
    A list of dropped restorable database IDs on the server.
    tags {[key: string]: string}
    A mapping of tags to assign to the resource.
    version string
    The version for the new server. Valid values are: 2.0 (for v11 server) and 12.0 (for v12 server).
    administrator_login str
    The administrator login name for the new server. Required unless azuread_authentication_only in the azuread_administrator block is true. When omitted, Azure will generate a default username which cannot be subsequently changed. Changing this forces a new resource to be created.
    administrator_login_password str
    The password associated with the administrator_login user. Needs to comply with Azure's Password Policy. Required unless azuread_authentication_only in the azuread_administrator block is true.
    azuread_administrator ServerAzureadAdministratorArgs
    An azuread_administrator block as defined below.
    connection_policy str
    The connection policy the server will use. Possible values are Default, Proxy, and Redirect. Defaults to Default.
    extended_auditing_policy ServerExtendedAuditingPolicyArgs

    Deprecated: the extended_auditing_policy block has been moved to azurerm_mssql_server_extended_auditing_policy and azurerm_mssql_database_extended_auditing_policy. This block will be removed in version 3.0 of the provider.

    foo ServerFooArgs
    fully_qualified_domain_name str
    The fully qualified domain name of the Azure SQL Server (e.g. myServerName.database.windows.net)
    identity ServerIdentityArgs
    An identity block as defined below.
    location str
    Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
    minimum_tls_version str
    The Minimum TLS Version for all SQL Database and SQL Data Warehouse databases associated with the server. Valid values are: 1.0, 1.1 and 1.2.
    name str
    The name of the Microsoft SQL Server. This needs to be globally unique within Azure.
    outbound_network_restriction_enabled bool
    Whether outbound network traffic is restricted for this server. Defaults to false.
    primary_user_assigned_identity_id str
    Specifies the primary user managed identity id. Required if type is UserAssigned and should be combined with user_assigned_identity_ids.
    public_network_access_enabled bool
    Whether public network access is allowed for this server. Defaults to true.
    resource_group_name str
    The name of the resource group in which to create the Microsoft SQL Server.
    restorable_dropped_database_ids Sequence[str]
    A list of dropped restorable database IDs on the server.
    tags Mapping[str, str]
    A mapping of tags to assign to the resource.
    version str
    The version for the new server. Valid values are: 2.0 (for v11 server) and 12.0 (for v12 server).
    administratorLogin String
    The administrator login name for the new server. Required unless azuread_authentication_only in the azuread_administrator block is true. When omitted, Azure will generate a default username which cannot be subsequently changed. Changing this forces a new resource to be created.
    administratorLoginPassword String
    The password associated with the administrator_login user. Needs to comply with Azure's Password Policy. Required unless azuread_authentication_only in the azuread_administrator block is true.
    azureadAdministrator Property Map
    An azuread_administrator block as defined below.
    connectionPolicy String
    The connection policy the server will use. Possible values are Default, Proxy, and Redirect. Defaults to Default.
    extendedAuditingPolicy Property Map

    Deprecated: the extended_auditing_policy block has been moved to azurerm_mssql_server_extended_auditing_policy and azurerm_mssql_database_extended_auditing_policy. This block will be removed in version 3.0 of the provider.

    foo Property Map
    fullyQualifiedDomainName String
    The fully qualified domain name of the Azure SQL Server (e.g. myServerName.database.windows.net)
    identity Property Map
    An identity block as defined below.
    location String
    Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
    minimumTlsVersion String
    The Minimum TLS Version for all SQL Database and SQL Data Warehouse databases associated with the server. Valid values are: 1.0, 1.1 and 1.2.
    name String
    The name of the Microsoft SQL Server. This needs to be globally unique within Azure.
    outboundNetworkRestrictionEnabled Boolean
    Whether outbound network traffic is restricted for this server. Defaults to false.
    primaryUserAssignedIdentityId String
    Specifies the primary user managed identity id. Required if type is UserAssigned and should be combined with user_assigned_identity_ids.
    publicNetworkAccessEnabled Boolean
    Whether public network access is allowed for this server. Defaults to true.
    resourceGroupName String
    The name of the resource group in which to create the Microsoft SQL Server.
    restorableDroppedDatabaseIds List<String>
    A list of dropped restorable database IDs on the server.
    tags Map<String>
    A mapping of tags to assign to the resource.
    version String
    The version for the new server. Valid values are: 2.0 (for v11 server) and 12.0 (for v12 server).

    Supporting Types

    ServerAzureadAdministrator, ServerAzureadAdministratorArgs

    LoginUsername string
    The login username of the Azure AD Administrator of this SQL Server.
    ObjectId string
    The object id of the Azure AD Administrator of this SQL Server.
    AzureadAuthenticationOnly bool
    Specifies whether only AD Users and administrators (like azuread_administrator.0.login_username) can be used to login, or also local database users (like administrator_login). When true, the administrator_login and administrator_login_password properties can be omitted.
    TenantId string
    The tenant id of the Azure AD Administrator of this SQL Server.
    LoginUsername string
    The login username of the Azure AD Administrator of this SQL Server.
    ObjectId string
    The object id of the Azure AD Administrator of this SQL Server.
    AzureadAuthenticationOnly bool
    Specifies whether only AD Users and administrators (like azuread_administrator.0.login_username) can be used to login, or also local database users (like administrator_login). When true, the administrator_login and administrator_login_password properties can be omitted.
    TenantId string
    The tenant id of the Azure AD Administrator of this SQL Server.
    loginUsername String
    The login username of the Azure AD Administrator of this SQL Server.
    objectId String
    The object id of the Azure AD Administrator of this SQL Server.
    azureadAuthenticationOnly Boolean
    Specifies whether only AD Users and administrators (like azuread_administrator.0.login_username) can be used to login, or also local database users (like administrator_login). When true, the administrator_login and administrator_login_password properties can be omitted.
    tenantId String
    The tenant id of the Azure AD Administrator of this SQL Server.
    loginUsername string
    The login username of the Azure AD Administrator of this SQL Server.
    objectId string
    The object id of the Azure AD Administrator of this SQL Server.
    azureadAuthenticationOnly boolean
    Specifies whether only AD Users and administrators (like azuread_administrator.0.login_username) can be used to login, or also local database users (like administrator_login). When true, the administrator_login and administrator_login_password properties can be omitted.
    tenantId string
    The tenant id of the Azure AD Administrator of this SQL Server.
    login_username str
    The login username of the Azure AD Administrator of this SQL Server.
    object_id str
    The object id of the Azure AD Administrator of this SQL Server.
    azuread_authentication_only bool
    Specifies whether only AD Users and administrators (like azuread_administrator.0.login_username) can be used to login, or also local database users (like administrator_login). When true, the administrator_login and administrator_login_password properties can be omitted.
    tenant_id str
    The tenant id of the Azure AD Administrator of this SQL Server.
    loginUsername String
    The login username of the Azure AD Administrator of this SQL Server.
    objectId String
    The object id of the Azure AD Administrator of this SQL Server.
    azureadAuthenticationOnly Boolean
    Specifies whether only AD Users and administrators (like azuread_administrator.0.login_username) can be used to login, or also local database users (like administrator_login). When true, the administrator_login and administrator_login_password properties can be omitted.
    tenantId String
    The tenant id of the Azure AD Administrator of this SQL Server.

    ServerExtendedAuditingPolicy, ServerExtendedAuditingPolicyArgs

    ServerFoo, ServerFooArgs

    Type string
    Specifies the identity type of the Microsoft SQL Server. Possible values are SystemAssigned (where Azure will generate a Service Principal for you) and UserAssigned where you can specify the Service Principal IDs in the user_assigned_identity_ids field.
    IdentityIds List<string>
    PrincipalId string
    The Principal ID for the Service Principal associated with the Identity of this SQL Server.
    TenantId string
    The tenant id of the Azure AD Administrator of this SQL Server.
    Type string
    Specifies the identity type of the Microsoft SQL Server. Possible values are SystemAssigned (where Azure will generate a Service Principal for you) and UserAssigned where you can specify the Service Principal IDs in the user_assigned_identity_ids field.
    IdentityIds []string
    PrincipalId string
    The Principal ID for the Service Principal associated with the Identity of this SQL Server.
    TenantId string
    The tenant id of the Azure AD Administrator of this SQL Server.
    type String
    Specifies the identity type of the Microsoft SQL Server. Possible values are SystemAssigned (where Azure will generate a Service Principal for you) and UserAssigned where you can specify the Service Principal IDs in the user_assigned_identity_ids field.
    identityIds List<String>
    principalId String
    The Principal ID for the Service Principal associated with the Identity of this SQL Server.
    tenantId String
    The tenant id of the Azure AD Administrator of this SQL Server.
    type string
    Specifies the identity type of the Microsoft SQL Server. Possible values are SystemAssigned (where Azure will generate a Service Principal for you) and UserAssigned where you can specify the Service Principal IDs in the user_assigned_identity_ids field.
    identityIds string[]
    principalId string
    The Principal ID for the Service Principal associated with the Identity of this SQL Server.
    tenantId string
    The tenant id of the Azure AD Administrator of this SQL Server.
    type str
    Specifies the identity type of the Microsoft SQL Server. Possible values are SystemAssigned (where Azure will generate a Service Principal for you) and UserAssigned where you can specify the Service Principal IDs in the user_assigned_identity_ids field.
    identity_ids Sequence[str]
    principal_id str
    The Principal ID for the Service Principal associated with the Identity of this SQL Server.
    tenant_id str
    The tenant id of the Azure AD Administrator of this SQL Server.
    type String
    Specifies the identity type of the Microsoft SQL Server. Possible values are SystemAssigned (where Azure will generate a Service Principal for you) and UserAssigned where you can specify the Service Principal IDs in the user_assigned_identity_ids field.
    identityIds List<String>
    principalId String
    The Principal ID for the Service Principal associated with the Identity of this SQL Server.
    tenantId String
    The tenant id of the Azure AD Administrator of this SQL Server.

    ServerIdentity, ServerIdentityArgs

    Type string
    Specifies the identity type of the Microsoft SQL Server. Possible values are SystemAssigned (where Azure will generate a Service Principal for you) and UserAssigned where you can specify the Service Principal IDs in the user_assigned_identity_ids field.
    PrincipalId string
    The Principal ID for the Service Principal associated with the Identity of this SQL Server.
    TenantId string
    The tenant id of the Azure AD Administrator of this SQL Server.
    UserAssignedIdentityIds List<string>
    Specifies a list of User Assigned Identity IDs to be assigned. Required if type is UserAssigned and should be combined with primary_user_assigned_identity_id.
    Type string
    Specifies the identity type of the Microsoft SQL Server. Possible values are SystemAssigned (where Azure will generate a Service Principal for you) and UserAssigned where you can specify the Service Principal IDs in the user_assigned_identity_ids field.
    PrincipalId string
    The Principal ID for the Service Principal associated with the Identity of this SQL Server.
    TenantId string
    The tenant id of the Azure AD Administrator of this SQL Server.
    UserAssignedIdentityIds []string
    Specifies a list of User Assigned Identity IDs to be assigned. Required if type is UserAssigned and should be combined with primary_user_assigned_identity_id.
    type String
    Specifies the identity type of the Microsoft SQL Server. Possible values are SystemAssigned (where Azure will generate a Service Principal for you) and UserAssigned where you can specify the Service Principal IDs in the user_assigned_identity_ids field.
    principalId String
    The Principal ID for the Service Principal associated with the Identity of this SQL Server.
    tenantId String
    The tenant id of the Azure AD Administrator of this SQL Server.
    userAssignedIdentityIds List<String>
    Specifies a list of User Assigned Identity IDs to be assigned. Required if type is UserAssigned and should be combined with primary_user_assigned_identity_id.
    type string
    Specifies the identity type of the Microsoft SQL Server. Possible values are SystemAssigned (where Azure will generate a Service Principal for you) and UserAssigned where you can specify the Service Principal IDs in the user_assigned_identity_ids field.
    principalId string
    The Principal ID for the Service Principal associated with the Identity of this SQL Server.
    tenantId string
    The tenant id of the Azure AD Administrator of this SQL Server.
    userAssignedIdentityIds string[]
    Specifies a list of User Assigned Identity IDs to be assigned. Required if type is UserAssigned and should be combined with primary_user_assigned_identity_id.
    type str
    Specifies the identity type of the Microsoft SQL Server. Possible values are SystemAssigned (where Azure will generate a Service Principal for you) and UserAssigned where you can specify the Service Principal IDs in the user_assigned_identity_ids field.
    principal_id str
    The Principal ID for the Service Principal associated with the Identity of this SQL Server.
    tenant_id str
    The tenant id of the Azure AD Administrator of this SQL Server.
    user_assigned_identity_ids Sequence[str]
    Specifies a list of User Assigned Identity IDs to be assigned. Required if type is UserAssigned and should be combined with primary_user_assigned_identity_id.
    type String
    Specifies the identity type of the Microsoft SQL Server. Possible values are SystemAssigned (where Azure will generate a Service Principal for you) and UserAssigned where you can specify the Service Principal IDs in the user_assigned_identity_ids field.
    principalId String
    The Principal ID for the Service Principal associated with the Identity of this SQL Server.
    tenantId String
    The tenant id of the Azure AD Administrator of this SQL Server.
    userAssignedIdentityIds List<String>
    Specifies a list of User Assigned Identity IDs to be assigned. Required if type is UserAssigned and should be combined with primary_user_assigned_identity_id.

    Import

    SQL Servers can be imported using the resource id, e.g.

     $ pulumi import azure:mssql/server:Server example /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/myresourcegroup/providers/Microsoft.Sql/servers/myserver

    To learn more about importing existing cloud resources, see Importing resources.

    Package Details

    Repository
    Azure Classic pulumi/pulumi-azure
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the azurerm Terraform Provider.
    azure logo

    We recommend using Azure Native.

    Viewing docs for Azure v4.42.0 (Older version)
    published on Monday, Mar 9, 2026 by Pulumi
    Go to latest version
    Schema (JSON)
    pulumi/pulumi-azure
      Try Pulumi Cloud free. Your team will thank you.