# Connection Timeout in Node-Contrib MS-SQL-PLUS

**URL:** <https://discourse.nodered.org/t/connection-timeout-in-node-contrib-ms-sql-plus/93079>\
**Category:** General\
**Tags:** node-red-contrib-mssql-plus\
**Created:** [11 November 2024 20:41 UTC](https://discourse.nodered.org/t/connection-timeout-in-node-contrib-ms-sql-plus/93079 "2024-11-11T20:41:12Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![bobfield](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bobfield/32/83723_2.png) [@bobfield](https://discourse.nodered.org/u/bobfield)\
**Post date:** [11 November 2024 20:41 UTC](https://discourse.nodered.org/t/connection-timeout-in-node-contrib-ms-sql-plus/93079/1 "2024-11-11T20:41:12Z")

</div>

Hi Dears,

I have a node-red program accessing a cloud database with node-contrib ms-sql-plus. Everything works perfectly on my machine, but when I take it to the client it cannot connect and it gives a timeout. His machine has access to the internet and the windows firewall is turned off. Any suggestions?

Thanks,

Roberto

---

<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:** [11 November 2024 21:00 UTC](https://discourse.nodered.org/t/connection-timeout-in-node-contrib-ms-sql-plus/93079/2 "2024-11-11T21:00:49Z")

</div>

Could be any number of things. Are you trying to connect to an instance? Is the SQL server set-up to accept connection? Is node-red running on the same subnet. Is node-red running in docker? If you install node-red-node-ping can the node-red instance ping the SQL server?

---

<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:** [11 November 2024 21:09 UTC](https://discourse.nodered.org/t/connection-timeout-in-node-contrib-ms-sql-plus/93079/3 "2024-11-11T21:09:43Z")

</div>

> [@bobfield](#):
>
> when I take it to the client it cannot connect

What, exactly, have you taken to the client?

---

<div class="post-metadata">

**Author:** ![bobfield](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bobfield/32/83723_2.png) [@bobfield](https://discourse.nodered.org/u/bobfield)\
**Post date:** [11 November 2024 22:11 UTC](https://discourse.nodered.org/t/connection-timeout-in-node-contrib-ms-sql-plus/93079/4 "2024-11-11T22:11:28Z")

</div>

Are you trying to connect to an instance? Yes, an instance in a AWS EC2 with MS-SQL-Server

Is the SQL server set-up to accept connection? Yes, in my home computer the connection Works perfectly

Is node-red running in docker? No, directly installed in a Windows machine

If you install node-red-node-ping...? This node returns false even under my home computer, where the connection works. I think that the AWS EC2 servers do not ping.

Is node-red running on the same subnet? I don't know. I will see this.

Thanks,

Roberto

---

<div class="post-metadata">

**Author:** ![bobfield](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bobfield/32/83723_2.png) [@bobfield](https://discourse.nodered.org/u/bobfield)\
**Post date:** [11 November 2024 22:15 UTC](https://discourse.nodered.org/t/connection-timeout-in-node-contrib-ms-sql-plus/93079/5 "2024-11-11T22:15:08Z")

</div>

The client has a machine with Windows installed e running some types of softwares. I installed there the Node-Red for Windows and the node-contrib MS-SQL Plus. I configured this node with the same configuration of my machine, including tcp/ip, user, password and database name. But it do not connect.

---

<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:** [11 November 2024 22:22 UTC](https://discourse.nodered.org/t/connection-timeout-in-node-contrib-ms-sql-plus/93079/6 "2024-11-11T22:22:04Z")

</div>

What node js & node-red versions do the working and non working node-red machines have installed?

As it is an instance, you might need to grab the port number from the SQL server logs (since instances have a dynamic port number by default & it is often not 1433)

See this thread and others within the repository: [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-1067390539)

---

<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:** [9 February 2025 22:22 UTC](https://discourse.nodered.org/t/connection-timeout-in-node-contrib-ms-sql-plus/93079/7 "2025-02-09T22:22:13Z")

</div>

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