How To Install MS SQL Server 2019 on Ubuntu 18.04 LTS

Minimum system requirements:

  • Memory: 2 GB
  • File System: XFS or EXT4 (other file systems, such as BTRFS, are unsupported)
  • Disk space: 6 GB
  • Processor speed: 2 GHz
  • Processor cores: 2 cores
  • Processor type: x64-compatible only

Install SQL Server

Step 0: Check Ubuntu version, memory and disk usage
lsb_release -a
free -h
df -h

Step 1: Update Ubuntu System
sudo apt-get update
sudo apt-get -y upgrade
sudo reboot

Step 2: Import the public repository GPG keys:
wget -qO- | sudo apt-key add –

Step 3: Register the Microsoft SQL Server Ubuntu repository for SQL Server 2019:
sudo add-apt-repository “$(wget -qO-”

Step 4: Run the following commands to install SQL Server:
sudo apt-get install -y mssql-serve

Step 5: Run mssql-conf setup and follow the prompts to set the SA password and choose your edition.
sudo /opt/mssql/bin/mssql-conf setup

Step 6: Check Sql server service status
systemctl status mssql-server –no-pager

Step 7: If you plan to use the SQL Server TCP port, don’t forget to open the portn (default 1433) on your firewall.

Quickstart: Install SQL Server and create a database on Ubuntu
How To Install MS SQL Server on Ubuntu 18.04/ Ubuntu 16.04 LTS