# Not able to connect mssql

**URL:** <https://discourse.nodered.org/t/not-able-to-connect-mssql/6111>\
**Category:** General\
**Created:** [24 December 2018 11:02 UTC](https://discourse.nodered.org/t/not-able-to-connect-mssql/6111 "2018-12-24T11:02:41Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![akhilendharreddy](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/akhilendharreddy/32/6953_2.png) [@akhilendharreddy](https://discourse.nodered.org/u/akhilendharreddy)\
**Post date:** [24 December 2018 11:02 UTC](https://discourse.nodered.org/t/not-able-to-connect-mssql/6111/1 "2018-12-24T11:02:41Z")

</div>

my host: 10.0._._\SQLEXPRESS, not able to connect to this db via mssql node

---

<div class="post-metadata">

**Author:** ![ukmoose](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ukmoose/32/13_2.png) [@ukmoose](https://discourse.nodered.org/u/ukmoose)\
**Post date:** [24 December 2018 11:13 UTC](https://discourse.nodered.org/t/not-able-to-connect-mssql/6111/2 "2018-12-24T11:13:46Z")

</div>

try with two \

---

<div class="post-metadata">

**Author:** ![akhilendharreddy](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/akhilendharreddy/32/6953_2.png) [@akhilendharreddy](https://discourse.nodered.org/u/akhilendharreddy)\
**Post date:** [24 December 2018 11:16 UTC](https://discourse.nodered.org/t/not-able-to-connect-mssql/6111/3 "2018-12-24T11:16:16Z")

</div>

@ukmoose tried still facing issue

---

<div class="post-metadata">

**Author:** ![ukmoose](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ukmoose/32/13_2.png) [@ukmoose](https://discourse.nodered.org/u/ukmoose)\
**Post date:** [24 December 2018 11:16 UTC](https://discourse.nodered.org/t/not-able-to-connect-mssql/6111/4 "2018-12-24T11:16:43Z")

</div>

then perhaps you could explain what you have tried?

---

<div class="post-metadata">

**Author:** ![akhilendharreddy](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/akhilendharreddy/32/6953_2.png) [@akhilendharreddy](https://discourse.nodered.org/u/akhilendharreddy)\
**Post date:** [24 December 2018 11:20 UTC](https://discourse.nodered.org/t/not-able-to-connect-mssql/6111/5 "2018-12-24T11:20:56Z")

</div>

@ukmoose tried '\' - two slashes  
using 10.0._._\SQLEXPRESS still ConnectionError: Connection is closed.

---

<div class="post-metadata">

**Author:** ![knolleary](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/knolleary/32/3_2.png) [@knolleary](https://discourse.nodered.org/u/knolleary)\
**Post date:** [24 December 2018 11:30 UTC](https://discourse.nodered.org/t/not-able-to-connect-mssql/6111/6 "2018-12-24T11:30:36Z")

</div>

Sorry, we cant debug this for you, especially when you haven't provided any details on what you have tried for yourself.

Have you checked your database allows external connections? Have you tried connecting with a different client? Lots of steps you could be taking for yourself.

---

<div class="post-metadata">

**Author:** ![akhilendharreddy](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/akhilendharreddy/32/6953_2.png) [@akhilendharreddy](https://discourse.nodered.org/u/akhilendharreddy)\
**Post date:** [24 December 2018 21:32 UTC](https://discourse.nodered.org/t/not-able-to-connect-mssql/6111/7 "2018-12-24T21:32:54Z")

</div>

@knolleary i am trying to connect mssql my config { user: "username",  
password: "password",  
server: "10.0._._\SQLEXPRESS",  
port:1433,  
database:"dbname",  
options: {  
encrypt: false  
}}

this is my config  
this mssql db has external connection able to connect from node js script using mssql npm, when i try to connect from node red keep getting Error: Global connection already exists. Call sql.close() first this error, please help me, i am using node-red-node-mssql in one flow, node-red-contrib-mssql-port in other flow

---

<div class="post-metadata">

**Author:** ![mauricio.lozornio](https://avatars.discourse-cdn.com/v4/letter/m/7993a0/32.png) [@mauricio.lozornio](https://discourse.nodered.org/u/mauricio.lozornio)\
**Post date:** [11 December 2019 23:05 UTC](https://discourse.nodered.org/t/not-able-to-connect-mssql/6111/8 "2019-12-11T23:05:53Z")

</div>

'Did you solve your problem? I have same too, is showing me "ConnectionError: Failed to connect to S04900814:1433 - getaddrinfo ENOTFOUND S04900814 S04900814:1433"