Win server connection with SQL server. pypyodbc.DatabaseError: ('08001', '[08001] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error')

Asked Jul 28 '21 at 18:10

Active Jul 28 '21 at 19:20

Viewed 575 times

I tried the below code to connect to SQL Server from Windows 10 and it ran successfully but now I'm trying to run the same code from Windows Server 2016 and it's giving me SSL error. The code:

    conn = pypyodbc.connect('Driver={SQL Server};'
                            'Server=server_name;'
                            'Database=db_name;'
                            'Trusted_Connection=yes;')

Exception it's throwing now is

pypyodbc.DatabaseError: ('08001', '[08001] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error')

I tried searching various solutions to this issue but I don't have access to password and username. The ODBC driver name on both, the server and my machine is SQL Server only. Still, connection is refused in case of server.

I'm unable to understand this. Can anybody suggest me a way to execute it successfully from the server? I tried pyodbc but getting same error.

edited Jul 28 '21 at 19:20

James Z

12,209
10
24
44

asked Jul 28 '21 at 18:10

Akanksha_p

Can you try using the newer "ODBC Driver 17 for SQL Server"? – Gord Thompson Jul 28 '21 at 19:29
I was hoping if few changes here and there in code would resolve the issue. In the end if nothing works, I will install ODBC Driver 17 for SQL Server and will update here if it works. – Akanksha_p Jul 28 '21 at 19:45
Every fix online points to using a newer driver. – Otter Jul 28 '21 at 19:52
@GordThompson, upgrading to new driver worked. – Akanksha_p Jul 30 '21 at 05:39

Win server connection with SQL server. pypyodbc.DatabaseError: ('08001', '[08001] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error')

0 Answers0