Ubuntu – Unable to install msodbcsql17 on Ubuntu 18.04


I installed the sqlserver based on the Microsoft Documentation.
The following commands are executed correctly.

wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -

sudo add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2017.list)"

sudo apt-get update
sudo apt-get install -y mssql-server

sudo /opt/mssql/bin/mssql-conf setup

systemctl status mssql-server

status of sql server

But when I try to install the SQL Server command-line tools,the following error occurs.

sudo apt-get install mssql-tools unixodbc-dev

Reading package lists... Done
Building dependency tree       
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
 mssql-tools : Depends: msodbcsql17 (>= but it is not going 
 to be installed
           Depends: msodbcsql17 (< but it is not going to be 
 E: Unable to correct problems, you have held broken packages.

My operation system is Linux Ubuntu 18.04.1 LTS

Best Answer

After searching around, I have found the requested package, it is located on Microsoft Ubuntu 18.04 repository, in order to install the package you have to add the repo first.

This will install msodbcsql17 that correspond to Ubuntu 18.04, open up terminal and run:

curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
echo "deb [arch=amd64] https://packages.microsoft.com/ubuntu/18.04/prod bionic main" | sudo tee /etc/apt/sources.list.d/mssql-release.list
sudo apt update
sudo apt install msodbcsql17