Blog Post

SQL Server Blog
2 MIN READ

SQL Server 2022 for RHEL 9 and Ubuntu 22.04 is now Generally Available (GA)

amvin87's avatar
amvin87
Icon for Microsoft rankMicrosoft
Nov 22, 2023

We are happy to announce that Starting CU 10 release for SQL Server 2022 , SQL Server 2022 on RHEL 9 and Ubuntu 22.04 is now generally available (GA), meaning you can run production workload on SQL Server 2022 deployed on Red Hat Enterprise Linux (RHEL) 9 and Ubuntu 22.04. For SQL Server 2022 on RHEL 9, the SELinux integration that enables you to run SQL Server 2022 on RHEL 9 as confined application is also now generally available. 

 

If you've had the preview packages installed previously, we recommend that you please uninstall the preview bits and upgrade to SQL Server 2022 GA packages available at the following repos, for steps on how to update repos refer the Configure repositories for installing and upgrading SQL Server on Linux - SQL Server | Microsoft Learn documentation.

 

For further details on getting started with the installation of SQL Server 2022 on RHEL 9 refer: RHEL: Install SQL Server on Linux - SQL Server | Microsoft Learn & for SQL Server on Ubuntu 22.04 refer: Ubuntu: Install SQL Server on Linux - SQL Server | Microsoft Learn

 

SQL Server 2022 container images on RHEL 9 & Ubuntu 22.04 also generally available:

SQL Server 2022 on RHEL 9 and Ubuntu 22.04 are also available as container images and generally available (GA). It is easy for you to get started. Like always, you can use both podman and/or docker tool. 

 

To pull and run the production ready SQL Server 2022 images on RHEL 9 use the tag: 2022-CU10-rhel-9.1

#Pull the image
podman pull mcr.microsoft.com/mssql/rhel/server:2022-CU10-rhel-9.1

#Run a container using the above image
podman run -e 'ACCEPT_EULA=Y' -e 'MSSQL_SA_PASSWORD=<YourP@ssword>' -e 'MSSQL_PID=Developer' -h sql22rhel9 --name sql22rhel9 -p 1433:1433 -d mcr.microsoft.com/mssql/rhel/server:2022-CU10-rhel-9.1

To pull and run the production ready SQL Server 2022 images on Ubuntu 22.04 use the tag: 2022-CU10-ubuntu-22.04

#Pull the image
docker pull mcr.microsoft.com/mssql/server:2022-CU10-ubuntu-22.04

#Run a container use the above image
docker run -e 'ACCEPT_EULA=Y' -e 'MSSQL_SA_PASSWORD=<YourP@ssword>' -e 'MSSQL_PID=Developer' -h sql22ubu2204 --name sql22ubu2204 -p 1433:1433 -d mcr.microsoft.com/mssql/server:2022-CU10-ubuntu-22.04

 

 

 

 

 

 

 

 

 

 

Updated Nov 22, 2023
Version 1.0
SQLServer2022
sqlserveronlinux
SQLServerTiger
  • JasonA2010's avatar
    JasonA2010
    Copper Contributor
    Sep 05, 2024

    Hi amvin87

     

    Many thanks you for the clarification. It just strange that 2019 is not compatible with redhat 9.x

     
  • amvin87's avatar
    amvin87
    Icon for Microsoft rankMicrosoft
    Sep 04, 2024

    Hello JasonA2010 ,

    SQL Server 2019 does not support RHEL 9.4. SQL 2022 supports RHEL 9.4. Here is a link for the supported OS list for SQL 2019 and SQL 2022. Hope this helps.

     

    Thanks

    Amit 

  • JasonA2010's avatar
    JasonA2010
    Copper Contributor
    Sep 04, 2024

    Hi

     

    Pls. execuse me of asking here about ms sql 2019. Is MS  SQL 2019 Enterprise supported on RHEL  9.4 version . I am asking since I have a current project and MS SQL 2019 services could not start/failing.

     

    Awaiting for your reply and Thank you in advance.

  • MooreOSU's avatar
    MooreOSU
    Copper Contributor
    Mar 08, 2024

    The instuctions for setting up AD auth show needing adutil but that does not seem to be available in the RHEL 9 msprod repo and installing from the RHEL 8 repo has a library dependency issue.  Is there a timeline to get adutil compiled for RHEL 9 and placed in the repository?

  • maulikmodi1025's avatar
    maulikmodi1025
    Copper Contributor
    Nov 26, 2023

    amvin87,  I was awaiting to get this announcement since the day Red Hat announced that RHEL 9 by default uses cgroups-v2 to have better control over cpu/memory limits. News of SQL Server 2022 supporting SELinux on RHEL 9 connects all the dotes now.

     

    I see that other Docker images published on Red Hat Container catalog shows Security / Vulnerability information e.g. Crunchy Postgres , Confluent Kafka , IBM Db2 

     

    Question 1: Where can we see security / vulnerability information of images published on MCR?

    mcr.microsoft.com/mssql/rhel/server:2022-CU10-rhel-9.1

    Question 2: Having docker image on RHEL 9 is a good starting point, Is there any plan to make Helm chart/Operator for SQL Server available so that it can be deployed seamlessly across Container orchestrators such as AKS, EKS, ARO or OCP for failover, availability, reliability etc...?

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

     

    Question 3: Could you please point us to industry standard database performance testing benchmark(TPC) comparison of SQL 2022 on VM vs Linux containers on same hardware?

     

    Question 4: As Red Hat OCP 4.14 Supports Windows Containers, What workloads are supported for running as windows containers? I saw that SQL server on windows containers are only for DEV/Test and not supported by Microsoft for production. 

     

    Question 5: Is TDE Supported on SQL Server 2022 on RHEL?

     

    Question 6 : What features from Unsupported features of SQL Server 2019 on Linux become supported in SQL 2022, as I am seeing the identical list of Unsupported features of SQL server 2022 on Linux as they are on Unsupported features of SQL server 2019 on Linux. Does it require doc update? What is the possibility of supporting any of the unsupported features in future SQL Server releases on linux? I guess AD Authentication is the only way to Enforce strong password policy - complexity, expiry rules.