How To Install Microsoft SQL Server on Ubuntu 16.04 LTS

Install Microsoft SQL Server on Ubuntu 16.04 LTS

In this tutorial we will show you how to install and configuration Microsoft SQL Server on Ubuntu 16.04. For those of you who didn’t know, Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications which may run either on the same computer or on another computer across a network (including the Internet).

This article assumes you have at least basic knowledge of linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple and assumes you are running in the root account, if not you may need to add ‘sudo’ to the commands to get root privileges. I will show you through the step by step installation Microsoft SQL Server on a Ubuntu 16.04 (Xenial Xerus) server.

Install Microsoft SQL Server on Ubuntu 16.04 LTS

Step 1. First make sure that all your system packages are up-to-date by running these following apt-get commands in the terminal.

Step 2. Installing Microsoft SQL Server on Ubuntu 16.04.

To begin, we’ll need to add two repositories to our software sources list:

Next we install the MS SQL server by following command:

Step 3. Configure MS SQL server.

Once installation is complete, you will be reminded to run the configuration script (/opt/mssql/bin/sqlservr-setup) to accept the license terms, set the password for the SA user, and start the service.


Finally, Start the Microsoft SQL Server Service:

Step 4. Connect to MS SQL server.

Once the installation is complete, connect to MS SQL server using the following command:

Congratulation’s! You have successfully installed Microsoft SQL Server. Thanks for using this tutorial for installing Microsoft SQL Server (MS SQL) on your Ubuntu 16.04 LTS (Xenial Xerus) system. For additional help or useful information, we recommend you to check the official Microsoft SQL Server web site.

VPS Manage Service Offer
If you don’t have time to do all of this stuff, or if this is not your area of expertise, we offer a service to do “VPS Manage Service Offer”, starting from $10 (Paypal payment). Please contact us to get a best deal!