Install MSSQL Server on Ubuntu (Linux)

admin/ January 21, 2017/ Linux/ 0 comments

Install SQL Server
To install the mssql-server Package on Ubuntu, follow these steps:

Import the public repository GPG keys:

$ sudo curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -

Register the Microsoft SQL Server Ubuntu repository:

$ sudo curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server.list | sudo tee /etc/apt/sources.list.d/mssql-server.list

Run the following commands to install SQL Server:

$ sudo apt-get update
$ sudo apt-get install -y mssql-server

After the package installation finishes, run the configuration script and follow the prompts. Make sure to specify a strong password for the SA account (Minimum length 8 characters, including uppercase and lowercase letters, base 10 digits and/or non-alphanumeric symbols).

$ sudo /opt/mssql/bin/sqlservr-setup

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

$ systemctl status mssql-server

Upgrade SQL Server
In order to upgrade the mssql-server package on RHEL, follow these steps:

Update the apt-get repository lists:

$ sudo apt-get update

Re-run the installation command, this will upgrade the specific mssql-server package:

$ sudo apt-get install mssql-server

These commands will download the newest package and replace the binaries located under /opt/mssql/. The user generated databases and system databases will not be affected by this operation.

Uninstall SQL Server
In order to remove the mssql-server package on RHEL, follow these steps:

Run the remove command. This will delete the package and remove the files under /opt/mssql/. However, this command will not affect user-generated and system databases.

$ sudo apt-get remove mssql-server

Removing the package will not delete the generated database files. If you want to delete the database files use the following command:

$ sudo rm -rf /var/opt/mssql/

Leave a Reply