I am getting the 'Unable to connect. Error: Failed to connect to xxx.xxx:1433 - socket hang up' error when connecting to SQL Server with encryption (and trusting the server certificate).
The SQL Server has TLS 1.2 enabled and I confirmed that when I connect to it using other tools, a TLS 1.2 connection is established.
I can see that the handshake fails on the server (in xEvents):
SNISecurity Handshake failed. PeerAddr: 5
This is SQL Server 2016 SP3. I have no problems with any other tools or applications connecting to the server with encryption.
Not entirely sure but will certainly investigate! Out of curiosity, does the connection work without using TLS?
Hi @Kabirdas, yes it works without TLS. I also had no problems with connecting Retool to SQL Server 2019.
That server was SQL Server 2012 that did not support TLS 1.2. I installed SP3, which adds TLS 1.2. The error message changed to what it is now. Then I upgraded to SQL Server 2016, but still get the same error. I have no problems with connecting to that server with other tools and applications using TLS 1.2.
Sorry about the late reply here. It looks as though this may be an issue on our end and our engineers will take a look into it. For some context, are you using an MSSQL resource for this connection or a MySQL resource?
Thank you, @Kabirdas. MSSQL (Microsoft SQL Server 2016)