SQL Server 2022 now available for both RHEL 9 and Ubuntu 22.04 in Preview mode

[Guest amvin87]

We are glad to announce that SQL Server 2022 is now available in preview mode for both Red Hat Enterprise Linux (RHEL) 9 and Ubuntu 22.04. For this preview, only Evaluation edition is available, which is limited to 180 days starting Thursday, July 27th, 2023.

 

 

 

In your Dev/Test environments, you may now take advantage of the most recent SQL Server 2022 improvements on both RHEL 9 and Ubuntu 22.04. Currently, production workloads on RHEL 9 and Ubuntu 22.04 are not supported by the SQL Server 2022 preview packages. You can run the production workloads for SQL Server 2022 on RHEL 8 and Ubuntu 22.04 and they are fully supported.

 

 

 

SELinux Integration:

 

 

With this preview release, you now have the option to run SQL Server 2022 as a confined application when you have the SELinux enabled and in enforcing mode. Thus, seamlessly integrating with the SELinux enabled secure environments. This integration is made possible by the new package called "mssql-server-selinux" which enables the custom policies required to run SQL Server as confined application with SELinux. For more information about confined and unconfined applications with SELinux, see Getting started with SELinux.

 

 

 

If you prefer to run SQL Server as unconfined application like in previous version of RHEL, then you can skip the installation of the "mssql-server-selinux" package and just install the mssql-server package like you did with the previous RHEL versions. For details on how you can get started with SQL Server 2022 on RHEL 9 preview please refer: RHEL: Install SQL Server on Linux - SQL Server | Microsoft Learn

 

 

 

Getting Started with SQL Server 2022 on Ubuntu 22.04 (preview)

 

 

You can get started with the SQL Server 2022 on Ubuntu 22.04 preview for details refer : Ubuntu: Install SQL Server on Linux - SQL Server | Microsoft Learn

 

 

SQL Server Container images (preview)

 

 

The preview packages for SQL Server 2022 on RHEL 9 and Ubuntu 22.04 are also available as container images and it is easy for you to get started. Like always, you can use both podman and/or docker tool.

 

 

 

SQL Server 2022 preview container image based on RHEL 9:

 

 

You can pull the preview container image using the tag: 2022-preview-rhel-9 as shown below

 

 

 

podman pull mcr.microsoft.com/mssql/rhel/server:2022-preview-rhel-9

 

 

 

Deploy the SQL Server containers using the command below, please note the use of Evaluation edition as this is currently in preview

 

 

 

podman run -e 'ACCEPT_EULA=Y' -e 'MSSQL_SA_PASSWORD=<YourP@ssword>' -e 'MSSQL_PID=Evaluation' -h sqlpreview --name sqlpreview -p 1433:1433 -d mcr.microsoft.com/mssql/rhel/server:2022-preview-rhel-9

 

 

 

SQL Server 2022 preview container image based on Ubuntu 22.04:

 

 

You can pull the preview container image using the tag: 2022-preview-ubuntu-22.04 as shown below

 

 

 

docker pull mcr.microsoft.com/mssql/server:2022-preview-ubuntu-22.04

 

 

 

Deploy the SQL Server containers using the command below, please note the use of Evaluation edition as this is currently in preview

 

 

 

docker run -e 'ACCEPT_EULA=Y' -e 'MSSQL_SA_PASSWORD=<YourP@ssword>' -e 'MSSQL_PID=Evaluation' -h sqlpreview --name sqlpreview -p 1433:1433 -d mcr.microsoft.com/mssql/server:2022-preview-ubuntu-22.04

 

 

 

For further details on container images, refer:

 

For RHEL based SQL Server 2022 preview container images: Microsoft SQL Server - RHEL based images

 

For Ubuntu based SQL Server 2022 preview container images: Microsoft SQL Server - Ubuntu based images

 

 

 

Let us know your experience with the preview package:

 

 

If you have any feedback or issue that you'd like to report for these preview packages we recommend you to use any of the following options that suits you the best.

 

1) Send us an email with your feedback to sqlpreviewpackage@microsoft.com.

 

2) Another option would be to submit your comments directly on Azure Ideas ( Use the SQL Server on Linux Group on the left side of the page)

 

3) Alternatively, you can open issues related to the preview packages Issues · microsoft/mssql-docker (github.com) on GitHub.

 

 

 

We hope you give SQL Server 2022 preview packages on Red Hat 9 and Ubuntu 22.04 a try and let us know what you think!

 

Continue reading...