X

How To Install MSSQL Linux 2017 On UBuntu 18.04

In this tutorial for hot to install MSSQL Linux 2017 On UBuntu 18.04. So please wait at least five or six minutes for installation completed. Now I am ssh my server via MobaXtreem then run all command using root user.

How To Install Laravel On Ubuntu 16.04 With Phpmyadmin and Mysql
How To Install WordPress (CMS) on Ubuntu 16.04

Step #01: Must be server update and upgrade needed for installation MSSQL Server 2017 on Ubuntu 16.04.

root@MSSQL-Linux:~# apt-get update && apt-get upgrade

Software properties needed or not

root@MSSQL-Linux:~# apt install software-properties-common

Step #02: Add Microsoft public via below command.

root@MSSQL-Linux:~# wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -

Step #03: Now add source list Microsoft source list.

root@MSSQL-Linux:~# add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2017.list)"

Then run below command

root@MSSQL-Linux:~# apt-get update

Step #04: Finally run command for install MSSQL server 2017 on Ubuntu 18.04.

root@MSSQL-Linux:~# apt-get install -y mssql-server

Wait at least five or six minutes for all package download and install.

Step #05: Setup below command for which version install on your server.

root@MSSQL-Linux:~# sudo /opt/mssql/bin/mssql-conf setup

Then press 2 for install Developer Edition its free. Another you can install paid version easily.

Choose an edition of SQL Server:
  1) Evaluation (free, no production use rights, 180-day limit)
  2) Developer (free, no production use rights)
  3) Express (free)
  4) Web (PAID)
  5) Standard (PAID)
  6) Enterprise (PAID)
  7) Enterprise Core (PAID)
  8) I bought a license through a retail sales channel and have a product key to enter.

type 2 then press Enter

Accept terms and condition : yes

Do you accept the license terms? [Yes/No]:yes

Type sa password for two times then. Now see service status using below command

root@MSSQL-Linux:~# systemctl status mssql-server

If any problem then don’t forget any comment so I try to provide another guide. For more details please see my YouTube channel.

5 1 vote
Article Rating
Admin: I am system administrator as Windows and Linux platform. I have 4 years skilled from the professional period. I have to configure Linux based system such as an Asterisk VOIP system, Network monitoring tools (ZABBIX), Virtualization (XEN Server), Cloud computing (Apache CloudStack) etc. Now share my professional skill each interested person. Thanks to all.

View Comments (2)

  • Enter the SQL Server system administrator password:
    Confirm the SQL Server system administrator password:
    Configuring SQL Server...

    sqlservr: This program requires a machine with at least 2000 megabytes of memory.
    /opt/mssql/bin/sqlservr: This program requires a machine with at least 2000 megabytes of memory.

    Initial setup of Microsoft SQL Server failed. Please consult the ERRORLOG
    in /var/opt/mssql/log for more information.

Leave a Comment