locked
Windows Updates and SQL Server CU's, If you install Automatically How do you do it? RRS feed

  • Question

  • Good Morning!

             So our System Admins have setup OU's that have windows updates pushed once a month, so for example, there is a folder 1st Tuesday 6am, and at 6am it installs all patches that have been approved.  (dev servers get them on the 3rd tuesday of the month, to catch all new security patches from patch tuesday before they are applied in production)  However with SQL Server CU's we are noticing that they will not install if the flag is set that states the server needs to reboot.  And it seems OS updates always apply first and proceed to set the flag, so the SQL CU's are failing pretty much every month that an OS patch sets that flag.  Then the next month comes, there are more OS patches which apply first and again set that reg entry and again the SQL Server CU from the previous month (or the one that replaced it) fails again.  System admins say there isn't much they can do about that, so we are just curious how other organizations handle this kind of process, and they also told us SQL Server CU's can not be excluded as the "CU" class encompasses all microsoft products.  Any input is appreciated!

    Thanks

    Jay

    Tuesday, June 5, 2018 3:31 PM

Answers

  • Hi Jason Spatz,

    Some details have to be confirmed as follows for a better assistance.

    1.The mentioned "failing pretty much every month" means failing to install or failing to detect?
    2.The version of your OS and SQL.
    3.The KB numbers of CU.

    For your concern, we recommend you to enable the option "No auto-restart with logged on users for scheduled automatic updates installations" in your GPO settings to stop the server's reboot. Then have a check whether SQL Server CU is installed.

    Hope this helps.

    Best regards,
    Li Jianjie

    Please remember to mark the replies as answers if they help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com


    • Edited by Li Jianjie Wednesday, June 6, 2018 6:52 AM
    • Marked as answer by Jason Spatz Monday, June 11, 2018 1:33 PM
    Wednesday, June 6, 2018 6:50 AM

All replies

  • Hi Jason Spatz,

    Some details have to be confirmed as follows for a better assistance.

    1.The mentioned "failing pretty much every month" means failing to install or failing to detect?
    2.The version of your OS and SQL.
    3.The KB numbers of CU.

    For your concern, we recommend you to enable the option "No auto-restart with logged on users for scheduled automatic updates installations" in your GPO settings to stop the server's reboot. Then have a check whether SQL Server CU is installed.

    Hope this helps.

    Best regards,
    Li Jianjie

    Please remember to mark the replies as answers if they help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com


    • Edited by Li Jianjie Wednesday, June 6, 2018 6:52 AM
    • Marked as answer by Jason Spatz Monday, June 11, 2018 1:33 PM
    Wednesday, June 6, 2018 6:50 AM
  • Hi Jay,

    We wonder whether your issue has been resolved. 

    If it has, I would appreciate if you could mark my replies as answer if they help and post your solutions to share with others having the same problem.

    If it has not, please feel free to contact us for further assistance.
    Thanks.

    Best regards,
    Li Jianjie

    Please remember to mark the replies as answers if they help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com



    • Edited by Li Jianjie Monday, June 11, 2018 7:51 AM
    Monday, June 11, 2018 7:50 AM