question

AlirezaShahamiri-3524 avatar image
1 Vote"
AlirezaShahamiri-3524 asked CarlRussell-2226 commented

unable to install Microsoft Sql on ubuntu 22.04

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?

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MichaelEmanuel-4644 avatar image
1 Vote"
MichaelEmanuel-4644 answered CarlRussell-2226 commented

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

· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

These commands were very helpful and solved my problem really quickly.
thanks to @JamesWest-0987 and @MichaelEmanuel-4644 answers, after about three weeks I installed Microsoft SQL Server on Ubuntu 22.04 successfully.

0 Votes 0 ·
solodriven-0355 avatar image solodriven-0355 AlirezaShahamiri-3524 ·

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

0 Votes 0 ·

Hi @solodriven-0355,

I just installed libssl1.1 before using these commands.

0 Votes 0 ·

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.

0 Votes 0 ·
SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered

Hi @AlirezaShahamiri-3524 ,

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://docs.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 documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

JamesWest-0987 avatar image
1 Vote"
JamesWest-0987 answered JamesWest-0987 published

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.