Microsoft to eliminate key SQL Server images for Linux VMs, requiring temporary manual installations

Major Changes to SQL Server on Linux Virtual Machines in Azure Marketplace

Microsoft has announced the upcoming removal of all Linux-based SQL Server virtual machine (VM) images from the Azure Marketplace. This change will affect new provisioning methods, as these images will be disabled across various platforms, including the Azure SQL hub, Command-Line Interface (CLI), Azure Portal, and PowerShell scripts. The phasing out is planned to commence shortly, spanning the next couple of months, during which time availability of these images may be intermittent. Fortunately, users with existing deployments will continue to have their systems functioning without disruption.

Transitioning to Manual Installation

As Microsoft transitions away from these pre-packaged images, they advise customers setting up new SQL Server instances to utilize a manual installation process. This involves creating a basic Linux Virtual Machine through the Azure Portal, CLI, or PowerShell, and subsequently following the comprehensive SQL Server installation guides available for RHEL, SLES, and Ubuntu. You can access the installation documentation using the links below:

Reasons Behind the Changes

The decision to discontinue support for these VM images stems from Microsoft’s strategic shift towards a script-based deployment model. This evolution is poised to enhance flexibility, allowing users to automate processes and maintain greater control over their SQL Server installations. With the upcoming script-based provisioning, customers will gain the ability to select their desired Linux distribution, choose specific SQL Server versions/editions, and customize parameters through VM extensions.

Impact on Users and Future Updates

This transition will impact all provisioning methods, effectively altering the landscape of how SQL Server on Linux is deployed within Azure. While the existing images provided straightforward deployment solutions, the upcoming methods—including manual installations and script-based deployments—intended for RHEL, SLES, and Ubuntu, are set to offer enhanced customization and control.

For ongoing developments and updates regarding this significant change, users are encouraged to monitor the Azure portal, relevant documentation, and the SQL Server blog, where Microsoft will provide further announcements and guidance.

Source: Microsoft

Source & Images