MSSQL, Net6.0, (provider: SSL Provider, error: 31 – Encryption(ssl/tls) handshake failed) on Ubuntu

I am trying to connect different versions of MSSQL which is not support TLSv1.2. So i searched on internet and found something useful.

First of all, which error occured , lets talk about it

Microsoft.Data.SqlClient.SqlException (0x80131904): 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)
 ---> System.IO.IOException:  Received an unexpected EOF or 0 bytes from the transport stream.
   at System.Net.Security.SslStream.ReceiveBlobAsync[TIOAdapter](TIOAdapter adapter)
   at System.Net.Security.SslStream.ForceAuthenticationAsync[TIOAdapter](TIOAdapter adapter, Boolean receiveFirst, Byte[] reAuthenticationData, Boolean isApm)
   at System.Net.Security.SslStream.AuthenticateAsClient(SslClientAuthenticationOptions sslClientAuthenticationOptions)
   at System.Net.Security.SslStream.AuthenticateAsClient(String targetHost, X509CertificateCollection clientCertificates, SslProtocols enabledSslProtocols, Boolean checkCertificateRevocation)

After i saw error and some search changed opensll.cnf

I have changed MinProtocol From TLSv1.2 to TLSv1 and DEFAULT@SECLEVEL=2 to 1. Afterwards connection established

See you, Gökhan


Posted

in

by

Tags:

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *