Until yesterday we had no problems connecting from n8n to our SQL Server 2017. Then yesterday we upgraded n8n from 0.194 to 0.195.5. And our SQL Server connections are now not working anymore. After the timeout we get
ConnectionError: Failed to connect to 178.255.193.119:1433 in 15000ms
at /usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/node_modules/mssql/lib/tedious/connection-pool.js:78:17
at Connection.onConnect (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/node_modules/tedious/lib/connection.js:1051:9)
at Object.onceWrapper (node:events:628:26)
at Connection.emit (node:events:513:28)
at Connection.emit (node:domain:489:12)
at Connection.emit (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/node_modules/tedious/lib/connection.js:1079:18)
at Connection.connectTimeout (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/node_modules/tedious/lib/connection.js:1284:10)
at Timeout._onTimeout (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/node_modules/tedious/lib/connection.js:1229:12)
at listOnTimeout (node:internal/timers:559:17)
at processTimers (node:internal/timers:502:7)
We had and still have TLS disabled. We connect to a server IP and port.
I’m not sure if OP still has problem, but it seems that something after 0.194 has caused SQL Server connections in some situations to stop working