I'm trying to access sql server database so i need sqlcmd but after following microsoft docs here and here. Running sqlcmd returns:

 sqlcmd: command not found 

and I do have mssql-tools installed:

amir@amir-pc:~$ sudo apt-get install mssql-tools
Reading package lists... Done
Building dependency tree       
Reading state information... Done
mssql-tools is already the newest version (

What am i missing? Also i'm on 16.10 and i had no problem installing it on 16.04


Quoting the page you linked to:

Optional Step: Create symlinks to 'SQLCMD' and 'BCP' under /usr/bin/.

ln -sfn /opt/mssql-tools/bin/sqlcmd- /usr/bin/sqlcmd 
ln -sfn /opt/mssql-tools/bin/bcp- /usr/bin/bcp
  • 4
    The commands might not work as it is, I had to remove the version numbers from binary paths like so: ln -sfn /opt/mssql-tools/bin/sqlcmd /usr/bin/sqlcmd
    – Asim
    Mar 1 '17 at 13:32
  1. Add the path either to ~/.bash_profile or ~/.profile if you don't have .bash_profile in your home directory.

    export PATH="$PATH:/opt/mssql-tools/bin" 
  2. Add the following path to your ~/.bashrc file

    export PATH="$PATH:/opt/mssql-tools/bin"
  3. Don't forget to update the path configuration by issuing the following command in your terminal window:

    source ~/.bashrc

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.