Additional SQL Server features and topics not covered by specific categories
For an on-premises SQL Server 2016 ESU purchase, register each SQL Server instance in the Azure portal, link the ESU invoice, and then download available patches from the instance’s Extended Security Updates pane.
If the servers are not connected to Azure Arc
This is the documented workflow for disconnected instances purchased through volume licensing:
- In the Azure portal, open SQL Server instances.
- Select Add → Register SQL Server instances.
- Select Single SQL Server Instance, or use Multiple SQL Instances to upload a CSV.
- Enter the instance details:
- Instance name—the output from
SELECT @@SERVERNAME. - SQL Server version and edition.
- Core count.
- On-premises physical or virtual host type.
- Instance name—the output from
- Confirm that you have rights to receive ESUs and finish registration.
- Select the registered instances and choose Link ESU invoice.
- Enter the Purchase Order Number shown under Invoice Summary on the Microsoft ESU invoice.
- Confirm that each instance now displays a valid ESU expiration date.
- Open the SQL Server instance’s Extended Security Updates pane and download the available package. ^1^
The Azure account performing registration needs Microsoft.AzureArcData/sqlServerInstances/read and /write, available through the Azure Connected SQL Server Onboarding, Contributor, or Owner role. The subscription must also have the Microsoft.AzureArcData resource provider registered. ^1^
If the servers are connected to Azure Arc
For Arc-connected servers:
- Azure portal → Azure Arc → Machines.
- Select the server.
- Under Operations, select SQL Server Configuration.
- Enable the ESU subscription and select Save.
- If automatic updates are enabled, available ESUs install automatically. Otherwise, open the SQL Server instance’s Extended Security Updates pane to download them manually. ^2^
ESU patches can also arrive through the normal servicing channels: Microsoft Update, Windows Update, System Center Configuration Manager, or Azure Update Manager. ^3^
Important timing and servicing requirements
- SQL Server 2016 reaches end of support on July 14, 2026; ESUs are available through July 17, 2029. ^3^
- ESUs are not issued on a regular monthly schedule. Microsoft releases them when SQL Server is affected by a vulnerability rated Critical by the Microsoft Security Response Center.
- ESUs do not include new features, functional improvements, or ordinary customer-requested fixes.
- SQL Server must be on its latest Service Pack before an ESU can be applied.
- SQL Server 2016 ESUs include the latest cumulative update. If the instances have only received GDR updates, install and validate the latest CU when subscribing rather than waiting for the first ESU. ^2^
Therefore, if no package is currently displayed, first check whether SQL Server 2016 is still within regular Extended Support or whether Microsoft has released an applicable Critical ESU; purchasing the subscription does not create a separate patch immediately.
References