Install SQL SERVER and Azure Data Studio in Ubuntu

This is a tutorial on how to install Microsoft SQL Server in Ubuntu.


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

1. First we need to make sure that we update our ubuntu
sudo apt update && sudo apt upgrade

2. Next, we need to import the Microsoft GPG key to ensure the authenticity of the packages we’ll be downloading.

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

3. To install Microsoft SQL Server on Ubuntu, we need to register the SQL Server Ubuntu repository.

sudo add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/20.04/mssql-server-2019.list)"


4. Install Microsoft SQL Server
sudo apt update
sudo apt install -y mssql-server


5: Configure Microsoft SQL Server

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


Finally our SQL SERVER SETUP is complete
you can now starting using the SQL SERVER Application

Step 6: Verify the Installation
systemctl status mssql-server --no-pager



Error:
The following packages have unmet dependencies:

"mssql-server : Depends: libldap-2.4-2 but it is not installable"
download here:
https://packages.debian.org/buster/amd64/libldap-2.4-2/download


Error: cannot find libcrypto
sudo apt-get install libssl-dev


My Other Channel:
https://www.youtube.com/channel/UCGCxdq6PYTy5doi9763eTCQ

Buy me a coffee:
https://www.buymeacoffee.com/arboiscodemedia

Join my facebook group for more:
https://www.facebook.com/groups/52326754561224