Advanced Threat Protection is disabled on SQL server Affecting Security Center service in Azure
Severity Framework
CCSS (Common Configuration Scoring System) is a set of measures used to determine the severity of the rule.
Snyk CCSS
Rule category
Each rule is associated with a high-level category. For example IAM, Container, Monitoring, Logging, Network, etc.
Monitoring/ Databases
Is your environment affected by this misconfiguration?
In a few clicks we can analyze your entire application and see what components are vulnerable in your application, and suggest you quick fixes.
Test your applicationsFrameworks
CIS-AzureCIS-Controls
- Snyk IDSNYK-CC-00590
- creditSnyk Research Team
Description
Advanced Threat Protection can identify potential SQL injection, access from an unusual location or data center, access from an unfamiliar principal or potentially harmful application, and brute force SQL credentials.
How to fix?
Set isEnabled to true to enable Advanced Threat Protection.
Example Configuration
{
"$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
"contentVersion": "1.0.0.0",
"resources": [
{
"type": "Microsoft.Security/advancedThreatProtectionSettings",
"apiVersion": "2019-01-01",
"name": "example-590-allowed1",
"properties": {
"isEnabled": "true"
}
}
]
}
Set enabled to true to enable Advanced Threat Protection.
Example Configuration
resource "azurerm_advanced_threat_protection" "allowed" {
target_resource_id = azurerm_storage_account.example590.id
enabled = true
}