CIS Microsoft Azure Foundations Benchmark v1.4.0/Database Services/68 of 115
4.5Ensure that Azure Active Directory Admin is configured
Control family: Database Services
Control description
Use Azure Active Directory Authentication for authentication with SQL Database to manage credentials in a single place.
How to implement
ResponsibilityCustomerYou configure and operate this in your own cloud accounts.
With a Microsoft Entra administrator set, people sign in to Azure SQL with their directory accounts and MFA, and access is managed in one place, instead of through SQL logins and passwords that are shared and rarely changed.
Before you start
The same on every cloud, before the steps in the tabs.
- Create a group of database administrators in Microsoft Entra ID to be the SQL admin, rather than one person.
- Agree when SQL logins may still be used, if at all.
Evidence
- The database administrator group and the authentication standard
On Azure the tasks set a Microsoft Entra admin group on each SQL server, then keep it checked with the CIS standard.
Task 1Set a Microsoft Entra admin
- Sign in to the Azure portal at portal.azure.com and open SQL servers, then the server.
- Select Settings > Microsoft Entra ID.
- Select Set admin, choose a group of database administrators (not a single person) and select Select.
- Optionally select Support only Microsoft Entra authentication for this server.
- Select Save.
- Check it: a member of the group can sign in with their directory account.
Task 2Keep it checked with the CIS v1.4.0 standard in Defender for Cloud
- Open Microsoft Defender for Cloud > Regulatory compliance and select Manage compliance policies.
- Select the subscription, select Security policies, find CIS Microsoft Azure Foundations Benchmark v1.4.0 and toggle its status to On (once per subscription).
- Back on Regulatory compliance, open the CIS Microsoft Azure Foundations Benchmark v1.4.0 standard and expand recommendation 4.5.
- Open the assessment for An Azure Active Directory administrator should be provisioned for SQL servers and fix the resources it lists as non-compliant.
- Check it: every resource under recommendation 4.5 shows as passing after the next evaluation.
Evidence
- The Microsoft Entra ID page of each SQL server, showing the admin group
- The CIS v1.4.0 standard, with recommendation 4.5 passing
Not applicable. This benchmark covers Azure only.
Not applicable. This benchmark covers Azure only.
Console steps as of 5 November 2026. Not every step has been confirmed in a live console yet, and menus and labels can move between releases, so look for the nearest match if one has changed.