Install SQL Server on Red Hat Enterprise Linux

This topic provides a walkthrough of how to install SQL Server vNext CTP 1.1 on Red Hat Enterprise Linux (RHEL) 7.3.

Note

You need at least 3.25GB of memory to run SQL Server on Linux. SQL Server Engine has only been tested up to 256GB of memory at this time.

Install SQL Server

To install the mssql-server package on RHEL, follow these steps:

  1. Enter superuser mode.

    sudo su
    
  2. Download the Microsoft SQL Server Red Hat repository configuration file:

    curl https://packages.microsoft.com/config/rhel/7/mssql-server.repo > /etc/yum.repos.d/mssql-server.repo
    
  3. Exit superuser mode.

    exit
    
  4. Run the following commands to install SQL Server:

    sudo yum install -y mssql-server
    
  5. 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
    
  6. Once the configuration is done, verify that the service is running:

    systemctl status mssql-server
    
  7. You may need to open a port on the firewall on RHEL. If you are using FirewallD for your firewall, you can use the following commands.

    sudo firewall-cmd --zone=public --add-port=1433/tcp --permanent
    sudo firewall-cmd --reload
    

Upgrade SQL Server on Red Hat Enterprise Linux

In order to upgrade the mssql-server package, execute the following command:

   sudo yum update 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 on Red Hat Enterprise Linux

In order to remove the mssql-server package, follow these steps:

  1. 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 database files, which are located under /var/opt/mssql.

    sudo yum remove mssql-server
    
  2. 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/
    

Next steps