I have successfully run a Node.js Webapp on Azure, which is connecting to an Azure SQL DB. Everything is working fine when entering the DB details manually into the code.

The issue es when I try and use the connection details as environment variables.

My Node.js connection looks like this:

const config = {
user: `${APPSETTING_user}`,
password: `${APPSETTING_pw}`,
server: `${APPSETTING_host}`,
database: `${APPSETTING_db}`,
options: 
 {
  encrypt: true
 }
};

In the Azure Webapp, I have done the following:

• Application Settings > App Settings

Entered the following:

• Key: user, Value: {db user login}
• Key: pw, Value: {my password}
• Key: host, Value: {SQL server address}
• Key: db, Value: {db name>}

Correct working values in plain text without curly brackets obviously.

I am getting an error on load that is cannot find db server: ${APPSETTING_host}

I have been looking through documentation and tutorials, which is limited or out of date on this - however from what I have read apparently I am doing it correctly?

I have successfully run a Node.js Webapp on Azure, which is connecting to an Azure SQL DB. Everything is working fine when entering the DB details manually into the code.

The issue es when I try and use the connection details as environment variables.

My Node.js connection looks like this:

const config = {
user: `${APPSETTING_user}`,
password: `${APPSETTING_pw}`,
server: `${APPSETTING_host}`,
database: `${APPSETTING_db}`,
options: 
 {
  encrypt: true
 }
};

In the Azure Webapp, I have done the following:

• Application Settings > App Settings

Entered the following:

• Key: user, Value: {db user login}
• Key: pw, Value: {my password}
• Key: host, Value: {SQL server address}
• Key: db, Value: {db name>}

Correct working values in plain text without curly brackets obviously.

I am getting an error on load that is cannot find db server: ${APPSETTING_host}

I have been looking through documentation and tutorials, which is limited or out of date on this - however from what I have read apparently I am doing it correctly?

• javascript
• node.js
• azure
• azure-sql-database
• azure-web-app-service

1 Answer 1

You need to use process.env.ENV_VARIABLE to read environment variables in Node. So in your case, it would be process.env.user, process.env.pw, etc...

See Read environment variables in Node.js for details.