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

Question

My server is windows 2008 server r2. I found the following error on my server after disable tls 1.0 and SSLv3.

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

Currently, only TLS 1.2 is enabled on my server, and at the client side the TLS 1.2 is set on

Is it posible if [DBNETLIB] is running on TLS 1.2?

Answer 1

There might be chances that ODBC 11.0 earlier version is been installed. In this case the connection string should be Driver={ODBC Driver 11 for SQL Server};Server=myServerAddress;Database=myDataBase;Trusted_Connection=yes;

And also check TLS 1.2 is enabled

Answer 2

I had to do several things. The server was Windows 2016 Standard testing with a .txt file I changed to .UDL. This server was trying to connect to our Sql Server 2008 R2 SP3

On the 2016 box I installed SQL Server Native client 10.0

Get that here : https://www.microsoft.com/en-us/download/details.aspx?id=57606

Finally on the sql server box I had to install patch KB4057113 to enable TLS1.2

Note when testing the connection by opening the .UDL file don't forget to change the provider to SQL Server Native Client 10.0

Answer 3

1. Open Regedit (Wind+R > regedit)
2. Locate HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib
3. Create a new word value and name it "Certificate" set the value to this: "Certificate=0"
4. Also modify the default REG_SZ and set the value to "Certificate=0"
5. Restart the MSSQL service

Hope this helps since worked for me.