Wednesday, December 20, 2017

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:

No comments:

Post a Comment

TIP 0005: Test bad SSL

This is a tool for testing "memorable site for testing clients against bad SSL configs"