How to Install SQL Server 2019 on Ubuntu 20.04

In this article, I am going to show you how to install Microsoft SQL Server on Ubuntu 20.04 Focal Fossa. In the previous article, I have installed the same SQL Server 2019 on Linux Mint 20. Basically, the installation steps are pretty much the same. Microsoft has made a great leap to provide their popular RDBMS database for Linux users. The MS SQL Server 2019 Linux version is compatible with the Windows version. So, we can easily transfer, backup, or restore the database from the Linux version to the Windows version vice versa.

Steps to Install Microsoft SQL Server 2019 on Ubuntu 20.04

Step 1. Update Ubuntu

It is important to have the most recent software package installed on the system. Do a system update with this command

sudo apt update && sudo apt upgrade

Step 2. Install GPG Public key

Now copy and paste this line to add and install the GPG key

sudo wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -

Step 3. Add the repository

Next, we are going to add the official repository of the MS SQL Server for Ubuntu 20.04

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

Step 4. Install MS SQL Server

Now we can install SQL Server with this command

sudo apt install mssql-server

Wait until the installation process. When it completes, you will see the following on your Terminal.

Finally, let’s run the config command below

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

Next, we need to choose the SQL Server edition.

In this case, I choose number 2, the Developer edition. Next, accept the license.

Next, enter the new SA password and confirm it. Finally, the installation is completed.

Next, we can check the service and make sure it is running

Install mssql-tools tool on Ubuntu 20.04

Now we are going to install the msssql-tools on Ubuntu 20.04. This is a command line tool to manage your SQL Server using Terminal console.

curl https://packages.microsoft.com/config/ubuntu/19.10/prod.list | sudo tee /etc/apt/sources.list.d/msprod.list
sudo apt update
sudo apt install mssql-tool

Next export the PATH

echo ‘export PATH=”$PATH:/opt/mssql-tools/bin”‘ >> ~/.bash_profile
echo ‘export PATH=”$PATH:/opt/mssql-tools/bin”‘ >> ~/.bashrc
source ~/.bashrc

Connect to SQL Server using sqlcmd

Now try to connect to the SQL Server with this command. Modify it with your own.

sqlcmd -S localhost -U SA -P 'YourP@ssword'

When connected, you will see 1> in Terminal. Next let’s create a new database

That’s it. Now you we successfully installed Microsoft SQL Server 2019 on Ubuntu 20.04 Focal Fossa. Thanks for reading this article and see you on the next ones.

1 Comment

  1. ran in to two problems, They do result in sqlcmd not being found….
    markwardell@ubuntu:~$ sudo apt install mssql-server autoremove
    Reading package lists… Done
    Building dependency tree
    Reading state information… Done
    E: Unable to locate package autoremove
    ///////////////////
    And then :

    markwardell@ubuntu:~$ sqlcmd -S localhost -U SA -P

Leave a Reply