Choosing between CA-issued certificate validation and TrustServerCertificate for SQL Server TLS in a mixed DNS environment
Our SQL Server 2022 instances serve applications that connect using both fully qualified domain names (FQDNs) and short hostnames, depending on network zone and legacy configuration. We want to enforce encryption with certificate validation (Encrypt=true, TrustServerCertificate=false) in production, but the current self-signed certificate only contains the F