# I have issue when i connect MSSQL with Node Red

**URL:** <https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691>\
**Category:** General\
**Tags:** node-red-dashboard\
**Created:** [16 May 2022 12:42 UTC](https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691 "2022-05-16T12:42:24Z")\
**Posts on this page:** 19\
**Page:** 4

<div class="post-metadata">

**Author:** ![Fathi2022](https://avatars.discourse-cdn.com/v4/letter/f/b487fb/32.png) [@Fathi2022](https://discourse.nodered.org/u/Fathi2022)\
**Post date:** [19 May 2022 15:34 UTC](https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691/61 "2022-05-19T15:34:51Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Fathi2022](https://avatars.discourse-cdn.com/v4/letter/f/b487fb/32.png) [@Fathi2022](https://discourse.nodered.org/u/Fathi2022)\
**Post date:** [19 May 2022 15:35 UTC](https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691/62 "2022-05-19T15:35:04Z")

</div>

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/8/8/88483c24ca161b3d077bed36b4c8b5edbd708b3e.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:** [19 May 2022 16:10 UTC](https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691/63 "2022-05-19T16:10:27Z")

</div>

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/2/2/2262aebadef29f2147d2a1eaf145cef84702f6b9.png)

Do this 👆

Read this 👉https://stackoverflow.com/questions/1339944/cant-connect-to-localhost-but-can-with-computer-name-in-sql-server-2008

---

<div class="post-metadata">

**Author:** ![Fathi2022](https://avatars.discourse-cdn.com/v4/letter/f/b487fb/32.png) [@Fathi2022](https://discourse.nodered.org/u/Fathi2022)\
**Post date:** [19 May 2022 17:25 UTC](https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691/64 "2022-05-19T17:25:34Z")

</div>

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/b/2/b2cd19023ccdda236d734253bd01460b34f89286.png)

---

<div class="post-metadata">

**Author:** ![Fathi2022](https://avatars.discourse-cdn.com/v4/letter/f/b487fb/32.png) [@Fathi2022](https://discourse.nodered.org/u/Fathi2022)\
**Post date:** [19 May 2022 17:26 UTC](https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691/65 "2022-05-19T17:26:43Z")

</div>

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/c/3/c366b01331497db7738e82340e063b6434c66539.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:** [19 May 2022 17:39 UTC](https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691/66 "2022-05-19T17:39:16Z")

</div>

`.` Cannot be used. Try 127.0.0.1\SQLEXPRESS03

---

<div class="post-metadata">

**Author:** ![Fathi2022](https://avatars.discourse-cdn.com/v4/letter/f/b487fb/32.png) [@Fathi2022](https://discourse.nodered.org/u/Fathi2022)\
**Post date:** [19 May 2022 17:44 UTC](https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691/67 "2022-05-19T17:44:36Z")

</div>

> [@Steve-Mcl](#):
>
> 127.0.0.1\SQLEXPRESS03

its request

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/c/e/ce083b538fdb27b52dd266962881f29a0e8576a3.png)

then

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/2/3/23afcd75c11392667fcfe38a55b4841b42ec9c7d.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:** [19 May 2022 18:44 UTC](https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691/68 "2022-05-19T18:44:28Z")

</div>

If you use SSMS, does `127.0.0.1\SQLEXPRESS03` work?

Can you also try SSMS to `10.12.37.172\SQLEXPRESS03` does that work?

Also, check the Event Log to double check there are no TCP errors for instance `SQLEXPRESS03` and also double check the PORT number it assigned

Also, i have said several times, I dont know if built in auth works - I ABSOLUTELY know that SQL Auth works.

---

<div class="post-metadata">

**Author:** ![Fathi2022](https://avatars.discourse-cdn.com/v4/letter/f/b487fb/32.png) [@Fathi2022](https://discourse.nodered.org/u/Fathi2022)\
**Post date:** [24 May 2022 13:07 UTC](https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691/69 "2022-05-24T13:07:00Z")

</div>

> [@Steve-Mcl](#):
>
> does `127.0.0.1\SQLEXPRESS03` work

does ` not work when I use 127.0.0.1\SQLEXPRESS03` and 10.12.37.172\SQLEXPRESS03

---

<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:** [24 May 2022 13:08 UTC](https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691/70 "2022-05-24T13:08:56Z")

</div>

> [@Fathi2022](#):
>
> does ` not work when I use 127.0.0.1\SQLEXPRESS03`

I asked you to try this in SSMS - Are you saying if you open SSMS (SQL Server Management Studio) that you CAN NOT connect to either `127.0.0.1\SQLEXPRESS03` or `10.12.37.172\SQLEXPRESS03` ?

---

<div class="post-metadata">

**Author:** ![Fathi2022](https://avatars.discourse-cdn.com/v4/letter/f/b487fb/32.png) [@Fathi2022](https://discourse.nodered.org/u/Fathi2022)\
**Post date:** [24 May 2022 13:10 UTC](https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691/71 "2022-05-24T13:10:16Z")

</div>

how can i check if TCP errors for instance `SQLEXPRESS03` and also double check the PORT number it assigned?

---

<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:** [24 May 2022 13:10 UTC](https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691/72 "2022-05-24T13:10:57Z")

</div>

please confirm the previous question first.

---

<div class="post-metadata">

**Author:** ![Fathi2022](https://avatars.discourse-cdn.com/v4/letter/f/b487fb/32.png) [@Fathi2022](https://discourse.nodered.org/u/Fathi2022)\
**Post date:** [24 May 2022 13:57 UTC](https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691/73 "2022-05-24T13:57:58Z")

</div>

> [@Steve-Mcl](#):
>
> 10.12.37.172\

i cant connect both of them ( `127.0.0.1\SQLEXPRESS03` or `10.12.37.172\SQLEXPRESS03`)

do I can connect ./SQLEXPRESS03

---

<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:** [24 May 2022 14:00 UTC](https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691/74 "2022-05-24T14:00:18Z")

</div>

> [@Fathi2022](#):
>
> ./SQLEXPRESS03

ah, ok, so my fault.

Can you connect `127.0.0.1/SQLEXPRESS03` or `10.12.37.172/SQLEXPRESS03` from SSMS?

---

<div class="post-metadata">

**Author:** ![Fathi2022](https://avatars.discourse-cdn.com/v4/letter/f/b487fb/32.png) [@Fathi2022](https://discourse.nodered.org/u/Fathi2022)\
**Post date:** [24 May 2022 14:00 UTC](https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691/75 "2022-05-24T14:00:37Z")

</div>

also i can connect by this (localdb)\MSSQLLocalDB

---

<div class="post-metadata">

**Author:** ![Fathi2022](https://avatars.discourse-cdn.com/v4/letter/f/b487fb/32.png) [@Fathi2022](https://discourse.nodered.org/u/Fathi2022)\
**Post date:** [24 May 2022 14:01 UTC](https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691/76 "2022-05-24T14:01:36Z")

</div>

No, I can not connect with `127.0.0.1/SQLEXPRESS03` or `10.12.37.172/SQLEXPRESS03` from SSMS.

---

<div class="post-metadata">

**Author:** ![Fathi2022](https://avatars.discourse-cdn.com/v4/letter/f/b487fb/32.png) [@Fathi2022](https://discourse.nodered.org/u/Fathi2022)\
**Post date:** [24 May 2022 14:03 UTC](https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691/77 "2022-05-24T14:03:20Z")

</div>

i can connect by those

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

or

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/8/3/83df6350f9debcc18bfba02f15e8ef6052286a0c.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:** [24 May 2022 14:15 UTC](https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691/78 "2022-05-24T14:15:33Z")

</div>

Could you try the following in NODE-RED MSSQL config settings...

1. Verify PORT number for instance SQLEXPRESS03

- Connect SSMS to `.\SQLEXPRESS03`
- enter the following...

```sql
USE master
GO
xp_readerrorlog 0, 1, N'Server is listening on', N'any', NULL, NULL, N'asc' 
GO

```

  

1. Try with computer name only

- Set server to `DS` (or whatever your host name is)
- Set PORT to that found in logs

  

1. Try with Loopback IP only

- Set server to `127.0.0.1`
- Set PORT to that found in logs

  

1. Try with Computer IP only

- Set server to `10.12.37.172`
- Set PORT to that found in logs

---

<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:** [23 July 2022 14:15 UTC](https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691/79 "2022-07-23T14:15:57Z")

</div>

Closed on 23 July 2022 14:15 UTC

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

[Previous page](https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691.md?page=3)
