TablePlus / Bolt-SQL-issue-tracker

2 stars 0 forks source link

Cannot connect to on prem MSSQL server #10

Open luigiman86 opened 7 months ago

luigiman86 commented 7 months ago

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 commented 7 months ago

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 commented 6 months ago

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

dustin-we commented 1 month ago

I am here to report the same error:

Screenshot

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