Install SQL Server on Linux: Ubuntu 22.04

In this video, we will show how to install SQL Server on a machine running Linux, specifically SQL Server 2022 on Ubuntu 22.04 LTS.

LINKS AND INFO

[clerincg]

Hello Kevin - I was charged with getting SS2022 installed on Ubuntu and, following your step-by-step instructions was invaluable. You have taken the pain out of attempting the same instructions from Microsoft. I look forward to your other video series entries on working with SQL Server on Linux. Thank you SO MUCH!

[ThijsLiefhebber]

Thank you so much! This has been a great help!

[SiLVERiCE]

It works like a charm! Thank you for this!!!!

[andrewhofmann]

Worked EXACTLY as you said it would.... Thanks!

[junkyardjuice]

excellent, thank you

I'm doing an ETL project and i have MySQL server as well as SQL server on my ubuntu server machine

I will be doing the data work on my main machine

[sajibbiswas]

Thank you so much, it worked smoothly.

[anuj]

Thank you so much. Please make a video on how to back up the database from the command line.

[fatihhguvenn]

"too cool for windows" had me dead right there 🤣

[ManoLeitonez]

Thank you, Kevin. The video is great.
Unfortunately, I'm noticing through stress tests that SQL Server on Ubuntu is 11x less performant than on Windows (with very similar resources: 4vCore, 16 GB RAM). Is there any configuration to make SQL Server perform better on Linux?

[miguelangelvelarde]

I tried several times to install MSSQL on Ubuntu 22.04 but always have the same error: /opt/mssql/bin/sqlservr: error while loading shared libraries: liblber-2.4.so.2: cannot open shared object file: No such file or directory
😖

[YONEL]

At The Moment, Warning! The 97.87 GiB filesystem mounted at / has only 1.51 MiB of free disk space

[mohammednhne]

well done, that is a great video. but I have a question when we want to connect from our MS SQL Management Studio, which password is entered?

[bengo]

Hi Kevin, great video but where do I find the commands you use in the video?

[arthurcarvalho]

If running "sudo apt-get install -y mssql-tools18 unixodbc-dev" you get an error such as: ""Unable to acquire the dpkg frontend lock (/var/lib/dpkg/lock-frontend), is another process using it?" just run "sudo killall apt apt-get" and rerun the command

[kvelez]

You should make a video on how to delete it.
*An install and delete for Fedora would be appreciated.

[YONEL]

When running the command to enable the sql agent it gives me the following error: The setting 'sqlagent.enable' is not supported. version del linux es : Ubuntu 22.04.5 LTS

[omargarcia]

Hi, excelent video!

It worked perfectly and It opend the database from local

But now i would like to commect with this database outside the network, do you know how to do it?

I would love an advice or some commands I could run

I already open the port 1433
And I know that when connecting in SQL Management studio i should put the PublicIP:1433

And then the sa with the password

But it still doesn't work

[itspersie]

On ubuntu 24.04 I think it'll not work after the config command,
I was getting this /opt/mssql/bin/sqlservr: error while loading shared libraries: liblber-2.5.so.0: cannot open shared object file: No such file or directory

[HazemH]

Hay Kevin
I got this
sudo apt-get install -y mssql-server
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
E: Unable to locate package mssql-server

Any Idea How to fix it?

[mohammednhne]

and systemctl status mssql-server --no-pager
this service is enabled but not Active, Active is failed.
how to Active it?