Skip to content
Cloud Governance Tools

Azure SQL Database should have Microsoft Entra-only authentication enabled

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."

Sources

  1. Azure SQL Database should have Microsoft Entra-only authentication enabled, read 10 Nov 2026
  2. How to test it first, read 10 Nov 2026

Last reviewed 16 Nov 2026.