Unable to launch TDM Datamaker - receiving SQL Client Error

Document ID : KB000111793
Last Modified Date : 21/08/2018
Show Technical Document Details
Issue:
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 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.