In Visual Studio Code, in the Azure explorer, right-click your App Service and select Open in portal.
Navigate to the Configuration page for your App Service. Under the Application Settings tab, create environment variables for each property in the following table, with your own values.
AZURE_SQL_SERVER=<YOURSERVERNAME>.database.windows.net AZURE_SQL_DATABASE=<YOURDATABASENAME> AZURE_SQL_PORT=1433 AZURE_SQL_USER=<YOURUSERNAME> AZURE_SQL_PASSWORD=<PASSWORD> NODE_ENV=development
Warning
Use caution when managing connection objects that contain secrets such as usernames, passwords, or access keys. These secrets shouldn't be committed to source control or placed in unsecure locations where they might be accessed by unintended users. For a real application in a production-grade Azure environment, you can store connection information in a secure location such as App Service configuration settings or Azure Key Vault. During local development, you'll generally connect to a local database that doesn't require storing secrets or connecting directly to Azure.
