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
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.