Share via

Servers - List

Service:
SQL Database
API Version:
2014-04-01

Returns a list of servers.

GET https://management.azure.com/subscriptions/{subscriptionId}/providers/Microsoft.Sql/servers?api-version=2014-04-01

URI Parameters

Name In Required Type Description
subscriptionId
 path True

string

The subscription ID that identifies an Azure subscription.
api-version
 query True

string

The API version to use for the request.

Responses

Name Type Description
200 OK

ServerListResult

OK

Examples

List servers

Sample request

GET https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/providers/Microsoft.Sql/servers?api-version=2014-04-01

Sample response

Status code:
200 
{
  "value": [
    {
      "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-7398/providers/Microsoft.Sql/servers/sqlcrudtest-4645",
      "name": "sqlcrudtest-4645",
      "type": "Microsoft.Sql/servers",
      "location": "Japan East",
      "kind": "v12.0",
      "properties": {
        "fullyQualifiedDomainName": "sqlcrudtest-4645.database.windows.net",
        "administratorLogin": "dummylogin",
        "administratorLoginPassword": null,
        "externalAdministratorLogin": null,
        "externalAdministratorSid": null,
        "version": "12.0",
        "state": "Ready"
      }
    },
    {
      "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-7398/providers/Microsoft.Sql/servers/sqlcrudtest-6661",
      "name": "sqlcrudtest-6661",
      "type": "Microsoft.Sql/servers",
      "location": "Japan East",
      "kind": "v12.0",
      "properties": {
        "fullyQualifiedDomainName": "sqlcrudtest-6661.database.windows.net",
        "administratorLogin": "dummylogin",
        "administratorLoginPassword": null,
        "externalAdministratorLogin": null,
        "externalAdministratorSid": null,
        "version": "12.0",
        "state": "Ready"
      }
    }
  ]
}

Definitions

Name Description
Server

Represents a server.
ServerListResult

Represents the response to a get server request.
ServerState

The state of the server.
ServerVersion

The version of the server.

Server

Object

Represents a server.

Name Type Description
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.
properties.administratorLogin

string

Administrator username for the server. Can only be specified when the server is being created (and is required for creation).
properties.administratorLoginPassword

string

The administrator login password (required for server creation).
properties.externalAdministratorLogin

string

The display name of the Azure Active Directory object with admin permissions on this server. Legacy parameter, always null. To check for Active Directory admin, query .../servers/{serverName}/administrators
properties.externalAdministratorSid

string (uuid)

The ID of the Active Azure Directory object with admin permissions on this server. Legacy parameter, always null. To check for Active Directory admin, query .../servers/{serverName}/administrators.
properties.fullyQualifiedDomainName

string

The fully qualified domain name of the server.
properties.state

ServerState

The state of the server.
properties.version

ServerVersion

The version of the server.
tags

object

Resource tags.
type

string

Resource type.

ServerListResult

Object

Represents the response to a get server request.

Name Type Description
value

Server[]

The list of servers.

ServerState

Enumeration

The state of the server.

Value Description
Ready
Disabled

ServerVersion

Enumeration

The version of the server.

Value Description
2.0
12.0