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

```text
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](https://raw.githubusercontent.com/Azure/azure-policy/master/built-in-policies/policyDefinitions/SQL/SqlServer_ADOnlyEnabled_DisableADAuth_Deny.json))
- **Test before applying:** As for every Azure Policy guardrail: [how to test before enforcing](/mechanisms/azure-policy/)
- **Mechanism:** [Azure Policy (built-in definitions)](/mechanisms/azure-policy/): Resources at the scope of the assignment (management group, subscription, resource group) and their children, except notScopes and exemptions
- **Taken from:** [open source set](https://raw.githubusercontent.com/Azure/azure-policy/master/built-in-policies/policyDefinitions/SQL/SqlServer_ADOnlyEnabled_DisableADAuth_Deny.json), 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 accounts](/guardrails/aws-scp-deny-member-root-credentials/): AWS, Service control policies (SCPs), identity and privilege
- [Deny the root user except for S3 bucket policy changes](/guardrails/aws-scp-deny-root-except-s3-bucket-policy/): AWS, Service control policies (SCPs), identity and privilege
- [Deny critical IAM user actions](/guardrails/aws-scp-deny-critical-iam-user-actions/): AWS, Service control policies (SCPs), identity and privilege
- [Storage accounts should prevent shared key access](/guardrails/azure-policy-storage-no-shared-key/): Azure, Azure Policy (built-in definitions), identity and privilege
- [Azure Key Vault should use the RBAC permission model](/guardrails/azure-policy-keyvault-use-rbac/): Azure, Azure Policy (built-in definitions), identity and privilege

## Related pages

- [Deploy diagnostic settings for Key Vault to Event Hub (Azure Azure Policy)](/guardrails/azure-policy-keyvault-diagnostic-logs/)
- [Application Insights components should block non-Entra ingestion (Azure Azure Policy)](/guardrails/azure-policy-appinsights-entra-ingestion/)
- [Configure Cognitive Services accounts to disable public network access (Azure Azure Policy)](/guardrails/azure-policy-ai-disable-public-network/)

## Sources

- Azure SQL Database should have Microsoft Entra-only authentication enabled: https://raw.githubusercontent.com/Azure/azure-policy/master/built-in-policies/policyDefinitions/SQL/SqlServer_ADOnlyEnabled_DisableADAuth_Deny.json (read 10 Nov 2026)
- How to test it first: https://learn.microsoft.com/en-us/azure/governance/policy/concepts/assignment-structure (read 10 Nov 2026)

Last reviewed 16 Nov 2026. Canonical: https://cloudgovernancetools.com/guardrails/azure-policy-sql-entra-only/
