# Mssql node-red raspberry pi

**URL:** <https://discourse.nodered.org/t/mssql-node-red-raspberry-pi/23503>\
**Category:** General\
**Created:** [23 March 2020 11:48 UTC](https://discourse.nodered.org/t/mssql-node-red-raspberry-pi/23503 "2020-03-23T11:48:05Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![sahebdatta](https://avatars.discourse-cdn.com/v4/letter/s/3d9bf3/32.png) [@sahebdatta](https://discourse.nodered.org/u/sahebdatta)\
**Post date:** [23 March 2020 11:48 UTC](https://discourse.nodered.org/t/mssql-node-red-raspberry-pi/23503/1 "2020-03-23T11:48:05Z")

</div>

Hello everyone,  
I am trying to send data from raspberry pi to MSSQL database running on my PC using node-red. The Raspberry Pi and PC are connected to the same network. Whenever I try to connect to the database, it shown "ConnectionError: Failed to connect to 192.168.43.244: undefined in 15000ms". Can somebody help me with this?

---

<div class="post-metadata">

**Author:** ![bakman2](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bakman2/32/6207_2.png) [@bakman2](https://discourse.nodered.org/u/bakman2)\
**Post date:** [23 March 2020 12:02 UTC](https://discourse.nodered.org/t/mssql-node-red-raspberry-pi/23503/2 "2020-03-23T12:02:00Z")

</div>

Welcome.

It looks like you forgot to specify the port it needs to connect to.

---

<div class="post-metadata">

**Author:** ![sahebdatta](https://avatars.discourse-cdn.com/v4/letter/s/3d9bf3/32.png) [@sahebdatta](https://discourse.nodered.org/u/sahebdatta)\
**Post date:** [23 March 2020 12:04 UTC](https://discourse.nodered.org/t/mssql-node-red-raspberry-pi/23503/3 "2020-03-23T12:04:33Z")

</div>

How do you do that?  
I got this message after trying to include the port...  
"ConnectionError: Failed to lookup instance on 192.168.43.244:1433 - getaddrinfo ENOTFOUND 192.168.43.244:1433"

---

<div class="post-metadata">

**Author:** ![sahebdatta](https://avatars.discourse-cdn.com/v4/letter/s/3d9bf3/32.png) [@sahebdatta](https://discourse.nodered.org/u/sahebdatta)\
**Post date:** [23 March 2020 12:06 UTC](https://discourse.nodered.org/t/mssql-node-red-raspberry-pi/23503/4 "2020-03-23T12:06:14Z")

</div>

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

If this helps

---

<div class="post-metadata">

**Author:** ![bakman2](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bakman2/32/6207_2.png) [@bakman2](https://discourse.nodered.org/u/bakman2)\
**Post date:** [23 March 2020 12:07 UTC](https://discourse.nodered.org/t/mssql-node-red-raspberry-pi/23503/5 "2020-03-23T12:07:36Z")

</div>

The server is an IP address and a port.  
192.168.43.244:1433

But you are using "MSSQL-CN" node - not "MySQL"

---

<div class="post-metadata">

**Author:** ![sahebdatta](https://avatars.discourse-cdn.com/v4/letter/s/3d9bf3/32.png) [@sahebdatta](https://discourse.nodered.org/u/sahebdatta)\
**Post date:** [23 March 2020 12:09 UTC](https://discourse.nodered.org/t/mssql-node-red-raspberry-pi/23503/6 "2020-03-23T12:09:44Z")

</div>

yes I'm using MSSQL and not MySql...Extremely sorry for the typo in the body..

---

<div class="post-metadata">

**Author:** ![sahebdatta](https://avatars.discourse-cdn.com/v4/letter/s/3d9bf3/32.png) [@sahebdatta](https://discourse.nodered.org/u/sahebdatta)\
**Post date:** [23 March 2020 12:13 UTC](https://discourse.nodered.org/t/mssql-node-red-raspberry-pi/23503/7 "2020-03-23T12:13:34Z")

</div>

It works when I am trying to send data from my PC to the database. But doesn't work when i try to send data from Raspberry Pi...

---

<div class="post-metadata">

**Author:** ![bakman2](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bakman2/32/6207_2.png) [@bakman2](https://discourse.nodered.org/u/bakman2)\
**Post date:** [23 March 2020 12:15 UTC](https://discourse.nodered.org/t/mssql-node-red-raspberry-pi/23503/8 "2020-03-23T12:15:05Z")

</div>

How does your PC connect to the database, compare the connection string.

---

<div class="post-metadata">

**Author:** ![sahebdatta](https://avatars.discourse-cdn.com/v4/letter/s/3d9bf3/32.png) [@sahebdatta](https://discourse.nodered.org/u/sahebdatta)\
**Post date:** [23 March 2020 12:26 UTC](https://discourse.nodered.org/t/mssql-node-red-raspberry-pi/23503/9 "2020-03-23T12:26:49Z")

</div>

Hey, thanks for your inputs. It works now. I had to allow the ports from firewall...

---

<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:** [22 May 2020 12:26 UTC](https://discourse.nodered.org/t/mssql-node-red-raspberry-pi/23503/10 "2020-05-22T12:26:50Z")

</div>

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