You might see “Set SQL Vulnerability assessment” failure in Activity log of Azure SQL Server. And in the details error, we will see below eror
{
"status": {
"value": "Failed",
"localizedValue": "Failed"
},
"subStatus": {
"value": "Conflict",
"localizedValue": "Conflict (HTTP Status Code: 409)"
},
"statusMessage": "{
"error": {
"code": "SqlVulnerabilityAssessmentStoragefullApiIsEnabled",
"message": "Vulnerability Assessment is enabled on this server or one of its underlying databases with an incompatible version. Additional troubleshooting information can be found https://aka.ms/SQLVAStoragelessDocumentation. "
}
}
}
This “error” is coming from a background process of Microsoft Defender for Cloud that’s verifying the configurations for Express enabled databases. If the resource is on Classic configuration, you get this error.
Solution: Migrate from Classic configuration to Express configuration at Subscription level.
SQLVAStoragelessDocumentation introduced the difference between the express and classic configuration of SQL vulnerability assessment.
文档信息
- 本文作者:Robin Chen
- 本文链接:https://crushonme.github.io/2025/05/15/Set-SQL-Vulnerability-assessment-failure/
- 版权声明:自由转载-非商用-非衍生-保持署名(创意共享4.0许可证)
Document Information
- Author :Robin Chen
- Link : https://crushonme.github.io/2025/05/15/Set-SQL-Vulnerability-assessment-failure/
- Copyright:Attribution-NonCommercial-NoDerivatives-No additional restrictions(CC BY-NC-ND 4.0)
Related Issues not found
Please contact @crushonme to initialize the comment