SQLTeam.com | Weblogs | Forums

Enable issue - SSL in SQL server 2017


I have tried to enable the SSL in SQL server 2017 with self-signed server certificate and wildcard SSL certificate.

self-signed server: I can able to create the certificate and configured with SQL server 2017 configuration manager.But the problem raised when we connect this to our application.We have confused to frame the connection string with these two properties Encrypt, TrustServerCertificate. Can you please let me know the actual use case of these two properties in both self-signed server certificate and CA Certificate.

wildcard SSL certificate: I can able to import this certificate but I can't see this in SQL server 2017 configuration manage. Also, provide Encrypt, TrustServerCertificate properties use case for this also.

any help would be appreciated!

Thank you