An error occurred during pre-login handshake when building TLS 1.3 connection

[JulieJiang752]

Can we get detailed instructions somewhere on how to build TLS 1.3 connection with SQL Server 2022?

Here we have Windows Server 2022 Standard (Version: 21H2) + SQL Server 2022 (Version: 16.0.1000.6).

1. TDS 8.x force strict encryption is enabled;
2. On a Windows 11 client (or having the Windows Server 2022 as the client), we tried to connect to the SQL Server using SQL Server Management Studio 19.2. The error is:
   A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) (Microsoft SQL Server, Error: 10054).

Note that the error won't occur if with TLS 1.2.
Your help will be appreciated.

[David-Engel]

SSMS 19 doesn't support TDS 8 and will only connect with TDS 7.x, which doesn't support TLS 1.3. You should be able to use Azure Data Studio to test your TDS 8 server configuration, though. Let us know if that works for you.

[David-Engel]

Closing due to inactivity.