Skip to content

sql-server-linux-setup.md

Latest commit

 

History

History
171 lines (120 loc) · 8.02 KB

sql-server-linux-setup.md

File metadata and controls

171 lines (120 loc) · 8.02 KB
title Install SQL Server 2017 on Linux | Microsoft Docs
description Install, update, and uninstall SQL Server on Linux. This topic covers online, offline, and unattended scenarios.
author rothja
ms.author jroth
manager jhubbard
ms.date 07/17/2017
ms.topic article
ms.prod sql-linux
ms.technology database-engine
ms.assetid 565156c3-7256-4e63-aaf0-884522ef2a52

Installation guidance for SQL Server on Linux

This topic explains how to install, update, and uninstall SQL Server 2017 on Linux. SQL Server 2017 RC1 is supported on Red Hat Enterprise Linux (RHEL), SUSE Linux Enterprise Server (SLES), and Ubuntu. It is also available as a Docker image, which can run on Docker Engine on Linux or Docker for Windows/Mac.

Tip

To get started quickly, jump to one of the quick start tutorials for RHEL, SLES, Ubuntu, or Docker.

Supported platforms

SQL Server 2017 is supported on the following Linux platforms:

Platform Supported version(s) Get
Red Hat Enterprise Linux 7.3 Get RHEL 7.3
SUSE Linux Enterprise Server v12 SP2 Get SLES v12 SP2
Ubuntu 16.04 Get Ubuntu 16.04
Docker Engine 1.8+ Get Docker

System requirements

SQL Server 2017 has the following system requirements for Linux:
Memory 3.25 GB
File System XFS or EXT4 (other file systems, such as BTRFS, are unsupported)
Disk space 6 GB
Processor speed 2 GHz
Processor cores 2 cores
Processor type x64-compatible only

Note

SQL Server Engine has been tested up to 1 TB of memory at this time.

Install SQL Server

You can install SQL Server on Linux from the command-line. For instructions, see one of the following quick start tutorials:

Upgrade SQL Server

To upgrade the mssql-server package on Linux, use one of the following commands based on your platform:

Platform Package update command(s)
RHEL sudo yum update mssql-server
SLES sudo zypper update mssql-server
Ubuntu sudo apt-get update
sudo apt-get install mssql-server

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

Uninstall SQL Server

To remove the mssql-server package on Linux, use one of the following commands based on your platform:

Platform Package removal command(s)
RHEL sudo yum remove mssql-server
SLES sudo zypper remove mssql-server
Ubuntu sudo apt-get remove mssql-server

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

sudo rm -rf /var/opt/mssql/

Unattended install

You can perform an unattended installation in the following way:

The following example configures the Developer edition of SQL Server with the MSSQL_PID environment variable. It also sets the SA user password with the MSSQL_SA_PASSWORD environment variable. The -n parameter pulls in these values for a simple unattended install:

sudo MSSQL_PID=Developer MSSQL_SA_PASSWORD='<YourStrong!Passw0rd>' /opt/mssql/bin/mssql-conf -n setup

You can also create a script that performs other actions. For example, you could install other SQL Server packages.

For a more detailed sample script, see the following examples:

Offline install

If your Linux machine does not have access to the online repositories used in the quick starts, you can download the package files directly. These packages are located in the Microsoft repository, https://packages.microsoft.com.

Tip

If you successfully installed with the steps in the quick starts, you do not need to download or manually install the package(s) below. This section is only for the offline scenario.

  1. Download the database engine package for your platform. Find package download links in the package details section of the Release Notes.

  2. 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 command.

  3. Install the database engine package. Use one of the following commands based on your platform. Replace the package file name in this example with the exact name you downloaded.

    Platform Package removal command
    RHEL sudo yum localinstall mssql-server_versionnumber.x86_64.rpm
    SLES sudo zypper install mssql-server_versionnumber.x86_64.rpm
    Ubuntu sudo dpkg -i mssql-server_versionnumber_amd64.deb

    [!NOTE] You can also install the RPM packages (RHEL and SLES) with the rpm -ivh command, but the commands in the previous table automatically install dependencies if available from approved repositories.

  4. Resolve missing dependencies: You might have missing dependencies at this point. If not, you can skip this step. On Ubuntu, if you have access to approved repositories containing those dependencies, the easiest solution is to use the apt-get -f install command. This command also completes the installation of SQL Server. To manually inspect dependencies, use the following commands:

    Platform List dependencies command
    RHEL rpm -qpR mssql-server_versionnumber.x86_64.rpm
    SLES rpm -qpR mssql-server_versionnumber.x86_64.rpm
    Ubuntu `dpkg -I mssql-server_versionnumber_amd64.deb

    After resolving the missing dependencies, attempt to install the mssql-server package again.

  5. Complete the SQL Server setup. Use mssql-conf to complete the SQL Server setup:

    sudo /opt/mssql/bin/mssql-conf setup

Next steps

After installation, you can also install other optional SQL Server packages.

Connect to your SQL Server instance to begin creating and managing databases. To get started, see the quick start tutorials: