As Microsoft announces next version of SQL server that is ready to install on other plate forms then Windows. SQL Server 2017 CTP 2.0 is supported on Red Hat Enterprise Linux, SUSE Linux Enterprise Server, and Ubuntu. It is also available as a Docker image which can run on Docker Engine on Linux or Docker for Windows/Mac. Question is how to install Linux and SQL Server on it. I am going to show you step by step guide to install both Linux and SQL Server vNext. I tried to cover all aspects as much as possible in both command line and graphically.
SQL Server Latest Releases on Linux:
The next version of SQL Server on Linux will include all the standard SQL Server management features that come with the Windows version. These include advanced features like always-encrypted, row-level security and columnstore indexes etc. You can get a full list of features which are supported in this Microsoft link: SQL Server on Linux Release Notes.
The first step is to decide which platform is required to install SQL Server vNext. I decided to download Ubuntu as I already have little bit of experience with it. You can download latest version of Ubuntu form https://www.ubuntu.com/ . You will find a list of Ubuntu files to download. I downloaded Ubuntu-17.04 server 64bit (Zesty Zapus) as shown in pic (InstallUbunut-01)
There are different ways to install Ubuntu on your machine. For this exercise I decided to use Oracle Virtual Box. VirtualBox is a powerful x86 and AMD64/Intel64 virtualization product for enterprise as well as home use. Not only is VirtualBox an extremely feature rich, high performance product for enterprise customers, it is also the only professional solution that is freely available as Open Source Software under the terms of the GNU General Public License (GPL) version 2. You can download Virtual Box – Windows host from following link https://www.virtualbox.org/wiki/Downloads
Before starting Virtual box installation it is benificial to download some other required tools during ubuntu installation. You can work directly in ubuntu plateform but there is another way to work by connecting through PuTTY. You can work with PuTTY untill you have openssh on your ubuntu server. You can install openssh directly from ubuntu or by downloading it and install form given path. Following is the image that is showing ubuntu and other downloaded files.
There are different ways to install linux. If you have Windows installed on your machine and want to install linux seperately, you can go for dual boot installation. Dual-booting is a technique which allows a single physical computer to run two or more operating systems. This is useful for experimenting with new OS without touching your existing setup. I have found a very good step by step installation guide on following link http://www.instructables.com/id/How-to-Dual-boot-Linux-and-Windows-on-a-PC-with-W/
I choose virtual box to install ubuntu from my existing Windows. Next is step by step example for installing oracle virtual box.
1- Double click on the VirtualBox setup to start installation.
2- This setup needs to check free space on your hard drive.
3- You will get reset warning that you can read and press Yes.
4- Setup will start installing Virtual box and it will take few minutes only depending on your machine performance.
5- You need to install Oracle Corporation Universal Serial Bus, press install
6- Setup may ask for some other network tools for installation
7- You will get successful installation message, press Finish to start Oracle Virtual box
8- After finishing setup Oracle VM Virtual Box Manager will open.
Create New VM using Oracle Virtual Box
1- To start creating new VM setup, Press New icon from left top corner
2- It will open new VM setup screen where you have to set name for your VM as we are installing Ubuntu for SQL Server so it will be “Ubuntu1710”
3- Next is Type of your operating system installation, for us it will be Linux
4- We need to select 64-bit because we have downloaded same version
5- You need to set required RAM for the VM that will be part from total available system RAM. In this case I have mentioned 4GB out of 6GB. You need at least 3.5 GB in order to install SQL Server on Linux. If you do not have enough RAM, You can change it even after creating VM.
6- Continue by pressing Next, You need to set Hard disk value. You can add it later or go for virtual hard disk now, which I have selected.
7- Next pop will be used to select hard disk file type, I have selected Virtual Box disk image
8- You have to select which type of storage you will prefer, I used dynamically allocated so that I can increase it when required.
9- In this setup you have to select storage file location and initial size of your VM. I have set 32 GB and will increase on demand.
10- Press “create” and your new VM will be created. You can see detail on VM main page
11- Given file location name will be created windows folder.
You have successfully completed virtual box and now need to start installing Ubuntu setup on it.
From this point on words Ubuntu installation will start. I will publish step by step detail in my next post... keep reading :)