1. Packages
  2. Azure Native v1
  3. API Docs
  4. sql
  5. Server
These are the docs for Azure Native v1. We recommenend using the latest version, Azure Native v2.
Azure Native v1 v1.104.0 published on Thursday, Jul 6, 2023 by Pulumi

azure-native.sql.Server

Explore with Pulumi AI

These are the docs for Azure Native v1. We recommenend using the latest version, Azure Native v2.
Azure Native v1 v1.104.0 published on Thursday, Jul 6, 2023 by Pulumi

An Azure SQL Database server. API Version: 2020-11-01-preview.

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 = "User",
            Sid = "00000011-1111-2222-2222-123456789111",
            TenantId = "00000011-1111-2222-2222-123456789111",
        },
        Location = "Japan East",
        ResourceGroupName = "sqlcrudtest-7398",
        ServerName = "sqlcrudtest-4645",
    });

});
Copy
package main

import (
	sql "github.com/pulumi/pulumi-azure-native-sdk/sql"
	"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("User"),
				Sid:                       pulumi.String("00000011-1111-2222-2222-123456789111"),
				TenantId:                  pulumi.String("00000011-1111-2222-2222-123456789111"),
			},
			Location:          pulumi.String("Japan East"),
			ResourceGroupName: pulumi.String("sqlcrudtest-7398"),
			ServerName:        pulumi.String("sqlcrudtest-4645"),
		})
		if err != nil {
			return err
		}
		return nil
	})
}
Copy
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 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(Map.ofEntries(
                Map.entry("azureADOnlyAuthentication", true),
                Map.entry("login", "bob@contoso.com"),
                Map.entry("principalType", "User"),
                Map.entry("sid", "00000011-1111-2222-2222-123456789111"),
                Map.entry("tenantId", "00000011-1111-2222-2222-123456789111")
            ))
            .location("Japan East")
            .resourceGroupName("sqlcrudtest-7398")
            .serverName("sqlcrudtest-4645")
            .build());

    }
}
Copy
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: "User",
        sid: "00000011-1111-2222-2222-123456789111",
        tenantId: "00000011-1111-2222-2222-123456789111",
    },
    location: "Japan East",
    resourceGroupName: "sqlcrudtest-7398",
    serverName: "sqlcrudtest-4645",
});
Copy
import pulumi
import pulumi_azure_native as azure_native

server = azure_native.sql.Server("server",
    administrator_login="dummylogin",
    administrator_login_password="PLACEHOLDER",
    administrators=azure_native.sql.ServerExternalAdministratorArgs(
        azure_ad_only_authentication=True,
        login="bob@contoso.com",
        principal_type="User",
        sid="00000011-1111-2222-2222-123456789111",
        tenant_id="00000011-1111-2222-2222-123456789111",
    ),
    location="Japan East",
    resource_group_name="sqlcrudtest-7398",
    server_name="sqlcrudtest-4645")
Copy
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
      resourceGroupName: sqlcrudtest-7398
      serverName: sqlcrudtest-4645
Copy

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,
           identity: Optional[ResourceIdentityArgs] = None,
           administrators: Optional[ServerExternalAdministratorArgs] = None,
           administrator_login: Optional[str] = None,
           key_id: Optional[str] = None,
           location: Optional[str] = None,
           minimal_tls_version: Optional[str] = None,
           primary_user_assigned_identity_id: Optional[str] = None,
           public_network_access: Optional[Union[str, ServerPublicNetworkAccess]] = None,
           administrator_login_password: Optional[str] = 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 This property is required. string
