Could not find location of SqlCmd

JasKik

HI

We have run deployment process via Octopus Successfully in our build and Test environments

During live deployment to production last night SQLautomation step failed with

a powershell  error indicating SQLAutomation Could not find location of SqlCmd

In the end we had to use SQL compare to deploy changes and exclude SQLAutomation

Any pointers as to why SQLCmd was not found?

(it was in the SQL Server instances' binn directory and that was referenced in the system path)

Regards
JM

Sergio R

SQL Change Automation uses the following algorithm to check for sqlcmd:

1. Lists all values from the 32-bit registry paths: "SOFTWARE\Microsoft\Microsoft SQL Server\{x}\Tools\ClientSetup\ODBCToolsPath", where "{x}" is in order 140, 130, 120, 110

2. Does the same for 64-bit registry

3. If nothing is found, it uses the following hardcoded path `Program files (64 or 32 bits depending on architecture)\Microsoft SQL Server\110\Tools\Binn`

JasKik

Thanks sergio

We have installed the odbc and commandline tools 

We are now creating a test project to deploy through to live and see if it works

Will update tomorrow

harishlyb

Hi am getting same error,.

I am using self hosted azure agent for my pipeline, i have installed odbc in it still getting this error.

what all software i need to install please suggest.

and how to check is that software installed or not, using command prompt.

Sergio R

Hi,

You need to install this software:

• Microsoft ODBC Driver 13.1 for SQL Server (download)
• Microsoft Command Line Utilities 14.0 for SQL Server (download)

From: https://documentation.red-gate.com/sca/getting-started/system-requirements/powershell-component-requirements

Sakshi

Hi
I am getting an error of ' Could not find location of SqlCmd.' while deploying a sql Automation project.

Any pointers as to why SQLCmd was not found?
Thanks
Sakshi