Azure IaaS Server with SQL - Automatic Updates

I noticed that some SQL servers were automatically restarting. After looking on the server, it looks like the settings show that the settings are set to automatically deploy updates:


Looking into the settings show that you may see the message "some settings are managed by your system administrator"

Looking deeper - I checked the registry settings and group policy and saw that they were not configured for automatic updates, additionally, the servers were not joined to the domain.

It appears that the SQL server from the Azure market place is set to automatically install updates Sunday at 2AM using the SQL Server IaaS Agent Extension.

To disable or change this, select the SQL server configuration setting and disable the automatic updates setting.




More information can be found here:
https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-automated-patching

Comments

Popular posts from this blog

VSTS error - PackageDeploymentFailed - using WebDeploy

Configuration Management with Salt Stack on Windows - Part 3 - Basic Configuration Management of Windows with Salt