The unique name of the resource.
args This property is required. ServerArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
resource_name This property is required. str
The unique name of the resource.
args This property is required. 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 This property is required. string
The unique name of the resource.
args This property is required. ServerArgs
The arguments to resource properties.
opts ResourceOption
Bag of options to control resource's behavior.
name This property is required. string
The unique name of the resource.
args This property is required. ServerArgs
The arguments to resource properties.
opts CustomResourceOptions
Bag of options to control resource's behavior.
name This property is required. String
The unique name of the resource.
args This property is required. 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",
    Identity = 
    {
        { "type", "string" },
        { "userAssignedIdentities", 
        {
            { "string", "any" },
        } },
    },
    Administrators = 
    {
        { "administratorType", "string" },
        { "azureADOnlyAuthentication", false },
        { "login", "string" },
        { "principalType", "string" },
        { "sid", "string" },
        { "tenantId", "string" },
    },
    AdministratorLogin = "string",
    KeyId = "string",
    Location = "string",
    MinimalTlsVersion = "string",
    PrimaryUserAssignedIdentityId = "string",
    PublicNetworkAccess = "string",
    AdministratorLoginPassword = "string",
    ServerName = "string",
    Tags = 
    {
        { "string", "string" },
    },
    Version = "string",
});
Copy
example, err := sql.NewServer(ctx, "exampleserverResourceResourceFromSql", &sql.ServerArgs{
	ResourceGroupName: "string",
	Identity: map[string]interface{}{
		"type": "string",
		"userAssignedIdentities": map[string]interface{}{
			"string": "any",
		},
	},
	Administrators: map[string]interface{}{
		"administratorType":         "string",
		"azureADOnlyAuthentication": false,
		"login":                     "string",
		"principalType":             "string",
		"sid":                       "string",
		"tenantId":                  "string",
	},
	AdministratorLogin:            "string",
	KeyId:                         "string",
	Location:                      "string",
	MinimalTlsVersion:             "string",
	PrimaryUserAssignedIdentityId: "string",
	PublicNetworkAccess:           "string",
	AdministratorLoginPassword:    "string",
	ServerName:                    "string",
	Tags: map[string]interface{}{
		"string": "string",
	},
	Version: "string",
})
Copy
var exampleserverResourceResourceFromSql = new Server("exampleserverResourceResourceFromSql", ServerArgs.builder()
    .resourceGroupName("string")
    .identity(%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference))
    .administrators(%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference))
    .administratorLogin("string")
    .keyId("string")
    .location("string")
    .minimalTlsVersion("string")
    .primaryUserAssignedIdentityId("string")
    .publicNetworkAccess("string")
    .administratorLoginPassword("string")
    .serverName("string")
    .tags(%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference))
    .version("string")
    .build());
Copy
exampleserver_resource_resource_from_sql = azure_native.sql.Server("exampleserverResourceResourceFromSql",
    resource_group_name=string,
    identity={
        type: string,
        userAssignedIdentities: {
            string: any,
        },
    },
    administrators={
        administratorType: string,
        azureADOnlyAuthentication: False,
        login: string,
        principalType: string,
        sid: string,
        tenantId: string,
    },
    administrator_login=string,
    key_id=string,
    location=string,
    minimal_tls_version=string,
    primary_user_assigned_identity_id=string,
    public_network_access=string,
    administrator_login_password=string,
    server_name=string,
    tags={
        string: string,
    },
    version=string)
Copy
const exampleserverResourceResourceFromSql = new azure_native.sql.Server("exampleserverResourceResourceFromSql", {
    resourceGroupName: "string",
    identity: {
        type: "string",
        userAssignedIdentities: {
            string: "any",
        },
    },
    administrators: {
        administratorType: "string",
        azureADOnlyAuthentication: false,
        login: "string",
        principalType: "string",
        sid: "string",
        tenantId: "string",
    },
    administratorLogin: "string",
    keyId: "string",
    location: "string",
    minimalTlsVersion: "string",
    primaryUserAssignedIdentityId: "string",
    publicNetworkAccess: "string",
    administratorLoginPassword: "string",
    serverName: "string",
    tags: {
        string: "string",
    },
    version: "string",
});
Copy
type: azure-native:sql:Server
properties:
    administratorLogin: string
    administratorLoginPassword: string
    administrators:
        administratorType: string
        azureADOnlyAuthentication: false
        login: string
        principalType: string
        sid: string
        tenantId: string
    identity:
        type: string
        userAssignedIdentities:
            string: any
    keyId: string
    location: string
    minimalTlsVersion: string
    primaryUserAssignedIdentityId: string
    publicNetworkAccess: string
    resourceGroupName: string
    serverName: string
    tags:
        string: string
    version: string
