search

tediousjs / node-mssql

Microsoft SQL Server client for Node.js
https://tediousjs.github.io/node-mssql
MIT License
2.24k stars 471 forks source link

error:0A000102 when linking to database #1661

Closed c03311 closed 5 months ago

c03311 commented 5 months ago

when I connect to sql server(whether local server or remote server),it shows ConnectionError:

error:0A000102:SSL routines:ssl_choose_client_version:unsupported protocol:c:\ws\deps\openssl\openssl\ssl\statem\statem_lib.c:1988:

It seems like SSL error but I didn't adjust any SSL settings for sql server or nodejs,they're all default.

Expected behaviour:

connect to sql server

Actual behaviour:

error:0A000102:SSL routines:ssl_choose_client_version:unsupported protocol:c:\ws\deps\openssl\openssl\ssl\statem\statem_lib.c:1988:

Configuration:

sqlConfig = {
  user: 'sa',
  password: password,
  database: 'test',
  server: 'localhost',
  options: {
    trustServerCertificate: true
  }
}

Software versions

dhensby commented 5 months ago

see https://github.com/tediousjs/tedious/issues/1407#issuecomment-1049529804