Install SQL Server on SUSE Linux Enterprise Server

This topic provides a walkthrough of how to install SQL Server vNext CTP 1.4 on SUSE Linux Enterprise Server (SLES) v12 SP2.

Note

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

Note

The file system must be XFS or EXT4. Other file systems, such as BTRFS, are unsupported.

Install SQL Server

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

  1. Download the Microsoft SQL Server SLES repository configuration file:

    sudo zypper addrepo -fc https://packages.microsoft.com/config/sles/12/mssql-server.repo
    
    sudo zypper --gpg-auto-import-keys refresh
    
  2. Run the following commands to install SQL Server:

    sudo zypper install mssql-server
    
  3. After the package installation finishes, run mssql-conf setup 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/mssql-conf setup
    
  4. Once the configuration is done, verify that the service is running:

    systemctl status mssql-server
    
  5. To allow remote connections, you may need to open the SQL Server TCP port on your firewall. The default SQL Server port is 1433.

Upgrade SQL Server

To upgrade the mssql-server package on SLES, execute the following command:

   sudo zypper 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

To remove the mssql-server package on SLES, 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 zypper 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