[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).] SSL security error on windows server 2008

Question

I have a problem of SQL connection between two servers. One of the servers where the site code is stored is a Windows Server 2008 and my database is on a Windows Server 2003.

Here is a part of my code :

Set Conn = Server.CreateObject("ADODB.Connection")
ConnStr = "Provider=SQLOLEDB; Data Source=10.0.0.17; Initial Catalog=******;UID=*******;Pwd=********%"
Conn.open ConnStr

Microsoft OLE DB Provider for SQL Server erreur '80004005' [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).] SSL security error.

So I saw on the internet people talking about enabling TLS 1.0 on my server and that's what I did on both.

Here is what I have in both my client and server registers

But even after that I still have the same mistake. Could someone please help me

Answer 1

Someone turned off TLS 1.0 support on your database server - thinking that it would improve security.

The October 2021 update of Windows 10 finally updated the SQLOLEDB driver to support TLS 1.2.

Otherwise you'll have to switch the currently supported MSOLEDBSQL driver. It's the only officially supported SQL Server OLEDB since SQL Server 2012, and it supports TLS 1.2.