Copy

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
This property is required.
Changes to this property will trigger replacement.
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 Changes to this property will trigger replacement. string
Administrator username for the server. Once created it cannot be changed.
AdministratorLoginPassword string
The administrator login password (required for server creation).
Administrators Changes to this property will trigger replacement. Pulumi.AzureNative.Sql.Inputs.ServerExternalAdministrator
The Azure Active Directory identity of the server.
Identity Changes to this property will trigger replacement. Pulumi.AzureNative.Sql.Inputs.ResourceIdentity
The Azure Active Directory identity of the server.
KeyId Changes to this property will trigger replacement. string
A CMK URI of the key to use for encryption.
Location Changes to this property will trigger replacement. 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.ServerPublicNetworkAccess
Whether or not public endpoint access is allowed for this server. Value is optional but if passed in, must be 'Enabled' or 'Disabled'
ServerName Changes to this property will trigger replacement. string
The name of the server.
Tags Dictionary<string, string>
Resource tags.
Version string
The version of the server.
ResourceGroupName
This property is required.
Changes to this property will trigger replacement.
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 Changes to this property will trigger replacement. string
Administrator username for the server. Once created it cannot be changed.
AdministratorLoginPassword string
The administrator login password (required for server creation).
Administrators Changes to this property will trigger replacement. ServerExternalAdministratorArgs
The Azure Active Directory identity of the server.
Identity Changes to this property will trigger replacement. ResourceIdentityArgs
The Azure Active Directory identity of the server.
KeyId Changes to this property will trigger replacement. string
A CMK URI of the key to use for encryption.
Location Changes to this property will trigger replacement. 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 | ServerPublicNetworkAccess
Whether or not public endpoint access is allowed for this server. Value is optional but if passed in, must be 'Enabled' or 'Disabled'
ServerName Changes to this property will trigger replacement. string
The name of the server.
Tags map[string]string
Resource tags.
Version string
The version of the server.
resourceGroupName
This property is required.
Changes to this property will trigger replacement.
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 Changes to this property will trigger replacement. String
Administrator username for the server. Once created it cannot be changed.
administratorLoginPassword String
The administrator login password (required for server creation).
administrators Changes to this property will trigger replacement. ServerExternalAdministrator
The Azure Active Directory identity of the server.
identity Changes to this property will trigger replacement. ResourceIdentity
The Azure Active Directory identity of the server.
keyId Changes to this property will trigger replacement. String
A CMK URI of the key to use for encryption.
location Changes to this property will trigger replacement. 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 | ServerPublicNetworkAccess
Whether or not public endpoint access is allowed for this server. Value is optional but if passed in, must be 'Enabled' or 'Disabled'
serverName Changes to this property will trigger replacement. String
The name of the server.
tags Map<String,String>
Resource tags.
version String
The version of the server.
resourceGroupName
This property is required.
Changes to this property will trigger replacement.
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 Changes to this property will trigger replacement. string
Administrator username for the server. Once created it cannot be changed.
administratorLoginPassword string
The administrator login password (required for server creation).
administrators Changes to this property will trigger replacement. ServerExternalAdministrator
The Azure Active Directory identity of the server.
identity Changes to this property will trigger replacement. ResourceIdentity
The Azure Active Directory identity of the server.
keyId Changes to this property will trigger replacement. string
A CMK URI of the key to use for encryption.
location Changes to this property will trigger replacement. 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 | ServerPublicNetworkAccess
Whether or not public endpoint access is allowed for this server. Value is optional but if passed in, must be 'Enabled' or 'Disabled'
serverName Changes to this property will trigger replacement. string
The name of the server.
tags {[key: string]: string}
Resource tags.
version string
The version of the server.
resource_group_name
This property is required.
Changes to this property will trigger replacement.
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 Changes to this property will trigger replacement. 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 Changes to this property will trigger replacement. ServerExternalAdministratorArgs
The Azure Active Directory identity of the server.
identity Changes to this property will trigger replacement. ResourceIdentityArgs
The Azure Active Directory identity of the server.
key_id Changes to this property will trigger replacement. str
A CMK URI of the key to use for encryption.
location Changes to this property will trigger replacement. 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 | ServerPublicNetworkAccess
Whether or not public endpoint access is allowed for this server. Value is optional but if passed in, must be 'Enabled' or 'Disabled'
server_name Changes to this property will trigger replacement. str
The name of the server.
tags Mapping[str, str]
Resource tags.
version str
The version of the server.
resourceGroupName
This property is required.
Changes to this property will trigger replacement.
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 Changes to this property will trigger replacement. String
Administrator username for the server. Once created it cannot be changed.
administratorLoginPassword String
The administrator login password (required for server creation).
administrators Changes to this property will trigger replacement. Property Map
The Azure Active Directory identity of the server.
identity Changes to this property will trigger replacement. Property Map
The Azure Active Directory identity of the server.
keyId Changes to this property will trigger replacement. String
A CMK URI of the key to use for encryption.
location Changes to this property will trigger replacement. 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'
serverName Changes to this property will trigger replacement. 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

