Server not found from SQL during install of Workload Automation AE

Products

• CA Workload Automation AE - Business Agents (AutoSys)

Issue/Introduction

When installing WorkLoad Automation AE on the machine Linux RedHat 8 + Database MSSQL Server

The message :

2021-04-07 14:40:58,887 [main] DEBUG com.ca.autosys.db.utils.CommandExecutor - Command Env : PATH = /opt/mssql-tools/bin:/usr/xpg4/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/opt/mssql-tools/bin:/root/bin:/opt/mssql-tools/bin:/bin:/usr/bin:/sbin:/usr/sbin:/usr/local/bin

2021-04-07 14:41:06,903 [Thread-17] ERROR com.ca.autosys.db.utils.CommandExecutorThread - Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Login timeout expired.

 2021-04-07 14:41:06,903 [Thread-17] ERROR com.ca.autosys.db.utils.CommandExecutorThread - Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : TCP Provider: Error code 0x2AF9.

2021-04-07 14:41:06,903 [Thread-17] ERROR com.ca.autosys.db.utils.CommandExecutorThread - Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. 

Environment

Release : 12.0

Component : AUTOSYS WORKLOAD AUTOMATION

Resolution

export IA_AE_SKIP_DB_CHECK=1

Rerun the installation again. However during the installation the database will not be created.

After the installation, you will need to run CreateAEDB.pl.
When you need to specify the server in case of named instance, the syntax should be as INSTANCE\\hostname or INSTANCE\\hostname:port
When specifying the DB user password, put it between double quotes.