SQL Server and Client-Side DNS: Certificate Subject Name Validation
TLS Handshake and Hostname Resolution When establishing a secure connection to Microsoft SQL Server using Encrypt=True and TrustServerCertificate=False , the client must validate that the server's identity matches the certificate provided during the TLS handshake. The validation process typically relies on the hostname specified in the connection string. If