Microsoft SQL Node Fails to Connect

Questions
1

Microsoft SQL Node Fails to Connect

Error Message:

ConnectionError: Failed to connect to 111.11.111.1:1433 in 15000ms at connectListener (/usr/local/lib/node_modules/n8n/node_modules/mssql/lib/tedious/connection-pool.js:85:17) at Connection.onConnect (/usr/local/lib/node_modules/n8n/node_modules/tedious/src/connection.ts:1759:9) at Object.onceWrapper (node:events:634:26) at Connection.emit (node:events:519:28) at Connection.emit (node:domain:488:12) at Connection.emit (/usr/local/lib/node_modules/n8n/node_modules/tedious/src/connection.ts:1902:18) at Connection.connectTimeout (/usr/local/lib/node_modules/n8n/node_modules/tedious/src/connection.ts:2173:10) at Timeout._onTimeout (/usr/local/lib/node_modules/n8n/node_modules/tedious/src/connection.ts:2118:12) at listOnTimeout (node:internal/timers:573:17) at processTimers (node:internal/timers:514:7)

Information on your n8n setup

  • n8n version: 1.46.0 (Cloud)
  • Database (default: SQLite): Microsoft SQL

I am able to connect using Visual Studio Code SQL Extension and a different n8n like website (didn’t whitelist anything) . My IT team said they whitelisted the n8n cloud IPs. Using the latest SQL workflow node. Anything else I should be trying?

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

Hey @EOMDEV,

Welcome to the community :tada:

That looks a pretty standard connection issue, If you are using cloud it would likely suggest that the cloud IPs are not allowed through the firewall or the port is incorrect.