Using Microsoft SQL Server With Node-Red and MQTT

[@giorgiopapandraeu5813]

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.

[@ArminDaDee]

Hey, maybe you bumped into a problem like "Connection failed to broker: NodeRedSQLClient@mqtt://localhost:1883"? Thanks

[@rafaelarmbrust7779]

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.

[@AlexandreSantos-cb5qk]

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.

[@edwardrut569]

Can it use function backup database?

[@testaccount6214]

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

[@GinoFavero94]

I have that problem too, did you can solve it?

[@azanfaiz622]

can u share us the Dev Database bak.file sir?

[@matheusvasconcellos3216]

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

[@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

[@liambroughton500]

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.

[@kurthansen391]

Setup SQL Server to listen on TCP on a fixed port number: SQL Configuration Manager SQL Server Network Configuration Protocols for {Instance} TCP/IP - Enabled (double-click) IP Address (on all desired interfaces) TCP Dynamic Ports = BLANK! (not zero) TCP Port - 1433 (or desired port)

[@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!

[@alqoidaassidiqi3274]

have you solved the problem ?

[@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 !!! Thanxxxxxxxxxxxx

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

[@Elvasco22]

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

[@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???

[@mahmoudzaidxx]

had the same issue, the mssql node does not seem to work with the express version

[@darthanakin3463]

@@mahmoudzaidxx Did you found out which version works? I have the same issue now.

[@nickmpogiatziou2133]

Same with me with express version isn't working

[@jagjitsinghrehill]

Look into InfluxDB and Grafana