HDBSetup can't stablish connection to DB using ODBC DRIVER 18

Products

• CA Harvest Software Change Manager

Issue/Introduction

Can't establish communication with DB using ODBC Driver 18 for SQL SERVER.

Environment

CA SCM HARVEST 14.0.2
Windows Server 2022

DB: SQL SERVER 2019

Cause

These errors occur if both the following conditions are true:

• The Force encryption setting for the SQL Server instance is set to No.
• The client connection string doesn't explicitly specify a value for encryption property, or the Encryption option wasn't explicitly set or updated in the DSN.

The error occurs because of a change in the default behavior of the client drivers. Older versions of client drivers are designed to assume that data encryption is OFF by default. The new drivers assume this setting to be ON by default. Because data encryption is set to ON, the driver tries to validate the server's certificate and fails.

Resolution

Using [ODBC Driver 17 for SQL Server] instead of [ODBC Driver 18 for SQL Server] resolved the problem.

Additional Information

Please see the Microsoft Support site (link) which discusses further information about this functionality.