How to resolve "sqlcmd is not recognized as an internal or external command" error when setting up a Spotfire Server database on SQL Server

 

When using SQL Server as the database for Spotfire Server, if sqlcmd is not installed, a message of "sqlcmd is not recognized as an internal or external command..." and the set up will fail.and the a How to use Chocolately package manager to install sqlcmd (a prerequisite to installing a Spotfire Server database in SQL)

 

 

When running the create_databases.bat script for SQL Server, located in the scripts>>mssql_install subfolder, if the sqlcmd is not installed, the following message will appear:

 

 

Note:  The above was encountered when running the create_databases.bat script via command line and entering the requirements one line at a time.

 

 

One method is to install sqlcmd.exe is to use chocolatey.   Chocolatey is a open source package manager for Windows.  For details, seehttps://chocolatey.org/aboutSome of the steps below are taken from here https://chocolatey.org/install

 

1.  Open an admin PowerShell window:

 

2.  Run Get-ExecutionPolicy. If it returns Restricted, then run Set-ExecutionPolicy AllSigned or Set-ExecutionPolicy Bypass -Scope Process.

 

 

3.  Run the following command:

 

 

 

4.  Run the following command:  choco install sqlcmd

 

 

Key in Y to install:

 

 

Once successfully installed, run the create_databases.bat  again to create the schema and schema owner.