[Python] [Microsoft][ODBC Driver 17 for SQL Server]SSL Provider: [error:0A000102:SSL...

I'm encountering an issue while trying to connect to a SQL Server database using Python on macOS with Brew. I'm receiving the following error message:

conn = Database.connect(connstr, **args) django.db.utils.OperationalError: ('08001', '[08001] [Microsoft][ODBC Driver 17 for SQL Server]SSL Provider: [error:0A000102:SSL routines::unsupported protocol] (-1) (SQLDriverConnect)')
​

I can ping the database server and I was able to connect to the database using the Azure Data Studio, so I know that the network connectivity and database access credentials are correct but still can't connect my application.

I tried specify openSSL version for ODBC Driver, since I have both openssl@3 and openssl@1.1 but none works.

I still tried to use Encrypt=false;TrustServerCertificate=true to disable encryption and ignore server certificate errors, but doesn't work too.

I appreciate any help.

Continue reading...