The WSUS database must be configured correctly to provide information storage and retrieval for updates, approvals, subscriptions, and events.
The WSUS database is not working properly.
First troubleshoot any SQL Server issues before continuing.
Verify that the WSUS database is in the SQL instance being used.
Open a command window
Type reg query "HKLM\SOFTWARE\Microsoft\Update Services\Server\Setup" /v SqlServerName
The output contains the SQL server name to be used in the next step.
Type osql -S "SqlServerName" -E -d SUSDB -Q
Review any error message and correct the problems.
Look for the corresponding error event.
Open a command window.
Type cd <WSUSInstallDir>\Tools
Type wsusutil checkhealth
Type eventvwr
Review the Application log for the most recent events from source Windows Server Update Services and event ID 11000.
Target | Microsoft.Windows.Server.UpdateServices.2012.R2.Server | ||
Parent Monitor | Microsoft.Windows.Server.UpdateServices.2012.R2.Server.DatabaseRollup | ||
Category | AvailabilityHealth | ||
Enabled | True | ||
Alert Generate | True | ||
Alert Severity | Error | ||
Alert Priority | Normal | ||
Alert Auto Resolve | True | ||
Monitor Type | Microsoft.Windows.2SingleEventLog2StateMonitorType | ||
Remotable | True | ||
Accessibility | Public | ||
Alert Message |
| ||
RunAs | Default |
<UnitMonitor ID="Microsoft.Windows.Server.UpdateServices.2012.R2.Server.DatabaseState" Accessibility="Public" Enabled="true" Target="Microsoft.Windows.Server.UpdateServices.2012.R2.Server" ParentMonitorID="Microsoft.Windows.Server.UpdateServices.2012.R2.Server.DatabaseRollup" Remotable="true" Priority="Normal" TypeID="Windows!Microsoft.Windows.2SingleEventLog2StateMonitorType" ConfirmDelivery="false">
<Category>AvailabilityHealth</Category>
<AlertSettings AlertMessage="Microsoft.Windows.Server.UpdateServices.2012.R2.Server.DatabaseState.AlertMessage">
<AlertOnState>Error</AlertOnState>
<AutoResolve>true</AutoResolve>
<AlertPriority>Normal</AlertPriority>
<AlertSeverity>Error</AlertSeverity>
</AlertSettings>
<OperationalStates>
<OperationalState ID="DBNotOk" MonitorTypeStateID="FirstEventRaised" HealthState="Error"/>
<OperationalState ID="DBOK" MonitorTypeStateID="SecondEventRaised" HealthState="Success"/>
</OperationalStates>
<Configuration>
<FirstComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</FirstComputerName>
<FirstLogName>Application</FirstLogName>
<FirstExpression>
<And>
<Expression>
<SimpleExpression>
<ValueExpression>
<XPathQuery>PublisherName</XPathQuery>
</ValueExpression>
<Operator>Equal</Operator>
<ValueExpression>
<Value>Windows Server Update Services</Value>
</ValueExpression>
</SimpleExpression>
</Expression>
<Expression>
<SimpleExpression>
<ValueExpression>
<XPathQuery>EventDisplayNumber</XPathQuery>
</ValueExpression>
<Operator>Equal</Operator>
<ValueExpression>
<Value>11002</Value>
</ValueExpression>
</SimpleExpression>
</Expression>
</And>
</FirstExpression>
<SecondComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</SecondComputerName>
<SecondLogName>Application</SecondLogName>
<SecondExpression>
<And>
<Expression>
<SimpleExpression>
<ValueExpression>
<XPathQuery>PublisherName</XPathQuery>
</ValueExpression>
<Operator>Equal</Operator>
<ValueExpression>
<Value>Windows Server Update Services</Value>
</ValueExpression>
</SimpleExpression>
</Expression>
<Expression>
<RegExExpression>
<ValueExpression>
<XPathQuery>EventDisplayNumber</XPathQuery>
</ValueExpression>
<Operator>MatchesRegularExpression</Operator>
<Pattern>^(11000|501|10000)$</Pattern>
</RegExExpression>
</Expression>
</And>
</SecondExpression>
</Configuration>
</UnitMonitor>