We will install SQL Server 2019 on Ubuntu 18.04 in this article.
Our Server Resource Information:
- CPU : 4
- RAM : 16
- Disk : 80 gb
Installation Steps:
Step 1: Store GPG keys
1 | wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add - |
Step 2: Add Microsoft SQL Server 2019 Ubuntu repos
1 | sudo add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/18.04/mssql-server-2019.list)" |
Step 3: Update packages
1 2 | sudo apt-get update sudo apt-get install -y mssql-server |
Step 4: Run SQL Server Mssql configuration Script
Confirmation Screens will appear.
- We approve the license (yes)
- We specify the SA password
- We enable SQL Server service to start (y)
- We enable automatic startup on reboot (y)
1 | sudo /opt/mssql/bin/mssql-conf setup |
We choose which version to install. We chose 2 for the Developer Edition.
We specify the ‘sa’ password.
Step 5: Check SQL Server service status
1 | systemctl status mssql-server --no-pager |
Let’s Connect with SQL Azure Studio;