MSSQL Node - Causes NR to keep crashing

Hi ,

On MSSQL Node - i see below errors in my console log.

Per past discussion for keeping MSSQL credentials across envs - we stored {MY_USER} and {MY_PASS} in cred file and have moved it other env. Problem is NR doesnt even come up.
On startup - we see below MSSQL node errors by the process :-

14 Jun 05:44:38 - [info] [MSSQL-CN:APPNAME] Error connecting to server :, database : APPNAME_DB, port : 1433, user :
ConnectionError: Connection is closed.
at Request._query (/usr/src/node-red/node_modules/mssql/lib/base/request.js:497:37)
at Request._query (/usr/src/node-red/node_modules/mssql/lib/tedious/request.js:367:11)
at /usr/src/node-red/node_modules/mssql/lib/base/request.js:461:12
at new Promise ()
at Request.query (/usr/src/node-red/node_modules/mssql/lib/base/request.js:460:12)
at dynatraceRegularInvoke (/opt/dynatrace/oneagent/agent/bin/
at Object.b.safeInvoke (/opt/dynatrace/oneagent/agent/bin/
at Request.query (/opt/dynatrace/oneagent/agent/bin/
at connection.node.execSql (/usr/src/node-red/node_modules/node-red-contrib-mssql-plus/src/mssql.js:423:40)
at doSQL (/usr/src/node-red/node_modules/node-red-contrib-mssql-plus/src/mssql.js:779:25) {

As i last checked env has the credentials as env variables.
Assuming they are not enabled, will this result in NR crashing ?

Looks like you are not picking up the user name

Q: are you 100% certain this is crashing node-red?
Q: When does this occur - after flows are started? (you didnt include full logs)

PS: PLEASE wrap code & logs etc in a code block (press the </> code button on forum toolbar THEN paste logs)

Yes. Its in docker and pod keeps going down.

Will come back.

My bad. Will take care.

Rechecked this. Hold the thought. May not something with SQLS. We will still investigating . Will keep you psted.

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.