Mssql node-red raspberry pi

General
1

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?

2

Welcome.

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

3

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"

4

image
image521Ă—589 12.5 KB

If this helps

5

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

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

6

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

7

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...

8

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

9

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

1 Like
10

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