Policy: Azure > SQL > Server > Active Directory Administrator > Name

Define the Azure Active Directory resource display name or object ID for Azure > SQL > Server > Active Directory Administrator policy.

Active Directory Authentication for SQL Server supports Active Directory User, Application, Group any one of them at a time.

Please make sure the value given is the valid Display Name or the ObjectID of the desired resource you want to use. example: ddc06e04-ce5f-4995-c758-c2b6c510e8fd d8831d9d-8756-4dd9-83e0-d8ce58525496 organizationuser@organizationwebsite.onmicrosoft.com azureAD-dev-application projectDevelopersGroup

Targets

This policy targets the following resource types:

Azure > SQL > Server

Primary Policy

This policy is used with the following primary policy:

Azure > SQL > Server > Active Directory Administrator

Controls

Setting this policy configures this control:

Azure > SQL > Server > Active Directory Administrator

Policy Packs

This policy setting is used by the following policy packs:

Azure CIS v2.0.0 - Section 4 - Database Services

Policy Specification

Schema Type	`string`
Examples [YAML]	turbotadmin@turbotad.onmicrosoft.com

In Your Workspace

Policy Settings by Type report

Developers

Category URI

tmod:@turbot/turbot#/control/categories/other

Policy Type URI

tmod:@turbot/azure-sql#/policy/types/serverActiveDirectoryAdministratorName

GraphQL

query policyType(id: "tmod:@turbot/azure-sql#/policy/types/serverActiveDirectoryAdministratorName") { … }

query policySettings(filter: "policyTypeId:'tmod:@turbot/azure-sql#/policy/types/serverActiveDirectoryAdministratorName'") { … }

query policyValues(filter: "policyTypeId:'tmod:@turbot/azure-sql#/policy/types/serverActiveDirectoryAdministratorName'") { … }

CLI

Get Policy Type

turbot graphql policy-type --id "tmod:@turbot/azure-sql#/policy/types/serverActiveDirectoryAdministratorName"

Get Policy Settings

turbot graphql policy-settings --filter "policyTypeId:tmod:@turbot/azure-sql#/policy/types/serverActiveDirectoryAdministratorName"