Search Server Upgrade cannot find sqlcmd

Products

• CA Service Desk Manager
• CA Service Management - Service Desk Manager

Issue/Introduction

When upgrading Search Server, the upgrade fails with this error:

2024/01/20 20.35.21.050 INFO  [AWT-EventQueue-0] [DatabaseHelper] Starting verifyDbClient...
2024/01/20 20.35.21.050 INFO  [AWT-EventQueue-0] [DatabaseHelper] Verifying database...mssql
2024/01/20 20.35.21.050 DEBUG [AWT-EventQueue-0] [CmdLineUtility] Command process started
2024/01/20 20.35.21.050 ERROR [AWT-EventQueue-0] [DatabaseHelper] Checking for SQLServer client sqlcmd threw exception.
2024/01/20 20.35.21.050 ERROR [AWT-EventQueue-0] [MDBValidator] SU2003
java.lang.Exception: SU2003

Caused by: com.ca.smsi.installcore.exceptions.CmdFailedException: java.io.IOException: Cannot run program "sqlcmd": CreateProcess error=2, The system cannot find the file specified

SQL Server Management Studio is able to connect to the Database with no issue

Environment

Search Server 17.3 and higher

SQL Server 2019

 

Cause

The client tools in SQL server are missing

The customer had recently upgraded SQL Server and they suspect these tools were removed during that process

Resolution

Ensure that the SQL client tools are correctly installed on the server

Reference another working server using the same version if necessary.