Compliancemanzill.com
CIS Microsoft Azure Foundations Benchmark v1.4.0

CIS Microsoft Azure Foundations Benchmark v1.4.0/Database Services/50 of 115

4.1.1Ensure that 'Auditing' is set to 'On'

Control family: Database Services

Control description

Enable auditing on SQL Servers.

How to implement

ResponsibilityCustomerYou configure and operate this in your own cloud accounts.

Auditing records the events on an Azure SQL server and its databases, such as logins, queries and permission changes, to storage or a Log Analytics workspace. Without it there is no record of who read or changed data. Turning it on at the server covers every database on it.

Before you start

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

  • Decide where SQL audit logs go (Log Analytics, storage or both), who may read them and how long they are kept (see 4.1.3).
  • Agree who reviews them.

Evidence

  • The database auditing standard

On Azure the tasks turn on auditing for each SQL server, then keep it checked with the CIS standard.

Task 1Turn on auditing for the server

  1. Sign in to the Azure portal at portal.azure.com and open SQL servers, then the server.
  2. Select Security > Auditing.
  3. Turn on Enable Azure SQL Auditing.
  4. Choose the destination: a Log Analytics workspace, a storage account (general-purpose v2 if behind a firewall) or both.
  5. Select Save.
  6. Check it: after some activity, audit records appear in the destination.

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 4.1.1.
  4. Open the assessment for Auditing on SQL server should be enabled and fix the resources it lists as non-compliant.
  5. Check it: every resource under recommendation 4.1.1 shows as passing after the next evaluation.

Evidence

  • Auditing of each SQL server, showing it on and its destination
  • The CIS v1.4.0 standard, with recommendation 4.1.1 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.