SQLCMD.EXE not found


Hi there,
while running the installation it failes with

  • Starting FineBuild5ConfigureSQL

Process Id 5: Starting SQL Configuration processing (See 6) at 14:44:59
Checking if update scripts are complete.
Process Id 5A: Services configuration (See 6.2) at 14:45:09
Process Id 5AA: Network Protocols (See at 14:45:09
Network Protocols (See complete
Process Id 5AC: Configure SQL Startup Parameters at 14:45:09
Configuring SQL Server parameters
Checking if update scripts are complete.
Configure SQL Startup Parameters complete
Process Id 5AE: Configure Service Startup Options at 14:45:24
Starting Reporting Services
Configure Service Startup Options complete
Process Id 5B: Instance configuration (See 6.3) at 14:45:32
Process Id 5BA: SQL Surface Area options (See at 14:45:32
***** Error has occurred *****
Process : 5BA: SQL Surface Area options (See
Error code : 1
Last Action: Run in a file: "E:\Program Files\Microsoft SQL Server\100\Tools\Binn\SQLCMD.EXE" -S "mybox\TEST" -E -b -e -Q "EXEC sp_configure 'show advanced options', '1'"
Instance Configuration failed
sqlcmd.exe can only be found in the temp directories:
E:>dir sqlcmd.exe /s
Volume in drive E is Programs
Volume Serial Number is 28D5-7798
Directory of E:\Temp\SQLMediaPCU\ia64\Setup\sql_engine_core_shared_msi\PFiles\S
03.04.2010 11:28 546.144 SQLCMD.EXE
           1 File(s)        546.144 bytes
Directory of E:\Temp\SQLMediaPCU\x64\Setup\sql_engine_core_shared_msi\PFiles\Sq
03.04.2010 12:00 345.952 SQLCMD.EXE
           1 File(s)        345.952 bytes
Directory of E:\Temp\SQLMediaPCU\x86\Setup\sql_engine_core_shared_msi\PFiles\Sq
03.04.2010 12:56 154.464 SQLCMD.EXE
           1 File(s)        154.464 bytes
 Total Files Listed:
           3 File(s)      1.046.560 bytes
           0 Dir(s)   1.986.527.232 bytes free
Please advise.

file attachments

Closed Feb 17, 2012 at 2:48 PM by EdVassie


EdVassie wrote Jan 25, 2012 at 12:28 PM


Can you attach the full FineBuild log file and XML file (probably in E:\Program Files\FineBuildLogs) and SQL Server install Summary file (probably in C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap)

This will help me to debug your problem.

sqlee_installer wrote Jan 25, 2012 at 1:04 PM

File attached.

EdVassie wrote Feb 17, 2012 at 2:43 PM

The problem was caused by a previous install of SQL Server that put the SQL Tools on a different disk. FineBuild did not check this situation, but it is now fixed in FineBuild v3.0.2.