1. Packages
  2. Azure Native v2
  3. API Docs
  4. sql
  5. getServer
These are the docs for Azure Native v2. We recommenend using the latest version, Azure Native v3.
Azure Native v2 v2.90.0 published on Thursday, Mar 27, 2025 by Pulumi

azure-native-v2.sql.getServer

Explore with Pulumi AI

These are the docs for Azure Native v2. We recommenend using the latest version, Azure Native v3.
Azure Native v2 v2.90.0 published on Thursday, Mar 27, 2025 by Pulumi

Gets a server. Azure REST API version: 2021-11-01.

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.

Using getServer

Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.

function getServer(args: GetServerArgs, opts?: InvokeOptions): Promise<GetServerResult>
function getServerOutput(args: GetServerOutputArgs, opts?: InvokeOptions): Output<GetServerResult>
Copy
def get_server(expand: Optional[str] = None,
               resource_group_name: Optional[str] = None,
               server_name: Optional[str] = None,
               opts: Optional[InvokeOptions] = None) -> GetServerResult
def get_server_output(expand: Optional[pulumi.Input[str]] = None,
               resource_group_name: Optional[pulumi.Input[str]] = None,
               server_name: Optional[pulumi.Input[str]] = None,
               opts: Optional[InvokeOptions] = None) -> Output[GetServerResult]
Copy
func LookupServer(ctx *Context, args *LookupServerArgs, opts ...InvokeOption) (*LookupServerResult, error)
func LookupServerOutput(ctx *Context, args *LookupServerOutputArgs, opts ...InvokeOption) LookupServerResultOutput
Copy

> Note: This function is named LookupServer in the Go SDK.

public static class GetServer 
{
    public static Task<GetServerResult> InvokeAsync(GetServerArgs args, InvokeOptions? opts = null)
    public static Output<GetServerResult> Invoke(GetServerInvokeArgs args, InvokeOptions? opts = null)
}
Copy
public static CompletableFuture<GetServerResult> getServer(GetServerArgs args, InvokeOptions options)
public static Output<GetServerResult> getServer(GetServerArgs args, InvokeOptions options)
Copy
fn::invoke:
  function: azure-native:sql:getServer
  arguments:
    # arguments dictionary
Copy

The following arguments are supported:

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.
ServerName
This property is required.
Changes to this property will trigger replacement.
string
The name of the server.
Expand string
The child resources to include in the response.
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.
ServerName
This property is required.
Changes to this property will trigger replacement.
string
The name of the server.
Expand string
The child resources to include in the response.
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.
serverName
This property is required.
Changes to this property will trigger replacement.
String
The name of the server.
expand String
The child resources to include in the response.
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.
serverName
This property is required.
Changes to this property will trigger replacement.
string
The name of the server.
expand string
The child resources to include in the response.
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.
server_name
This property is required.
Changes to this property will trigger replacement.
str
The name of the server.
expand str
The child resources to include in the response.
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.
serverName
This property is required.
Changes to this property will trigger replacement.
String
The name of the server.
expand String
The child resources to include in the response.

getServer Result

The following output properties are available:

