MS SQL On Ubuntu 16.04

How to install MS SQL Server on Ubuntu 16.04

By:

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.


Leave a Reply

Your email address will not be published. Required fields are marked *