CIS Microsoft Azure Foundations Benchmark v1.4.0/Database Services/53 of 115
4.2.1Ensure that Advanced Threat Protection (ATP) on a SQL Server is Set to 'Enabled'
Control family: Database Services
Control description
Enable "Azure Defender for SQL" on critical SQL Servers.
How to implement
ResponsibilityCustomerYou configure and operate this in your own cloud accounts.
Microsoft Defender for SQL, once called Advanced Threat Protection, alerts on SQL injection, unusual access and brute-force attempts, and runs vulnerability assessment. Turning it on at the subscription (2.3) covers every server; it can also be turned on for one server at a time.
Before you start
The same on every cloud, before the steps in the tabs.
- Agree that Defender for SQL covers every SQL server, and who triages its alerts with the database owners.
Evidence
- The database security standard and alert owners
On Azure the tasks turn on Defender for SQL for each server, then keep it checked with the CIS standard.
Task 1Turn on Microsoft Defender for SQL
- Sign in to the Azure portal at portal.azure.com and open SQL servers, then the server.
- Select Security > Defender for Cloud.
- Select Enable Microsoft Defender for SQL (or turn on the Databases plan for the whole subscription, as in 2.3).
- Check it: the page shows Defender for SQL as on for the server.
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.2.1.
- Open the assessment for Azure Defender for SQL should be enabled for unprotected Azure SQL servers and fix the resources it lists as non-compliant.
- Check it: every resource under recommendation 4.2.1 shows as passing after the next evaluation.
Evidence
- The Defender for Cloud page of each SQL server, showing Defender for SQL on
- The CIS v1.4.0 standard, with recommendation 4.2.1 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.