FullyQualifiedDomainName string
The fully qualified domain name of the server.
Id string
Resource ID.
Kind string
Kind of sql server. This is metadata used for the Azure portal experience.
Location string
Resource location.
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
AdministratorLogin string
Administrator username for the server. Once created it cannot be changed.
Administrators Pulumi.AzureNative.Sql.Outputs.ServerExternalAdministratorResponse
The Azure Active Directory administrator of the server.
FederatedClientId string
The Client id used for cross tenant CMK scenario
Identity Pulumi.AzureNative.Sql.Outputs.ResourceIdentityResponse
The Azure Active Directory identity of the server.
KeyId string
A CMK URI of the key to use for encryption.
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
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
Whether or not to restrict outbound network access for this server. Value is optional but if passed in, must be 'Enabled' or 'Disabled'
Tags Dictionary<string, string>
Resource tags.
Version string
The version of the server.
FullyQualifiedDomainName string
The fully qualified domain name of the server.
Id string
Resource ID.
Kind string
Kind of sql server. This is metadata used for the Azure portal experience.
Location string
Resource location.
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
AdministratorLogin string
Administrator username for the server. Once created it cannot be changed.
Administrators ServerExternalAdministratorResponse
The Azure Active Directory administrator of the server.
FederatedClientId string
The Client id used for cross tenant CMK scenario
Identity ResourceIdentityResponse
The Azure Active Directory identity of the server.
KeyId string
A CMK URI of the key to use for encryption.
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
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
Whether or not to restrict outbound network access for this server. Value is optional but if passed in, must be 'Enabled' or 'Disabled'
Tags map[string]string
Resource tags.
Version string
The version of the server.
fullyQualifiedDomainName String
The fully qualified domain name of the server.
id String
Resource ID.
kind String
Kind of sql server. This is metadata used for the Azure portal experience.
location String
Resource location.
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
administratorLogin String
Administrator username for the server. Once created it cannot be changed.
administrators ServerExternalAdministratorResponse
The Azure Active Directory administrator of the server.
federatedClientId String
The Client id used for cross tenant CMK scenario
identity ResourceIdentityResponse
The Azure Active Directory identity of the server.
keyId String
A CMK URI of the key to use for encryption.
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
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
Whether or not to restrict outbound network access for this server. Value is optional but if passed in, must be 'Enabled' or 'Disabled'
tags Map<String,String>
Resource tags.
version String
The version of the server.
fullyQualifiedDomainName string
The fully qualified domain name of the server.
id string
Resource ID.
kind string
Kind of sql server. This is metadata used for the Azure portal experience.
location string
Resource location.
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
administratorLogin string
Administrator username for the server. Once created it cannot be changed.
administrators ServerExternalAdministratorResponse
The Azure Active Directory administrator of the server.
federatedClientId string
The Client id used for cross tenant CMK scenario
identity ResourceIdentityResponse
The Azure Active Directory identity of the server.
keyId string
A CMK URI of the key to use for encryption.
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
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
Whether or not to restrict outbound network access for this server. Value is optional but if passed in, must be 'Enabled' or 'Disabled'
tags {[key: string]: string}
Resource tags.
version string
The version of the server.
fully_qualified_domain_name str
The fully qualified domain name of the server.
id str
Resource ID.
kind str
Kind of sql server. This is metadata used for the Azure portal experience.
location str
Resource location.
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
administrator_login str
Administrator username for the server. Once created it cannot be changed.
administrators ServerExternalAdministratorResponse
The Azure Active Directory administrator of the server.
federated_client_id str
The Client id used for cross tenant CMK scenario
identity ResourceIdentityResponse
The Azure Active Directory identity of the server.
key_id str
A CMK URI of the key to use for encryption.
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
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
Whether or not to restrict outbound network access for this server. Value is optional but if passed in, must be 'Enabled' or 'Disabled'
tags Mapping[str, str]
Resource tags.
version str
The version of the server.
fullyQualifiedDomainName String
The fully qualified domain name of the server.
id String
Resource ID.
kind String
Kind of sql server. This is metadata used for the Azure portal experience.
location String
Resource location.
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
administratorLogin String
Administrator username for the server. Once created it cannot be changed.
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.
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
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
Whether or not to restrict outbound network access for this server. Value is optional but if passed in, must be 'Enabled' or 'Disabled'
tags Map<String>
Resource tags.
version String
The version of the server.

Supporting Types

PrivateEndpointConnectionPropertiesResponse

GroupIds This property is required. List<string>
Group IDs.
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.
GroupIds This property is required. []string
Group IDs.
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.
groupIds This property is required. List<String>
Group IDs.
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.
groupIds This property is required. string[]
Group IDs.
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.
group_ids This property is required. Sequence[str]
Group IDs.
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.
groupIds This property is required. List<String>
Group IDs.
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

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

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.

ResourceIdentityResponse

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

ServerExternalAdministratorResponse

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

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

UserIdentityResponse

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.

Package Details

Repository
azure-native-v2 pulumi/pulumi-azure-native
License
Apache-2.0
These are the docs for Azure Native v2. We recommenend using the latest version, Azure Native v3.
Azure Native v2 v2.90.0 published on Thursday, Mar 27, 2025 by Pulumi