Install MS SQL on Ubuntu 16.04
To install MS SQL On Ubuntu we need to install the mssql-server Package on Ubuntu using the terminal, following these steps:
Enter superuser mode.
|
1 |
sudo su |
Import the public repository GPG keys:
|
1 |
curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add - |
Register the Microsoft SQL Server Ubuntu repository and the Microsoft tools repository:
|
1 2 |
curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server.list > /etc/apt/sources.list.d/mssql-server.list curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list > /etc/apt/sources.list.d/msprod.list |
Exit superuser mode.
|
1 |
exit |
Run the following commands to install MS SQL Server on Ubuntu and MS SQL Tools:
|
1 2 |
sudo apt-get update sudo apt-get install -y mssql-server mssql-tools |
After the package installation finishes, run the configuration script to set up MS SQL (sa) credentials – type this and follow the prompts.
|
1 |
sudo /opt/mssql/bin/sqlservr-setup |
Once the configuration is done, verify that the service is running:
|
1 |
systemctl status mssql-server |
Job’s a good ‘un – largely because open source is cheap and SSMS with ApexSQL tools is a brilliant combination for getting stuff done. MySQL workbench is nice, but Microsoft knows how to make great enterprise software and SSMS is one of their best offerings.