After new KTA installation the Designer cannot be opened.
Within the eventlog we observed that the sqlcmd.exe crashed with the following error message:
Faulting application name: SQLCMD.EXE, version: 2014.120.2000.8, time stamp: 0x5306c4e4 Faulting module name: SQLCMD.EXE, version: 2014.120.2000.8, time stamp: 0x5306c4e4 Exception code: 0xc0000005 Fault offset: 0x00001470 Faulting process id: 0x990 Faulting application start time: 0x01d0cea64ac9a478 Faulting application path: C:\Program Files (x86)\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn\SQLCMD.EXE
The KTA installation was running successfully and the databases/tables were created.
When the SQLcmd.exe crashed during creating the KTA databases it has been seen, that the KTA tables has lots of missing entries which results in a non-working KTA environment.
The used SQLCMD.exe version was 10.50.2500.0
(C:\Program Files (x86)\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn\)
To solve this, remove the KTA databases again and also uninstall KTA from the application server. Install the SQL commandline utilities from the SQL installation media by installing the SQL management studio.
For the SQL 2008 R2 it will install the SSQLCMD.exe in version 10.50.1600.1.
This will verify that the version of the SQL commandline utility is the same as the SQL server.
Keywords: total agility, designer loading sqlcmd.exe, Import, Installation