SQL Client connection fails from windows server 2016

Question

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

Answer 1

Maybe this will help

https://community.progress.com/s/article/How-to-resolve-SSL-Security-error-and-SECCreateCredentials-failures-in-Admin-Console-and-ODBC-connections-after-disabling-SSL-and-TLS1-0-protocols-on-the-WhatsUp-Gold-server

Answer 2

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"

Answer 3

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.