Unable to launch TDM Datamaker - receiving SQL Client Error

Products

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

Issue/Introduction

When attempting to connect to a SQL Server based Repo, the SQL Native Client returns errors such as:

Reconfigure SQL Server - connect

Profile:    [profile name]
Title:    Test Data Repository

Database Fatal Error Message:    SQLSTATE = 08001
Microsoft SQL Server Native Client 10.0
Encryption not supported on the client.

Transaction Error Code:    -1
Database Error Code:    21

CA Test Data Manager - Datamaker Details:

GUI Version:    4.6.0.13    (7/24/2018 18:32:24)
REP Version:    3.2M

Transaction Details:

PB DBMS driver:    SNC SQL Native Client(OLE DB)
Server DBMS:    SQL Server (sql server)
Server Version:    12.00.5571
Current System:    [SQL SERVER HOSTNAME]
Current Database:    gtrep
Database:    
Login ID:    PIM_Test
DBParm:    Database='gtrep',DelimitIdentifier=0,DisableBind=0,AppName='CA Test Data Manager - Datamaker'
ServerName:    [SQL SERVER HOSTNAME]
AutoCommit:    false

ii_identifier_case = 3
ib_current_schema_only = false
ib_db2 = false
ib_db2_400 = false
ib_extra_fkeys = false
ib_fkey_capable = true
ib_new_fkeys = false
ib_pkey_capable = true
ib_single_schema = false
ib_unicode = true
ib_user_views = false

OR

Failed to get sessionid

Profile: [profile name]
Title: Test Data Repository

Database Error Message: SQLSTATE = 37000
[Microsoft][SQL Server Native Client 11.0][SQL Server]'SYS_CONTEXT' is not a recognized built-in function name.

Transaction Error Code: -1
Database Error Code: 195

CA Test Data Manager - Datamaker Details:

GUI Version: 4.5.0.36 (3/21/2018 12:47:28)
REP Version: 3.2L

Transaction Details:

PB DBMS driver: odbc
ODBC Driver: sql server native client 11.0
ODBC DBMS Name: sql server
Server DBMS: SQL Server (sql server)
Server Version: 12.00.5571
Current System: [SQL SERVER HOSTNAME]
Current Database: gtrep
Database:
User ID: PIM_Test
DBParm: ConnectString='Driver={SQL Server Native Client 11.0};server=[SQL SERVER HOSTNAME];database=gtrep; UID=PIM_Test; PWD=*; APP=CA Test Data Manager - Datamaker',ConnectOption='SQL_DRIVER_CONNECT,SQL_DRIVER_NOPROMPT',DelimitIdentifier='NO'
AutoCommit: false

ii_identifier_case = 3
ib_current_schema_only = false
ib_db2 = false
ib_db2_400 = false
ib_extra_fkeys = false
ib_fkey_capable = true
ib_new_fkeys = false
ib_pkey_capable = true
ib_single_schema = false
ib_unicode = true
ib_user_views = false

Environment

Supported Test Data Manager versions with supported MS SQL Server based repository.

Resolution

Ensure that the proper SQL Native client version is installed for use with the SQL Server version being used.
If TLS 1.2 is enabled/forced on the server, a patched version of the client may be required.

If the version is appropriate, it is recommended to uninstall any installed version of the client (including the current version) and reinstall the appropriate version for the SQL Server in question.