Installing Ubuntu 18.04 for SQL Server 2019 on Virtual Machine Using VMware Workstation

Total: 2 Average: 5

Microsoft has been supporting SQL Server for Linux-based operating systems since the SQL Server 2017 release. The current article will focus on installing one of the popular Linux operating system Ubuntu 18.04 and describe the process step by step. The goal is to install the latest SQL Server 2019 on this operating system. We have to perform each step correctly to configure SQL Server 2019 in your production environment or set up your own lab.

CodingSight - Installing Ubuntu for SQL

To install the SQL Server instance, we need a machine and a supported operating system. Thus, we will first create the machine and then will install the operating system. Below are our goals:

  1. Build a system or a virtual machine to install the Ubuntu OS
  2. Install Ubuntu 18.04
  3. Install SQL Server
  4. Install SQL Server Tools

If you don’t have a system to install Ubuntu at the moment, I would recommend you install the latest version of the VMware workstation PRO. It is an industry leader in running multiple virtual machines from a single host computer.  

The current article will cover the first two tasks: Build a system or virtual machine to install Ubuntu operating system and Install Ubuntu 18.04. The remaining tasks will be the focus of the next articles.

Before going ahead, we should also validate the basic system requirement to install Ubuntu 18.04 for SQL Server 2019:

  • CPU: 1.4GHz or more
  • RAM: 2 GB or more
  • Disk: 10 GB or more

The above values are for testing machines. It should not be a configuration for your production systems. I would recommend you having proper capacity planning in place for the workload for your system. If you want to master and configure your lab, the above configuration will be considered.

Let’s create a virtual machine using VMware Workstation. Then we’ll install Ubuntu Linux on it. Note: I will explain the step-by-step process to install the Ubuntu server edition and not the desktop edition which has a graphical user interface for end-users.

Create a Virtual Machine with VMware Workstation

Launch VMware Workstation to create a virtual machine. As you can see in the image below, I have already created 3 virtual machines for various requirements. These machines are accessible from the left-side pane.  Now, I will create one more virtual machine where we plan to install the Ubuntu Linux server.

Click Create a New Virtual Machine on the right-side pane:

Launching VMware Workstation to create a virtual machine

You will get a New Virtual Machine Wizard With two options:

  1. Typical (recommended)
  2. Custom (advanced)

We need to select one according to our type of virtual machine configuration. As Typical is recommended, let’s select it. Click Next.

New Virtual Machine Wizard

The below screen will appear. You need to select the target operating system installer image file. If you don’t have an operating system installer image file ready and want to install the OS later, you can choose the last option – I will install the operating system later.

I have the installer image file ready, so I have chosen the Installer disc image file option. Click the browse button to select the file (you can download the Ubuntu Linux installer image from their website).

The New Virtual Machine Wizard will automatically detect the selected installer image file and display its version. This OS is qualified for the VMware Workstation’s Easy Install feature that automates the guest OS installation.

Click Next to fill in details for Easy Install.

Guest Operating System Installation

The Easy Install Information screen will ask you to enter some details, such as username and password to install the Ubuntu server. Fill in the details and click Next.

Easy Install Information

Set the name and location of the virtual machine. Ensure that you have enough space at the location where you want to save the virtual machine files. Click Next.

Name the Virtual Machine

Configure the disk. You can configure its size for your requirement and choose whether to keep this virtual disk as one file or split it into multiple files. Specify your preferences and click Next.

Specify Disk Capacity

Finally, verify the provided details and click Finish.  

Ready to Create Virtual-Machine

This creates your virtual machine and initiates the guest OS, i.e. Ubuntu installation with the Easy install approach.

If you want to modify any hardware-level configuration, click Customize Hardware to review and modify these settings before clicking Finish. If you don’t want to initiate this installation, uncheck this option.

Install Ubuntu 18.04

As we have checked the Power on this virtual machine after the creation option, this virtual machine will start to power on with initiating the Ubuntu 18.04 installation right after clicking Finish.

Ubuntu Installation

You will see a series of executions on your screen. Just wait until you get the welcome screen. Select the language and press Enter to proceed.

Select the language

After that, you get a notification about an Installer update available for this operating system package. You can choose the options you prefer. I have chosen Continue without updating highlighted in green (see the bottom of the image below). Press Enter to proceed.

Installer update available

The next screen offers you to configure the keyboard layout. Select your preferences and press Enter.

Configure the keyboard layout

Now, you should specify the Network connections. I have left settings as-is. Click Enter.

Specify Network Connection

Configure proxy. I have left the default values and pressed Enter to proceed.

Proxy Configuration

Again, I’ve chosen to stick to the default values. Click Enter.

Stick to the Default Values

Consider the Guided storage configuration – I’ve left the defaults. Press Enter.

Guided Storage Configuration

The Storage configuration may also remain the default, or you can configure it as you wish. After that, press Enter.

Storage Configuration

Profile setup will appear after the storage configuration screen. Here, we need to enter the details – Name, Server name, Username & password.

Profile setup

I filled in all details as shown below. Press Enter to proceed.

Filling the details

The next screen appears for the SSH Setup. You can choose to install the OpenSSH server and other settings as shown below. After configuring the setup, press Enter.

SSH Setup

I have left the next screen as it is and proceeded to initiate the installation by hitting Enter.

Initiate the installation

The Ubuntu 18.04 installing process has started. You don’t need to do anything – just wait for completion.

Installation process has started

Click View full log at the bottom if you want to get familiar with the details.

View full log

Finally, the installation is complete. Next, we must reboot this machine by hitting the green tab – see the below image.

Installation is complete

After the reboot, you can connect to this newly created virtual machine. The post-reboot image displays the OS version – Ubuntu 18.04.5. We had set the name of the virtual machine as SQLServer-Ubuntu and can see it in the login prompt.

Setting the name for virtual machine

Enter your login name and password to establish a connection with Ubuntu. I have created the username as manvendra. You’ll use your login name.

Now, we have successfully connected to the Ubuntu operating system.

Successful connection to Ubuntu operating system

We can execute some basic commands to check and validate the essential details. The first command is to check the IP address of this new virtual machine. For that, we run the ifconfig command.

You can also go ahead and validate all configuration items of the newly-created virtual machine.

Validating all items

Conclusion

This article demonstrated how to create a virtual machine using VMware Workstation and how to install the Ubuntu 18.04 operating system. As you see, it is quite straightforward.

Stay tuned for the next article dedicated to the step-by-step process of installing SQL Server 2019 on the Ubuntu 18.04 operating system.

Comment and share your feedback on this article. Also, let us know which topics interest you – the comment section is waiting for your suggestions!

Manvendra Singh

Manvendra has 15 years of experience in the database domain where he has worked on various critical deliveries like heterogeneous migration of SAP databases from AIX\Oracle platform to Windows\SQL Server, On Prem to Cloud migrations, Database consolidation projects and various HA & DR implementations.