SQL Client connection fails from windows server 2016

Somaiah, Devaraja 1 Reputation point
2022-11-14T12:38:55.503+00:00

Hi,

From windows server 2016 trying connection to SQL server it complains with below error

[DBNETLIB][ConnectionOpen (SECCreateCredentials()).]SSL Security error.

Same connection works fine from Windows server 2012 R2.Please let me know what is the issue here I checked TLS1.2 settings in registry it looks ok to me.

Thanks
Devaraj

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,322 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Ken Tucker 5,846 Reputation points
    2022-11-14T12:50:11.257+00:00

  2. PandaPan-MSFT 1,911 Reputation points
    2022-11-15T07:05:14.333+00:00

    Hi @Somaiah, Devaraja ,
    I think this error may arise from the version of ODBC are not compitable for your windows server 2016. You can dowload the latest version in this link: https://learn.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver16


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment"


  3. Somaiah, Devaraja 1 Reputation point
    2022-11-15T09:13:41.497+00:00

    Hi @PandaPan-MSFT
    Thank you for the response.I was not able to get root cause for the issue.
    I enabled TLS1.0/1.1/1.2 in registry settings for the client then I was able to establish connection to SQL server.

    0 comments No comments