Compliancemanzill.com
CIS Microsoft Azure Foundations Benchmark v1.4.0

CIS Microsoft Azure Foundations Benchmark v1.4.0/Microsoft Defender for Cloud/26 of 115

2.4Ensure that Microsoft Defender for SQL servers on machines is set to 'On'

Control family: Microsoft Defender for Cloud

Control description

Turning on Microsoft Defender for SQL servers on machines enables threat detection for SQL servers on machines, providing threat intelligence, anomaly detection, and behavior analytics in the Microsoft Defender for Cloud.

How to implement

ResponsibilityCustomerYou configure and operate this in your own cloud accounts.

Defender for SQL servers on machines brings the same SQL threat detection and vulnerability assessment to SQL Server running on Azure VMs and on servers connected through Azure Arc. It is the second database type in the Databases plan.

Before you start

The same on every cloud, before the steps in the tabs.

  • Agree that the Databases (SQL servers on machines) plan is on in every subscription, including new ones, and who owns the alerts it raises.
  • List the SQL Server machines, including Azure Arc ones, so coverage can be checked.

Evidence

  • The Defender for Cloud standard: plans on and alert owners

On Azure the tasks turn on the Databases plan in Microsoft Defender for Cloud for each subscription, then keep it checked with the CIS standard.

Task 1Turn on the Databases plan

  1. Sign in to the Azure portal at portal.azure.com and open Microsoft Defender for Cloud.
  2. In the Defender for Cloud menu, select Environment settings, then the subscription to protect.
  3. On the Defender plans page, find Databases and set its status to On (or select Enable all).
  4. Select Select types (or Settings) on the Databases plan, turn on SQL servers on machines, and select Continue.
  5. Select Save.
  6. Check it: the Databases plan shows On for the subscription; repeat for every subscription.

Task 2Keep it checked with the CIS v1.4.0 standard in Defender for Cloud

  1. Open Microsoft Defender for Cloud > Regulatory compliance and select Manage compliance policies.
  2. Select the subscription, select Security policies, find CIS Microsoft Azure Foundations Benchmark v1.4.0 and toggle its status to On (once per subscription).
  3. Back on Regulatory compliance, open the CIS Microsoft Azure Foundations Benchmark v1.4.0 standard and expand recommendation 2.4.
  4. Open the assessment for Azure Defender for SQL servers on machines should be enabled and turn the plan on for any subscription it lists.
  5. Check it: every resource under recommendation 2.4 shows as passing after the next evaluation.

Evidence

  • Environment settings for each subscription, showing the Databases plan on
  • The CIS v1.4.0 standard in Defender for Cloud, with recommendation 2.4 passing

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.