I have scheduled windows updates for Sundays at 5 AM but last Sunday it didn't install and restart. This server run SQL Server. Would that prevent it from running automatically? Is there a way for this to happen automatically? Thanks!

I have not understood what you cant to perform exactly. For SQL questions, post in the SQL forums: http://social.msdn.microsoft.com/Forums/en-US/categories This posting is provided "AS IS" with no warranties or guarantees , and confers no rights. Microsoft Student Partner Microsoft Certified Professional Microsoft Certified Systems Administrator: Security Microsoft Certified Systems Engineer: Security Microsoft Certified Technology Specialist: Windows Server 2008 Active Directory, Configuration Microsoft Certified Technology Specialist: Windows Server 2008 Network Infrastructure, Configuration

I just have automatic updates scheduled on this server. But it didn't install them automatically last Sunday. Is there a good way to find out why they didn't install?

Check event viewer logs. This posting is provided "AS IS" with no warranties or guarantees , and confers no rights. Microsoft Student Partner Microsoft Certified Professional Microsoft Certified Systems Administrator: Security Microsoft Certified Systems Engineer: Security Microsoft Certified Technology Specialist: Windows Server 2008 Active Directory, Configuration Microsoft Certified Technology Specialist: Windows Server 2008 Network Infrastructure, Configuration

Any update?

Have you confirmed that there were even any outstanding updates due to be installed? Eg if there were no new updates since it presumably ran the previous Sunday? Other than checking the event logs, have you checked the c:\windows\windowsupdate.log to see if there are any errors displayed in there that might explain what's happening? Apart from anything else that log should give you an indicatation of whether the server thought there were any updates outstanding. As for SQL Server, no I've got several SQL installs on different versions and all those that are setup for automatic installation and scheduled reboot do so just like the other servers.

I guess I wasn't clear enough in my explanation. The updates install but the server does not reboot. When I login to the server it wants to reboot. Is there anyway to have it reboot after installing the updates?

Change in registry to enable the auto restart after install updates Open up regedit.exe through the start menu search box or run dialog, and navigate down to the following key, creating new keys if they don’t exist. [HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\WindowsUpdate\AU] NoAutoRebootWithLoggedOnUsers=- Create a new 32-bit DWORD value named NoAutoRebootWithLoggedOnUsers to enable automatic reboot while users are logged on. Delete the value to put things back to the way they were. Cheers :)