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:

Register the Microsoft SQL Server Ubuntu repository:

Run the following commands to install SQL 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).

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

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

Update the apt-get repository lists:

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

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.

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

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.