Autosys R12.1 Database Validation failed during installation

Products

• CA Workload Automation AE

Issue/Introduction

Hi support team, 

I am getting this error during the installation, the new versions of sqlcmd are secure by default.

In command line I can add -No option to disable encryption? (sqlcmd -No -S localhost -U sa), How can I bypass this in the installation?

Database Validation
-------------------

Error:
[CAUAJM_E_112515] Unable to connect to the "aedb-server" database server 
using the database client utility. For more information, refer to the log 
file.

2023-09-11 17:03:15,082 [Thread-29] ERROR com.ca.autosys.db.utils.CommandExecutorThread(44) - Sqlcmd: Error: Microsoft ODBC Driver 18 for SQL Server : SSL Provider: [error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed:self signed certificate].
2023-09-11 17:03:15,083 [Thread-29] ERROR com.ca.autosys.db.utils.CommandExecutorThread(44) - Sqlcmd: Error: Microsoft ODBC Driver 18 for SQL Server : Client unable to establish connection.

Environment

Release : 12.1

Resolution

The issue was resolved as follows:

1. Rename the current sqlcmd to sqlcmd_orig.

2. Create a wrapper script named sqlcmd with the following content:

#!/bin/bash
/opt/mssql-tools18/bin/sqlcmd_orig -No "$@"

3. Run the installer to install the product.