Installing SQL Server vNext on Ubuntu using Hyper-V

The following steps were used to create a test Hyper-V virtual machine (VM) with SQL Server vNext on Ubuntu 16.04.2 TLS Desktop.
 
Prerequisites:

  • Create a Generation 1 VM
  • Ensure the VM has at least 3.25GB of memory allocated or the install of SQL Server vNext will fail
  • Ensure the VM has an internet connection
  • Download and add the ubuntu-16.04.2-desktop-amd64.iso from https://www.ubuntu.com/download/desktop to the VM as a DVD
  • Start the VM

After the install of Ubuntu you may get a message to remove the Ubuntu media. Simply turning off/on the VM should resolve this.
 
Here were the commands to install SQL Server vNext:
 

sudo apt install curl

curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -

curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list | sudo tee /etc/apt/sources.list.d/mssql-server.list

sudo apt-get update

sudo apt-get install -y mssql-server

sudo /opt/mssql/bin/mssql-conf setup

systemctl status mssql-server

curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list | sudo tee /etc/apt/sources.list.d/msprod.list

sudo apt-get update

sudo apt-get install mssql-tools

sudo ln -sfn /opt/mssql-tools/bin/sqlcmd /usr/bin/sqlcmd

sqlcmd -S localhost -U sa -P '$trongPa55'

AKAWN_vNext_Ubuntu

Leave a Reply