An Azure service to centrally manages updates and compliance at scale.
Hello Seelan, Sathiya, it sounds like you're having trouble patching SQL Server 2022 instances through Azure Update Manager, and you're curious if there's an issue with only SQL Server 2019 being patched.
Here are a few things to check:
- Azure Update Manager Compatibility: Ensure that Azure Update Manager is correctly set up for SQL Server 2022. Azure Update Manager is designed to manage updates for SQL Server across various versions, but you need to check if the integration is properly configured for your SQL Server VM.
- Enabled Automated Patching: If you have both Azure Update Manager and Automated Patching enabled, it might cause conflicts. Make sure to disable Automated Patching before using Azure Update Manager. This can be done via the Azure portal by navigating to your SQL virtual machine resource, selecting Updates, and choosing to disable Automated Patching.
- Maintenance Configuration: Ensure your maintenance window is set correctly. Azure Update Manager installs updates during the configured maintenance window.
- Check for Updates Availability: After setting everything up, trigger a manual assessment by selecting Check for updates in Azure Update Manager to see if the SQL Server 2022 patches appear.
- Logs and Diagnostics: Check the logs located at
C:\WindowsAzure\Logs\AggregateStatusto see if there are any errors being reported when trying to apply patches for versions other than SQL Server 2019. - Mismatch in Cumulative Updates: There might be cases where certain KB (Knowledge Base) articles are not applicable to SQL Server 2022 yet. It’s essential to verify if the patches listed are compatible with your version.
Hope this helps, and let me know if you have further questions!
References