SQL Server 2022 public preview is now available on Linux.
Published Jun 02 2022 09:24 AM 4,355 Views
Microsoft

In continuation of last week's announcement of SQL Server 2022 public preview, we are pleased to announce availability of SQL Server 2022 on Linux/Containers for public preview. Here are the details for getting started with the SQL Server 2022 public preview packages on Linux/Containers.

 

The following are the container images for SQL Server 2022 on Linux, as well as installation instructions:

  • For RHEL based SQL Server 2022 images refer: mssql/rhel/server - Certified Container Image - Red Hat Ecosystem Catalog
    • To pull and run the SQL Server 2022 RHEL based container image
      podman pull mcr.microsoft.com/mssql/rhel/server:2022-latest
      podman run -e 'ACCEPT_EULA=Y' -e 'MSSQL_SA_PASSWORD=yourStrong(!)Password' --name sql22 --hostname sql22 -p 1433:1433 -d mcr.microsoft.com/mssql/rhel/server:2022-latest
  • For Ubuntu based SQL Server 2022 images refer: Microsoft SQL Server by Microsoft | Docker Hub
    • To pull and run the SQL Server 2022 Ubuntu based container image:
      docker pull mcr.microsoft.com/mssql/server:2022-latest
      docker run -e 'ACCEPT_EULA=Y' -e 'MSSQL_SA_PASSWORD=yourStrong(!)Password' --name sql22 --hostname sql22 -p 1433:1433 -d mcr.microsoft.com/mssql/server:2022-latest

To learn more about the platforms and distributions on which the SQL Server 2022 on Linux public preview can be installed, visit: Release notes for SQL Server 2022 Preview on Linux - SQL Server | Microsoft Docs.

 

Quick installation instructions:

Please register the 'mssql-server-preview' repository to install the SQL Server 2022 public preview. Here's a quick tutorial for installing and getting started with SQL Server 2022 public preview.

 

For RHEL 8 based distributions:
  1. Download the Microsoft SQL Server preview repository configuration file:
    sudo curl -o /etc/yum.repos.d/mssql-server-preview.repo https://packages.microsoft.com/config/rhel/8/mssql-server-preview.repo​​
  2. Run the following command to install SQL Server:
    sudo yum install -y mssql-server​
  3. After the package installation finishes, run mssql-conf setup and follow the prompts to set the SA password and choose your edition.
    sudo /opt/mssql/bin/mssql-conf setup​
  4. Once the configuration is done, verify that the service is running:
    systemctl status mssql-server​
For Ubuntu 20.04 based distributions:
  1. Import the public repository GPG keys.
    curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add –​
  2. Register the Microsoft SQL server preview Ubuntu repository
    sudo add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/20.04/mssql-server-preview.list)"​
  3. Run the following commands to install SQL Server:
    sudo apt-get update
    sudo apt-get install -y mssql-server​
  4. After the package installation finishes, run mssql-conf setup and follow the prompts to set the SA password and choose your edition.
    sudo /opt/mssql/bin/mssql-conf setup​
  5. Once the configuration is done, verify that the service is running:
    systemctl status mssql-server --no-pager​

That's all! SQL Server 2022 public preview is installed, and you can begin using/testing the new features right away!

 

Please see: Installation guidance for SQL Server 2022 Preview on Linux - SQL Server | Microsoft Docs for more information on installation.

 

To install the SQL Server command-line tools for RHEL based distribution please refer RHEL: Install SQL Server on Linux - SQL Server | Microsoft Docs and for Ubuntu based distribution refer: Ubuntu: Install SQL Server on Linux - SQL Server | Microsoft Docs.

 

For more information on the features supported, see : Editions and supported features of SQL Server 2022 Preview - Linux - SQL Server | Microsoft Docs, and for release notes, see  Release notes for SQL Server 2022 Preview on Linux - SQL Server | Microsoft Docs.

Co-Authors
Version history
Last update:
‎Jun 02 2022 09:20 AM
Updated by: