MSSQL connection problem with instance

Questions
21

We have added the 3 IP’s now to our firewall and the sql server connection is working again.

1 Like
22

Awesome, thanks for confirming!

23

Hi team,

Following on from the above …

Has anyone experience of using the MS SQL node / credentials with SQL Express instances ?

I have tried all combinations of connection string parameters in this article but cannot get the Credentials for an MS SQL node to connect to a SQL Express instance.

2 examples: one SQL Server express 2019 (on port 1433) and one 2016 (on another port). Can connect to both using SSMS from my desktop so TCP/IP access is enabled. Can telnet to both on their correct ports from the n8n server so I am assuming this is not a firewall issue. I have tried with and without the port being set; with and without the INSTANCE name being suffixed to the server name in the credentials, with both single () and double (\) slashes in between. (Double slashes timeout as no address found; single slashes just timeout as ‘failed to connect’).

Any advice welcome.

Thanks
Simon

24

Hi all - closing this one down as I must admit that this was a firewall problem on our side :flushed: !!
n8n now chatting perfectly well with this particular SQL Express instance. Yay ! :grinning:

2 Likes
25

I am so sorry, I missed your previous response to this older thread @simon.lewis. I am really glad to hear this is sorted :smiley:

26

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