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.

Create Azure Linux Virtual Machine and make website running


While moving my blog to Azure Virtual Machine, I found some complexity just because of Linux virtual machine. As a ASP.NET geek, I am not that much of aware about Linux and its management commands. So, I have decided to write the blog on how to make my first Hello World website in Azure Linux Virtual Machine. I am also planning to write the blog on installing ASP.NET 5 into Linux Virtual Machine.

Create Linux Virtual Machine into Azure Cloud

The first step into making your website up and live is creating Linux Virtual Machine into Azure Cloud. Hence, I am logging with my Azure Account. There are two methods to create Virtual Machine into Azure. First one is creating Virtual Machine using Quick Create. Quick Create is used when you are creating only one Azure Machine. Another way to create Virtual Machine is using From Gallery, and it will be used when you are a need into creating multiple Azure Virtual Machine with some advance settings.

Sign into Azure portal and Click on New at the bottom left of Azure portal, then Click on COMPUTE -> VIRTUAL MACHINE -> QUICK CREATE as shown into the image.

Create Azure Virtual Machine
Create Azure Virtual Machine

After clicking on Quick Create, you will be prompted for entering some information about Virtual Machine like DNS name, Image for VM, Size for VM, Username, password, and region. I am going to creating VM with webstackdemo DNS name, and I am selecting Ubuntu Server 15.10 as Image name to create Linux Virtual Machine. Just enter all information and click on CREATE A VIRTUAL MACHINE button. You have to wait for some time after clicking on CREATE A VIRTUAL MACHINE while new server is up and running. On successful creation, your will be prompt like Successfully created virtual machine webstackdemo.

Login into Linux Cloud Virtual Machine
After successfully creating the virtual machine, you can look at endpoints of the virtual machine in Azure Portal. There will be default endpoint with named SSH having 22 as private and public port. You can change port at any time to secure your Virtual Machine. You can find SSH Details to connect or login into your machine in Dashboard tab. To login with your windows machine you need SSH client for windows like PuTTY.

Now, open PuTTY client and enter hostname and port detail from SSH Detail and click on open.

PuTTY detail to login into Azure
PuTTY detail to login into Azure

Now, PuTTY will prompt for credential. Login with the credential that you have created while creating your Azure Machine.

Installing Apache2, MySql, and PHP
To run large data driven application you need to have Apache2, MySql, and PHP installed into the virtual machine. So, you must have root access. Type following command to switch to root user.

sudo su

In order to install the latest version of services, your packages list from repository should be updated. There is apt-get command in Ubuntu server to update package list from repository server. So, type the following command to update package list

sudo apt-get update

After update modules, type following commands to install Apache2, MySql, and PHP

sudo apt-get install apache2
sudo apt-get install mysql-server
sudo apt-get install php5
sudo apt-get install php5-mysql

While Installing the MySql you will be prompted to enter the password for MySql. After successfully installing all above services you can type the following command to check that MySql services properly installed.
mysql -u root –p
It will prompt you to enter the password to log in.

Setup Virtual Host for Apache2
Create directory structure for your website and to set up virtual host into Apache2. Consider that you are going to setup webstackgeek.com into apache. In order to create the directory structure for webstackgeek.com type following command.

sudo mkdir -p /var/www/webstackgeek.com/html

Now, Create file into that html directory for your webstackgeek.com, you can use touch command to create file and nano to edit that file. You can also upload it using FTP, but for now, I am not going to cover that. Type following commands to create and edit index file.

cd /var/www/webstackgeek.com/html
sudo index.html
nano index.html

Type some HTML into index.html and save index.html file. Apache2 should have proper permission on that newly created directory. You can use chmod to give 755 permission on /var/www/ directory. Now, Its turn to create virtual host file and configure Apache2 to point that directory for webstackgeek.com. Apache has default virtual host file called 000-default.conf. Copy that file with the new name like webstackgeek.com.conf. Type the following command of copying the file the as the new name.

sudo cp /etc/apache2/sites-available/000-default.conf /etc/apache2/sites-available/webstackgeek.com.conf

Open that file and edit it to add configuration related to webstackgeek.com domain. After editing your host file, it should look like

<VirtualHost *:80>
    ServerAdmin admin@yoursite.com
    ServerName webstackgeek.com
    ServerAlias www.webstackgeek.com
    DocumentRoot /var/www/webstackgeek.com/html
    ErrorLog ${APACHE_LOG_DIR}/error.log
    CustomLog ${APACHE_LOG_DIR}/access.log combined

After creating host file, you have to enable host file into Apache2. You can use a2ensite command of apache2 to enable that and then restart Apache2.

sudo a2ensite yourdomain.com.conf

The final step for your site to up and running is to add endpoints into Azure Cloud portal. Go to your virtual machine and click on ENDPOINTS. Click Add button from the bottom and Add HTTP Endpoint having 80 public port and private port for your site, you can also configure the endpoint to use HTTPS with 443 port.

Now you can run yourdomain.com into your favorite browser to check that everything is working.