WSUS ERROR:Connection Error

Question

Recently, my Windows 10 updates were not properly synchronised on my WSUS, so I manually synchronised my Windows 10 patches.

However, after a few hours, I discovered that nearly 70k new patches had been synced in my wsus unapproved page.

After that, when I switched to an unapproved page, it would freeze and hang, followed by an error message.

See the attached image

Error : Connection Error

An error occurred trying to connect the WSUS server. This error happens for a number of reasons

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()

Answer 1

Hi @EDP Team ,

 

Thanks for your feedback and sharing. We're glad that the question is fixed now. Here's a short summary for the problem, we believe this will help other users to search for useful information more quickly. It's appreciated that you could click "Accept Answer" to the reply.

Problem/Symptom:
WSUS ERROR: Connection Error when switched to unapproved page.

Solution/Workaround:

1. Disable the WSUSPool service in IIS.
2. Installed SSMS
3. Connected the WSUS Database in SSMS using the server’s name listed below: .\pipe\MSSQL$MICROSOFT##SSEE\sql\query
4. Examine the SUSDB Disk usage.
5. Where Unused space reveals very little space
6. Downloaded WsusDBMaintenance.sql and followed the instructions from the link below.

https://www.urtech.ca/2016/10/solved-how-to-clean-up-and-repair-wsus/

1. The query will take 30 minutes to complete.
2. Restarted the WSUS Application service in IIS.
3. Start WSUSconsole, then navigate to the unapproved page and manually decline all 70K patches from the console.

Thanks again for your time! Have a nice day!

Best regards,
Cherry

 

Answer 2

Hi @EDP Team ,

According to the screenshot your provided, the number of unapproved updates has reached more than 70,000. As AJTek-Adam-J-Marshall mentioned, have you performed proper WSUS maintenance? For example, Server Cleanup Wizard (SCW), declining superseded updates, running the SQL Indexing script, etc.

For more information about WSUS maintenance, we can refer to following links:
How to Setup, Manage, and Maintain WSUS: Part 8 - WSUS Server Maintenance - AJ Tek Corporation
Note: Microsoft provides third-party contact information to help you understand the problem. This contact information may change without notice. Microsoft does not guarantee the accuracy of this third-party contact information.

Windows Server Update Services (WSUS) maintenance guide for Configuration Manager - Configuration Manager | Microsoft Learn

Looking forward to your feedback.

Best regards,
Cherry

---

If the response is helpful, please click "Accept Answer" and upvote it.
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.