I'm facing an issue where I keep getting this error on our Azure Devops instance while running our yaml pipeline using the task AzureAppServiceSettings@1 to setup the connection strings for our DB server.
- task: AzureAppServiceSettings@1
displayName: 'Dev app service settings'
inputs:
azureSubscription: '**subscriptionName**'
appName: '**appName**'
resourceGroupName: '**resourceGroupName**'
connectionStrings: |
[
{
"name": "DefaultConneciton",
"value": "Server=tcp:**serverName**,1433;Initial Catalog=**dbName**;Persist Security Info=False;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Authentication=\"Active Directory Default\";",
"type": "SQLAzure",
"slotSetting": false
}
]
After running the task it throws this error:
##[error]Error: Failed to update App service 'appName' Connection Strings. Error: BadRequest - The parameter properties has an invalid value. (CODE: 400)
I've also tried editing the app settings through Azure Resource Explorer And had the same output:
{
"Code": "BadRequest",
"Message": "The parameter properties has an invalid value.",
"Target": null,
"Details": [
{
"Message": "The parameter properties has an invalid value."
},
{
"Code": "BadRequest"
},
{
"ErrorEntity": {
"ExtendedCode": "51008",
"MessageTemplate": "The parameter {0} has an invalid value.",
"Parameters": [
"properties"
],
"Code": "BadRequest",
"Message": "The parameter properties has an invalid value."
}
}
],
"Innererror": null
}
I'm being able to edit the connection string only trough the portal.