Installing mssql in Ubuntu 22.04

Swain, Rajesh Kumar 40

Hi all,

Is mssql server installation is supported in Ubuntu 22.04 officially as of today.

If yes would someone please provide the steps?. I followed other threads but could not succeed till now.

NJT145 1 Reputation point

2023-08-21T14:05:53.7833333+00:00
I am using Ubuntu ~~20.04~~ 22.04 and I get the same issue.

mssql-server : Depends: libldap-2.4-2 but it is not installable

you need to use libldap-common instead.

here is the result when I try command sudo apt install libldap-2.4-2

Reading package lists... Done Building dependency tree... Done Reading state information... Done Package libldap-2.4-2 is not available, but is referred to by another package. This may mean that the package is missing, has been obsoleted, or is only available from another source However the following packages replace it: libldap-common E: Package 'libldap-2.4-2' has no installation candidate

Yeah, I see now that my Ubuntu is 22.04 version. I need to install any version of mssql-server to my Ubuntu 22.04 . So, I need to use docker container... Such a shame...
NJT145 1 Reputation point

2023-08-22T08:07:24.9666667+00:00

Another point about this topic is that; althought Docker Desktop is available now for Linux, the documentation for Docker containers usage is only talking about how to do that with Docker Engine. So, please refresh your documentation.

And you really need to switch to libldap-common in order to make mssql-server available for latest LTS version of Ubuntu, which is 22.04 now. Follow the latest standards, not the old ones...
Harmony Mncube 0 Reputation points

2023-11-16T08:52:58.7666667+00:00

just follow this link , the problem needs you to manually install the missing dependencies

but before you waste your time with my post , type the following to make sure you are missing ldap and another library, i forgot the name

ldd /opt/mssql/bin/sqlservr

https://medium.com/@mncubeharmony/resolving-sql-server-startup-issues-on-linux-missing-ldap-libraries-efc5b25e6063

4 answers

Swain, Rajesh Kumar 40 Reputation points

2023-03-28T04:07:23.2433333+00:00
HI,

Thanks for the responses. There are few problems while following the link.

The link says to installation steps for 20.04 and not for 22.04.

Considering the steps will work in 22.04 i followed and got the errors when i executed sudo apt-get update and sudo apt-get install -y mssql-server

error is as below:

The following packages have unmet dependencies:

mssql-server : Depends: libldap-2.4-2 but it is not installable

E: Unable to correct problems, you have held broken packages.

This tried before also and stuck with this error.
Please sign in to rate this answer.

3 people found this answer helpful.
Mahesh Shinde 1 Reputation point

2023-07-10T07:14:49.8+00:00

I'm also getting same error.
Sign in to comment
Bjoern Peters 8,781 Reputation points

2023-03-27T16:18:13.99+00:00

Hi,

Welcome to Q&A Forum; this is a great place to get support, answers, and tips.

Thank you for posting your question; I'll be more than glad to help you out.

This isn't an official statement!

I would suggest that installing the latest version of SQL Server on the latest Ubuntu system won't break any requirements; maybe just the documentation is missing this newest Ubuntu version (docs teams maybe has a backlog).

Installation procedure... as with the older version... follow the normal Ubuntu description:

https://learn.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu?view=sql-server-ver16

I hope my answer is helpful to you,

Your

Bjoern Peters

If the reply was helpful, please upvote and/or accept it as an answer, as this helps others in the community with similar questions. Thanks!
Please sign in to rate this answer.
Swain, Rajesh Kumar 40 Reputation points

2023-03-28T03:37:37.2266667+00:00

HI Bjoern Peters,

Thanks for the response. There are few problems while following the link.

The linke says to installation steps for 20.04 and not for 22.04.

Considering the steps will work in 22.04 i followed and got the errors when i executed sudo apt-get update and sudo apt-get install -y mssql-server

error is as below:

The following packages have unmet dependencies:

mssql-server : Depends: libldap-2.4-2 but it is not installable

E: Unable to correct problems, you have held broken packages.

This tried before also and stuck with this error.

ALUMNO 0 Reputation points

2023-06-15T03:00:17.7533333+00:00

Following the steps I have the same error

The following packages have unmet dependencies:

mssql-server : Depends: libldap-2.4-2 but it is not installable
Sign in to comment
Sander van de Velde 28,236 Reputation points MVP

2023-03-27T21:53:46.3433333+00:00

Hello @Swain, Rajesh Kumar,

Have you considered installing Microsoft SQL Server as a Docker container?

The footprint of this container is just as much as the settings set in the Docker runtime.

Deployment can also be established as part of the Azure IoT Edge offering.

In your case, Azure IoT is used solely to distribute docker containers (including this SQL Server container) at scale.

As an alternative to the SQL Server container, Microsoft also offers SQL Edge, a SQL Server optimized for TimeSeries data.

If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. All community members with similar issues will benefit by doing so. Your contribution is highly appreciated.
Please sign in to rate this answer.
Swain, Rajesh Kumar 40 Reputation points

2023-03-28T03:38:51.8633333+00:00

Hi,

My current requirement is to install mssql server in ubuntu 22.04.

So docker solution may not work for me.

Sander van de Velde 28,236 Reputation points MVP

2023-03-28T13:01:08.8833333+00:00

Hello @Swain, Rajesh Kumar,

With Moby, you can run Docker containers on Ubuntu 22.04. This runtime is made open-source.

Without pushing this, have you considered running containers on Ubuntu 22.04 (LTS) in general?
Sign in to comment
Seeya Xi-MSFT 16,436 Reputation points

2023-03-28T02:25:44.09+00:00

Hi @Swain, Rajesh Kumar,

In addition to the official link posted by Bjoern Peters. You can also refer to this blog post.

https://citizix.com/how-to-install-and-set-up-ms-sql-server-2019-on-ubuntu-2204/?utm_source=rss&utm_medium=rss&utm_campaign=how-to-install-and-set-up-ms-sql-server-2019-on-ubuntu-2204

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".
Please sign in to rate this answer.
Seeya Xi-MSFT 16,436 Reputation points

2023-03-28T05:56:26.9066667+00:00

Hi @Swain, Rajesh Kumar,

You can try the following command to install the missing package:

sudo apt install libldap-2.4-2

Ubuntu 22.04

But for questions about the official documentation not mentioning versions above 20.04, you can ask them here.

I hope your problem could be solved.

Best regards,

Seeya

Swain, Rajesh Kumar 40 Reputation points

2023-03-28T11:02:04.3133333+00:00

Hi Seeya,

The following packages have unmet dependencies: mssql-server : Depends: libatomic1 but it is not going to be installed Depends: libldap-2.4-2 but it is not installable E: Unable to correct problems, you have held broken packages. amd@amd-virtual-machine:~$ sudo apt install libldap-2.4-2 Reading package lists... Done Building dependency tree... Done Reading state information... Done Package libldap-2.4-2 is not available, but is referred to by another package. This may mean that the package is missing, has been obsoleted, or is only available from another source However the following packages replace it: libldap-common E: Package 'libldap-2.4-2' has no installation candidate

This is what i see while trying to install in 22.04
Sign in to comment