ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Server not found from SQL during install of Workload Automation AE

book

Article ID: 212492

calendar_today

Updated On:

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.