Configuring the ODBC Driver for Encryption
You must configure the SQL Server ODBC to enable encryption.
For example, with SQL Server ODBC Driver, follow the below settings:
- Connection Encryption is set to Mandatory.
- Trust server certificate checkbox is selected.
- The Hostname in certificate field must match the hostname in the database server
certificate.