Database

I recently had the pleasure of installing Microsoft SQL Server on Linux – Ubuntu Server. This was a very straight-forward installed and just works. The following steps are what were taken to install and configure this server.

We need to import the repository GPG Keys by first downloading and adding it with he following command: curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add –

Next we register the repository by entering: add-apt-repository “$(curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2017.list)”

Next we need to upload the repository list and install SQL with the following commands: apt update | apt install mssql-server -y

After the SQL Server package has completed installing. You will be instructed to run mssql-config setup to setup the SQL Server version you will be installing, in addition to password credentials. This is done by issue the following command: /opt/mssql/bin/mssql-conf setup

Optional – Open your firewall if enabled to allow for SQL’s TCP/1433 from remote hosts.