Other Articles

SQL Server – Require Microsoft Entra-Only Authentication

Secure Configuration Checks > Azure

This check ensures that Azure SQL servers accept only Microsoft Entra authentication. When Entra-only authentication is enabled, SQL logins with usernames and passwords can no longer be used, so access is controlled centrally through Microsoft Entra ID.

Check Details

  • Resource: SQL Server
  • Check: Require Entra-Only Authentication for SQL Servers
  • Risk: If SQL authentication is allowed, passwords can be guessed, leaked or shared, and access cannot be centrally managed with features such as MFA and Conditional Access.

Before you start

  • A Microsoft Entra admin must already be set on the SQL server.
  • Applications and users that connect with SQL logins will stop working once this is enabled. Move them to Entra authentication (for example, managed identities) first.

Remediation via Azure Portal

  1. Log in to the Azure Portal. Azure Portal dashboard
  2. Navigate to SQL servers and select the affected SQL server. SQL servers list
  3. In the left menu, click on Microsoft Entra ID under Settings. Microsoft Entra ID in the SQL server menu
  4. If no admin is set, click Set admin and choose a user or group.
  5. Select Support only Microsoft Entra authentication for this server. Microsoft Entra admin set on the SQL server
  6. Click Save to apply the changes.

Remediation via Azure CLI

  1. Open Azure Cloud Shell from the Azure Portal or use a local terminal with Azure CLI installed. Azure Cloud Shell
  2. If no Entra admin is set, run the following command first:
    az sql server ad-admin create \
    --resource-group <resource-group-name> \
    --server-name <sql-server-name> \
    --display-name <admin-display-name> \
    --object-id <admin-object-id>
    
  3. Run the following command to enable Entra-only authentication:
    az sql server ad-only-auth enable \
    --resource-group <resource-group-name> \
    --name <sql-server-name>
    

    Replace <resource-group-name>, <sql-server-name>, <admin-display-name> and <admin-object-id> with your actual values.

Updated on 03 November, 2026