Microsoft.Sql servers/administrators 2019-06-01-preview

Template format

To create a Microsoft.Sql/servers/administrators resource, add the following JSON to the resources section of your template.

  "name": "string",
  "type": "Microsoft.Sql/servers/administrators",
  "apiVersion": "2019-06-01-preview",
  "properties": {
    "administratorType": "ActiveDirectory",
    "login": "string",
    "sid": "string",
    "tenantId": "string"

Property values

The following tables describe the values you need to set in the schema.

Microsoft.Sql/servers/administrators object


In Bicep, type and apiVersion are specified in the first line of the resource declaration. Use the format <type>@<apiVersion>. Don't set those properties in the resource body.

Name Type Required Value
name string Yes Name of the server administrator resource.
type enum Yes For JSON -administrators

See Set name and type for child resources.
apiVersion enum Yes For JSON - 2019-06-01-preview
properties object Yes Resource properties. - AdministratorProperties object

AdministratorProperties object

Name Type Required Value
administratorType enum Yes Type of the sever administrator. - ActiveDirectory
login string Yes Login name of the server administrator.
sid string Yes SID (object ID) of the server administrator. - globally unique identifier
tenantId string No Tenant ID of the administrator. - globally unique identifier