I am receiving an error on one of our WSUS downstream servers "Windows Server 2008 R2 Foundation," but all other WSUS downstream servers are not having this issue.
When I do a manual synchronization of WSUS from our clients server to our main WSUS server I receive the following error:
Synchronization Error Detail
An error occurred with the server's data store
SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
at Microsoft.UpdateServices.DatabaseAccess.DBConnection.DrainObsoleteConnections(SqlException e)
at Microsoft.UpdateServices.Internal.DataAccess.HideUpdatesForReplicaSync(String xmlUpdateIds)
at Microsoft.UpdateServices.ServerSync.CatalogSyncAgentCore.ProcessHiddenUpdates(Guid hiddenUpdates)
at Microsoft.UpdateServices.ServerSync.CatalogSyncAgentCore.ExecuteSyncProtocol(Boolean allowRedirect)
Also, I receive an event log error 10022 for Windows Server Update Services saying:
The last catalog synchronization attemp was unsuccessful.
Finally, when going into WSUS and bringing up reports on specific pc's WSUS will crash or stay stuck on generating report.
Any help will be thankful.