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
- To pull and run the SQL Server 2022 RHEL based container image
- 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 pull and run the SQL Server 2022 Ubuntu based container image:
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:
- 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
- Run the following command to install SQL Server:
sudo yum install -y mssql-server
- 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
- Once the configuration is done, verify that the service is running:
systemctl status mssql-server
For Ubuntu 20.04 based distributions:
- Import the public repository GPG keys.
curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add –
- 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)"
- Run the following commands to install SQL Server:
sudo apt-get update sudo apt-get install -y mssql-server
- 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
- 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.