How to install SQL Server 2022 on Ubuntu Server 24.04 LTS

Question

How to install SQL Server 2022 on Ubuntu Server 24.04 LTS

Eghost 0

I couldn't find a proper way to install SQL Server 2022 on Ubuntu Server 24.04 LTS. I tried to use Microsoft SQL Server 2022 from the Ubuntu 22.04 repository, but I couldn't run the service correctly. I'm done with this state of service (see printout).Is there any way I can perform the service? The truth is I'm just using Linux but I need to install SQL Server. If you could guide me step by step I would appreciate it.

Captura desde 2024-06-09 17-59-25

Anonymous

2024-06-17T05:53:40.6333333+00:00

Hi @Eghost ,

We haven't heard any response from you yet.

Is this issue solved now? If you have any questions, please feel free to share with us.

May I humbly suggest that you accept Answer if they helped. It may help others who see the thread in seek of help.

Your action would be helpful to other users who encounter the same issue and read this thread. :)

Thanks for your understanding. Wish you have a nice day!

Best regards,

Lucy Chen
PhiHung Bach 25 Reputation points

2024-07-05T22:54:01.0233333+00:00

Same problem here. I went through the steps for 22.04. Due to the error:

/opt/mssql/bin/sqlservr: error while loading shared libraries: liblber-2.5.so.0: cannot open shared object file: No such file or directory

5 answers

Your answer

Anonymous

2024-06-17T05:53:40.6333333+00:00

Hi @Eghost ,

We haven't heard any response from you yet.

Is this issue solved now? If you have any questions, please feel free to share with us.

May I humbly suggest that you accept Answer if they helped. It may help others who see the thread in seek of help.

Your action would be helpful to other users who encounter the same issue and read this thread. :)

Thanks for your understanding. Wish you have a nice day!

Best regards,

Lucy Chen
PhiHung Bach 25 Reputation points

2024-07-05T22:54:01.0233333+00:00

Same problem here. I went through the steps for 22.04. Due to the error:

/opt/mssql/bin/sqlservr: error while loading shared libraries: liblber-2.5.so.0: cannot open shared object file: No such file or directory

Answer 1

PhiHung Bach 25

Solved. Complete Steps.

=========================================
Install MSSQL Server 2022 on Ubuntu 24.04
curl -fsSL https://packages.microsoft.com/keys/microsoft.asc | sudo gpg --dearmor -o /usr/share/keyrings/microsoft-prod.gpg
curl https://packages.microsoft.com/keys/microsoft.asc | sudo tee /etc/apt/trusted.gpg.d/microsoft.asc
curl -fsSL https://packages.microsoft.com/config/ubuntu/22.04/mssql-server-2022.list | sudo tee /etc/apt/sources.list.d/mssql-server-2022.list
:: Need to download & install libldap-2.5
curl -OL http://archive.ubuntu.com/ubuntu/pool/main/o/openldap/libldap-2.5-0_2.5.18+dfsg-0ubuntu0.22.04.1_amd64.deb
sudo apt-get install ./libldap-2.5-0_2.5.18+dfsg-0ubuntu0.22.04.1_amd64.deb
sudo apt-get update
sudo apt-get install -y mssql-server
sudo /opt/mssql/bin/mssql-conf setup		####!
systemctl status mssql-server --no-pager
sudo ufw allow 1433/tcp
sudo ufw enable
sudo ufw status

Dave Hunt 0 Reputation points

2024-07-07T19:15:12.1066667+00:00

This..... This worked for me.
John Marquess 0 Reputation points

2024-07-16T06:22:08.9466667+00:00

Can confirm this worked for me.
Al 0 Reputation points

2024-07-25T13:30:34.6066667+00:00

Worked for me, however SQLCMD is failing with Sqlcmd: Error: Microsoft ODBC Driver 18 for SQL Server : SSL Provider: [error:0A000086:SSL routines::certificate verify failed:self-signed certificate].
Anonymous

2024-07-26T01:10:01.7466667+00:00

Hi @Eghost ,

We haven't heard any response from you yet.

Is this issue solved now? If you have any questions, please feel free to share with us.

May I humbly suggest that you accept Answer if they helped. It may help others who see the thread in seek of help.

Your action would be helpful to other users who encounter the same issue and read this thread. :)

Thanks for your understanding. Wish you have a nice day!

Best regards,

Lucy Chen
Murugapandian Ramaiah 10 Reputation points

2024-11-27T07:57:52.06+00:00

This worked for me with a small change for Ubuntu 24.04.1 LTS

Install MSSQL Server 2022 on Ubuntu 24.04

curl -fsSL https://packages.microsoft.com/keys/microsoft.asc | sudo gpg --dearmor -o /usr/share/keyrings/microsoft-prod.gpg

curl https://packages.microsoft.com/keys/microsoft.asc | sudo tee /etc/apt/trusted.gpg.d/microsoft.asc

