Hi, I want to install mssql-server 2019 on my ubuntu 22.04 machine and I got some error, after searching I found out this problem is because mssql does not support this version of ubuntu. When will mssql support ubuntu 22.04?

Thanks! This was very helpful and solved my problem. For anyone looking for explicit commands on an Ubuntu 22.04 installation, $ cd /opt/mssql/lib $ ls -la $ sudo rm libcrypto.so libssl.so $ sudo ln -s /usr/lib/x86_64-linux-gnu/libcrypto.so.1.1 libcrypto.so $ sudo ln -s /usr/lib/x86_64-linux-gnu/libssl.so.1.1 libssl.1.1 If you're missing version 1.1 of these files, you can first do $ sudo apt install libssl1.1

You can successfully use mssql-server on ubuntu 22.04, you will need copies of libssl.so.1.1 and libcrypto.so.1.1 from Ubuntu 20.04, you can place these files in the /opt/mssql/lib directory as libssl.so and libcrypto.so

Hi @Alireza Shahamiri , Welcome to Microsoft Q&A! Yes. As you said, mssql does not support ubuntu 22.04. So far, you can install SQL Server 2019 on Ubuntu 16.04, 18.04, or 20.04(CU10). Please see this document: https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-setup?view=sql-server-ver15#supportedplatforms Your question is related to SQL Server future plans. Here is a feedback site where you can post your question: https://feedback.azure.com/d365community/forum/04fe6ee0-3b25-ec11-b6e6-000d3a4f0da0 Best regards, Seeya If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our <a href="https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Flearn.microsoft.com%2Fen-us%2Fanswers%2Farticles%2F67444%2Femail-notifications.html&data=04%7C01%7Cv-linsyu%40microsoft.com%7C406ab7ce595e4231457208d98ec04c53%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C637697778836244725%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=uQ4Qtk2yKrZMliUMyPBgwcKXOd6vKLrHsWoHNih%2BviM%3D&reserved=0" rel="ugc nofollow">documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

unable to install Microsoft Sql on ubuntu 22.04

Accepted answer

Michael Emanuel 81 Reputation points

2022-06-03T15:56:25.23+00:00

Thanks! This was very helpful and solved my problem. For anyone looking for explicit commands on an Ubuntu 22.04 installation,
$ cd /opt/mssql/lib
$ ls -la
$ sudo rm libcrypto.so libssl.so
$ sudo ln -s /usr/lib/x86_64-linux-gnu/libcrypto.so.1.1 libcrypto.so
$ sudo ln -s /usr/lib/x86_64-linux-gnu/libssl.so.1.1 libssl.1.1

If you're missing version 1.1 of these files, you can first do
$ sudo apt install libssl1.1
Please sign in to rate this answer.

1 person found this answer helpful.
Alireza Shahamiri 76 Reputation points

2022-06-06T04:49:45.657+00:00

These commands were very helpful and solved my problem really quickly.
thanks to @James West and @Michael Emanuel answers, after about three weeks I installed Microsoft SQL Server on Ubuntu 22.04 successfully.

solo_driven 6 Reputation points

2022-06-09T10:38:36.143+00:00

Hi, I have the same problem. Can you please say which commands you used before using this ones. My mssql located in anther directory and it's not working for me

Alireza Shahamiri 76 Reputation points

2022-06-11T04:20:40.987+00:00

Hi @solo_driven ,

I just installed libssl1.1 before using these commands.

Carl Russell 6 Reputation points

2022-07-07T15:38:47.947+00:00

No installs are needed if snap has core & core20 installed.
The symbolic links should then be:

$ sudo ln -s /snap/core20/1518/usr/lib/x86_64-linux-gnu/libcrypto.so.1.1 libcrypto.so
$ sudo ln -s /snap/core20/1518/usr/lib/x86_64-linux-gnu/libssl.so.1.1 libssl.so

MSSql started without issue.

Weir, Alan 6 Reputation points

2022-08-19T19:08:06.593+00:00

This didn't work for me using a new install of Canonical 22.04 Desktop.
I first created and installed a dummy libldap-2.4-2 dpkg to keep the mssql-server dependency happy
Then ran:
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/20.04/mssql-server-preview.list)"
sudo apt-get install -y mssql-server

Next I executed ldd sqlserver
And it reported that liblber-2.4.so.2 and libldap_r-2.4.so.2 were missing - I added to /opt/mssql/lib from Ubuntu 20.04
ldd sqlserver then reported that libgssapi.so.3 was missing - I added to /opt/mssql/lib from Ubuntu 20.04
ldd sqlserver continued to report that libgssapi.so.3 was missing !

I don't understand why it continues to report that the library is missing - what am I missing?
And why have non of the responders to this post had to perform similar steps?

Weir, Alan 6 Reputation points

2022-08-22T13:19:17.203+00:00

The issue is that I had installed 22.04.1 which includes ldap 2.5 and mssql is hard coded to ldap 2.4.

Carl Russell 6 Reputation points

2022-09-07T11:49:08.143+00:00

The subdirectory changed on core20 from 1518 to 1593, after changing links mssql started without issue.

ln -s /snap/core20/1593/usr/lib/x86_64-linux-gnu/libcrypto.so.1.1 /opt/mssql/lib/libcrypto.so
ln -s /snap/core20/1593/usr/lib/x86_64-linux-gnu/libssl.so.1.10 /opt/mssql/lib/libssl.so

walmartshopper 1 Reputation point

2022-09-21T18:07:03.773+00:00

/snap/core20/1593 no longer exists which I found out the hard way when my DB was down this morning after an unattended-upgrade reboot. I am now using /snap/core20/current which is a symlink to the latest version and should continue working without having to manually update the mssql-server symlinks constantly. So I would recommend the following as a better solution that will not require manual intervention after snap updates:

cd /opt/mssql/lib
ln -s /snap/core20/current/usr/lib/x86_64-linux-gnu/libcrypto.so.1.1 libcrypto.so
ln -s /snap/core20/current/usr/lib/x86_64-linux-gnu/libssl.so.1.1 libssl.so

Wei Zhang 1 Reputation point

2022-10-21T08:39:41.35+00:00

root@ubuntu:~# cd /opt/mssql/lib \-bash: cd: /opt/mssql/lib: No such file or directory

Ashok Yadav 0 Reputation points

2023-12-11T07:41:36.8033333+00:00

this change allowed to install ms sqlserver 2019 on ubuntu 22.04 but its setup shown only one option "This is a preview version (free, no production use rights, 180-day limit starting now)" ,its did not shown other sql server version their ,pls suggest how we can install standard version only here

Xavier Plante 5 Reputation points

2024-03-14T15:44:51.6066667+00:00

I have this error when trying to install mssql-server on Ubuntu 22.04 :

"The following packages have unsatisfied dependencies: mssql-server: Depends on libldap-2.4-2 but it is not installable.
E: Unable to correct problems, defective packages are in 'Keep in state' mode."

I've tried to install libssl1.1 but it says :

"The package 'libssl1.1' has no installation candidate."

Does anyone have an idea why I can't install libldap-2.4-2 since I need that package if I want to install mssql-server?

Thanks!
Sign in to comment

unable to install Microsoft Sql on ubuntu 22.04

2 additional answers