Issue with RDM on Ubuntu 22.04 - SSL Handshake Error with MSSQL
Hello,
I'm currently setting up Remote Desktop Manager (RDM) on a Ubuntu 22.04 workstation. I've encountered a problem while trying to connect to a Microsoft SQL Server data source. The error message I receive is: "A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 31 - Encryption(ssl/tls) handshake failed)."
After some investigation, I believe the issue is related to the SSL/TLS protocol version being used. It seems that my client is attempting to use TLSv1, which is likely causing the handshake failure. To address this, I have tried modifying the OpenSSL configuration. In the /etc/ssl/openssl.cnf file, I added the following lines to enforce a minimum protocol of TLSv1.2:MinProtocol = TLSv1.2CipherString = DEFAULT@SECLEVEL=2
Despite these changes, the issue persists, and the client still seems to default to TLSv1. I'm looking for advice or solutions from anyone who may have experienced a similar issue or has expertise in this area. Any help or guidance on how to force the client to use TLSv1.2 or troubleshoot this problem further would be greatly appreciated.
Hello,
What is the operating system of the server you are trying to connect to?
Your problem is probably on the server side. Some older versions of Windows only have TLSv1.0 and/or TLSv1.1 enabled by default. Even if you force TLSv1.2 on the client side, the server may not allow this protocol.
On Ubuntu 22.04, you can try changing CipherString = DEFAULT@SECLEVEL=2 to level 0 and changing TLSv1.2 to TLSv1. If this works, we can say that the problem is that your server only accepts TLSv1. If this is the case and you can change the server configuration, I'd suggest enabling TSLv1.2 and later versions instead of TLSv1.0.
Try the above changes on your Ubuntu and let me know if it works.
Regards,
Simon Duguay Létourneau