# MSSQL Node - Causes NR to keep crashing
**URL:** https://discourse.nodered.org/t/mssql-node-causes-nr-to-keep-crashing/64006
**Category:** General
**Created:** [16 June 2022 09:16 UTC](https://discourse.nodered.org/t/mssql-node-causes-nr-to-keep-crashing/64006 "2022-06-16T09:16:25Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@SandeepA](https://discourse.nodered.org/u/SandeepA)
#### Post date: [16 June 2022 09:16 UTC](https://discourse.nodered.org/t/mssql-node-causes-nr-to-keep-crashing/64006/1 "2022-06-16T09:16:25Z")
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 : [xxxx-appname-sqlsvr.database.windows.net](http://xxxx-appname-sqlsvr.database.windows.net/), 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/1.239.226.20220509-150249/any/nodejs/nodejsagent.js:2918:20)
at Object.b.safeInvoke (/opt/dynatrace/oneagent/agent/bin/1.239.226.20220509-150249/any/nodejs/nodejsagent.js:2990:41)
at Request.query (/opt/dynatrace/oneagent/agent/bin/1.239.226.20220509-150249/any/nodejs/nodejsagent.js:12178:15)
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) {
code: 'ECONNCLOSED'
As i last checked env has the credentials as env variables.
Assuming they are not enabled, will this result in NR crashing ?
---
### Author:  [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [16 June 2022 09:43 UTC](https://discourse.nodered.org/t/mssql-node-causes-nr-to-keep-crashing/64006/2 "2022-06-16T09:43:17Z")
> [@SandeepA](#):
>
> APPNAME\_DB, port : 1433, user :
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)
---
### Author:  [@SandeepA](https://discourse.nodered.org/u/SandeepA)
#### Post date: [16 June 2022 09:55 UTC](https://discourse.nodered.org/t/mssql-node-causes-nr-to-keep-crashing/64006/3 "2022-06-16T09:55:10Z")
> [@Steve-Mcl](#):
>
> Q: are you 100% certain this is crashing node-red?
Yes. Its in docker and pod keeps going down.
> [@Steve-Mcl](#):
>
> Q: When does this occur - after flows are started? (you didnt include full logs)
Will come back.
> [@Steve-Mcl](#):
>
> PS: PLEASE wrap code & logs etc in a code block (press the `` code button on forum toolbar THEN paste logs)
My bad. Will take care.
---
### Author:  [@SandeepA](https://discourse.nodered.org/u/SandeepA)
#### Post date: [16 June 2022 14:12 UTC](https://discourse.nodered.org/t/mssql-node-causes-nr-to-keep-crashing/64006/4 "2022-06-16T14:12:18Z")
> [@Steve-Mcl](#):
>
> Q: are you 100% certain this is crashing node-red?
Rechecked this. Hold the thought. May not something with SQLS. We will still investigating . Will keep you psted.
---
### Author:  [@system](https://discourse.nodered.org/u/system)
#### Post date: [15 August 2022 14:12 UTC](https://discourse.nodered.org/t/mssql-node-causes-nr-to-keep-crashing/64006/5 "2022-08-15T14:12:28Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.