I have tried all available combinations to connect to Microsoft SQL Server without luck.
I always get this error:
“Couldn’t connect with these settings
Failed to connect to …”
I tried both url and ip address of the server address; different authentication types but I was not able to connect.
Does anyone know how to connect?
SSMS example settings:
Tad confused. So to be clear, you have a working MySQL server on an IP, and you are trying to connect to it via n8n? Or you can’t even connect to the sql server without n8n?
No, it’s not a MySQL server, it’s a Microsoft SQL Server as I stated in my description and I can connect to it outside of n8n.
Hi, What is the error message that you are getting? Can you reach the actual SQL server from the n8n instance? Can you reach the machine and does the port connect? I would imagine that an SQL server would be locked down in primary defense to anything what shouldn’t reach it traffic-wise. If you mention, it works from a normal sql client, i image you are trying to run the n8n from the same machine.
reg,
J
Hi,
When I try to add a new connection, I get this error:
“Couldn’t connect with these settings
Failed to connect to {ip address or url, timeout duration}"
I can connect to the SQL server from that machine (and other machines). also with other tools.
I also tried connecting form an n8n instance on another machine without luck.
Hi,
I’ve made a quick test to see how it works.
please try the following:
Go into the configuration of your N8N credentials for MSSQL.
I guess the connectivity test to your server fails there too?
Anyway, there is a small “more details” toggle which you can click, which hopefully provides you the real reason for not being able to connect.
When i enable TLS for example it fails, and you can see the actual problem
Hope it will show what we need to get this working
I tied this before posting (including a lot more possible combination of the setting visible on the interface) but I got the same error message in the connectivity test.
Hi, I’m sorry but it’s hard to say much tbh. Can you describe where the SQL server is running? Are you running self-hosted on n8n docker? An overview where everything runs and how it’s connected would give a clue at least on how to solve. as it says a timeout of 15s, i just looks to me that there’s is no connectivity/reachability
Is your n8n self-hosted running inside a docker? Then the server name would be “host.docker.internal” and also some few steps for setting the port number, etc.
