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/