Share via

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

Selvam, Prabhakar Panner 6 Reputation points
2021-06-02T08:45:11.473+00:00

Hi Leads,
When we connect ODBC connection error on windows server2012 R2. 101673-ssl-security-error.png
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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,852 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,238 questions

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. CarrinWu-MSFT 6,856 Reputation points
    2021-06-03T03:15:38.543+00:00

    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:
    101953-1.png

    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.

    1 person found this answer helpful.
    0 comments
  2. Erland Sommarskog 102.1K Reputation points MVP
    2021-06-02T22:14:57.32+00:00

    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.

    0 comments
  3. Daniel Serrano 0 Reputation points
    2023-02-19T18:04:13.3233333+00:00
    0 comments
  4. Alpesh Dhori 0 Reputation points
    2023-09-26T11:14:43.8566667+00:00

    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

    0 comments