WSUS - Windows Server Update Services Event ID 7042

Ty412 1 Reputation point
2020-08-21T19:42:42.507+00:00

I've searched TechNet threads about this issue but came up short with all resolutions that everyone suggested. I keep receiving the message below which is causing my Console to crash. I've removed old workstations, ran the utility reset, restarted SQL but the issues occurs. Has anyone seen this before? The server is a Windows 2012 R2 standard server. Nothing has changed for weeks. Issue just started out of nowhere.

"The WSUS administration console was unable to connect to the WSUS Server Database.

Verify that SQL server is running on the WSUS Server. If the problem persists, try restarting SQL.

System.Data.SqlClient.SqlException -- Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Source
.Net SqlClient Data Provider
Stack Trace:
at Microsoft.UpdateServices.Internal.BaseApi.SoapExceptionProcessor.DeserializeAndThrow(SoapException soapException)
at Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccessProxy.ExecuteSPGetComputerCount(String computerTargetScopeXml)
at Microsoft.UpdateServices.UI.AdminApiAccess.AdminApiTools.ConvertToUpdateScope(ExtendedUpdateScope extendedUpdateScope)
at Microsoft.UpdateServices.UI.SnapIn.Pages.UpdatesSummaryPage.GetStatusChart(UpdateListScope scope)
at Microsoft.UpdateServices.UI.SnapIn.Pages.UpdatesSummaryPage.GetScopeStatusCharts()
at Microsoft.UpdateServices.UI.SnapIn.Pages.UpdatesSummaryPage.backgroundWorker_DoWork(Object sender, DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)"

Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
8,239 questions
No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Adam J. Marshall 5,666 Reputation points Microsoft MVP
    2020-08-21T20:03:36.56+00:00

    Have you got your application memory pool setup properly? Your vCPUs set appropriately (if it's on a VM)

    https://www.ajtek.ca/wsus/wsus-system-requirements-what-should-i-plan-for/

    Are you performing the proper WSUS maintenance including but not limited to running the Server Cleanup Wizard (SCW), declining superseded updates, running the SQL Indexing script, etc.?

    https://www.ajtek.ca/wsus/how-to-setup-manage-and-maintain-wsus-part-8-wsus-server-maintenance/


  2. Rita Hu -MSFT 9,401 Reputation points
    2020-08-24T02:19:10.21+00:00

    Hi Ty412-5469,

    Thanks for your posting on this forum.

    1. Please help to confirm whether the WSUS Server installed the latest updates.
    2. We could try the following steps to see whether this issue will be resolved:
      Open CMD as an administrator and navigate to the wsusutil.exe tool(Location: C:\Program Files\Update Services\Tools).
      Then we could enter wsusutil.exe postinstall/servicing

    Regards,
    Rita


    If the response is helpful, please click "Accept Answer" and upvote it.

    No comments

  3. wilmpohlcat 1 Reputation point
    2021-12-09T21:09:38.207+00:00

    I am having this problem when running the cleanup wizard. We run the wizard every month before we patch servers. 4/5 run fine, only "Unused updates and update revisions" , the first option, makes the mmc time out.
    previously we made the iis recycle setting.
    while on WID I ran all the recommended scripts for defrag, indexing, removing duplicates, shrink, etc...
    Deleted the update storage folder contents
    moved DB to a sql 2016 box - Our DBA assures me there is no corruption or any issues with the integrity of the DB
    rebuilt the app server, reset iis recycle from 18xxxxx to 10000000 to 0 for unlimited.
    VM, dual proc (3.2 xeon on hosts) 16 GB of mem.
    nothing has worked. any suggestions??