Windows server 2008 MSSQL extension config

jbulko — Tue, 20 Aug 2024 10:17:50 GMT

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?

Re: windows server 2008 MSSQL extension config

jegron — Wed, 19 Jul 2023 06:50:01 GMT

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-server-e4472ef8-90a9-13c1-e4d8-44aad198cdbe

And then check the TLS configuration registry :

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

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 🙂

topic Re: windows server 2008 MSSQL extension config in Extensions

Windows server 2008 MSSQL extension config

Re: windows server 2008 MSSQL extension config