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
All CA Service Desk Manager environments where the MDB is hosted on a remote SQL Server
The SQL Client is not installed on the CA SDM server
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.