VIS Creator - 'sqlcmd' is not recognized as an internal or external command
This article applies to
This article does not apply to
This article is not tied to any specific product.
Not all product versions are identified in this article.
Symptoms
Installation of Creator fails to complete. The log file created during install (in directory c:\VIS Creator Install Log) contains the following output:
Action 12:58:34: InstallServices. Installing new services
Action 12:58:34: InstallDatabaseCommand.
CAQuietExec: "C:\WINDOWS\Microsoft.NET\Framework\v3.5\MSBuild.exe" "C:\Program Files (x86)\DynamicOps Virtual Resource Manager Server\DeploymentScripts\DeployVMPS.xml" /t:BuildDB /p:DBServer=cscdvcsqlcl01;DBName="VRM" /p:DBConnectParam=" -U cscdvrmsql -P Td007" /p:ServiceUser=ndcvc\cscdvrm /p:ReportLogin=ndcvc\cscdvrm /p:DBDir="\." /p:LogDir="\."
CAQuietExec: Microsoft (R) Build Engine Version 3.5.30729.1
CAQuietExec:
CAQuietExec: Copyright (C) Microsoft Corporation 2007. All rights reserved.
CAQuietExec:
CAQuietExec: Build started 10/20/2009 12:58:36 PM.
CAQuietExec: Project "C:\Program Files (x86)\DynamicOps Virtual Resource Manager Server\DeploymentScripts\DeployVMPS.xml" on node 0 (BuildDB target(s)).
CAQuietExec: 'sqlcmd' is not recognized as an internal or external command,
CAQuietExec: operable program or batch file.
CAQuietExec: C:\Program Files (x86)\DynamicOps Virtual Resource Manager Server\DeploymentScripts\DeployVMPS.xml(23,5): error MSB3073: The command "sqlcmd -S cscdvcsqlcl01 -U cscdvrmsql -P Td007 -i DropDatabase.sql -v DBName="VRM" DBDir="\." LogDir="\."" exited with code 9009.
CAQuietExec: Done Building Project "C:\Program Files (x86)\DynamicOps Virtual Resource Manager Server\DeploymentScripts\DeployVMPS.xml" (BuildDB target(s)) -- FAILED.
CAQuietExec:
CAQuietExec: Build FAILED.
CAQuietExec:
CAQuietExec: "C:\Program Files (x86)\DynamicOps Virtual Resource Manager Server\DeploymentScripts\DeployVMPS.xml" (BuildDB target) (1) ->
CAQuietExec: (DropDB target) ->
CAQuietExec: C:\Program Files (x86)\DynamicOps Virtual Resource Manager Server\DeploymentScripts\DeployVMPS.xml(23,5): error MSB3073: The command "sqlcmd -S cscdvcsqlcl01 -U cscdvrmsql -P Td007 -i DropDatabase.sql -v DBName="VRM" DBDir="\." LogDir="\."" exited with code 9009.
CAQuietExec:
CAQuietExec: 0 Warning(s)
CAQuietExec: 1 Error(s)
CAQuietExec:
CAQuietExec: Time Elapsed 00:00:00.87
CAQuietExec: Error 0x80070001: Command line returned an error.
CAQuietExec: Error 0x80070001: CAQuietExec Failed
Action ended 12:58:37: InstallFinalize. Return value 3.
Action 12:58:37: Rollback. Rolling back action:
Action 12:58:34: InstallServices. Installing new services
Action 12:58:34: InstallDatabaseCommand.
CAQuietExec: "C:\WINDOWS\Microsoft.NET\Framework\v3.5\MSBuild.exe" "C:\Program Files (x86)\DynamicOps Virtual Resource Manager Server\DeploymentScripts\DeployVMPS.xml" /t:BuildDB /p:DBServer=cscdvcsqlcl01;DBName="VRM" /p:DBConnectParam=" -U cscdvrmsql -P Td007" /p:ServiceUser=ndcvc\cscdvrm /p:ReportLogin=ndcvc\cscdvrm /p:DBDir="\." /p:LogDir="\."
CAQuietExec: Microsoft (R) Build Engine Version 3.5.30729.1
CAQuietExec:
CAQuietExec: Copyright (C) Microsoft Corporation 2007. All rights reserved.
CAQuietExec:
CAQuietExec: Build started 10/20/2009 12:58:36 PM.
CAQuietExec: Project "C:\Program Files (x86)\DynamicOps Virtual Resource Manager Server\DeploymentScripts\DeployVMPS.xml" on node 0 (BuildDB target(s)).
CAQuietExec: 'sqlcmd' is not recognized as an internal or external command,
CAQuietExec: operable program or batch file.
CAQuietExec: C:\Program Files (x86)\DynamicOps Virtual Resource Manager Server\DeploymentScripts\DeployVMPS.xml(23,5): error MSB3073: The command "sqlcmd -S cscdvcsqlcl01 -U cscdvrmsql -P Td007 -i DropDatabase.sql -v DBName="VRM" DBDir="\." LogDir="\."" exited with code 9009.
CAQuietExec: Done Building Project "C:\Program Files (x86)\DynamicOps Virtual Resource Manager Server\DeploymentScripts\DeployVMPS.xml" (BuildDB target(s)) -- FAILED.
CAQuietExec:
CAQuietExec: Build FAILED.
CAQuietExec:
CAQuietExec: "C:\Program Files (x86)\DynamicOps Virtual Resource Manager Server\DeploymentScripts\DeployVMPS.xml" (BuildDB target) (1) ->
CAQuietExec: (DropDB target) ->
CAQuietExec: C:\Program Files (x86)\DynamicOps Virtual Resource Manager Server\DeploymentScripts\DeployVMPS.xml(23,5): error MSB3073: The command "sqlcmd -S cscdvcsqlcl01 -U cscdvrmsql -P Td007 -i DropDatabase.sql -v DBName="VRM" DBDir="\." LogDir="\."" exited with code 9009.
CAQuietExec:
CAQuietExec: 0 Warning(s)
CAQuietExec: 1 Error(s)
CAQuietExec:
CAQuietExec: Time Elapsed 00:00:00.87
CAQuietExec: Error 0x80070001: Command line returned an error.
CAQuietExec: Error 0x80070001: CAQuietExec Failed
Action ended 12:58:37: InstallFinalize. Return value 3.
Action 12:58:37: Rollback. Rolling back action:
Resolution
The installer requires a local install of the SQL Client. Two SQL components must be installed on the Creator server.
Microsoft SQL Server 2008 Native client and Microsoft SQL Server 2008 Command Line Utilities, both of which can be found through the following link:
Once both have been installed, the following path needs to be added to the System Variables section of the Environment Variables for the Server:
C:\Program Files\Microsoft SQL Server\100\Tools\Binn\
Care must be taken so that no white spaces are inserted before or after the semicolon.
DOPS solution 61.
Article Properties
Article Number: 000066558
Article Type: Solution
Last Modified: 21 Feb 2021
Version: 3
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.