Installing SQL Server 2017 on Ubuntu Linux 16.04

I was sitting here having a discussion with one of my good friends about running SQL Server 2017 on the Linux Platform, he stated that it worked great on CentOS 7 and i wanted to see if i could get SQL Server to run on an Ubuntu Linux Server. I was about to get SQL Server 2017 to run on Ubuntu 16.04 using the following steps:

1. Import the public repo GPG Keys:

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









2. Register MS SQL Server Ubuntu repo

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











3. Install MSSQL Server 2017

when running apt-get update you will run into the following error

I was able to resolve this error by running the dpkg --configure -a command, Once dpkg completed i was able to run  both apt-get update & apt-get install mssql-server

4. Setting up the MSSQL Sever 2017 Configuration

 /opt/mssql/bin/mssql-conf setup

5.  Checking the Status of the mssql-server running

systemctl status mssql-server

Now that I have the Database up and running i found i still needed to install the SQL Server command line tools. The command-line tools will allow you to connect to the database and run SQL statements against the database

6.  Import the public repo GPG keys

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


7. Register the Microsoft Ubuntu repo


 curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list 

| sudo tee /etc/apt/sources.list.d/msprod.list


8. Update the sources list and run the install.

apt-get update
apt-get install mssql-tools unixodbc-dev

9. Connect to the local database

/opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P ''