We Installed WSUS SP2 and Microsoft SQL 2008 R2 on Windows 2008 R2 64 bit server in Feb 2014, the server was fine till last week.
Now when we try to access the console, we got the below mentioned error. We have set Virus defnition updates for Auto approval and its is working fine , only thing is we cannot access the WSUS console.
I tried to reintall only WSUS Console but same error. please suggest.
Error:
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 -- 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.ExecuteSPGetComputersNotContactedSinceCount(DateTime fromDate)
at Microsoft.UpdateServices.UI.SnapIn.Pages.ServerSummaryPage.GetServerTasks(UpdateServerStatus serverStatus)
at Microsoft.UpdateServices.UI.SnapIn.Pages.ServerSummaryPage.RefreshTaskList(UpdateServerStatus status)
at Microsoft.UpdateServices.UI.SnapIn.Pages.ServerSummaryPage.backgroundWorker_RunWorkerCompleted(Object sender, RunWorkerCompletedEventArgs e)
