windows server 2008 MSSQL extension config

[jbulko]

Hi,

I have few MSSQL instances configured, but got error:

Failed to assign monitoring configuration to ActiveGate. Reason: Fast check failed for 1 endpoint(s). Cannot connect to database server\dbinstance:1433. Exception occured: 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 [TLS13, TLS12]".

OS version:  Microsoft Windows Server 2008 R2 Enterprise (6.1.7601 Service Pack 1 Build 7601)
SQL: Microsoft SQL Server 2008 R2 (SP3) - 10.50.6000.34 (X64) 

How can I fix this issue?

[jegron · Accepted solution]

Hi @jbulko !

Already have this issue. First you have to patch your server to enable TLS1.2 :

https://support.microsoft.com/fr-fr/topic/kb3135244-prise-en-charge-de-tls-1-2-pour-microsoft-sql-se...

And then check the TLS configuration registry :

https://knowledge.digicert.com/quovadis/ssl-certificates/ssl-general-topics/how-to-enable-tls-1_2-on...

From what I remember the change works on the fly once the patch has been applied, but it may require a server reboot.

Hope it help 🙂