Unable to connect local MS SQL Express

Questions
1

Describe the problem/error/question

My n8n instance is self-hosted using Docker, and I’ve also installed Microsoft SQL Server Express 2012 on the same notebook.

I’m trying to use the Microsoft SQL node in n8n, but the connection fails.

I’ve checked my local SQL Server Express installation, and everything seems to be running normally.

Does n8n support connections to SQL Server Express, or only to full versions of SQL Server?

Any ideas on what might be causing the issue?

image
image1139×717 29.9 KB

image
image937×594 25.6 KB

What is the error message (if any)?

Please share your workflow

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

Information on your n8n setup

  • n8n version: n8n Version 1.113.2
  • Database (default: SQLite): MSSQL EXPRESS
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker n8n self-host
  • Operating system: Window11
2

Can you try changing the IP address with host.docker.internal?

2 Likes
3

Thank you so much. it works and solved.

4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.