locked
Unable to Open WSUS Admin Console RRS feed

  • Question

  • Today i just working on my WSUS server and ran cleanup wizard after that i just close WSUS console and trying to open console again but an SQL connectivity error occurred (See Screen Shot).

    However i restarted iis service , restart wsus server multiple times.

    All Event Logs attached here


    • Edited by Osama-Mansoor Saturday, June 11, 2016 7:31 AM hyperlink
    Saturday, June 11, 2016 7:28 AM

Answers

All replies

  • This WSUS server seems very unhealthy, problems started maybe 23/05/2016 and progressively worsened...

    Currently:
    Your WSUS service cannot connect to it's own database (SUSDB).

    Looking through the logs supplied, this seems to have been using WID (Windows Internal Database).

    Have you changed the database methods or storage?
    Is the WID (sqlservice) running/started correctly?

    Also note that this server seems to have several unplanned shutdowns (crashes?) in the last few days...

    The previous system shutdown at 1:23:22 AM on ‎6/‎8/‎2016 was unexpected.

    Also note there are many recurring file download/verification failures (these are mostly Win10 upgrades but there are also other failures for a long time)

    Content file download failed.
    Reason: File cert verification failure.
    Source File: /d/upgr/2016/03/10586.0.160212-2000.th2_refresh_clientprofessionalnvl_vol_x64fre_en-gb_8d583c41f44dae126fe31adb2cef75a0e648f8ea.esd
    Destination File: D:\wsus\WsusContent\EA\8D583C41F44DAE126FE31ADB2CEF75A0E648F8EA.esd

    Also note that WSUS self-health-checks began failing (Event 12072) 23/05/2016

    The WSUS content directory is not accessible.
    System.Net.WebException: The remote server returned an error: (500) Internal Server Error.
       at System.Net.HttpWebRequest.GetResponse()
       at Microsoft.UpdateServices.Internal.HealthMonitoring.HmtWebServices.CheckContentDirWebAccess(EventLoggingType type, HealthEventLogger logger)


    Don [doesn't work for MSFT, and they're probably glad about that ;]

    Saturday, June 11, 2016 8:47 AM
  • I just google and found this link issue resolved

    https://social.technet.microsoft.com/Forums/windowsserver/en-US/98db09ef-88d0-41dc-8674-9e64a0917347/wsus-down-after-yesterdays-patch-tuesday-updates?forum=winserverwsus

    Uninstalled : 3159706

    Saturday, June 11, 2016 9:28 AM
  • I just google and found this link issue resolved

    https://social.technet.microsoft.com/Forums/windowsserver/en-US/98db09ef-88d0-41dc-8674-9e64a0917347/wsus-down-after-yesterdays-patch-tuesday-updates?forum=winserverwsus

    Uninstalled : 3159706


    Uninstalling KB3159706 will not resolve all errors, and, will disable the ability to deploy Win10 upgrades.

    Don [doesn't work for MSFT, and they're probably glad about that ;]

    Saturday, June 11, 2016 11:05 AM
  • Yes your absolutely right i can't see Upgrades option in my WSUS console when i remove KB3159706 

    but what should i do for complete restoration and restore UPGRADES option in my WSUS console

    Sunday, June 12, 2016 6:48 AM
  • DonPick :

    yes you are correct servers restarted due to power failures and yes Windows 10 Upgrades are failure time to time (I just click on re-downloaded).

    and i have not make any changes with DB of WSUS

    Now what is your suggestions

    Should i newly installed WSUS on this WSUS life can be Safe

    Sunday, June 12, 2016 6:53 AM
  • Sunday, June 12, 2016 7:16 AM
  • for WS2012R2, ensure that the WSUS is correctly updated with all required Windows Updates;

    ensure (check "Installed Updates")

    - KB2919355 https://support.microsoft.com/en-au/kb/2919355
    - KB2938066 https://support.microsoft.com/en-au/kb/2938066
    - KB3095113 https://support.microsoft.com/en-us/kb/3095113
    (ensure to perform wsusutil postinstall)

    - KB3159706 https://support.microsoft.com/en-us/kb/3159706
    (ensure to perform wsusutil postinstall /servicing)

    Server Manager Add Roles and Features wizard
    -Add Feature
    --.NET Framework 4.5 Features
    ---WCF Services
    ----HTTP Activation (enable this)

    ** It's very important that you perform the manual configuration steps for this KB **

    Also note that if the Win10 Upgrades was incorrectly enabled before correct patches applied to WSUS, you may need to follow the steps in this article to resolve that problem:
    https://blogs.technet.microsoft.com/wsus/2016/01/29/how-to-delete-upgrades-in-wsus/


    Don [doesn't work for MSFT, and they're probably glad about that ;]


    Sunday, June 12, 2016 10:42 PM
  • Thanks DonPick,

    Now i am little confuse.

    Below KB are already Installed in my WSUS server.

     KB2919355 https://support.microsoft.com/en-au/kb/2919355
    - KB2938066 https://support.microsoft.com/en-au/kb/2938066

    Also performed 

    erver Manager Add Roles and Features wizard
    -Add Feature
    --.NET Framework 4.5 Features 
    ---WCF Services
    ----HTTP Activation (enable this)

    Now what should i do next

    Monday, June 13, 2016 4:43 AM
  • Thanks DonPick,

    Now i am little confuse.

    Below KB are already Installed in my WSUS server.

     KB2919355 https://support.microsoft.com/en-au/kb/2919355
    - KB2938066 https://support.microsoft.com/en-au/kb/2938066

    Also performed 

    erver Manager Add Roles and Features wizard
    -Add Feature
    --.NET Framework 4.5 Features 
    ---WCF Services
    ----HTTP Activation (enable this)

    Now what should i do next

    - install KB3095113 https://support.microsoft.com/en-us/kb/3095113
    (ensure to perform wsusutil postinstall)
    elevated CMD: "C:\Program Files\Update Services\Tools\wsusutil.exe" postinstall 

    - install KB3159706 https://support.microsoft.com/en-us/kb/3159706
    (ensure to perform wsusutil postinstall /servicing)
    elevated CMD: "C:\Program Files\Update Services\Tools\wsusutil.exe" postinstall /servicing

    Also note that if the Win10 Upgrades was incorrectly enabled before correct patches applied to WSUS, you may need to follow the steps in this article to resolve that problem:
    https://blogs.technet.microsoft.com/wsus/2016/01/29/how-to-delete-upgrades-in-wsus/


    Don [doesn't work for MSFT, and they're probably glad about that ;]


    • Edited by DonPick Monday, June 13, 2016 5:08 AM
    Monday, June 13, 2016 5:07 AM
  • Also note that if the Win10 Upgrades was incorrectly enabled before correct patches applied to WSUS, you may need to follow the steps in this article to resolve that problem:
    https://blogs.technet.microsoft.com/wsus/2016/01/29/how-to-delete-upgrades-in-wsus/

    Error in 

    $s.SearchUpdates(“version 1511, 10586”) | foreach { $s.DeleteUpdate($_.Id.UpdateId) } 

    Should i continue ?

    Monday, June 13, 2016 6:11 AM
  • have you previously approved/deployed the Win10 upgrades to any groups on your WSUS?

    Don [doesn't work for MSFT, and they're probably glad about that ;]

    Monday, June 13, 2016 6:22 AM
  • yes before issues in WSUS
    Monday, June 13, 2016 6:33 AM
  • should i continue with next commands?
    Monday, June 13, 2016 7:18 AM
  • decline all Win10 upgrades (this will address the problematic Approvals you have previously performed),

    then re-run the delete step again.

    then enable Upgrades

    then perform sync


    Don [doesn't work for MSFT, and they're probably glad about that ;]

    Monday, June 13, 2016 7:34 AM
  • Much thanks and appricated

    Above commands ran successfully

    I hope sync is on the way and takes times and i have to wait ? correct me if i am wrong

    Monday, June 13, 2016 8:57 AM
  • Yes, looks good, so far ;)

    Don [doesn't work for MSFT, and they're probably glad about that ;]

    Monday, June 13, 2016 9:13 PM
  • Hi Osama-Mansoor,

    Is the issue in your original post resolved? If yes, you may mark the useful replies as answer so that we can close this case. If not, what's going now, and I recall you have created another post about the related issue, which step are you on now?

    Best Regards,

    Anne


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

    Wednesday, June 15, 2016 5:52 AM