none
SSL Crtificates in SQL Server RRS feed

  • Question

  • Hi,

       We have implemented SSL Encryption by enabling Force Encryption and Certificate. I have queried sys.dm_exec_conn and encrypt_option is true for all connections. Post this SQL services have been restarted but I am able to make a test connection like earlier from a different machine without any certificate being imported. Is this normal behavior or am I missing anything? Followed below link for enabling but certificate has been created by our OS admins.

    https://www.mssqltips.com/sqlservertip/3299/how-to-configure-ssl-encryption-in-sql-server/

    Regards,

    Raaj

    Monday, July 15, 2019 10:03 AM

All replies