Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I have a scenario where an SQL Server update makes an app fail.

I would like to disable SQL Server updates. I don't want to disable all other Updates. I would like to keep Windows Update.

Is there any way to do this?

These machines aren't in a domain and cannot use WSUS.

share|improve this question
    
What version of SQL Server? –  mrdenny May 11 '12 at 5:59
    
2008 R2, it fails with the update KB2494088 –  Ricardo Polo May 11 '12 at 6:11
1  
You know you can have non-domain machines use WSUS, right ? –  Stephane May 11 '12 at 7:28
    
If the OS is Server 2008 R2 why did you use the windows-7 tag? Please ensure you use appropriate tags in future. –  John Gardeniers May 11 '12 at 12:42

1 Answer 1

Microsoft/Windows Update gives you the ability to exclude specific updates from being offered / installed. Just opening the update notification window, unticking the update and selecting "Do not show this update again".

Of course, getting an update list in the WU notification dialog would require having the updates either set to "notify", hit the notification window before the updates are actually installed, or trigger the update detection manually through the WU client GUI.

Edit: There is no way to disable a specific product's updates, but you might choose to disable automatic updates for any Microsoft products apart from the OS itself by unticking this checkbox:

Windows Update Settings

share|improve this answer
    
And how could i configure this for 10.000 machines? Any registry key? Any command? Thank you @syneticon-dj –  Ricardo Polo May 14 '12 at 18:17
    
@RicardoPolo You have 10,000 machines running SQL server? And you are not using SCCM or at least WSUS to deploy updates? For disabling MS update, consider trying the removal of the HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\Services\7971f918-a‌​847-4430-9279-4a52d1efe18d key and restarting wuauserv - I have not tested it, but the documentation suggests it might work out. –  the-wabbit May 15 '12 at 7:12
    
If you have 10K in machines or even 10 for that matter. Consider using and setting up Windows Update Service. Its included with server r2 for free. Pretty easy setup. –  Sarge Jan 7 '13 at 13:05

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.