WSUS ERROR:Connection Error

EDP Team 51 Reputation points
2022-12-26T10:35:08.05+00:00

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

274016-screenshot-2022-12-26-at-35658-pm.png273997-screenshot-2022-12-26-at-35410-pm.png
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()

Internet Information Services
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,394 questions
0 comments No comments
{count} votes

Accepted answer
  1. CherryZhang-MSFT 6,481 Reputation points
    2023-01-11T05:33:04.8066667+00:00

    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

     

    2 people found this answer helpful.
    0 comments No comments

5 additional answers

Sort by: Most helpful
  1. Adam J. Marshall 9,041 Reputation points MVP
    2022-12-26T16:08:59.68+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/

    2 people found this answer helpful.
    0 comments No comments

  2. EDP Team 51 Reputation points
    2023-01-06T16:03:38.687+00:00

    CherryZhang-MSFT,

    I tried all of the steps listed above, but the problem persisted.
    During that time, the wsus console was launched after restarting the wsus.

    But the problem started when I changed the unapproved page; it was loading and hanging, and then it reset the server node page appears

    Is there any powershell script that can reject all unapproved updates?

    2 people found this answer helpful.
    0 comments No comments

  3. EDP Team 51 Reputation points
    2023-01-10T12:05:03.587+00:00

    CherryZhang-MSFT

    My WSUS is now fully operational.

    Thank you for your input, but the above-mentioned solution did not work for me.

    I tried the following steps:

    1. Disable the WSUSPool service in IIS.
    2. Installed SSMS
    3. Connected the WSUS Database in SSMS using the server name listed below

    \.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

    1. Examine the SUSDB Disk usage
    2. where Unused space reveals very little space 6.Then I 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 my WSUSconsole, then navigate to the unapproved page and manually decline all 70K patches from the console.

    That's all 277904-error.jpg277931-wsus-new-dashboard.jpg277869-optimized-db.jpg277941-wsusdb.jpg

    2 people found this answer helpful.
    0 comments No comments

  4. CherryZhang-MSFT 6,481 Reputation points
    2022-12-27T06:25:33.537+00:00

    Hi @EDP Team ,

    I have also down some research on this issue. There are many people who have encountered such problems and this problem may be caused by various reasons. Here are some solutions for your reference.

    1, I found a similar thread that many users solved the problem with this method. The following steps are for your reference:
    1)Open the IIS Manager on your PC using the search bar.

    2) Navigate to the Application Pools option in the Connections list.

    3) Select the WsusPool service in the list and click on the Recycling… option in the Actions pane.

    Note: Alternatively, you can right-click on the WsusPool service, click on the Advanced Settings… option, and set the memory limit to 0 to increase the limit to infinity value or increase the Private Memory Limit to the value you want.

    4) Untick the option Private memory usage (in KB) in the Memory Based Maximums section and click on the Next button.

    5) Ensure that the Regular time intervals option is selected in the Configure recycling events section and click on the Finish button.

    6) Right-click on the WsusPool item in the Application Pools page and click on the Start option in the drop-down menu.

    7) Restart the WSUS console using the steps explained earlier.

    The following link for your reference:
    The WSUS administration console was unable to connect to the WSUS Server via the remote API. (kb3159706) (microsoft.com)
    How to Resolve Wsus Server Connection Error | Fix: WSUS Connection Error Reset
    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.

    2, Besides, about how to Fix WSUS Administration Console Unable to Connect WSUS Server via Remote API, this link provides some solutions for your reference:
    https://techcult.com/fix-wsus-administration-console-unable-to-connect-wsus-server-via-remote-api/
    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.

    Looking forward to your feedback.

    Best regards
    Cherry

    1 person found this answer helpful.