Install SQL Server 2019 CTP 2.2 on Ubuntu Part – 1

In this series of blog post, we are going to install SQL Server 2019 CTP 2.2 on Ubuntu 18.04.1 Bionic Beaver. This is the first Part of the series. And, In this first part, we are going to install and prepare Ubuntu 18.04.1 in Hyper-V Manager of Windows 10. You can also create virtual machine in Azure Cloud.

Hyper-V Manager

Whether you are a software developer, an IT professional, or a technology enthusiast, you need to run multiple operating systems including multiple flavor. Hyper-V lets you run multiple operating systems as virtual machines on Windows.

You can install Hyper-V Manager in many ways. First of all I am enabling using “Turn Windows Features on or off”.

  • Open control panel
  • Click on Programs & then “Turn Windows Features on or off”
  • Turn on Hyper-V and both of the features beneath it. Find screenshot to know what exactly need to tick.
  • Click Ok, and wait until it will install the Hyper-V feature.
  • Restart your computer.

Now, you have Hyper-V installed. We are quickly skipping to create a virtual machine on Hyper-V Manager using Quick Create Virtual Machine. Open Hyper-V and go to Action Quick Create. It will open the following window.

Create Virtual Machine using Hyper-V
Create Virtual Machine using Hyper-V Manager

Finally, click on Create Virtual Machine will download the Ubuntu and create a virtual machine for you.

Downloading image Ubuntu
Downloading image ‘Ubuntu 18.04.1 LTS’
Virtual Machine created
Virtual machine created Successfully

Install Ubuntu 18.04.1 LTS

Now, we have a virtual machine ready to start with the image of Ubuntu 18.04.1 LTS. You are just about to start the installation using turning on the virtual machine from Hyper-V. Turning on the virtual machine will launch the following installation wizard, then Choose your preferred language from the list.

Ubuntu Installation - Choose language
Welcome – Choose Language
Ubuntu Installation - Keyboard layout
Keyboard layout
Ubuntu Installation - Where are you?
Ubuntu Installation – Where are you?
ubuntu who are you
Ubuntu Installation – Who are you?

Now, you need to click on continue and take a rest until will install and ready the virtual machine with Ubuntu.

Preparing Ubuntu 18.04.1 for SQL Server 2019

After installation, you can take the virtual machine to install the SQL server, but at some point, it’s easy to login into the VM using tool like PuTTy using SSH. Ubuntu doesn’t install the SSH by default because of the security reason. So, you need to install the SSH. Here is the command to install and check the status of SSH server.

sudo apt install ssh
sudo service ssh status
Check status of SSH service
Check status of SSH service

So, I am going to conclude this blog post here, because this post was write with the intention to prepare Ubuntu to install SQL Server 2019 CTP 2.2, hence Please find more about How to install SQL Server 2019 CTP 2.2 in Hyper-V virtual machine in next Part the series.