Troubleshooting DpeNanoServices under Linux

Issue

Solution

A specified windows machine name cannot be found from Linux client, e.g. MyServer

Use fully qualified domain names (FQDN), e.g. MyServer.MyDomain.com

A specified MS SQL Server can be found from a Linux client but pre-login SSL handshake fails

CODE

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.EndOfStreamException: End of stream reached

Probably your SQL server or operating system does not support TLS 1.2. Enable TLS 1.2 or use a newer SQL server.

Also see https://learn.microsoft.com/en-us/sql/connect/ado-net/sqlclient-troubleshooting-guide?view=sql-server-ver15#login-phase-errors