Using Microsoft SQL Server With Node-Red and MQTT

Pushing MQTT data into Microsoft SQL Server using node-red-contrib-MSSQL node.

In a previous video I showed setting up Microsoft SQL Server to receive MQTT data.

Here is the example flow used in the video:

[rafaelarmbrust]

Also after 5 years, absolulty brilliant and the best tutorial to connect a MS SQL Database to nodered.
I try to use it to send data from a SQL Database with my Ecommerce orders to a Siemens S7 1200/1500 to build a pick&place solution for my warehouse.

[giorgiopapandraeu]

Thank you - you're a life saver!
Exactly what I've been trying to get working on a tight deadline.

Probably the most useful, clearest, fussless demonstration and instructional video I've seen.

[matheusvasconcellos]

Congratulations, I was looking for a simple tutorial and you did it! Thanks.

[Elvasco]

Muchas gracias hermano!! Me ayudó mucho tu video. Saludos desde Argentina!

[kessedk]

Nice video! I'm new to node red, so great to see you use the import function, and go through all the configuration of it!
I have used MSSQL fore some time, and you might finde the GETDATE() function usefull for timestamps...

[inteligenciamilgrau]

I recommend to install the "plus" version if you have a different port on your server side!! npm install node-red-contrib-mssql-plus !!!

[VailopillyRavindranArunPrasad]

Great Video Jonathan. I Tried to do the same thing using a SQL Server 2016 Dev Edition installed on a Azure VM. However, the connection is refusing. Does node-red-contrib-MSSQL node support local installation or it does support AZURE SQL database. Would be interesting to stream data directly into Azure Database in the cloud so that we can use ML. My goal is to use data secured from MQTT into the cloud and then run some ML


Could you help me please

[testaccount]

Hello, I have an external device programmed with node red and a PC with MSSQL installed. I followed your steps but I have no success sending data. My device is connected to a ethernet swithc and also the PC... How can I send the data from my device to the SQL server installed in the PC???

[AlexandreSantos-cbqk]

Hi! There are any way to do it in Node-RED IBM Cloud? I need to bring data from SQL Server to Node-RED in Cloud.

[apaterninajc]

How do you solve the "Connection Error: Connection is closed", I having this problem trying to do insert one after one however, I tested adding a delay but happen sometimes, any suggestion? I see that happen to you in the video. Thank you!

[liambroughton]

Hi there, trying to sort this out but my port for mssql server is 58970 and not 1443. How can I change this? As it keeps giving me an error saying failed to connect ENOTFOUND

Thanks.

- Liam.

[hypersmart_uk]

Hi, I wanted to try and connect with mssql express on local machine with windows authentication. I installed node-red-contrib-mssql and checked that mssql service is running and just incase I set used sql server configuration TCP/IP to port 1433. I tried a simple inject insert query, but whatever I do the connection fails. Any ideas what else I might be able to try? I wanted to avoid MQTT at the moment until I understand and get the basic connection working and your video is the only one that has inspired me in the sense that it seems to work with Server 2016 so it should work with Express???