# MSSQL node - Unable to connect all of a sudden

**URL:** <https://discourse.nodered.org/t/mssql-node-unable-to-connect-all-of-a-sudden/64731>\
**Category:** General\
**Created:** [5 July 2022 16:11 UTC](https://discourse.nodered.org/t/mssql-node-unable-to-connect-all-of-a-sudden/64731 "2022-07-05T16:11:09Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![SandeepA](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/sandeepa/32/63225_2.png) [@SandeepA](https://discourse.nodered.org/u/SandeepA)\
**Post date:** [5 July 2022 16:11 UTC](https://discourse.nodered.org/t/mssql-node-unable-to-connect-all-of-a-sudden/64731/1 "2022-07-05T16:11:09Z")

</div>

Hi ,

I am using MSSQL contrib node - extensively. All was working till a few hours back.  
And then all of a sudden - i have started getting 👎  
I have configuration to DB1 , DB2.  
My node was pointing to DB1.

I changed DB2 credentials - and made the node point to DB2. I got below errors.  
And now when i move the node back to DB1 - i am getting the below.

```auto
class: undefined

code: "ESOCKET"

lineNumber: undefined

message: "Failed to connect to XXXXX:62520 - Could not connect (sequence)"

details: "Failed to connect to XXXXXX:62520 - Could not connect (sequence)"

name: "ConnectionError"

number: undefined

procName: undefined

serverName: undefined

state: undefined

toString: function

```

I have tried recreating connection and everything. Nothing works.  
And the funny thing - the connection from another instance of NR which i did not disturb works to this DB1.

Any inputs will help.

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [5 July 2022 16:13 UTC](https://discourse.nodered.org/t/mssql-node-unable-to-connect-all-of-a-sudden/64731/2 "2022-07-05T16:13:57Z")

</div>

Which MSSQL node (and version) are you using (full node-red-contrib-xxxxxxxx) name please

Also, what version of nodejs and node-red?

---

<div class="post-metadata">

**Author:** ![SandeepA](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/sandeepa/32/63225_2.png) [@SandeepA](https://discourse.nodered.org/u/SandeepA)\
**Post date:** [5 July 2022 16:25 UTC](https://discourse.nodered.org/t/mssql-node-unable-to-connect-all-of-a-sudden/64731/3 "2022-07-05T16:25:40Z")

</div>

node-red-contrib-mssql-plus 0.7.3  
Node REd : 2.2.2

nodejs :

node -v  
v16.13.2

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [3 September 2022 16:26 UTC](https://discourse.nodered.org/t/mssql-node-unable-to-connect-all-of-a-sudden/64731/4 "2022-09-03T16:26:06Z")

</div>

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