1. Packages
  2. Azure Native
  3. API Docs
  4. sql
  5. Server
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.76.0 published on Friday, Dec 6, 2024 by Pulumi

azure-native.sql.Server

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.76.0 published on Friday, Dec 6, 2024 by Pulumi

    An Azure SQL Database server. Azure REST API version: 2021-11-01. Prior API version in Azure Native 1.x: 2020-11-01-preview.

    Other available API versions: 2014-04-01, 2022-11-01-preview, 2023-02-01-preview, 2023-05-01-preview, 2023-08-01-preview, 2024-05-01-preview.

    Warning: when AzureADOnlyAuthentication is enabled, the Azure SQL API rejects any AdministratorLoginPassword, even if it is the same as the current one.

    According to the Azure team, this API design owes to the following reasons:

    • Changing the password is not allowed when Entra-only authentication is enabled because it could lead to invalid templates.
    • Any updates containing the same, unchanged password are also rejected because different behavior for same vs different passwords would be a vector for brute forcing the password.

    To work around this, you can comment out AdministratorLoginPassword when enabling AzureADOnlyAuthentication. To update the password, you can disable AzureADOnlyAuthentication and re-enable it after the update.

    For more details and discussion please see this issue.

    Example Usage

    Create server

    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using AzureNative = Pulumi.AzureNative;
    
    return await Deployment.RunAsync(() => 
    {
        var server = new AzureNative.Sql.Server("server", new()
        {
            AdministratorLogin = "dummylogin",
            AdministratorLoginPassword = "PLACEHOLDER",
            Administrators = new AzureNative.Sql.Inputs.ServerExternalAdministratorArgs
            {
                AzureADOnlyAuthentication = true,
                Login = "bob@contoso.com",
                PrincipalType = AzureNative.Sql.PrincipalType.User,
                Sid = "00000011-1111-2222-2222-123456789111",
                TenantId = "00000011-1111-2222-2222-123456789111",
            },
            Location = "Japan East",
            PublicNetworkAccess = AzureNative.Sql.ServerNetworkAccessFlag.Enabled,
            ResourceGroupName = "sqlcrudtest-7398",
            RestrictOutboundNetworkAccess = AzureNative.Sql.ServerNetworkAccessFlag.Enabled,
            ServerName = "sqlcrudtest-4645",
        });
    
    });
    
    package main
    
    import (
    	sql "github.com/pulumi/pulumi-azure-native-sdk/sql/v2"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		_, err := sql.NewServer(ctx, "server", &sql.ServerArgs{
    			AdministratorLogin:         pulumi.String("dummylogin"),
    			AdministratorLoginPassword: pulumi.String("PLACEHOLDER"),
    			Administrators: &sql.ServerExternalAdministratorArgs{
    				AzureADOnlyAuthentication: pulumi.Bool(true),
    				Login:                     pulumi.String("bob@contoso.com"),
    				PrincipalType:             pulumi.String(sql.PrincipalTypeUser),
    				Sid:                       pulumi.String("00000011-1111-2222-2222-123456789111"),
    				TenantId:                  pulumi.String("00000011-1111-2222-2222-123456789111"),
    			},
    			Location:                      pulumi.String("Japan East"),
    			PublicNetworkAccess:           pulumi.String(sql.ServerNetworkAccessFlagEnabled),
    			ResourceGroupName:             pulumi.String("sqlcrudtest-7398"),
    			RestrictOutboundNetworkAccess: pulumi.String(sql.ServerNetworkAccessFlagEnabled),
    			ServerName:                    pulumi.String("sqlcrudtest-4645"),
    		})
    		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.sql.Server;
    import com.pulumi.azurenative.sql.ServerArgs;
    import com.pulumi.azurenative.sql.inputs.ServerExternalAdministratorArgs;
    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 server = new Server("server", ServerArgs.builder()
                .administratorLogin("dummylogin")
                .administratorLoginPassword("PLACEHOLDER")
                .administrators(ServerExternalAdministratorArgs.builder()
                    .azureADOnlyAuthentication(true)
                    .login("bob@contoso.com")
                    .principalType("User")
                    .sid("00000011-1111-2222-2222-123456789111")
                    .tenantId("00000011-1111-2222-2222-123456789111")
                    .build())
                .location("Japan East")
                .publicNetworkAccess("Enabled")
                .resourceGroupName("sqlcrudtest-7398")
                .restrictOutboundNetworkAccess("Enabled")
                .serverName("sqlcrudtest-4645")
                .build());
    
        }
    }
    
    import pulumi
    import pulumi_azure_native as azure_native
    
    server = azure_native.sql.Server("server",
        administrator_login="dummylogin",
        administrator_login_password="PLACEHOLDER",
        administrators={
            "azure_ad_only_authentication": True,
            "login": "bob@contoso.com",
            "principal_type": azure_native.sql.PrincipalType.USER,
            "sid": "00000011-1111-2222-2222-123456789111",
            "tenant_id": "00000011-1111-2222-2222-123456789111",
        },
        location="Japan East",
        public_network_access=azure_native.sql.ServerNetworkAccessFlag.ENABLED,
        resource_group_name="sqlcrudtest-7398",
        restrict_outbound_network_access=azure_native.sql.ServerNetworkAccessFlag.ENABLED,
        server_name="sqlcrudtest-4645")
    
    import * as pulumi from "@pulumi/pulumi";
    import * as azure_native from "@pulumi/azure-native";
    
    const server = new azure_native.sql.Server("server", {
        administratorLogin: "dummylogin",
        administratorLoginPassword: "PLACEHOLDER",
        administrators: {
            azureADOnlyAuthentication: true,
            login: "bob@contoso.com",
            principalType: azure_native.sql.PrincipalType.User,
            sid: "00000011-1111-2222-2222-123456789111",
            tenantId: "00000011-1111-2222-2222-123456789111",
        },
        location: "Japan East",
        publicNetworkAccess: azure_native.sql.ServerNetworkAccessFlag.Enabled,
        resourceGroupName: "sqlcrudtest-7398",
        restrictOutboundNetworkAccess: azure_native.sql.ServerNetworkAccessFlag.Enabled,
        serverName: "sqlcrudtest-4645",
    });
    
    resources:
      server:
        type: azure-native:sql:Server
        properties:
          administratorLogin: dummylogin
          administratorLoginPassword: PLACEHOLDER
          administrators:
            azureADOnlyAuthentication: true
            login: bob@contoso.com
            principalType: User
            sid: 00000011-1111-2222-2222-123456789111
            tenantId: 00000011-1111-2222-2222-123456789111
          location: Japan East
          publicNetworkAccess: Enabled
          resourceGroupName: sqlcrudtest-7398
          restrictOutboundNetworkAccess: Enabled
          serverName: sqlcrudtest-4645
    

    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,
               location: Optional[str] = None,
               primary_user_assigned_identity_id: Optional[str] = None,
               federated_client_id: Optional[str] = None,
               identity: Optional[ResourceIdentityArgs] = None,
               key_id: Optional[str] = None,
               administrator_login: Optional[str] = None,
               minimal_tls_version: Optional[str] = None,
               administrators: Optional[ServerExternalAdministratorArgs] = None,
               public_network_access: Optional[Union[str, ServerNetworkAccessFlag]] = None,
               administrator_login_password: Optional[str] = None,
               restrict_outbound_network_access: Optional[Union[str, ServerNetworkAccessFlag]] = None,
               server_name: Optional[str] = None,
               tags: Optional[Mapping[str, str]] = None,
               version: 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-native:sql: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 exampleserverResourceResourceFromSql = new AzureNative.Sql.Server("exampleserverResourceResourceFromSql", new()
    {
        ResourceGroupName = "string",
        Location = "string",
        PrimaryUserAssignedIdentityId = "string",
        FederatedClientId = "string",
        Identity = new AzureNative.Sql.Inputs.ResourceIdentityArgs
        {
            Type = "string",
            UserAssignedIdentities = new[]
            {
                "string",
            },
        },
        KeyId = "string",
        AdministratorLogin = "string",
        MinimalTlsVersion = "string",
        Administrators = new AzureNative.Sql.Inputs.ServerExternalAdministratorArgs
        {
            AdministratorType = "string",
            AzureADOnlyAuthentication = false,
            Login = "string",
            PrincipalType = "string",
            Sid = "string",
            TenantId = "string",
        },
        PublicNetworkAccess = "string",
        AdministratorLoginPassword = "string",
        RestrictOutboundNetworkAccess = "string",
        ServerName = "string",
        Tags = 
        {
            { "string", "string" },
        },
        Version = "string",
    });
    
    example, err := sql.NewServer(ctx, "exampleserverResourceResourceFromSql", &sql.ServerArgs{
    	ResourceGroupName:             pulumi.String("string"),
    	Location:                      pulumi.String("string"),
    	PrimaryUserAssignedIdentityId: pulumi.String("string"),
    	FederatedClientId:             pulumi.String("string"),
    	Identity: &sql.ResourceIdentityArgs{
    		Type: pulumi.String("string"),
    		UserAssignedIdentities: pulumi.StringArray{
    			pulumi.String("string"),
    		},
    	},
    	KeyId:              pulumi.String("string"),
    	AdministratorLogin: pulumi.String("string"),
    	MinimalTlsVersion:  pulumi.String("string"),
    	Administrators: &sql.ServerExternalAdministratorArgs{
    		AdministratorType:         pulumi.String("string"),
    		AzureADOnlyAuthentication: pulumi.Bool(false),
    		Login:                     pulumi.String("string"),
    		PrincipalType:             pulumi.String("string"),
    		Sid:                       pulumi.String("string"),
    		TenantId:                  pulumi.String("string"),
    	},
    	PublicNetworkAccess:           pulumi.String("string"),
    	AdministratorLoginPassword:    pulumi.String("string"),
    	RestrictOutboundNetworkAccess: pulumi.String("string"),
    	ServerName:                    pulumi.String("string"),
    	Tags: pulumi.StringMap{
    		"string": pulumi.String("string"),
    	},
    	Version: pulumi.String("string"),
    })
    
    var exampleserverResourceResourceFromSql = new Server("exampleserverResourceResourceFromSql", ServerArgs.builder()
        .resourceGroupName("string")
        .location("string")
        .primaryUserAssignedIdentityId("string")
        .federatedClientId("string")
        .identity(ResourceIdentityArgs.builder()
            .type("string")
            .userAssignedIdentities("string")
            .build())
        .keyId("string")
        .administratorLogin("string")
        .minimalTlsVersion("string")
        .administrators(ServerExternalAdministratorArgs.builder()
            .administratorType("string")
            .azureADOnlyAuthentication(false)
            .login("string")
            .principalType("string")
            .sid("string")
            .tenantId("string")
            .build())
        .publicNetworkAccess("string")
        .administratorLoginPassword("string")
        .restrictOutboundNetworkAccess("string")
        .serverName("string")
        .tags(Map.of("string", "string"))
        .version("string")
        .build());
    
    exampleserver_resource_resource_from_sql = azure_native.sql.Server("exampleserverResourceResourceFromSql",
        resource_group_name="string",
        location="string",
        primary_user_assigned_identity_id="string",
        federated_client_id="string",
        identity={
            "type": "string",
            "user_assigned_identities": ["string"],
        },
        key_id="string",
        administrator_login="string",
        minimal_tls_version="string",
        administrators={
            "administrator_type": "string",
            "azure_ad_only_authentication": False,
            "login": "string",
            "principal_type": "string",
            "sid": "string",
            "tenant_id": "string",
        },
        public_network_access="string",
        administrator_login_password="string",
        restrict_outbound_network_access="string",
        server_name="string",
        tags={
            "string": "string",
        },
        version="string")
    
    const exampleserverResourceResourceFromSql = new azure_native.sql.Server("exampleserverResourceResourceFromSql", {
        resourceGroupName: "string",
        location: "string",
        primaryUserAssignedIdentityId: "string",
        federatedClientId: "string",
        identity: {
            type: "string",
            userAssignedIdentities: ["string"],
        },
        keyId: "string",
        administratorLogin: "string",
        minimalTlsVersion: "string",
        administrators: {
            administratorType: "string",
            azureADOnlyAuthentication: false,
            login: "string",
            principalType: "string",
            sid: "string",
            tenantId: "string",
        },
        publicNetworkAccess: "string",
        administratorLoginPassword: "string",
        restrictOutboundNetworkAccess: "string",
        serverName: "string",
        tags: {
            string: "string",
        },
        version: "string",
    });
    
    type: azure-native:sql:Server
    properties:
        administratorLogin: string
        administratorLoginPassword: string
        administrators:
            administratorType: string
            azureADOnlyAuthentication: false
            login: string
            principalType: string
            sid: string
            tenantId: string
        federatedClientId: string
        identity:
            type: string
            userAssignedIdentities:
                - string
        keyId: string
        location: string
        minimalTlsVersion: string
        primaryUserAssignedIdentityId: string
        publicNetworkAccess: string
        resourceGroupName: string
        restrictOutboundNetworkAccess: string
        serverName: 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 that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
    AdministratorLogin string
    Administrator username for the server. Once created it cannot be changed.
    AdministratorLoginPassword string
    The administrator login password (required for server creation).
    Administrators Pulumi.AzureNative.Sql.Inputs.ServerExternalAdministrator
    The Azure Active Directory administrator of the server.
    FederatedClientId string
    The Client id used for cross tenant CMK scenario
    Identity Pulumi.AzureNative.Sql.Inputs.ResourceIdentity
    The Azure Active Directory identity of the server.
    KeyId string
    A CMK URI of the key to use for encryption.
    Location string
    Resource location.
    MinimalTlsVersion string
    Minimal TLS version. Allowed values: '1.0', '1.1', '1.2'
    PrimaryUserAssignedIdentityId string
    The resource id of a user assigned identity to be used by default.
    PublicNetworkAccess string | Pulumi.AzureNative.Sql.ServerNetworkAccessFlag
    Whether or not public endpoint access is allowed for this server. Value is optional but if passed in, must be 'Enabled' or 'Disabled'
    RestrictOutboundNetworkAccess string | Pulumi.AzureNative.Sql.ServerNetworkAccessFlag
    Whether or not to restrict outbound network access for this server. Value is optional but if passed in, must be 'Enabled' or 'Disabled'
    ServerName string
    The name of the server.
    Tags Dictionary<string, string>
    Resource tags.
    Version string
    The version of the server.
    ResourceGroupName string
    The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
    AdministratorLogin string
    Administrator username for the server. Once created it cannot be changed.
    AdministratorLoginPassword string
    The administrator login password (required for server creation).
    Administrators ServerExternalAdministratorArgs
    The Azure Active Directory administrator of the server.
    FederatedClientId string
    The Client id used for cross tenant CMK scenario
    Identity ResourceIdentityArgs
    The Azure Active Directory identity of the server.
    KeyId string
    A CMK URI of the key to use for encryption.
    Location string
    Resource location.
    MinimalTlsVersion string
    Minimal TLS version. Allowed values: '1.0', '1.1', '1.2'
    PrimaryUserAssignedIdentityId string
    The resource id of a user assigned identity to be used by default.
    PublicNetworkAccess string | ServerNetworkAccessFlag
    Whether or not public endpoint access is allowed for this server. Value is optional but if passed in, must be 'Enabled' or 'Disabled'
    RestrictOutboundNetworkAccess string | ServerNetworkAccessFlag
    Whether or not to restrict outbound network access for this server. Value is optional but if passed in, must be 'Enabled' or 'Disabled'
    ServerName string
    The name of the server.
    Tags map[string]string
    Resource tags.
    Version string
    The version of the server.
    resourceGroupName String
    The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
    administratorLogin String
    Administrator username for the server. Once created it cannot be changed.
    administratorLoginPassword String
    The administrator login password (required for server creation).
    administrators ServerExternalAdministrator
    The Azure Active Directory administrator of the server.
    federatedClientId String
    The Client id used for cross tenant CMK scenario
    identity ResourceIdentity
    The Azure Active Directory identity of the server.
    keyId String
    A CMK URI of the key to use for encryption.
    location String
    Resource location.
    minimalTlsVersion String
    Minimal TLS version. Allowed values: '1.0', '1.1', '1.2'
    primaryUserAssignedIdentityId String
    The resource id of a user assigned identity to be used by default.
    publicNetworkAccess String | ServerNetworkAccessFlag
    Whether or not public endpoint access is allowed for this server. Value is optional but if passed in, must be 'Enabled' or 'Disabled'
    restrictOutboundNetworkAccess String | ServerNetworkAccessFlag
    Whether or not to restrict outbound network access for this server. Value is optional but if passed in, must be 'Enabled' or 'Disabled'
    serverName String
    The name of the server.
    tags Map<String,String>
    Resource tags.
    version String
    The version of the server.
    resourceGroupName string
    The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
    administratorLogin string
    Administrator username for the server. Once created it cannot be changed.
    administratorLoginPassword string
    The administrator login password (required for server creation).
    administrators ServerExternalAdministrator
    The Azure Active Directory administrator of the server.
    federatedClientId string
    The Client id used for cross tenant CMK scenario
    identity ResourceIdentity
    The Azure Active Directory identity of the server.
    keyId string
    A CMK URI of the key to use for encryption.
    location string
    Resource location.
    minimalTlsVersion string
    Minimal TLS version. Allowed values: '1.0', '1.1', '1.2'
    primaryUserAssignedIdentityId string
    The resource id of a user assigned identity to be used by default.
    publicNetworkAccess string | ServerNetworkAccessFlag
    Whether or not public endpoint access is allowed for this server. Value is optional but if passed in, must be 'Enabled' or 'Disabled'
    restrictOutboundNetworkAccess string | ServerNetworkAccessFlag
    Whether or not to restrict outbound network access for this server. Value is optional but if passed in, must be 'Enabled' or 'Disabled'
    serverName string
    The name of the server.
    tags {[key: string]: string}
    Resource tags.
    version string
    The version of the server.
    resource_group_name str
    The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
    administrator_login str
    Administrator username for the server. Once created it cannot be changed.
    administrator_login_password str
    The administrator login password (required for server creation).
    administrators ServerExternalAdministratorArgs
    The Azure Active Directory administrator of the server.
    federated_client_id str
    The Client id used for cross tenant CMK scenario
    identity ResourceIdentityArgs
    The Azure Active Directory identity of the server.
    key_id str
    A CMK URI of the key to use for encryption.
    location str
    Resource location.
    minimal_tls_version str
    Minimal TLS version. Allowed values: '1.0', '1.1', '1.2'
    primary_user_assigned_identity_id str
    The resource id of a user assigned identity to be used by default.
    public_network_access str | ServerNetworkAccessFlag
    Whether or not public endpoint access is allowed for this server. Value is optional but if passed in, must be 'Enabled' or 'Disabled'
    restrict_outbound_network_access str | ServerNetworkAccessFlag
    Whether or not to restrict outbound network access for this server. Value is optional but if passed in, must be 'Enabled' or 'Disabled'
    server_name str
    The name of the server.
    tags Mapping[str, str]
    Resource tags.
    version str
    The version of the server.
    resourceGroupName String
    The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
    administratorLogin String
    Administrator username for the server. Once created it cannot be changed.
    administratorLoginPassword String
    The administrator login password (required for server creation).
    administrators Property Map
    The Azure Active Directory administrator of the server.
    federatedClientId String
    The Client id used for cross tenant CMK scenario
    identity Property Map
    The Azure Active Directory identity of the server.
    keyId String
    A CMK URI of the key to use for encryption.
    location String
    Resource location.
    minimalTlsVersion String
    Minimal TLS version. Allowed values: '1.0', '1.1', '1.2'
    primaryUserAssignedIdentityId String
    The resource id of a user assigned identity to be used by default.
    publicNetworkAccess String | "Enabled" | "Disabled"
    Whether or not public endpoint access is allowed for this server. Value is optional but if passed in, must be 'Enabled' or 'Disabled'
    restrictOutboundNetworkAccess String | "Enabled" | "Disabled"
    Whether or not to restrict outbound network access for this server. Value is optional but if passed in, must be 'Enabled' or 'Disabled'
    serverName String
    The name of the server.
    tags Map<String>
    Resource tags.
    version String
    The version of the server.

    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 server.
    Id string
    The provider-assigned unique ID for this managed resource.
    Kind string
    Kind of sql server. This is metadata used for the Azure portal experience.
    Name string
    Resource name.
    PrivateEndpointConnections List<Pulumi.AzureNative.Sql.Outputs.ServerPrivateEndpointConnectionResponse>
    List of private endpoint connections on a server
    State string
    The state of the server.
    Type string
    Resource type.
    WorkspaceFeature string
    Whether or not existing server has a workspace created and if it allows connection from workspace
    FullyQualifiedDomainName string
    The fully qualified domain name of the server.
    Id string
    The provider-assigned unique ID for this managed resource.
    Kind string
    Kind of sql server. This is metadata used for the Azure portal experience.
    Name string
    Resource name.
    PrivateEndpointConnections []ServerPrivateEndpointConnectionResponse
    List of private endpoint connections on a server
    State string
    The state of the server.
    Type string
    Resource type.
    WorkspaceFeature string
    Whether or not existing server has a workspace created and if it allows connection from workspace
    fullyQualifiedDomainName String
    The fully qualified domain name of the server.
    id String
    The provider-assigned unique ID for this managed resource.
    kind String
    Kind of sql server. This is metadata used for the Azure portal experience.
    name String
    Resource name.
    privateEndpointConnections List<ServerPrivateEndpointConnectionResponse>
    List of private endpoint connections on a server
    state String
    The state of the server.
    type String
    Resource type.
    workspaceFeature String
    Whether or not existing server has a workspace created and if it allows connection from workspace
    fullyQualifiedDomainName string
    The fully qualified domain name of the server.
    id string
    The provider-assigned unique ID for this managed resource.
    kind string
    Kind of sql server. This is metadata used for the Azure portal experience.
    name string
    Resource name.
    privateEndpointConnections ServerPrivateEndpointConnectionResponse[]
    List of private endpoint connections on a server
    state string
    The state of the server.
    type string
    Resource type.
    workspaceFeature string
    Whether or not existing server has a workspace created and if it allows connection from workspace
    fully_qualified_domain_name str
    The fully qualified domain name of the server.
    id str
    The provider-assigned unique ID for this managed resource.
    kind str
    Kind of sql server. This is metadata used for the Azure portal experience.
    name str
    Resource name.
    private_endpoint_connections Sequence[ServerPrivateEndpointConnectionResponse]
    List of private endpoint connections on a server
    state str
    The state of the server.
    type str
    Resource type.
    workspace_feature str
    Whether or not existing server has a workspace created and if it allows connection from workspace
    fullyQualifiedDomainName String
    The fully qualified domain name of the server.
    id String
    The provider-assigned unique ID for this managed resource.
    kind String
    Kind of sql server. This is metadata used for the Azure portal experience.
    name String
    Resource name.
    privateEndpointConnections List<Property Map>
    List of private endpoint connections on a server
    state String
    The state of the server.
    type String
    Resource type.
    workspaceFeature String
    Whether or not existing server has a workspace created and if it allows connection from workspace

    Supporting Types

    AdministratorType, AdministratorTypeArgs

    ActiveDirectory
    ActiveDirectory
    AdministratorTypeActiveDirectory
    ActiveDirectory
    ActiveDirectory
    ActiveDirectory
    ActiveDirectory
    ActiveDirectory
    ACTIVE_DIRECTORY
    ActiveDirectory
    "ActiveDirectory"
    ActiveDirectory

    IdentityType, IdentityTypeArgs

    None
    None
    SystemAssigned
    SystemAssigned
    UserAssigned
    UserAssigned
    SystemAssigned_UserAssigned
    SystemAssigned,UserAssigned
    IdentityTypeNone
    None
    IdentityTypeSystemAssigned
    SystemAssigned
    IdentityTypeUserAssigned
    UserAssigned
    IdentityType_SystemAssigned_UserAssigned
    SystemAssigned,UserAssigned
    None
    None
    SystemAssigned
    SystemAssigned
    UserAssigned
    UserAssigned
    SystemAssigned_UserAssigned
    SystemAssigned,UserAssigned
    None
    None
    SystemAssigned
    SystemAssigned
    UserAssigned
    UserAssigned
    SystemAssigned_UserAssigned
    SystemAssigned,UserAssigned
    NONE
    None
    SYSTEM_ASSIGNED
    SystemAssigned
    USER_ASSIGNED
    UserAssigned
    SYSTEM_ASSIGNED_USER_ASSIGNED
    SystemAssigned,UserAssigned
    "None"
    None
    "SystemAssigned"
    SystemAssigned
    "UserAssigned"
    UserAssigned
    "SystemAssigned,UserAssigned"
    SystemAssigned,UserAssigned

    PrincipalType, PrincipalTypeArgs

    User
    User
    Group
    Group
    Application
    Application
    PrincipalTypeUser
    User
    PrincipalTypeGroup
    Group
    PrincipalTypeApplication
    Application
    User
    User
    Group
    Group
    Application
    Application
    User
    User
    Group
    Group
    Application
    Application
    USER
    User
    GROUP
    Group
    APPLICATION
    Application
    "User"
    User
    "Group"
    Group
    "Application"
    Application

    PrivateEndpointConnectionPropertiesResponse, PrivateEndpointConnectionPropertiesResponseArgs

    GroupIds List<string>
    Group IDs.
    ProvisioningState string
    State of the private endpoint connection.
    PrivateEndpoint Pulumi.AzureNative.Sql.Inputs.PrivateEndpointPropertyResponse
    Private endpoint which the connection belongs to.
    PrivateLinkServiceConnectionState Pulumi.AzureNative.Sql.Inputs.PrivateLinkServiceConnectionStatePropertyResponse
    Connection state of the private endpoint connection.
    GroupIds []string
    Group IDs.
    ProvisioningState string
    State of the private endpoint connection.
    PrivateEndpoint PrivateEndpointPropertyResponse
    Private endpoint which the connection belongs to.
    PrivateLinkServiceConnectionState PrivateLinkServiceConnectionStatePropertyResponse
    Connection state of the private endpoint connection.
    groupIds List<String>
    Group IDs.
    provisioningState String
    State of the private endpoint connection.
    privateEndpoint PrivateEndpointPropertyResponse
    Private endpoint which the connection belongs to.
    privateLinkServiceConnectionState PrivateLinkServiceConnectionStatePropertyResponse
    Connection state of the private endpoint connection.
    groupIds string[]
    Group IDs.
    provisioningState string
    State of the private endpoint connection.
    privateEndpoint PrivateEndpointPropertyResponse
    Private endpoint which the connection belongs to.
    privateLinkServiceConnectionState PrivateLinkServiceConnectionStatePropertyResponse
    Connection state of the private endpoint connection.
    group_ids Sequence[str]
    Group IDs.
    provisioning_state str
    State of the private endpoint connection.
    private_endpoint PrivateEndpointPropertyResponse
    Private endpoint which the connection belongs to.
    private_link_service_connection_state PrivateLinkServiceConnectionStatePropertyResponse
    Connection state of the private endpoint connection.
    groupIds List<String>
    Group IDs.
    provisioningState String
    State of the private endpoint connection.
    privateEndpoint Property Map
    Private endpoint which the connection belongs to.
    privateLinkServiceConnectionState Property Map
    Connection state of the private endpoint connection.

    PrivateEndpointPropertyResponse, PrivateEndpointPropertyResponseArgs

    Id string
    Resource id of the private endpoint.
    Id string
    Resource id of the private endpoint.
    id String
    Resource id of the private endpoint.
    id string
    Resource id of the private endpoint.
    id str
    Resource id of the private endpoint.
    id String
    Resource id of the private endpoint.

    PrivateLinkServiceConnectionStatePropertyResponse, PrivateLinkServiceConnectionStatePropertyResponseArgs

    ActionsRequired string
    The actions required for private link service connection.
    Description string
    The private link service connection description.
    Status string
    The private link service connection status.
    ActionsRequired string
    The actions required for private link service connection.
    Description string
    The private link service connection description.
    Status string
    The private link service connection status.
    actionsRequired String
    The actions required for private link service connection.
    description String
    The private link service connection description.
    status String
    The private link service connection status.
    actionsRequired string
    The actions required for private link service connection.
    description string
    The private link service connection description.
    status string
    The private link service connection status.
    actions_required str
    The actions required for private link service connection.
    description str
    The private link service connection description.
    status str
    The private link service connection status.
    actionsRequired String
    The actions required for private link service connection.
    description String
    The private link service connection description.
    status String
    The private link service connection status.

    ResourceIdentity, ResourceIdentityArgs

    Type string | Pulumi.AzureNative.Sql.IdentityType
    The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
    UserAssignedIdentities List<string>
    The resource ids of the user assigned identities to use
    Type string | IdentityType
    The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
    UserAssignedIdentities []string
    The resource ids of the user assigned identities to use
    type String | IdentityType
    The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
    userAssignedIdentities List<String>
    The resource ids of the user assigned identities to use
    type string | IdentityType
    The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
    userAssignedIdentities string[]
    The resource ids of the user assigned identities to use
    type str | IdentityType
    The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
    user_assigned_identities Sequence[str]
    The resource ids of the user assigned identities to use
    type String | "None" | "SystemAssigned" | "UserAssigned" | "SystemAssigned,UserAssigned"
    The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
    userAssignedIdentities List<String>
    The resource ids of the user assigned identities to use

    ResourceIdentityResponse, ResourceIdentityResponseArgs

    PrincipalId string
    The Azure Active Directory principal id.
    TenantId string
    The Azure Active Directory tenant id.
    Type string
    The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
    UserAssignedIdentities Dictionary<string, Pulumi.AzureNative.Sql.Inputs.UserIdentityResponse>
    The resource ids of the user assigned identities to use
    PrincipalId string
    The Azure Active Directory principal id.
    TenantId string
    The Azure Active Directory tenant id.
    Type string
    The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
    UserAssignedIdentities map[string]UserIdentityResponse
    The resource ids of the user assigned identities to use
    principalId String
    The Azure Active Directory principal id.
    tenantId String
    The Azure Active Directory tenant id.
    type String
    The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
    userAssignedIdentities Map<String,UserIdentityResponse>
    The resource ids of the user assigned identities to use
    principalId string
    The Azure Active Directory principal id.
    tenantId string
    The Azure Active Directory tenant id.
    type string
    The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
    userAssignedIdentities {[key: string]: UserIdentityResponse}
    The resource ids of the user assigned identities to use
    principal_id str
    The Azure Active Directory principal id.
    tenant_id str
    The Azure Active Directory tenant id.
    type str
    The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
    user_assigned_identities Mapping[str, UserIdentityResponse]
    The resource ids of the user assigned identities to use
    principalId String
    The Azure Active Directory principal id.
    tenantId String
    The Azure Active Directory tenant id.
    type String
    The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
    userAssignedIdentities Map<Property Map>
    The resource ids of the user assigned identities to use

    ServerExternalAdministrator, ServerExternalAdministratorArgs

    AdministratorType string | Pulumi.AzureNative.Sql.AdministratorType
    Type of the sever administrator.
    AzureADOnlyAuthentication bool
    Azure Active Directory only Authentication enabled.
    Login string
    Login name of the server administrator.
    PrincipalType string | Pulumi.AzureNative.Sql.PrincipalType
    Principal Type of the sever administrator.
    Sid string
    SID (object ID) of the server administrator.
    TenantId string
    Tenant ID of the administrator.
    AdministratorType string | AdministratorType
    Type of the sever administrator.
    AzureADOnlyAuthentication bool
    Azure Active Directory only Authentication enabled.
    Login string
    Login name of the server administrator.
    PrincipalType string | PrincipalType
    Principal Type of the sever administrator.
    Sid string
    SID (object ID) of the server administrator.
    TenantId string
    Tenant ID of the administrator.
    administratorType String | AdministratorType
    Type of the sever administrator.
    azureADOnlyAuthentication Boolean
    Azure Active Directory only Authentication enabled.
    login String
    Login name of the server administrator.
    principalType String | PrincipalType
    Principal Type of the sever administrator.
    sid String
    SID (object ID) of the server administrator.
    tenantId String
    Tenant ID of the administrator.
    administratorType string | AdministratorType
    Type of the sever administrator.
    azureADOnlyAuthentication boolean
    Azure Active Directory only Authentication enabled.
    login string
    Login name of the server administrator.
    principalType string | PrincipalType
    Principal Type of the sever administrator.
    sid string
    SID (object ID) of the server administrator.
    tenantId string
    Tenant ID of the administrator.
    administrator_type str | AdministratorType
    Type of the sever administrator.
    azure_ad_only_authentication bool
    Azure Active Directory only Authentication enabled.
    login str
    Login name of the server administrator.
    principal_type str | PrincipalType
    Principal Type of the sever administrator.
    sid str
    SID (object ID) of the server administrator.
    tenant_id str
    Tenant ID of the administrator.
    administratorType String | "ActiveDirectory"
    Type of the sever administrator.
    azureADOnlyAuthentication Boolean
    Azure Active Directory only Authentication enabled.
    login String
    Login name of the server administrator.
    principalType String | "User" | "Group" | "Application"
    Principal Type of the sever administrator.
    sid String
    SID (object ID) of the server administrator.
    tenantId String
    Tenant ID of the administrator.

    ServerExternalAdministratorResponse, ServerExternalAdministratorResponseArgs

    AdministratorType string
    Type of the sever administrator.
    AzureADOnlyAuthentication bool
    Azure Active Directory only Authentication enabled.
    Login string
    Login name of the server administrator.
    PrincipalType string
    Principal Type of the sever administrator.
    Sid string
    SID (object ID) of the server administrator.
    TenantId string
    Tenant ID of the administrator.
    AdministratorType string
    Type of the sever administrator.
    AzureADOnlyAuthentication bool
    Azure Active Directory only Authentication enabled.
    Login string
    Login name of the server administrator.
    PrincipalType string
    Principal Type of the sever administrator.
    Sid string
    SID (object ID) of the server administrator.
    TenantId string
    Tenant ID of the administrator.
    administratorType String
    Type of the sever administrator.
    azureADOnlyAuthentication Boolean
    Azure Active Directory only Authentication enabled.
    login String
    Login name of the server administrator.
    principalType String
    Principal Type of the sever administrator.
    sid String
    SID (object ID) of the server administrator.
    tenantId String
    Tenant ID of the administrator.
    administratorType string
    Type of the sever administrator.
    azureADOnlyAuthentication boolean
    Azure Active Directory only Authentication enabled.
    login string
    Login name of the server administrator.
    principalType string
    Principal Type of the sever administrator.
    sid string
    SID (object ID) of the server administrator.
    tenantId string
    Tenant ID of the administrator.
    administrator_type str
    Type of the sever administrator.
    azure_ad_only_authentication bool
    Azure Active Directory only Authentication enabled.
    login str
    Login name of the server administrator.
    principal_type str
    Principal Type of the sever administrator.
    sid str
    SID (object ID) of the server administrator.
    tenant_id str
    Tenant ID of the administrator.
    administratorType String
    Type of the sever administrator.
    azureADOnlyAuthentication Boolean
    Azure Active Directory only Authentication enabled.
    login String
    Login name of the server administrator.
    principalType String
    Principal Type of the sever administrator.
    sid String
    SID (object ID) of the server administrator.
    tenantId String
    Tenant ID of the administrator.

    ServerNetworkAccessFlag, ServerNetworkAccessFlagArgs

    Enabled
    Enabled
    Disabled
    Disabled
    ServerNetworkAccessFlagEnabled
    Enabled
    ServerNetworkAccessFlagDisabled
    Disabled
    Enabled
    Enabled
    Disabled
    Disabled
    Enabled
    Enabled
    Disabled
    Disabled
    ENABLED
    Enabled
    DISABLED
    Disabled
    "Enabled"
    Enabled
    "Disabled"
    Disabled

    ServerPrivateEndpointConnectionResponse, ServerPrivateEndpointConnectionResponseArgs

    Id string
    Resource ID.
    Properties Pulumi.AzureNative.Sql.Inputs.PrivateEndpointConnectionPropertiesResponse
    Private endpoint connection properties
    Id string
    Resource ID.
    Properties PrivateEndpointConnectionPropertiesResponse
    Private endpoint connection properties
    id String
    Resource ID.
    properties PrivateEndpointConnectionPropertiesResponse
    Private endpoint connection properties
    id string
    Resource ID.
    properties PrivateEndpointConnectionPropertiesResponse
    Private endpoint connection properties
    id str
    Resource ID.
    properties PrivateEndpointConnectionPropertiesResponse
    Private endpoint connection properties
    id String
    Resource ID.
    properties Property Map
    Private endpoint connection properties

    UserIdentityResponse, UserIdentityResponseArgs

    ClientId string
    The Azure Active Directory client id.
    PrincipalId string
    The Azure Active Directory principal id.
    ClientId string
    The Azure Active Directory client id.
    PrincipalId string
    The Azure Active Directory principal id.
    clientId String
    The Azure Active Directory client id.
    principalId String
    The Azure Active Directory principal id.
    clientId string
    The Azure Active Directory client id.
    principalId string
    The Azure Active Directory principal id.
    client_id str
    The Azure Active Directory client id.
    principal_id str
    The Azure Active Directory principal id.
    clientId String
    The Azure Active Directory client id.
    principalId String
    The Azure Active Directory principal id.

    Import

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

    $ pulumi import azure-native:sql:Server sqlcrudtest-4645 /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName} 
    

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

    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.76.0 published on Friday, Dec 6, 2024 by Pulumi