Cannot connect to on prem MSSQL server

[luigiman86]

I have not been able to successfully connect to my on prem SQL Server instance in Bolt SQL. I am using a non-SSH connection with SQL auth, and default port 1433, but I am always getting getaddrinfo ENOTFOUND error. I have tried using other ports, and connecting via IP rather than hostname, and with and without square brackets. The only time I get a different error is when I try just the server hostname, not the named instance I am trying to connect to, at which point I get: Error: Failed to connect to [server hostname]:1433 - 40089984:error:100000f0:SSL routines:OPENSSL_internal:UNSUPPORTED_PROTOCOL:....\third_party\boringssl\src\ssl\handshake_client.cc:713:

is it trying to force SSL?

I connected to this same named instance without issue in TablePlus.

I am not a dev so I have probably not explained this well. Is this a bug or am I doing something wrong?

[huyphams]

Weird, TablePlus and Bolt are using the same library for SQL Server. Could you send a screen shot of the connection form on TablePlus and Bolt to nick@tableplus.com thanks

[luigiman86]

@huyphams I did send over the requested screenshots. Any update on this issue?

[dustin-we]

I am here to report the same error:

Credentials are the same, tried with and without DB, nothing works for me. Maybe it's using another driver?

[luigiman86]

Just to note on this issue, the research I have done indicates that the issue is incompatible TLS versions, which makes sense to me since the server I am trying to connect to is running a very old SQL version. I am not the DBA so I can't update it. With most clients I have to connect with 'Encrypt=False' or TrustServerCertificate=True' etc., and I think that's what is missing here, an option to connection without encryption, or similar.