Interval connection error

[Steve-Mcl]

@Dar

I used node-red-contrib-mssql

I would strongly recommend you do not use that node.
I would suggest you switch to node-red-contrib-mssql-plus
Here is why:

Mssql not sending data to database using mustache format

That node is over 7 years old, uses old libraries (with CVE issues) and has a number of known bugs and last, but not least, does not have the additional features that make mssql-plus the best SQL node in the catalog. I suggest you remove that and add the newer/better one and use parameters. You have 2 choices to acheive that ^ remove all traces of mssql from your flows remove node-red-contrib-mssql via palette manager install node-red-contrib-mssql-plus via palette manager restart node-red a…

@TotallyInformation

I don't use MS SQL - does the driver have a connection pooling option?

The OP is using the (very) old contrib. node-red-contrib-mssql-plus does support pooling (and stored procs and prepared statements)