How to install MS SQL Server on Ubuntu 16.04

MS SQL On Ubuntu 16.04

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.

Import the public repository GPG keys:

Register the Microsoft SQL Server Ubuntu repository and the Microsoft tools repository:

Exit superuser mode.

Run the following commands to install MS SQL Server on Ubuntu and MS SQL Tools:

After the package installation finishes, run the configuration script to set up MS SQL (sa) credentials – type this and follow the prompts.

Once the configuration is done, verify that the service is running:

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.