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

Document ID : KB000027404
Last Modified Date : 14/02/2018
Show Technical Document Details

Problem

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

All CA Service Desk Manager environments where the MDB is hosted on a remote SQL Server

Cause

The SQL Client 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.