AE R12 install with MSSQL DB error Unable to find SQLCMD

book

Article ID: 206757

calendar_today

Updated On:

Products

CA Workload Automation AE - Scheduler (AutoSys)

Issue/Introduction

When installing Autosys AE 12 with a Microsoft SQL DB, I receive an error about  Unable to find "sqlcmd" in the PATH...

Cause

AE requires an additional package to connect to the database

Resolution

Cancel the install.

Download Microsoft SQL Server Management Studio (SSMS): SSMS is a requirement for sqlcmd utility.

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

Install it.
Reboot

Download the Microsoft sqlcmd utility from this link

https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility?view=sql-server-ver15

Install it.
Reboot

You do not need to do anything with this utility. It just needs to be installed and the server rebooted.

Start the AE installer again.

Attachments