[Microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error

Question

Hi Leads,
When we connect ODBC connection error on windows server2012 R2.
Please find the attached file which is having error. Kindly help on this resolve this issue.

OS: Windows Server 2012 R2
SQL version: SQL Server 2012
ODBC version: 12.64.00.00

Thanks & Regards,
Prabhakar
+91-7829124152

Answer 1

Hi @Selvam, Prabhakar Panner ,

Welcome to Microsoft Q&A!

Are you use TLS 1.0 or TLS 1.2? And please check Erland mentioned SELECT @@version. If you use TLS 1.2, not every SQL Server release is supposted TLS 1.2, please refter to KB3135244 - TLS 1.2 support for Microsoft SQL Server:

Best regards,
Carrin

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

What does "SELECT @@version" report?

The most likely this is a TLS issue where one component uses TLS 1.0 and the other wants TLS 1.2. I don't know the ODBC version numbers by heart, but you can always download and install the most recent ODBC driver which is ODBC 17. Don't forget to change the connection string.

Answer 3

Tested solution here:

https://danarman.blogspot.com/2023/02/windows-11-unable-to-connect-to-sql.html

Answer 4

I notice this with Microsoft SQL Server 2016 (SP2) and Windows Server 2012, You need to enable the TLS 1.0 and follow by restart of Window Server.

Refer this article link for more details https://community.brightlysoftware.com/s/article/SSL-Security-error-message-in-Confirm