# Hello everyone I need some help about mssql-plus

**URL:** <https://discourse.nodered.org/t/hello-everyone-i-need-some-help-about-mssql-plus/88111>\
**Category:** General\
**Tags:** node-red-contrib-mssql-plus\
**Created:** [20 May 2024 05:35 UTC](https://discourse.nodered.org/t/hello-everyone-i-need-some-help-about-mssql-plus/88111 "2024-05-20T05:35:54Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![Xiang](https://avatars.discourse-cdn.com/v4/letter/x/9fc348/32.png) [@Xiang](https://discourse.nodered.org/u/Xiang)\
**Post date:** [20 May 2024 05:35 UTC](https://discourse.nodered.org/t/hello-everyone-i-need-some-help-about-mssql-plus/88111/1 "2024-05-20T05:35:54Z")

</div>

I want to use mssql-plus to connect to the SQL server database, but I can't connect all the time, and the request times out.  
This is the error message:

```auto
{"code":"ETIMEOUT",
"message":"Failed to connect to 192.168.28.1\\data in 15000ms",
"details":"Failed to connect to 192.168.28.1\\data in 15000ms",
"name":"ConnectionError"}

```

---

<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:** [20 May 2024 05:55 UTC](https://discourse.nodered.org/t/hello-everyone-i-need-some-help-about-mssql-plus/88111/2 "2024-05-20T05:55:14Z")

</div>

Hi @Xiang welcome to the forum.

Please provide more detail:

Where is node-red and SQL server running? (Same computer? Windows? Linux??, in docker? Etc)

Is your SQL server a named instance?

Are you able to connect using ssms? (Show us what you enter to connect)

Show us what you have entered in the connection config on node-red.

---

<div class="post-metadata">

**Author:** ![Xiang](https://avatars.discourse-cdn.com/v4/letter/x/9fc348/32.png) [@Xiang](https://discourse.nodered.org/u/Xiang)\
**Post date:** [20 May 2024 06:15 UTC](https://discourse.nodered.org/t/hello-everyone-i-need-some-help-about-mssql-plus/88111/3 "2024-05-20T06:15:42Z")

</div>

Both node-red and SQL server are running on the same computer, is windows.  
SQL server can log in normally, including local login and account password, and can also be connected normally, I have tested it with Java.  
I can connect with using ssms.

 ![1b6c6e6bcedd1af4650641866cc81a85](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/8/7/878db0aa3abf7d2f9ae58a8dd022fb1fb160a136.png)  
 ![7441786a4db78969b54769cc6df326b8](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/8/7/871a7f77215ce13f917c8c0d71d095615f759077.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:** [20 May 2024 06:27 UTC](https://discourse.nodered.org/t/hello-everyone-i-need-some-help-about-mssql-plus/88111/4 "2024-05-20T06:27:37Z")

</div>

Why have you added `\data` to the host name?

> [@Xiang](#):
>
> can connect with using ssms

☝ Please show us as requested 👇

> [@Steve-Mcl](#):
>
> (Show us what you enter to connect)

  
  

> [@Steve-Mcl](#):
>
> Is your SQL server a named instance

Please answer this ☝

---

<div class="post-metadata">

**Author:** ![Xiang](https://avatars.discourse-cdn.com/v4/letter/x/9fc348/32.png) [@Xiang](https://discourse.nodered.org/u/Xiang)\
**Post date:** [20 May 2024 06:47 UTC](https://discourse.nodered.org/t/hello-everyone-i-need-some-help-about-mssql-plus/88111/5 "2024-05-20T06:47:31Z")

</div>

![98aeb84c907efa42bcc8736a439c2883](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/c/a/ca9e8701dd50c0e5edc016fe38a74f32d982f567.png)  
 ![7820c650cf83e1e566151db283cef964](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/3/d/3dd8950eb31ba4d8772190dd3976db6678a27b0c.png)  
And my SQL is a default instance

---

<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:** [20 May 2024 07:01 UTC](https://discourse.nodered.org/t/hello-everyone-i-need-some-help-about-mssql-plus/88111/6 "2024-05-20T07:01:14Z")

</div>

I'm which case, the only issue I see is you added \data to the host. Remove that and try again.

Try unchecking Use Encryption too.

---

<div class="post-metadata">

**Author:** ![Xiang](https://avatars.discourse-cdn.com/v4/letter/x/9fc348/32.png) [@Xiang](https://discourse.nodered.org/u/Xiang)\
**Post date:** [20 May 2024 07:02 UTC](https://discourse.nodered.org/t/hello-everyone-i-need-some-help-about-mssql-plus/88111/7 "2024-05-20T07:02:36Z")

</div>

I unticked 'Use Encryption?', 'Trust Certificate?' and 'Assume UTC?' and it work

---

<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:** [20 May 2024 07:03 UTC](https://discourse.nodered.org/t/hello-everyone-i-need-some-help-about-mssql-plus/88111/8 "2024-05-20T07:03:34Z")

</div>

> [@Xiang](#):
>
> Assume UTC

Leave that ticked.

Also, did you remove `\data` from the server Field?

---

<div class="post-metadata">

**Author:** ![Xiang](https://avatars.discourse-cdn.com/v4/letter/x/9fc348/32.png) [@Xiang](https://discourse.nodered.org/u/Xiang)\
**Post date:** [20 May 2024 07:05 UTC](https://discourse.nodered.org/t/hello-everyone-i-need-some-help-about-mssql-plus/88111/9 "2024-05-20T07:05:59Z")

</div>

Yes, I remove it.Thank you very much for your help.

---

<div class="post-metadata">

**Author:** ![Xiang](https://avatars.discourse-cdn.com/v4/letter/x/9fc348/32.png) [@Xiang](https://discourse.nodered.org/u/Xiang)\
**Post date:** [20 May 2024 07:17 UTC](https://discourse.nodered.org/t/hello-everyone-i-need-some-help-about-mssql-plus/88111/10 "2024-05-20T07:17:55Z")

</div>

My classmate can run and he checked the Use Encryption. Can you tell me why? pls.

---

<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:** [20 May 2024 07:21 UTC](https://discourse.nodered.org/t/hello-everyone-i-need-some-help-about-mssql-plus/88111/11 "2024-05-20T07:21:29Z")

</div>

The server part was the only problem as far as I can see. Try switching it back on.

---

<div class="post-metadata">

**Author:** ![Xiang](https://avatars.discourse-cdn.com/v4/letter/x/9fc348/32.png) [@Xiang](https://discourse.nodered.org/u/Xiang)\
**Post date:** [20 May 2024 07:30 UTC](https://discourse.nodered.org/t/hello-everyone-i-need-some-help-about-mssql-plus/88111/12 "2024-05-20T07:30:30Z")

</div>

I forgot one detail, he added `\data`

---

<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:** [3 June 2024 07:30 UTC](https://discourse.nodered.org/t/hello-everyone-i-need-some-help-about-mssql-plus/88111/13 "2024-06-03T07:30:38Z")

</div>

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