curl -fsSL https://packages.microsoft.com/config/ubuntu/22.04/mssql-server-2022.list | sudo tee /etc/apt/sources.list.d/mssql-server-2022.list

:: Need to download & install libldap-2.5

curl -OL http://archive.ubuntu.com/ubuntu/pool/main/o/openldap/libldap-2.5-0_2.5.18+dfsg-0ubuntu0.22.04.2_amd64.deb

sudo apt-get install ./libldap-2.5-0_2.5.18+dfsg-0ubuntu0.22.04.2_amd64.deb

sudo apt-get install -y mssql-server

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

systemctl status mssql-server --no-pager

sudo ufw allow 1433/tcp

sudo ufw enable

sudo ufw status
srbrills 5 Reputation points

2025-02-09T18:40:56.18+00:00

Agreed with @Murugapandian Ramaiah , was able to use this installation method to get it working but had to switch libldap-2.5-0_2.5.18+dfsg-0ubuntu0.22.04.1_amd64.deb to libldap-2.5-0_2.5.18+dfsg-0ubuntu0.22.04.2_amd64.deb. Notice the change to *.2_amd64.deb there at the end.
Rojo 0 Reputation points

2025-04-28T18:38:47.18+00:00

One more update to @Murugapandian Ramaiah and @srbrills , the latest version is now *.3_amd64.deb for the step to download the ldap libraries, else you'll likely receive a cert error trying to install.

curl -OL http://archive.ubuntu.com/ubuntu/pool/main/o/openldap/libldap-2.5-0_2.5.18+dfsg-0ubuntu0.22.04.**3**_amd64.deb

worked for me and I was able to complete the install - thanks all!

Answer 2

Kleidi Kumbaro 11

I got into this problem when updating ubuntu 22.04 to 24.04 and got it working with

wget http://mirrors.kernel.org/ubuntu/pool/main/o/openldap/libldap-2.5-0_2.5.11+dfsg-1~exp1ubuntu3_amd64.deb (search here https://pkgs.org/search/?q=libldap)

sudo dpkg -i libldap-2.5-0_2.5.11+dfsg-1~exp1ubuntu3_amd64.deb

now sql server is starting normally on ubuntu 24.04 (Microsoft SQL Server 2022 (RTM-CU16) (KB5048033) - 16.0.4165.4 (X64) Nov 6 2024 19:24:49 Copyright (C) 2022 Microsoft Corporation Developer Edition (64-bit)

Mohamed Alla Pitchai 0 Reputation points

2025-04-04T01:57:11.5633333+00:00

I was trying to install MSSQL Serer in Ubuntu 22.04 and got the error. I removed the MS SQL Server install and installed the libldap package as pointed above by Kleidi and re-install the MSSQL Server again. It worked fine.

Answer 3

Olaf Helper 47,436

How to install SQL Server 2022 on Ubuntu Server 24.04 LTS

Currently installation of SQL Server is supported on Ubuntu 20.04 and 22.04, but not on 24.04

It may will work, but not supported. See

https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-setup?view=sql-server-ver16#supportedplatforms

Answer 4

Hi @Eghost ,

Thank you for reaching out and welcome to Microsoft Q&A.

What steps did you take? Here is an article of how to install SQL Server on Ubuntu, it shows steps in detail, hope this can help you well.

In addition, from the error messages you provided, please ensure the virtual machine configure available memory to at least 2GB and use the correct mssql-conf command.

Please feel free to share your issue here if you have any confusions.

Best regards,

Lucy Chen

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.

https://docs.microsoft.com/en-us/answers/support/email-notifications

Anonymous

2024-06-14T03:30:48.7266667+00:00

Hi @Eghost ,

We haven't heard any response from you yet.

Is this issue solved now? If you have any questions, please feel free to share with us.

May I humbly suggest that you accept Answer if they helped. It may help others who see the thread in seek of help.

Your action would be helpful to other users who encounter the same issue and read this thread. :)

Thanks for your understanding. Wish you have a nice day!

Answer 5

PhiHung Bach 25

Solved.

Download & Install :

curl -OL http://archive.ubuntu.com/ubuntu/pool/main/o/openldap/libldap-2.5-0_2.5.18+dfsg-0ubuntu0.22.04.1_amd64.deb
sudo apt-get install ./libldap-2.5-0_2.5.18+dfsg-0ubuntu0.22.04.1_amd64.deb

Kleidi Kumbaro 11 Reputation points

2025-01-05T22:35:53.8633333+00:00

the link does not download a debian file. however this one seems to be working http://mirrors.kernel.org/ubuntu/pool/main/o/openldap/libldap-2.5-0_2.5.11+dfsg-1~exp1ubuntu3_amd64.deb

Share via

How to install SQL Server 2022 on Ubuntu Server 24.04 LTS

5 answers

Your answer