Hello Mahmoodi, Somayeh (Admin)
The ARM template generated by Azure includes a resource for SQL Vulnerability Assessment with a property vulnerabilityAssessments_Default_storageContainerPath. As you don't want vulnerability assessment enabled on the new SQL resources and cannot find a value for this property in the API playground. Removing the property and section caused a deployment error:\ “The content for this response was already consumed.”
- The template includes a resource of type
Microsoft.Sql/servers/vulnerabilityAssessments. - This resource requires
storageContainerPathbecause vulnerability assessment stores scan results in a storage account. - Even if scans are disabled, the schema still expects this property.
- Removing only the property (or leaving references in
dependsOnorparameters) makes the template invalid, causing deployment failure. - Checked API Playground → property not found (because VA was never enabled).
- Removed the property and section → error occurred due to broken dependencies and missing required fields.
To resolve this or as a workaround you have two options:
Option 1: Remove Vulnerability Assessment Completely
- Delete the entire resource block and Validate no other resource references this parameter.
Your template should look like below:
{
"type": "Microsoft.Sql/servers",
"apiVersion": "2024-05-01-preview",
"name": "[parameters('servers_server_2_name')]",
"location": "[parameters('location')]",
"properties": {
"administratorLogin": "[parameters('administratorLogin')]",
"administratorLoginPassword": "[parameters('administratorLoginPassword')]",
"version": "12.0"
}
}
Here remove the block as shown below:
Parameter: vulnerabilityAssessments_Default_storageContainerPath
Any dependsOn referencing vulnerability assessment.
{
"type": "Microsoft.Sql/servers/vulnerabilityAssessments",
"apiVersion": "2024-05-01-preview",
"name": "[concat(parameters('servers_server_2_name'), '/Default')]",
...
}
Option 2: Keep It but Disable Properly
If you want to keep the resource for compliance or template consistency:
-
isEnabledisfalsescans won’t run. -
storageContainerPathis required by schema use empty string or dummy URL.
This satisfies schema validation, and scans won’t run because they’re disabled.
The property only appears when vulnerability assessment is explicitly configured. If it was never enabled, the API won’t return it.
So, If you don’t need vulnerability assessment, remove the resource entirely or If you need to keep the structure, use a placeholder for storageContainerPath.
{
"type": "Microsoft.Sql/servers/vulnerabilityAssessments",
"apiVersion": "2024-05-01-preview",
"name": "[concat(parameters('servers_server_2_name'), '/Default')]",
"dependsOn": [
"[resourceId('Microsoft.Sql/servers', parameters('servers_server_2_name'))]"
],
"properties": {
"recurringScans": {
"isEnabled": false,
"emailSubscriptionAdmins": true
},
"storageContainerPath": ""
// Alternatively, use a dummy value:
// "storageContainerPath": "https://dummy.blob.core.windows.net/container"
}
}
If you have any queries, please feel free to reach out.
Thanks,
Suchitra.