# ConnectionError SQL SERVER 19

**URL:** <https://discourse.nodered.org/t/connectionerror-sql-server-19/38993>\
**Category:** General\
**Created:** [12 January 2021 10:21 UTC](https://discourse.nodered.org/t/connectionerror-sql-server-19/38993 "2021-01-12T10:21:34Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mattia.88](https://avatars.discourse-cdn.com/v4/letter/m/898d66/32.png) [@Mattia.88](https://discourse.nodered.org/u/Mattia.88)\
**Post date:** [12 January 2021 10:21 UTC](https://discourse.nodered.org/t/connectionerror-sql-server-19/38993/1 "2021-01-12T10:21:35Z")

</div>

Goog morning,  
i have some problem with sql server (in local pc), using "node-red-contrib-mssql":

"ConnectionError: Failed to connect to LM-NBK-03:undefined in 15000ms"

My instance name is: LM-NBK-03\DEV19

Problably the problem is the port "undefined

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/e/1/e12a4b179f98111e96e746e1da7062c37539fffc.png)  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/3/5/3598a5b1413bdaa9994011b0f47e2b8c02b13db9.png)  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/e/d/ed97158defab177e016e1df6188c6dc1b69445b6.png)

Help please!

---

<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:** [12 January 2021 11:16 UTC](https://discourse.nodered.org/t/connectionerror-sql-server-19/38993/2 "2021-01-12T11:16:37Z")

</div>

> [@Mattia.88](#):
>
> using "node-red-contrib-mssql":

Try `node-red-contrib-mssql-plus` instead (that other `node-red-contrib-mssql` is pretty much dead, is missing many features & has bugs)

---

<div class="post-metadata">

**Author:** ![Mattia.88](https://avatars.discourse-cdn.com/v4/letter/m/898d66/32.png) [@Mattia.88](https://discourse.nodered.org/u/Mattia.88)\
**Post date:** [12 January 2021 11:41 UTC](https://discourse.nodered.org/t/connectionerror-sql-server-19/38993/3 "2021-01-12T11:41:44Z")

</div>

> [@Steve-Mcl](#):
>
> node-red-contrib-mssql-plus

The problem is same:

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/1/a/1a8c8882ca15d0aaa4976482b36077591fa42f58.png)

---

<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:** [12 January 2021 11:45 UTC](https://discourse.nodered.org/t/connectionerror-sql-server-19/38993/4 "2021-01-12T11:45:13Z")

</div>

Questions...

1. Did you remove `node-red-contrib-mssql` and restart node-red?

2. Can you (from the node-red server) PING `LM-NBK-03`

## From the tedious website...

### SQL Server Configurations

Ensure SQL Server Browser and [SQL Server Agent is running](https://stackoverflow.com/questions/11632849/how-to-check-if-sql-server-agent-is-running) (Agent can only run on SQL Server Developer/Enterprise, NOT SQL Server Express).

[Enable TCP/IP port](https://www.habaneroconsulting.com/stories/insights/2015/tcpip-is-disabled-by-default-in-microsoft-sql-server-2014) via SQL Configuration Manager ( `C:\Windows\SysWOW64\SQLServerManager14.msc` for windows).

Ensure user is enabled: SQL Server Management Studio -\> Security -\> logins -\> enable user

---

<div class="post-metadata">

**Author:** ![Mattia.88](https://avatars.discourse-cdn.com/v4/letter/m/898d66/32.png) [@Mattia.88](https://discourse.nodered.org/u/Mattia.88)\
**Post date:** [12 January 2021 13:59 UTC](https://discourse.nodered.org/t/connectionerror-sql-server-19/38993/5 "2021-01-12T13:59:24Z")

</div>

Ok now is ok.

The SQL Server Browser was not active. Sorry!

Thanks

---

<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:** [26 January 2021 13:59 UTC](https://discourse.nodered.org/t/connectionerror-sql-server-19/38993/6 "2021-01-26T13:59:25Z")

</div>

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