TDM unable to connect with SQL Server

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

When trying to connect to SQL Server from TDM, getting below error:

ERROR:

"encrypt" property is set to "false" and "trustServerCertificate" property is set to "true" but the driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption: Error: The server selected protocol version TLS10 is not accepted by client preferences [TLS13, TLS12].

Environment

TDM 4.11.x

Cause

Inability of SQL Sever instance to support TLSv1.2

Resolution

This error indicates that the target SQL Server is not supporting TLSv1.2 and trying to use TLSv1.0.

From the JDK being used in the later patches of TDM, the older version of TLSv1.0 has been deprecated due to multiple security vulnerabilities.

To resolve this issue without compromising on security, target SQL Server to be patched with a version that supports TLSv1.2. Please refer below article:

- https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/tls-1-2-support-microsoft-sql-server