During Hdbsetup Getting Error Sqlcmd Is Not Recognized As An Internal Or External Command

Document ID : KB000107517
Last Modified Date : 20/07/2018
Show Technical Document Details
Issue:
Installing SCM v13.0.3 to a SQL Server database.  During hdbsetup "CR" step I get this error message: 

'sqlcmd' is not recognized as an internal or external command, operable program or batch file.
Error loading schema

What could be causing this problem?.
Environment:
CA Harvest SCM v13 and up
Windows server, connecting to a remote SQL Server database
Cause:
When configuring Harvest SCM to connect to a remote SQL Server database, you will need to install both the SQL Server Native Client and the Command Line Utilities.  "sqlcmd" is one of those command line utilities.
Resolution:
Both the Native Client and Command Line Utilities packages can be found in the SQL Server Feature Pack for your version of SQL Server, found on the Microsoft website.  For SQL Server 2012, this is the link to use:  https://www.microsoft.com/en-us/download/details.aspx?id=29065

When you get there: 

1. Expand the "Install Instructions" section of the page 

2. For the Native Client, look for the paragraph titled "Microsoft® SQL Server® 2012 Native Client".  For the command line utilities, look for a paragraph titled "Microsoft® SQL Server® 2012 Command Line Utilities". It should come just after the paragraph about "Microsoft® SQL Server® 2012 Native Client" 

3. For both components there will be the following links: 

X86 Package(SqlCmdLnUtils.msi) 
X64 Package (SqlCmdLnUtils.msi) 

Select the link for the bit-level you need and the installer will download. 

Note: This component requires both Windows Installer 4.5 and Microsoft SQL Server Native Client (which is another component available from this page). 

4. Install the both the native client and the command line utilities. 

After this HDBSetup can complete successfully and the installation will finish.