"Error running SQL script to check permission" error when running CA Service Desk Manager (CA SDM) Configuration.

Products

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

Issue/Introduction

During running CA Service Desk Manager (CA SDM) Configuration, the following error is displayed:

Error running SQL script to check permission

In the logs we see the following error:

INFO CheckDB.java 352 WARNING: Current server not yet defined. 

INFO ProcessUtilities.java 572 Process C:\Program Files (x86)\CA\Service Desk Manager\bin\.\sql_check_db.exe completed with exit code 11 

INFO SQLDatabasePage.java 665 Running: sqlcmd -S <servername> -U ServiceDesk -P <password> -l 5 -i tmp_sql.sql 

ERROR SQLDatabasePage.java 705 java.io.IOException: Cannot run program "sqlcmd" (in directory C:\Users\ADMINI~1\AppData\Local\Temp\3"): CreateProcess error=2, The system cannot find the file specified.

Environment

Release: 12.6 or higher
Component:  CA Service Desk Manager

MDB is hosted on a remote SQL Server

Cause

The SQL Client "sqlcmd" is not installed on the CA SDM server

Resolution

The error detailed above can be resolved by installing the SQL Client on the CA Service Desk Manager server.

The SQL Client is required on the CA Service Desk Manager server to enable communication with the SQL Server that is installed on the remote server in support of the MDB database.