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.
    This image shows the configuration settings for SQL Server ODBC