This topic provides a walkthrough of how to install SQL Server 2017 CTP 2.1 on SUSE Linux Enterprise Server (SLES) v12 SP2.
You need at least 3.25GB of memory to run SQL Server on Linux. Also, the file system must be XFS or EXT4. Other file systems, such as BTRFS, are unsupported. For other system requirements, see System requirements for SQL Server on Linux.
Install SQL Server
To install the mssql-server package on SLES, follow these steps:
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
Run the following commands to install SQL Server:
sudo zypper install mssql-server
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
Once the configuration is done, verify that the service is running:
systemctl status mssql-server
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:
removecommand. 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
sudo zypper 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/
If your Linux machine does not have access to the online repositories used in the previous sections, you can download the package files directly. These packages are located in the Microsoft repository, https://packages.microsoft.com.
If you successfully installed with the steps in the previous sections, you do not need to download or manually install the package(s) below. This is only for the offline scenario.
To manually install the SQL Server database engine package for SUSE Linux Enterprise Server, use the following steps:
Download the .rpm database engine package. Find package download links in the package details section of the Release Notes.
Move the downloaded package to your Linux machine. If you used a different machine to download the packages, one way to move the packages to your Linux machine is with the scp commmand.
Install the database engine package. Use the zypper install command. Replace
versionnumberwith your package version number.
sudo zypper install mssql-server_versionnumber.x86_64.rpm
You can also install the RPM package with the
rpm -ivhcommand, but the
zypper installcommand also installs dependencies if available from approved repositories.
Resolve missing dependencies: You might have missing dependencies at this point. If not, you can skip this step. In some cases, you must manually locate and install these dependencies. Use the rpm command to inspect the dependencies of the SQL Server packages:
rpm -qpR mssql-server_versionnumber.x86_64.rpm
Complete the SQL Server setup. Use mssql-conf to complete the SQL Server setup:
sudo /opt/mssql/bin/mssql-conf setup