ProvisioningState This property is required. 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.
ProvisioningState This property is required. 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.
provisioningState This property is required. 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.
provisioningState This property is required. 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.
provisioning_state This property is required. 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.
provisioningState This property is required. 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 This property is required. string
The actions required for private link service connection.
Description This property is required. string
The private link service connection description.
Status This property is required. string
The private link service connection status.
ActionsRequired This property is required. string
The actions required for private link service connection.
Description This property is required. string
The private link service connection description.
Status This property is required. string
The private link service connection status.
actionsRequired This property is required. String
The actions required for private link service connection.
description This property is required. String
The private link service connection description.
status This property is required. String
The private link service connection status.
actionsRequired This property is required. string
The actions required for private link service connection.
description This property is required. string
The private link service connection description.
status This property is required. string
The private link service connection status.
actions_required This property is required. str
The actions required for private link service connection.
description This property is required. str
The private link service connection description.
status This property is required. str
The private link service connection status.
actionsRequired This property is required. String
The actions required for private link service connection.
description This property is required. String
The private link service connection description.
status This property is required. 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 Dictionary<string, object>
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 map[string]interface{}
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 Map<String,Object>
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 {[key: string]: any}
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 Mapping[str, Any]
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 Map<Any>
The resource ids of the user assigned identities to use

ResourceIdentityResponse
, ResourceIdentityResponseArgs

PrincipalId This property is required. string
The Azure Active Directory principal id.
TenantId This property is required. 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 This property is required. string
The Azure Active Directory principal id.
TenantId This property is required. 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 This property is required. String
The Azure Active Directory principal id.
tenantId This property is required. 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 This property is required. string
The Azure Active Directory principal id.
tenantId This property is required. 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 This property is required. str
The Azure Active Directory principal id.
tenant_id This property is required. 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 This property is required. String
The Azure Active Directory principal id.
tenantId This property is required. 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.

ServerPrivateEndpointConnectionResponse
, ServerPrivateEndpointConnectionResponseArgs

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

ServerPublicNetworkAccess
, ServerPublicNetworkAccessArgs

Enabled
Enabled
Disabled
Disabled
ServerPublicNetworkAccessEnabled
Enabled
ServerPublicNetworkAccessDisabled
Disabled
Enabled
Enabled
Disabled
Disabled
Enabled
Enabled
Disabled
Disabled
ENABLED
Enabled
DISABLED
Disabled
"Enabled"
Enabled
"Disabled"
Disabled

UserIdentityResponse
, UserIdentityResponseArgs

ClientId This property is required. string
The Azure Active Directory client id.
PrincipalId This property is required. string
The Azure Active Directory principal id.
ClientId This property is required. string
The Azure Active Directory client id.
PrincipalId This property is required. string
The Azure Active Directory principal id.
clientId This property is required. String
The Azure Active Directory client id.
principalId This property is required. String
The Azure Active Directory principal id.
clientId This property is required. string
The Azure Active Directory client id.
principalId This property is required. string
The Azure Active Directory principal id.
client_id This property is required. str
The Azure Active Directory client id.
principal_id This property is required. str
The Azure Active Directory principal id.
clientId This property is required. String
The Azure Active Directory client id.
principalId This property is required. 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/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-7398/providers/Microsoft.Sql/servers/sqlcrudtest-4645 
Copy

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

Package Details

Repository
azure-native-v1 pulumi/pulumi-azure-native
License
Apache-2.0
These are the docs for Azure Native v1. We recommenend using the latest version, Azure Native v2.
Azure Native v1 v1.104.0 published on Thursday, Jul 6, 2023 by Pulumi