Your submission was sent successfully! Close

Thank you for signing up for our newsletter!
In these regular emails you will find the latest updates from Canonical and upcoming events where you can meet our team.Close

Thank you for contacting our team. We will be in touch shortly.Close

  1. Blog
  2. Article

Mohamed Wadie Nsiri
on 19 December 2023

Still running SQL Server on Ubuntu 16.04 LTS or 18.04 LTS ?


Running SQL Server on Ubuntu 16.04 LTS or 18.04 LTS? If so, this blog is for you to evaluate options to avoid compromising the security of your data

Houston, we have a problem

Ubuntu 16.04 LTS and 18.04 LTS reached the end of standard support on 31 May 2021 and 31 May 2023, respectively.

While SQL Server is famous for being the least vulnerable database for over a decade, running it on an unsupported operating system can leave your data vulnerable to cyber security threats. It is therefore important to upgrade your stack to a supported setup. Let’s go over your options.

Solving the problem

You have two main options to mitigate risks:

  • Expand your security coverage with Ubuntu Pro to extend your support until April 2026 for Ubuntu 16.04 and April 2028 for Ubuntu 18.04.
  • Upgrade to Ubuntu 20.04 LTS or Ubuntu 22.04 LTS.

Let’s explore these two options in more detail.

How Ubuntu Pro can help

Ubuntu Pro provides you with Expanded Security Maintenance for an additional 5 years (so 10 in total). Second, it widens your patch coverage to more than 30,000 packages that are part of Ubuntu repositories (up from 2,300 packages in Ubuntu LTS). Moreover, it offers tools to harden your OS following the most stringent compliance regimes and security standards like ISO 27k, PCI-DSS, CIS, DISA-STIG and FedRAMP. With an Ubuntu Pro subscription, you can also opt in for 24/7 support.

You can upgrade to Ubuntu Pro in-place without the need for complex migrations. Please follow this tutorial for a step-by-step guide.   

You can also deploy new Azure virtual machines running SQL Server on top of Ubuntu Pro using the following optimised images from Azure’s marketplace:

Together, Canonical and Microsoft provide 24/7 support for the above configurations. You can use the same flow when opening support tickets in Azure to get help. Behind the scenes, Microsoft and Canonical coordinate to help you resolve your issues promptly. Ubuntu Pro is available for free for personal and small-scale commercial users on up to 5 machines. It is also available for bigger enterprise deployments with transparent, per-machine pricing.

Upgrading to Ubuntu 20.04 or Ubuntu 22.04

Transitioning to the latest operating system, such as Ubuntu 20.04 LTS or Ubuntu Pro 22.04 LTS, is another option to keep your stack supported. Using a more recent version of Ubuntu provides additional benefits like performance improvements and hardware enablement.  

Depending on your environment, it may be complex to execute such upgrades. Therefore, we recommend performing proper testing with your workloads. Our Ubuntu Server upgrade guide can help you plan for your upgrades. You also need to check that your SQL Server version is supported on the target Ubuntu version:

SQL Server versionSupported Ubuntu versionsReleases notes and details
SQL Server 201716.04 or 18.04Release notes for SQL Server 2017 
SQL Server 201916.04 or 18.04 or 20.04Release notes for SQL Server 2019 
SQL Server 202220.04 or 22.04Releases notes for SQL Server 2022 
Compatibility between Ubuntu versions and SQL Server versions

When opting for an out-of-place migration (using new VMs), we also recommend upgrading to the latest version of SQL Server to benefit from all the new added features.

More Information

You can learn more about Ubuntu support policies and lifecycle using:

If you have any questions, please contact the Canonical team.

Related posts


Serdar Vural
29 February 2024

Telco-grade Sylva-compliant Canonical platforms

Cloud and server Article

In December 2023, Canonical joined the Sylva project of Linux Foundation Europe to provide fully open-source and upstream telco platform solutions to the project. Sylva aims to tackle the fragmentation in telco cloud technologies and the vendor lock-in caused by proprietary platform solutions, by defining a common validation software fram ...


Canonical
28 February 2024

Canonical announces the availability of Real-time Ubuntu for Amazon EKS Anywhere

Canonical announcements Article

Collaboration to benefit communication service providers and business application vendors at the telco edge Barcelona, Spain. 28 February 2024. Canonical today announced an expansion of its relationship with Amazon Web Services (AWS) to make Real-time Ubuntu available to Amazon Elastic Kubernetes Service Anywhere (Amazon EKS Anywhere) cus ...


Canonical
14 February 2024

Firecell and Canonical to demonstrate 5G private mobile network (PMN) solution running on Ubuntu at MWC Barcelona

Canonical announcements Article

Paris, France. 14 February 2024. United by a common goal to advance open source software in telecommunications, Firecell and Canonical will demonstrate at this year’s Mobile Wireless Congress (MWC) event in Barcelona, 5G private mobile network (PMN) solutions running on Canonical’s Ubuntu operating system. Recognising the future of Open R ...