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