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.
My Setup:
- Ubuntu 17.10 Server – VMware Template
- Network Connectivity
- SQL Server Management Studio 17 – Testing connectivity to SQL Server
Prerequisites:
- Ubuntu Linux Server – Memory: 3.25, Disk Space: 6GB, CPU (x64): 2 Cores
- Internet Access – Offline Installs are also possible
- Root or SU Access
- Time – 5-6 Minutes
Steps:
- Log into Ubuntu Linux server via console or SSH (Preferred), su into root
- 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.
- Test connecting to your newly install SQL Server via SSMS.
- Done!
Screenshot:
Video:
[youtube id=”fRUNcC1ZSB4″ width=”600″ height=”350″]