Azure Microsoft Defender for Cloud is set to Off for SQL servers on machines misconfiguration detect

Rule Details

Cortex AppSec Rule ID	APPSEC_AZURE_79
Category - Subcategory	Monitoring - Alerting And Notifications
Provider	AZURE
Severity	LOW
Framework	ARM, Bicep, Terraform, Terraform Plan
Mapped CSPM/KSPM Rule	d0d41a3f-5c0d-4d6e-8559-2d44298a36ed

Impact

Azure Defender is a cloud workload protection service that utilizes and agent-based deployment to analyze signals from Azure network fabric and the service control plane, to detect threats across all Azure resources. It can also analyze non-Azure resources, utilizing Azure Arc, including those on-premises and in both AWS and GCP (once they've been onboarded). Azure Defender for SQL servers on machines extends the protections for your Azure-native SQL Servers to fully support hybrid environments and protect SQL servers (all supported version) hosted in Azure.

How to Fix

Resource: azurerm_security_center_subscription_pricing

• Arguments: resource_type - (Required) The resource type this setting affects. Ensure that SqlServers and SqlServerVirtualMachines are declared to pass this check. [source,go]

---

resource "azurerm_security_center_subscription_pricing" "example" { tier = "Standard" resource_type = "AppServices,ContainerRegistry,KeyVaults,KubernetesService,SqlServers,SqlServerVirtualMachines,StorageAccounts,VirtualMachines,ARM,DNS" }