Web/sites/config Connection strings issue

[MaciekSondej]

Hi
I wanted to parametrise connection string to update webapp(web/site) after deployment
I want to use connectionStrings properties NOT appsettings

So I do have 2 Connection string for a webApp:
var conStrSB= {
name: 'ServiceBus'
connectionString: '@Microsoft.KeyVault(VaultName=kvname;SecretName=SBSecret)'
type: 'Custom'
}
var conStrSQL= {
name: 'EsbDbConnection'
connectionString: '@Microsoft.KeyVault(VaultName=kvName;SecretName=SQLSecret)'
type: 'SQLAzure'
}

And I wanted to inject them into WebApp

I've tried the 'old' way for appSettings:
e.g.
resource webSiteConnectionStrings 'Microsoft.Web/sites/config@2021-03-01' = {
name: '${webAppName}/connectionstrings'
properties: conStrSB
}

or recommended in ms docs:

resource appServiceApp 'Microsoft.Web/sites@2020-06-01' existing = {
name: webAppName
}

resource symbolicname 'Microsoft.Web/sites/config@2021-03-01' = {
name: 'connectionstrings'
kind: 'string'
parent: appServiceApp
properties: connStrings
}

but it throws meaningless errors..

Can you please advise how to inject connection strings?

Preferably I would like to inject array of connectonstring like:
var connStrArray = [
{
name: 'ServiceBus'
connectionString: '@Microsoft.KeyVault(VaultName=kvname;SecretName=SBSecret)'
type: 'Custom'
}
{
name: 'EsbDbConnection'
connectionString: '@Microsoft.KeyVault(VaultName=kvName;SecretName=SQLSecret)'
type: 'SQLAzure'
}
]

which seems to be most natural way of putting series of connection strings to webapp

[brwilkinson]

You can try below

resource webSite 'Microsoft.Web/sites@2021-03-01' existing = {
  name: 'acu1-brw-aoa-t5-be'
}

resource connectionstrings 'Microsoft.Web/sites/config@2021-03-01' = {
  name: 'connectionstrings'
  parent: webSite
  properties: {
    SQL01: {
      value: 'teststringconnetionvalue2'
      type: 'SQLServer'
    }
  }
}

The specification is here: https://docs.microsoft.com/en-us/azure/templates/microsoft.web/sites/config-connectionstrings?tabs=bicep

[brwilkinson]

Hi @MaciekSondej please let us know if the above example works for you?

[Lampei]

Worked like a charm! Might be useful if added to the azure quickstarts
https://github.com/Azure/azure-quickstart-templates/tree/master/quickstarts/microsoft.web

[brwilkinson]

adding @johndowns to note down the sample request for web sites config 'connectionstring'.

[brwilkinson]

looks like we do have an example here:

• https://github.com/Azure/azure-quickstart-templates/blob/master/quickstarts/microsoft.web/web-app-managed-identity-sql-db/main.bicep#L80

Slightly different, since it was implemented as a nested resource, instead of using parent.

  resource connectionString 'config@2020-12-01' = {
    name: 'connectionstrings'
    properties: {
      DefaultConnection: {
        value: 'Data Source=tcp:${sqlserver.properties.fullyQualifiedDomainName},1433;Initial Catalog=${sqlserver::database.name};User Id=${sqlserver.properties.administratorLogin}@${sqlserver.properties.fullyQualifiedDomainName};Password=${sqlAdministratorPassword};'
        type: 'SQLAzure'
      }
    }
  }
}

[dileepainivossl]

when I try to add the configuration like this

  {
          name: 'ConnectionStrings:DefaultConnection'
          value: dbConnectionString
        }

it throws error

AppSetting with name 'ConnectionStrings:DefaultConnection' is not allowed

[ahelland]

I don't know if you run on Linux or Windows, but in general the format used when pushing appsettings through code would be ConnectionString__DefaultConnection.

https://learn.microsoft.com/en-us/aspnet/core/fundamentals/configuration/?view=aspnetcore-8.0#non-prefixed-environment-variables