# Node red can't connect sql server

**URL:** <https://discourse.nodered.org/t/node-red-cant-connect-sql-server/75327>\
**Category:** General\
**Created:** [17 February 2023 06:44 UTC](https://discourse.nodered.org/t/node-red-cant-connect-sql-server/75327 "2023-02-17T06:44:02Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![komkitPP](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/komkitpp/32/76273_2.png) [@komkitPP](https://discourse.nodered.org/u/komkitPP)\
**Post date:** [17 February 2023 06:44 UTC](https://discourse.nodered.org/t/node-red-cant-connect-sql-server/75327/1 "2023-02-17T06:44:02Z")

</div>

How to solve the problem

-- node-red version 3.0.2

-- node version 18.3.0

-- use sql server management version 18.0.1

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/6/3/634f6cfc8125b7d86b12c06a94a2b9917fbc3be9.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:** [17 February 2023 06:53 UTC](https://discourse.nodered.org/t/node-red-cant-connect-sql-server/75327/2 "2023-02-17T06:53:17Z")

</div>

Firstly, I would remove that very old and unsupported node & install the newer node-red-contrib-mssql-plus node.

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [17 February 2023 07:09 UTC](https://discourse.nodered.org/t/node-red-cant-connect-sql-server/75327/3 "2023-02-17T07:09:21Z")

</div>

You have your node-red and node versions switched. You can edit your post and correct them

---

<div class="post-metadata">

**Author:** ![komkitPP](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/komkitpp/32/76273_2.png) [@komkitPP](https://discourse.nodered.org/u/komkitPP)\
**Post date:** [17 February 2023 11:26 UTC](https://discourse.nodered.org/t/node-red-cant-connect-sql-server/75327/4 "2023-02-17T11:26:32Z")

</div>

what SQL Server Version you use.

---

<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:** [17 February 2023 13:21 UTC](https://discourse.nodered.org/t/node-red-cant-connect-sql-server/75327/5 "2023-02-17T13:21:14Z")

</div>

I'm not. Last time I used SQL Server it was with a 2019 server.

Did you replace the old MSSQL node with the newer [node-red-contrib-mssql-plus](https://flows.nodered.org/node/node-red-contrib-mssql-plus) node?

---

<div class="post-metadata">

**Author:** ![komkitPP](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/komkitpp/32/76273_2.png) [@komkitPP](https://discourse.nodered.org/u/komkitPP)\
**Post date:** [17 February 2023 13:34 UTC](https://discourse.nodered.org/t/node-red-cant-connect-sql-server/75327/6 "2023-02-17T13:34:24Z")

</div>

Yes, but not work

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/c/5/c503c1e3a94ba7e83e83a84b90035c8d63c832d9.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:** [17 February 2023 15:34 UTC](https://discourse.nodered.org/t/node-red-cant-connect-sql-server/75327/7 "2023-02-17T15:34:06Z")

</div>

OK, some questions...

1. Please clarify the exact version of SQL Server  
[History of Microsoft SQL Server - Wikipedia](https://en.wikipedia.org/wiki/History_of_Microsoft_SQL_Server)

2. Where is node-red running? On the same computer as SQL Server?

3. Have you enabled SQL Server Authentication mode?  
[https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/change-server-authentication-mode?view=sql-server-ver16](https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/change-server-authentication-mode?view=sql-server-ver16)

4. When you use SSMS to connect, did you use the SQL Server Authentication User+Password (e.g. `sa`)?

---

<div class="post-metadata">

**Author:** ![komkitPP](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/komkitpp/32/76273_2.png) [@komkitPP](https://discourse.nodered.org/u/komkitPP)\
**Post date:** [18 February 2023 08:11 UTC](https://discourse.nodered.org/t/node-red-cant-connect-sql-server/75327/8 "2023-02-18T08:11:17Z")

</div>

1.ssms version 19.0.1  
2.yes run same computer  
3.enable  
4.yes i use sa and change password

---

<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:** [18 February 2023 08:25 UTC](https://discourse.nodered.org/t/node-red-cant-connect-sql-server/75327/9 "2023-02-18T08:25:22Z")

</div>

Ok so a SQL instance doesn't get port 1433

Connect to your SQL server and check the start up log. You should see the port number assigned. Try using that instead of 1433 in the connection config

---

<div class="post-metadata">

**Author:** ![komkitPP](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/komkitpp/32/76273_2.png) [@komkitPP](https://discourse.nodered.org/u/komkitPP)\
**Post date:** [18 February 2023 08:36 UTC](https://discourse.nodered.org/t/node-red-cant-connect-sql-server/75327/10 "2023-02-18T08:36:50Z")

</div>

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/7/5/75a7dd17d55dccd6bd495ed41e2f32f62b2ae525.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:** [18 February 2023 08:39 UTC](https://discourse.nodered.org/t/node-red-cant-connect-sql-server/75327/11 "2023-02-18T08:39:39Z")

</div>

As I said...

> [@Steve-Mcl](#):
>
> a SQL instance doesn't get port 1433

So look in the SQL logs using ssms to find the actual port being used by your instance.

---

<div class="post-metadata">

**Author:** ![komkitPP](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/komkitpp/32/76273_2.png) [@komkitPP](https://discourse.nodered.org/u/komkitPP)\
**Post date:** [18 February 2023 08:55 UTC](https://discourse.nodered.org/t/node-red-cant-connect-sql-server/75327/12 "2023-02-18T08:55:33Z")

</div>

Port 1433 I use every Time when i use Sql

---

<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:** [18 February 2023 09:02 UTC](https://discourse.nodered.org/t/node-red-cant-connect-sql-server/75327/13 "2023-02-18T09:02:52Z")

</div>

Ok that's cool but...

#### Microsoft documentation...

> If enabled, the default instance of the SQL Server Database Engine listens on TCP port 1433. Named instances of the Database Engine and SQL Server Compact are configured for dynamic ports

So, did you do what I said?

Also, try removing the `/instancename` part

See here where I helped others connect to an instance: [Problem connecting to mssql express · Issue #63 · bestlong/node-red-contrib-mssql-plus · GitHub](https://github.com/bestlong/node-red-contrib-mssql-plus/issues/63#issuecomment-1068399367)

---

<div class="post-metadata">

**Author:** ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)\
**Post date:** [18 February 2023 09:36 UTC](https://discourse.nodered.org/t/node-red-cant-connect-sql-server/75327/14 "2023-02-18T09:36:07Z")

</div>

Also you still don't seem to be trying the node Steve recommended  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/8/4/849f95353f572b695542bc38da6883c07d9552c1.png)

---

<div class="post-metadata">

**Author:** ![komkitPP](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/komkitpp/32/76273_2.png) [@komkitPP](https://discourse.nodered.org/u/komkitPP)\
**Post date:** [18 February 2023 11:36 UTC](https://discourse.nodered.org/t/node-red-cant-connect-sql-server/75327/15 "2023-02-18T11:36:53Z")

</div>

why dynamic port 0

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/c/4/c4a5a080574e0925100cfd4d44e8461379842a9b.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:** [18 February 2023 11:50 UTC](https://discourse.nodered.org/t/node-red-cant-connect-sql-server/75327/16 "2023-02-18T11:50:57Z")

</div>

@komkitPP that is how instances are setup by default.

If you want to connect to an instance you need to find the port number.

That will be listed in the SQL logs as I have pointed out time and time again.

> [@Steve-Mcl](#):
>
> Connect to your SQL server and check the start up log. You should see the port number assigned. Try using that instead of 1433 in the connection config

> [@Steve-Mcl](#):
>
> As I said...
> 
> > [@Steve-Mcl](#):
> >
> > a SQL instance doesn't get port 1433
> 
> So look in the SQL logs using ssms to find the actual port being used

> [@Steve-Mcl](#):
>
> So, did you do what I said?
> 
> Also, try removing the `/instancename` part
> 
> See here where I helped others connect to an instance: [Problem connecting to mssql express · Issue #63 · bestlong/node-red-contrib-mssql-plus · GitHub](https://github.com/bestlong/node-red-contrib-mssql-plus/issues/63#issuecomment-1068399367)

  

Until you do this I can not help any further.

---

<div class="post-metadata">

**Author:** ![komkitPP](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/komkitpp/32/76273_2.png) [@komkitPP](https://discourse.nodered.org/u/komkitPP)\
**Post date:** [18 February 2023 15:25 UTC](https://discourse.nodered.org/t/node-red-cant-connect-sql-server/75327/17 "2023-02-18T15:25:20Z")

</div>

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/f/d/fdab29b8a7e37f4d8400b59ef597a85c6c148edc.png)  
This is port

---

<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:** [18 February 2023 15:45 UTC](https://discourse.nodered.org/t/node-red-cant-connect-sql-server/75327/18 "2023-02-18T15:45:19Z")

</div>

> [@komkitPP](#):
>
> ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/f/d/fdab29b8a7e37f4d8400b59ef597a85c6c148edc.png)

> [@Steve-Mcl](#):
>
> Also, try removing the `/instancename` part

remove the instance name as I said earlier and as it says in the linked GitHub issue.

---

<div class="post-metadata">

**Author:** ![komkitPP](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/komkitpp/32/76273_2.png) [@komkitPP](https://discourse.nodered.org/u/komkitPP)\
**Post date:** [18 February 2023 16:05 UTC](https://discourse.nodered.org/t/node-red-cant-connect-sql-server/75327/19 "2023-02-18T16:05:34Z")

</div>

Sorry, Where is instance name

---

<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:** [18 February 2023 16:22 UTC](https://discourse.nodered.org/t/node-red-cant-connect-sql-server/75327/20 "2023-02-18T16:22:09Z")

</div>

![Screenshot_20230218-162005](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/f/a/fa74c062c6df418e9116fc20e9f2b7473b04a2a6.png)

[Next page](https://discourse.nodered.org/t/node-red-cant-connect-sql-server/75327.md?page=2)