Skip to content

sql-server-linux-setup-2022.md

Latest commit

 

History

History
227 lines (149 loc) · 12.4 KB

sql-server-linux-setup-2022.md

File metadata and controls

227 lines (149 loc) · 12.4 KB
title Installation guidance for SQL Server 2022 Preview on Linux
titleSuffix SQL Server
description Install, update, and uninstall SQL Server 2022 Preview on Linux. This article covers online, offline, and unattended scenarios.
author VanMSFT
ms.author vanto
ms.reviewer randolphwest
ms.date 07/25/2022
ms.topic conceptual
ms.prod sql
ms.custom
sqlfreshmay19
intro-installation
ms.technology linux
monikerRange >=sql-server-ver16||>=sql-server-linux-ver16

Installation guidance for [!INCLUDE sssql22-md] on Linux

[!INCLUDE SQL Server - Linux]

This article provides guidance for installing, updating, and uninstalling [!INCLUDE sssql22-md] community technology preview (CTP) 2.1 on Linux.

Tip

For installing [!INCLUDE sssql17-md] or [!INCLUDE sssql19-md] on Linux, see the Installation guidance for SQL Server on Linux.

You can also install SQL Server on Windows, or Docker containers on Linux.

This guide covers several deployment scenarios. If you're only looking for step-by-step installation instructions, jump to one of the quickstarts:

For answers to frequently asked questions, see the SQL Server on Linux FAQ.

Supported platforms

SQL Server is supported on Red Hat Enterprise Linux (RHEL), and Ubuntu. It's also supported as a Docker image, which can run on Docker Engine on Linux.

Important

SUSE Linux Enterprise Server (SLES) is not supported for [!INCLUDEsssql22] on Linux CTP 2.1, and will follow in a later release.

Platform File System Installation Guide Get
Red Hat Enterprise Linux 8.0 - 8.5 Server XFS or EXT4 Installation guide Get RHEL 8.0
Ubuntu 20.04 LTS XFS or EXT4 Installation guide Get Ubuntu 20.04
Docker Engine 1.8+ on Linux N/A Installation guide Get Docker

Microsoft also supports deploying and managing SQL Server containers by using OpenShift and Kubernetes.

Note

SQL Server is tested and supported on Linux for the previously listed distributions. If you choose to install SQL Server on an unsupported operating system, please review the Support policy section of the Technical support policy for Microsoft SQL Server to understand the support implications.

System requirements

SQL Server has the following system requirements for Linux:

Requirement
Memory 2 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

If you use Network File System (NFS) remote shares in production, note the following support requirements:

  • Use NFS version 4.2 or higher. Older versions of NFS don't support required features, such as fallocate and sparse file creation, common to modern file systems.
  • Locate only the /var/opt/mssql directories on the NFS mount. Other files, such as the SQL Server system binaries, aren't supported.
  • Ensure that NFS clients use the nolock option when mounting the remote share.

Configure source repositories

When you install or upgrade [!INCLUDE sssql22-md], you get the latest version of SQL Server from your configured Microsoft repository.

Although the quickstarts refer to the Cumulative Update CU repository, you must use the mssql-server-preview repository for CTP 2.1.

For more information on repositories and how to configure them, see Configure repositories for SQL Server on Linux.

Install SQL Server

You can install SQL Server on Linux from the command line. For step-by-step instructions, see the following quickstarts, which currently refer to [!INCLUDE sssql19-md]:

For [!INCLUDE sssql22-md] on Linux CTP 2.1, SUSE Linux Enterprise Server (SLES) isn't supported.

You can also run SQL Server on Linux in an Azure virtual machine. For more information, see Provision a SQL VM in Azure.

After installing, consider making additional configuration changes for optimal performance. For more information, see Performance best practices and configuration guidelines for SQL Server on Linux.

Update or upgrade SQL Server

To update the mssql-server package to the latest release, use one of the following commands based on your platform:

Platform Package update command(s)
RHEL sudo yum 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 aren't affected by this operation.

To upgrade SQL Server, first change your configured repository to the desired version of SQL Server. Then use the same update command to upgrade your version of SQL Server. This is only possible if the upgrade path is supported between the two repositories.

Roll back SQL Server

To roll back or downgrade SQL Server to a previous release, use the following steps:

  1. Identify the version number for the SQL Server package you want to downgrade to. For a list of package numbers, see the Release notes.

  2. Downgrade to a previous version of SQL Server. In the following commands, replace <version_number> with the SQL Server version number you identified in step one.

    Platform Package update command(s)
    RHEL sudo yum downgrade mssql-server-<version_number>.x86_64
    Ubuntu sudo apt-get install mssql-server=<version_number>
    sudo systemctl start mssql-server

Note

It is only supported to downgrade to a release within the same major version, such as [!INCLUDE sssql22-md].

Check installed SQL Server version

To verify your current version and edition of SQL Server on Linux, use the following procedure:

  1. If not already installed, install the SQL Server command-line tools.

  2. Use sqlcmd to run a Transact-SQL command that displays your SQL Server version and edition.

    sqlcmd -S localhost -U SA -Q 'select @@VERSION'

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
Ubuntu sudo apt-get remove mssql-server

Removing the package doesn't 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:

  • Follow the initial steps in the quickstarts to register the repositories and install SQL Server.
  • When you run mssql-conf setup, set environment variables and use the -n (no prompt) option.

The following example configures the Developer edition of SQL Server with the MSSQL_PID environment variable. It also accepts the EULA (ACCEPT_EULA) and sets the SA user password (MSSQL_SA_PASSWORD). The -n parameter performs an unprompted installation where the configuration values are pulled from the environment variables.

Important

The SA_PASSWORD environment variable is deprecated. Please use MSSQL_SA_PASSWORD instead.

sudo MSSQL_PID=Developer ACCEPT_EULA=Y 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 doesn't 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 SQL Server package(s). 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 install command
    RHEL sudo yum localinstall mssql-server_versionnumber.x86_64.rpm
    Ubuntu sudo dpkg -i mssql-server_versionnumber_amd64.deb

    [!NOTE] You can also install the RPM packages 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
    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

Licensing and pricing

SQL Server is licensed the same for Linux and Windows. For more information about SQL Server licensing and pricing, see How to license SQL Server.

Optional SQL Server features

After installation, you can also install or enable optional SQL Server features.

[!INCLUDEGet Help Options]

Tip

For answers to frequently asked questions, see the SQL Server on Linux FAQ.