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- | sudo apt-key add -
sudo add-apt-repository "$(wget -qO- )"
sudo apt-get update
sudo apt-get install -y mssql-server
sudo /opt/mssql/bin/mssql-conf setup
systemctl status mssql-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 (>= 17.3.0.0) but it is not going to be installed Depends: msodbcsql17 (< 17.4.0.0) but it is not going to be installed E: Unable to correct problems, you have held broken packages.

My operation system is Linux Ubuntu 18.04.1 LTS

5 Answers

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 | sudo apt-key add -
echo "deb [arch=amd64] bionic main" | sudo tee /etc/apt/sources.list.d/mssql-release.list
sudo apt update
sudo apt install msodbcsql17

4

I had the same issue but above solutions didn't workout for me. So here's how I solved this problem.

sudo apt-get install -y libodbc1
sudo apt update
sudo apt install unixodbc

Following commands from microsoft docs

sudo su
curl | apt-key add -
curl > /etc/apt/sources.list.d/mssql-release.list
exit
sudo apt-get update
sudo ACCEPT_EULA=Y apt-get install msodbcsql17

2

I had similar problem but not same. In my case error was

can't open lib '/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.2.so.0.1' : file not found

I was uninstalling msodbc and then reinstalling it. After some research, I needed to uninstall msodbc17, and then do re-install.

sudo apt-get remove msodbcsql17
sudo apt-get install msodbcsql17 -y

It was not enough in my case, and I was made to execute the following commands: sudo apt install libodbc1 sudo apt install unixodbc

This issue was resolved here correctly on TechDirectArchive.

• Root cause: The msodbcsql17 package have a different version of mssql-tools, both should have the same version

Solution: Update msodbcsql17 package running the following command

• sudo apt-get install msodbcsql17

Formore infomation, see the link below

0

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

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