Azure SQL Database should have Microsoft Entra-only authentication enabled
Facts read 10 Nov 2026. Page reviewed 16 Nov 2026.
Azure SQL Database should have Microsoft Entra-only authentication enabled is an Azure guardrail written in Azure Policy. Denies enabling local (SQL) authentication on Azure SQL logical servers after they are created. What it breaks: the definition does not block servers from being created with local authentication enabled; Microsoft points to the Entra-only authentication initiative to cover both.
More identity and privilege guardrails ยท About Azure Policy
Built-in policy definition: Azure SQL Database should have Microsoft Entra-only authentication enabled
Definition ID: b3a22bc9-66de-45fb-98fa-00f5df42f41a
Category: SQL
Supported effects: Audit, Deny, Disabled
policyRule (copied from the repository file):
{
"if": {
"allOf": [
{
"field": "type",
"equals": "Microsoft.Sql/servers/azureADOnlyAuthentications"
},
{
"value": "[resourcegroup().managedBy]",
"notContains": "/providers/Microsoft.Synapse/"
},
{
"anyOf": [
{
"field": "Microsoft.Sql/servers/azureADOnlyAuthentications/azureADOnlyAuthentication",
"exists": false
},
{
"field": "Microsoft.Sql/servers/azureADOnlyAuthentications/azureADOnlyAuthentication",
"equals": false
}
]
}
]
},
"then": {
"effect": "[parameters('effect')]"
}
}
- Blocks
- Denies enabling local (SQL) authentication on Azure SQL logical servers after they are created.
- Breaks
- The definition does not block servers from being created with local authentication enabled; Microsoft points to the Entra-only authentication initiative to cover both. (source)
- Test before applying
- As for every Azure Policy guardrail: how to test before enforcing
- Mechanism
- Azure Policy (built-in definitions): Resources at the scope of the assignment (management group, subscription, resource group) and their children, except notScopes and exemptions
- Taken from
- open source set, MIT License, Azure/azure-policy repository, https://raw.githubusercontent.com/Azure/azure-policy/master/LICENSE
What the source says
"Require Azure SQL logical servers to use Microsoft Entra-only authentication." (read 10 Nov 2026).
On what it breaks: "This policy doesn't block servers from being created with local authentication enabled."
Related guardrails
- Prevent root credentials management in member accountsAWS, Service control policies (SCPs), identity and privilege
- Deny the root user except for S3 bucket policy changesAWS, Service control policies (SCPs), identity and privilege
- Deny critical IAM user actionsAWS, Service control policies (SCPs), identity and privilege
- Storage accounts should prevent shared key accessAzure, Azure Policy (built-in definitions), identity and privilege
- Azure Key Vault should use the RBAC permission modelAzure, Azure Policy (built-in definitions), identity and privilege
Related pages
Sources
- Azure SQL Database should have Microsoft Entra-only authentication enabled, read 10 Nov 2026
- How to test it first, read 10 Nov 2026
Last reviewed 16 Nov 2026.