WSUS API console keeps crashing

Eaven HUANG 2,191 Reputation points
2022-04-08T03:31:43.06+00:00

Dear Experts,

Please help to check following errors and also screenshot where our WSUS server always crashes and I can't check the console by any chance.

Our IIS has no ram limit to WSUS application pool.

191130-wsus-connection-error.png

The WSUS administration console was unable to connect to the WSUS Server via the remote API.   
  
Verify that the Update Services service, IIS and SQL are running on the server. If the problem persists, try restarting IIS, SQL, and the Update Services Service.  
  
System.Net.WebException -- The operation has timed out  
  
Source  
System.Web.Services  
  
Stack Trace:  
   at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest request)  
   at Microsoft.UpdateServices.Internal.DatabaseAccess.ApiRemotingCompressionProxy.GetWebResponse(WebRequest webRequest)  
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)  
   at Microsoft.UpdateServices.Internal.ApiRemoting.ExecuteSPSearchUpdates(String updateScopeXml, String preferredCulture, Int32 publicationState)  
   at Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccessProxy.ExecuteSPSearchUpdates(String updateScopeXml, String preferredCulture, ExtendedPublicationState publicationState)  
   at Microsoft.UpdateServices.Internal.BaseApi.Update.SearchUpdates(UpdateScope searchScope, ExtendedPublicationState publicationState, UpdateServer updateServer)  
   at Microsoft.UpdateServices.UI.AdminApiAccess.UpdateManager.GetUpdates(ExtendedUpdateScope filter)  
   at Microsoft.UpdateServices.UI.AdminApiAccess.BulkUpdatePropertiesCache.GetAndCacheUpdates(ExtendedUpdateScope updateScope, ComputerTargetScope computerTargetScope)  
   at Microsoft.UpdateServices.UI.SnapIn.Pages.UpdatesListPage.GetListRows()  
Windows for business | Windows Server | User experience | Other
0 comments No comments
{count} votes

Accepted answer
  1. Rita Hu -MSFT 9,661 Reputation points
    2022-04-08T09:12:54.113+00:00

    @Eaven HUANG
    We could check the following registry value in the WSUS Server to confirm the type of the database we used.
    HKLM\Software\Microsoft\Update Services\Server\SetupSqlServerName
    SQL Server database:
    191249-13.png

    WID database:
    191277-14.png

    Reference link:
    https://learn.microsoft.com/de-de/security-updates/windowsupdateservices/18127574

    In addition, please try to follow the below link to maintenance if you haven't tried for a long time.
    https://learn.microsoft.com/en-us/troubleshoot/mem/configmgr/wsus-maintenance-guide#help-my-wsus-has-been-running-for-years-without-ever-having-maintenance-done-and-the-cleanup-wizard-keeps-timing-out

    Hope the above will be helpful.

    Have a great weekend.

    Regards,
    Rita


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.
    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Adam J. Marshall 10,356 Reputation points MVP
    2022-04-08T12:25:22.823+00:00

    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/

    If you don't do the maintenance, you WILL experience issues like what you're talking about. WSUS, like any application that uses a database, does need maintenance.

    You LIKELY have the WID, as that is the most common installation of WSUS (defaults).

    https://www.ajtek.ca/wsus/how-do-i-connect-to-the-windows-internal-database-wid/

    I'd recommend spending some time reading all of my guides relating to WSUS

    https://www.ajtek.ca/category/guides/wsus/

    2 people found this answer helpful.
    0 comments No comments

  2. Rita Hu -MSFT 9,661 Reputation points
    2022-04-08T05:44:15.51+00:00

    @Eaven HUANG
    Thanks for your getting support on this forum.

    Have you done any operations before the WSUS console crash? What is the type of your database? WID or SQL Server? Please try to open the SSMS as an administrator and check whether we could connect to the database.

    Best regards,
    Rita


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.