How to set ConnectionString configuration for Azure App Service in Azure DevOps?

Question

I am deploying a website written in Asp.Net Core 2.2 which has a connection to an Azure Sql Database. Where do I set the Connection String in the Azure App Service deploy task in Azure DevOps?

In my WebApp, the DefaultConnection is in appsettings.json which works fine locally. I want to override this when deployed to Azure.

I tried setting -DefaultConnection $(DefaultConnection) in the Application and Configuration Settings section of the Azure App Service deploy task but the Connection String did not get set. The value is in a variable in Azure DevOps.

Where am I going wrong?

Put the connection string in a key vault. Retrieve the connection string from the key vault at runtime. — Daniel Mann, Jul 07 '19 at 03:26

score 8 · Answer 1 · answered Mar 17 '20 at 01:31

8

There is a new preview task Azure App Service Setting can help you with.

You can refer to this Deploy Connection Strings using Azure App Service Deploy #9017

answered Mar 17 '20 at 01:31

Huodong

523
8
23

score 2 · Answer 2 · edited Jul 09 '19 at 10:14

2

It may need you define the value of ConnectionString in the Azure app service.

This could not be configured in Variables if you want to set it in Configuration setting.

edited Jul 09 '19 at 10:14

IDarkCoder

709
7
18

answered Jul 09 '19 at 09:02

Amy

37
4

Adding the connection string there does not fix the problem. – Mark Allison Jul 10 '19 at 12:44

score -1 · Answer 3 · answered Oct 07 '19 at 05:58

-1

The parameter name used in the deployment should be ConnectionStrings_DefaultConnectionString as the appsettings.json uses this hierarchy for connection strings.

i.e. -ConnectionStrings_DefaultConnectionString $(DefaultConnection)

answered Oct 07 '19 at 05:58

Can Bilgin

471
2
6

Didn't work when I tried it , ended up with an AppSetting with the underscore in the name – Rob Sedgwick Nov 16 '21 at 13:06
Usually, setting nested variables like this [requires a double-underscore](https://learn.microsoft.com/en-us/azure/app-service/configure-common?tabs=portal). Regardless, this method doesn't work. – Mark Mar 24 '22 at 16:06

score -5 · Answer 4 · answered Jul 23 '19 at 01:40

-5

change it in appsettings.json , it should work

answered Jul 23 '19 at 01:40

user5419119

193
1
1
7

How to set ConnectionString configuration for Azure App Service in Azure DevOps?

4 Answers4