# 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:** 20\
**Page:** 3

<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 May 2022 19:24 UTC](https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691/41 "2022-05-18T19:24:40Z")

</div>

> [@Fathi2022](#):
>
> i dont know how can I delete MSSQL Config in node red sorry

![chrome_BGFuDwpKDv](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/5/3/534243c23adeea3941c97a552d206bab53282b88.gif)

---

<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:** [18 May 2022 19:25 UTC](https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691/42 "2022-05-18T19:25:29Z")

</div>

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/4/2/421613d18227168f59da47e14f30267c1ae323a5.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 May 2022 19:26 UTC](https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691/43 "2022-05-18T19:26:56Z")

</div>

Good! So far we have...

- Port number is: `1433` ✅
- Instance name is: `SQLEXPRESS03` ✅

Now show me the MSSQL config node settings

Also, remember to delete ALL config nodes except 1

---

<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:** [18 May 2022 19:27 UTC](https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691/44 "2022-05-18T19:27:17Z")

</div>

how can I delete them, please

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/c/9/c9e60acd38005dc848e8244cbebf6d7f7b1790c0.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 May 2022 19:28 UTC](https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691/45 "2022-05-18T19:28:02Z")

</div>

> [@Fathi2022](#):
>
> how can I delete them, please

As I showed you...

> [@Steve-Mcl](#):
>
> ![chrome_BGFuDwpKDv](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/5/3/534243c23adeea3941c97a552d206bab53282b88.gif)

1. Select config
2. click pencil
3. click delete
4. click done
5. goto step 1 & do it again

---

<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:** [18 May 2022 19:32 UTC](https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691/46 "2022-05-18T19:32:09Z")

</div>

I got it thanks a lot 🥰 lol I delete them

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/0/f/0ff10540ce55964d55cd88753a3871ab808fb0e8.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 May 2022 19:36 UTC](https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691/47 "2022-05-18T19:36:36Z")

</div>

Now if you put a SQL username and password in, Update & Deploy

then test a simple query something like ...

```sql
SELECT 1 as [one], GetDate() as [now]

```

What happens?

---

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

</div>

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/3/7/37439eb2c8390ba1b039363c5ca5f1bb584f25db.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 May 2022 19:40 UTC](https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691/49 "2022-05-18T19:40:37Z")

</div>

Is the SQL Server on the same computer as node-red?

If YES - try again with the server field set to `127.0.0.1\SQLEXPRESS03` in MSSQL Config

---

<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:** [18 May 2022 19:42 UTC](https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691/50 "2022-05-18T19:42:28Z")

</div>

I am using Windows authorization so no need to put the user name and password.

Yes they are on the same PC.

---

<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 May 2022 19:43 UTC](https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691/51 "2022-05-18T19:43:30Z")

</div>

> [@Fathi2022](#):
>
> Yes they are on the same PC.

Then try 127.0.0.1\SQLEXPRESS03

> [@Fathi2022](#):
>
> I am using Windows authorization so no need to put the user name and password

As I said below...

> [@Steve-Mcl](#):
>
> > [@Fathi2022](#):
> >
> > I would like to connect it by windows authorization is ok
> 
> I've not tested that so cant answer - however SQL Server auth definately 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:** [18 May 2022 19:45 UTC](https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691/52 "2022-05-18T19:45:19Z")

</div>

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

yes its work

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

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/4/6/469ecb13eabba1507fd8f51e266462b5e0a43538.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:** [18 May 2022 20:11 UTC](https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691/53 "2022-05-18T20:11:18Z")

</div>

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

I think the issue here

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/e/7/e7e5e324d97b35f75f7f1d9c5cfab0209bb2ec83.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 May 2022 20:38 UTC](https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691/54 "2022-05-18T20:38:12Z")

</div>

If node-red and the SQL server are on the same machine then the loopback address (127.0.0.1) should work.

Are you running any of these in docker?

---

<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 12:36 UTC](https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691/55 "2022-05-19T12:36:04Z")

</div>

Hi, mate so I have to change all IPs to 127.0.0.1?

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/2/1/21a0972f0a7cb5f6087b67cb7a80713c56882317.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 13:03 UTC](https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691/56 "2022-05-19T13:03:09Z")

</div>

Do you know what loopback address is? It is something built in to the OS.  
127.0.0.1 means? It is (mostly) associated with `localhost` or THIS COMPUTER  
Read up - [localhost - Wikipedia](https://en.wikipedia.org/wiki/Localhost#:~:text=The%20address%20127.0.0.1%20is,on%20the%20same%20port%20number).

So to answer your question -

> [@Fathi2022](#):
>
> so I have to change all IPs to 127.0.0.1?

No - it should work!

HOWEVER there is a BUT

> [@Steve-Mcl](#):
>
> Are you running any of these in docker?

👆 Cannot advise until you answer 👆

---

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

</div>

> [@Steve-Mcl](#):
>
> Are you running any of these in docker?

What do you mean by in docker, 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:** [19 May 2022 13:13 UTC](https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691/58 "2022-05-19T13:13:34Z")

</div>

Is node-red or SQL Server running in a Virtual Machine or a container or docker environment?

OR are node-red AND SQL Server both installed DIRECTLY in windows AND on the SAME windows computer?

---

<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 13:18 UTC](https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691/59 "2022-05-19T13:18:26Z")

</div>

> [@Fathi2022](#):
>
> ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/2/1/21a0972f0a7cb5f6087b67cb7a80713c56882317.png)
> 
> image617×756 56.3 KB

Can you show me all entries in this list 👆

---

<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:27 UTC](https://discourse.nodered.org/t/i-have-issue-when-i-connect-mssql-with-node-red/62691/60 "2022-05-19T15:27:52Z")

</div>

The node-red AND SQL Server both installed DIRECTLY in windows AND on the SAME windows.

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

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