Azure Bicep Deploy Error - The 'parameters.properties.storageAccountSubscriptionId' segment in the url is invalid.
insights Stats
warning Please login first to view stats information.
Kontext
Microsoft Azure
Data analytics, application development with Microsoft Azure cloud platform.
Issue context
When setting up Azure SQL database with auditing using Azure Blob Storage, you may encounter the following error:
The 'parameters.properties.storageAccountSubscriptionId' segment in the url is invalid.
The bicep resource code looks something like the following:
resource auditSettings 'Microsoft.Sql/servers/auditingSettings@2022-05-01-preview' = { parent: kontextSqlServer name: 'default' properties: { auditActionsAndGroups: [ 'SUCCESSFUL_DATABASE_AUTHENTICATION_GROUP' 'FAILED_DATABASE_AUTHENTICATION_GROUP' 'BATCH_COMPLETED_GROUP' ] isAzureMonitorTargetEnabled: false isDevopsAuditEnabled: false isManagedIdentityInUse: false isStorageSecondaryKeyInUse: false retentionDays: 0 state: 'Enabled' storageAccountSubscriptionId: subscription_id storageEndpoint: sql_audit_blob_endpoint } }
subcription_id
and sql_audit_blob_endpoint
are parameters of string type.
Fix the issue
After spending some time to debug this issue, I found the error occurred because the parameter for subscription_id
is null or empty. After I ensure it is passed into the template correctly, the issue is resolved automatically.
storageAccountSubscriptionId: subscription_id storageEndpoint: sql_audit_blob_endpoint
References
This error is different from the following one:
info Last modified by Kontext 2 years ago
copyright
This page is subject to Site terms.
comment Comments
No comments yet.