Install Microsoft SQL Server 2019 on Ubuntu 20.04 and then, Install dbaever tool to connect to the SQL Server

Install Microsoft SQL Server 2019 on Ubuntu 20.04 and then, Install dbaever tool to connect to the SQL Server

Minimum system requirements

-Minimum memory of 2 GB

-CPU processor with a minimum speed of 1.4 GHz. But the recommended is >= 2 GHz

-SQL Server requires a minimum of 10 GB of available hard-disk space

Install MS SQL Server on Ubuntu 20.04

Follow the steps below to install and configure the MS SQL database server on Ubuntu 20.04

I will check the version of Ubuntu Linux

Step 1: Update Ubuntu System

We ensure all system packages are updated before adding any new packages

If you have kernel updates done, ensure a reboot is done for the system to boot into a new kernel.

Step 3: Add Microsoft SQL Server 2019 Ubuntu repository

Add Microsoft SQL Server 2019 APT repository to your Ubuntu 20.04

Step 4: Install MS SQL Server 2019 on Ubuntu 20.04

Now run the following commands to install SQL Server

Press the- y key to start the installation of Microsoft SQL Server 2019 on Ubuntu 20.04

Step 5: Initialize MS SQL Server 2019 on Ubuntu 20.04

When the installation is done, proceed to set the root user password by running the initial setup

The MS SQL service should be started.

We can confirm the SQL Server service is running by issuing the command

Step 6: Install MS SQL tools and unixODBC plugin

It is done.

And then, Install dbaever tool to connect to the SQL Server

You can use PPA repository to easily install/upgrade DBeaver on Debian Linuxes. Mostly it is the same as the regular Debian repo but it is hosted on Launchpad.

It is done. We can connect to SQL Server. Firstly, I will check the test connection.

Test connection successful. And we are inside.

References

https://4sysops.com/archives/install-microsoft-sql-server-on-ubuntu-linux/

https://computingforgeeks.com/how-to-install-ms-sql-on-ubuntu/

https://dbeaver.io/download/

I am SQL Server Database Administrator. So, I am doing this job and I am enjoying it super.