Skip to content

Instantly share code, notes, and snippets.

@linuxkathirvel

linuxkathirvel/how-to-solve-mssql-ODBC-ssl-routine-ssl-choose-client_version-unsupported-protocol.md

Last active May 11, 2021 14:10
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save linuxkathirvel/b93fa80d6ea04b86360977188da0a20c to your computer and use it in GitHub Desktop.
Save linuxkathirvel/b93fa80d6ea04b86360977188da0a20c to your computer and use it in GitHub Desktop.
Download ZIP
pyodbc.OperationalError: ('08001', '[08001] [Microsoft][ODBC Driver 17 for SQL Server]SSL Provider: [error:1425F102:SSL routines:ssl_choose_client_version:unsupported protocol] (-1) (SQLDriverConnect)')
Raw
how-to-solve-mssql-ODBC-ssl-routine-ssl-choose-client_version-unsupported-protocol.md

How to solve pyodbc.OperationalError: ('08001', '[08001] [Microsoft][ODBC Driver 17 for SQL Server]SSL Provider: [error:1425F102:SSL routines:ssl_choose_client_version:unsupported protocol] (-1) (SQLDriverConnect)') error?

This error due to openssl.

Steps

Open /etc/ssl/openssl.cnf and update these lines
[system_default_sect]
MinProtocol = TLSv1
CipherString = DEFAULT@SECLEVEL=1
Reference

microsoft/msphpsql#1112 (comment)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment