Connecting to Mircrosoft SQL

Questions
1

I encounter the issue when trying to connect to MS SQL server on my laptop.
Further info related to MS SQL:

  • I have 3 instances running on my machine.
  • 1 instance running on port 1433 (TCP dynamic port: null)
  • I already created the inbound/outbound rule to allow connection to port 1433 in firewall denfender.
  • I have tested the connection on my laptop, I connected without any issue. GPT said it’s the issue with config on n8n → I config as below, based on GPT instruction

any idea what should be fixed to achieve the connection.

image
image1224×755 33.1 KB

2

If you’re sure you’re connecting to a default instance:

Use: Server: 127.0.0.1 (instead of localhost)
Port: 1433

If it’s a named instance:
Use: Server: 127.0.0.1\INSTANCE
Remove the port field

Check if telnet localhost 1433 responds from the command line.

It also checks if the login has access to the master, what role the login has, or what role the database user has within the master database.

3

Are you on the cloud version or selfhosted ?

4

selfhosted using vps