error:100000f0:SSL routines:OPENSSL_internal:UNSUPPORTED_PROTOCOL

[feihuao]

I been looking for something like this for some time. Similar one is SQLCell but it does not support autocomplete. When I connect to mssql，it fails Failed to connect to "test": Failed to connect to xxx.xx.xxx:1433 - 16484744:error:100000f0:SSL routines:OPENSSL_internal:UNSUPPORTED_PROTOCOL:../../third_party/boringssl/src/ssl/handshake_client.cc:697:

[cmoog]

Thanks for this report. I haven't been able to reproduce using my testing setup. Can you share steps that I can follow to reproduce the behavior? Are you using a network proxy that enforces specific encryption? What about your DB configuration?

Ultimately, we just need to find out what configuration should be passed to the mssql node driver for the handshake to succeed. That code is here for reference.

I'm testing with the following

1. Startup local mssql server

docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=yourStrong(!)Password" -p 1433:1433 -d mcr.microsoft.com/mssql/server:2022-latest

2. Create new connection config

{
  "driver": "mssql",
  "host": "localhost",
  "port": 1433,
  "user": "sa",
  "password": "yourStrong(!)Password",
  "encrypt": false,
  "serverTrustCertificate": false,
}

Then the extension connects and executes queries as expected.

[dicer2000]

I get that same error. I've got the connection info set just like you have in 2.

Could this be a Mac vs. Windows thing? I'm trying to connect on a Mac.

Here is the error message:

Failed to connect to "SQL": Failed to connect to ev-compsci-01:1433 - 140407413018712:error:100000f0:SSL routines:OPENSSL_internal:UNSUPPORTED_PROTOCOL:../../third_party/boringssl/src/ssl/handshake_client.cc:697:

[ilkosta]

same error from linux connecting to an old sql2008