Installing MS SQL Server on Ubuntu 16.04

This post about installing the MS SQL Server on Ubuntu 16.04. MS SQL Server could be installed only on Windows, Now Microsoft released SQL Server 2017, which adds Linux support for these Linux platforms: Red Hat Enterprise Linux, SUSE Linux Enterprise Server, Ubuntu & Docker Engine. Find the steps below for installing MS SQL Server on Ubuntu 16.04

1. Login to sudo user

$sudo su

2.Install CURL (if curl is not already installed)

$sudo apt-get install curl

3.Register MS SQL Server repository

$curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add
$curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server.list > /etc/apt/sources.list.d/mssql-server.list
$curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list > /etc/apt/sources.list.d/msprod.list
sudo apt-get update

Note: mssql-server.list contains mssql-server and msprod.list contains mssql-tools
4. Install MS SQL server.

$sudo apt-get install -y mssql-server
$sudo /opt/mssql/bin/sqlservr-setup

Note: Do remember the password you have entered while installing the MS SQL server. Default username for the server is SA
5.Check the MS SQL Server service is running or not

$systemctl status mssql-server

6. Install MS SQL Tools

$sudo apt-get install mssql-tools

7. Connect the MS SQL Server via terminal using "sqlcmd" command and test some sample queries Syntax:

sqlcmd -S <hostname> -U <username> -P <password>

Example:

$sqlcmd -S localhost -U SA -P password
>CREATE DATABASE school;
>USE school
>CREATE DATABASE student(rollnumber INT, name VARCHAR(50));
>INSERT INTO student VALUES(1,'HARISH');
>SELECT * FROM school.student;
>QUIT