MSSQL server - TLS 1.2

Hello,

I installed LinceBi in Ubuntu 20.04. I didn’t have any problem.

Now, I’m trying to connect with a MSSQL database, in Windows 2008 server with SP2. When I try it, the tomcat log report said:

The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: “The server selected protocol version TLS10 is not accepted by client preferences [TLS12]”

I repeat the connection with a Windows 2012 r2 server. The log message was the same.

I found this information:

Windows 2012 r2 server, by default, it has TLS 1,2 enabled.

Windows 2008 server:

  Install  KB4019276
  With Regedit create:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Client] “DisableByDefault”=dword:00000000

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Client] “Enabled”=dword:1

And restart the server.

I continuous with the problem.

Could you tell me if is necesary to do anythink more?

Many thanks.

Make sure that your SQL Server has installed the required updates to support TLS 1.2.
https://support.microsoft.com/en-us/topic/kb3135244-tls-1-2-support-for-microsoft-sql-server-e4472ef8-90a9-13c1-e4d8-44aad198cdbe