Adding env variable to app service and to connect with azure sql azure database

Question

Adding environment variable to the app service with the name of the SQL server database to allow app service to connect with it. Please suggest how we can achieve this.

Answer 1

Hello Varma,

Thanks for your question.

To achieve this, you will need app settings

1. Click on the "Application settings" tab.
2. Scroll down to the "Application settings" section and click on "New application setting".
3. Enter the name for the env variable as well as value
4. In your code you can then retrieve the app settings how u want to

See: https://learn.microsoft.com/en-us/azure/app-service/reference-app-settings?tabs=kudu%2Cdotnet

You can mark it 'Accept Answer' and 'Upvote' if this helped you

Regards,

Abiola