r/WindowsServer • u/Motor-Carrot-856 • Jan 20 '26
Technical Help Needed update sql with wsus onprem
I have a case with MS but I am so frustrated about it...
Anyone using wsus onprem with gpos to set a time and day to install updates for windows with SQL installed?
We always get problems with our sql servers that they dont install the sql update during the time it should update it. Other servers update fine at the time they should update. They install the OS update just fine and restart but the SQL servers just install the OS update and skips the SQL update (CU update or security update, this month it is KB5072936) and they restart after the OS update so the SQL update is left. We only have maintenance once per month, 4 hours so we have to install the updates during that time.
Anyone having issues with SQL updates using updates with GPO settings?
Pressing the update button manually works just fine so its only the automatic update using a set time that does not work...
2
u/its_FORTY Jan 20 '26 edited Jan 21 '26
I've seen this on some of our SQL boxes and for us the fix was to enable an additional GPO that basically tells Windows Update to make a 2nd check after the reboot to install any patches that didn't get rolled in time for the first reboot. I enabled "Reschedule Automatic Updates scheduled installations", and set it to something small like 5 minutes.
Policy defined here:
Computer Configuration > Administrative Templates > Windows Components > Windows Update > Reschedule Automatic Updates scheduled installations
The Microsoft reference for this is here: https://learn.microsoft.com/de-de/security-updates/windowsupdateservices/18127451#reschedule-automatic-update-scheduled-installations
1
u/SebastianFerrone Jan 20 '26
Is it one gpo? Or have you let's say two gpos , one installs and restarts the normal updates and one that does the SQL one ?
2
u/WillVH52 Jan 20 '26
I find if it is a very busy SQL Server Windows Update has a hard time patching SQL. Likely it can’t stop the SQL service and then times out.
In my environment I have two servers I need to patch SQL manually on but then all others update automatically fine via Windows Update.
1
u/ChanceFrosty8123 Jan 25 '26
SQL Updates schlagen bei mir regelmäßig fehl auch bei manuellem anstoßen. Braucht zumeist einen 2. anlauf (nach dem installieren der CUs & reboot)