SQL Server 2022 public preview is now available on Linux.

This post has been republished via RSS; it originally appeared at: New blog articles in Microsoft Tech Community.

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 imagepodman 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 repositorysudo 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.