Let us assume that the SQL Server installation is done properly.
If the command prompt returns -
(name of the software) is not recognized as an internal or external
command, operable program or batch file.
this means that the file of software of command is not defined in the %PATH% environment variable.
With this latter it is possible to recall executable applications without defining their full path. Then, to solve this issue you can create an environment variable with the complete location and add it to the path:
On my system I have SQLCMD.exe at location C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn. Please find where it is in your system. To find simply go to SQL Server installation folder and search for sqlcmd.exe.
- Control Panel > System > Advanced > Environment Variables
- Add a new variable give it a name let say SQLSERVERSQLCMD and add path in the value i.e. C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn.
- Find another variable named PATH and add %SQLSERVERSQLCMD% at the end of it.
Hope this helps and solves your problem.