監視資料存取服務的資料庫連線。
資料存取服務無法連線至 Operations Manager 資料庫。若資料存取服務未執行,使用者將無法使用 Operations 主控台、Web 主控台或命令殼層。任何連接第三方管理系統的連接器也會無法運作。
Operations Manager 資料庫伺服器離線或無法連線。
Operations Manager 資料庫離線或已卸離。
資料存取服務沒有足夠權限連線至資料庫。
檢查安裝 Operations Manager 資料庫的資料庫伺服器,確認其已連線,且 Operations Manager 資料庫也已連線。
確認可以從安裝資料存取服務的伺服器連線到資料庫伺服器。
確認 SQL 伺服器接受使用 SQL Server 組態管理員的遠端連線。
確認資料存取服務使用的帳戶有足夠的權限存取 Operations Manager 資料庫。
Target | Microsoft.SystemCenter.RootManagementServer | ||
Parent Monitor | Microsoft.SystemCenter.SDKService.AvailabilityHealthRollup | ||
Category | StateCollection | ||
Enabled | False | ||
Alert Generate | True | ||
Alert Severity | Error | ||
Alert Priority | High | ||
Alert Auto Resolve | True | ||
Monitor Type | Microsoft.Windows.2SingleEventLog2StateMonitorType | ||
Remotable | True | ||
Accessibility | Internal | ||
Alert Message |
| ||
RunAs | Default |
<UnitMonitor ID="Microsoft.SystemCenter.SDKService.DatabaseConnectivity" Accessibility="Internal" Enabled="false" Target="SCLibrary!Microsoft.SystemCenter.RootManagementServer" ParentMonitorID="SCLibrary!Microsoft.SystemCenter.SDKService.AvailabilityHealthRollup" Remotable="true" Priority="Normal" TypeID="Windows!Microsoft.Windows.2SingleEventLog2StateMonitorType" ConfirmDelivery="true">
<Category>StateCollection</Category>
<AlertSettings AlertMessage="Microsoft.SystemCenter.SDKService.DatabaseConnectivity.AlertMessage">
<AlertOnState>Error</AlertOnState>
<AutoResolve>true</AutoResolve>
<AlertPriority>High</AlertPriority>
<AlertSeverity>Error</AlertSeverity>
</AlertSettings>
<OperationalStates>
<OperationalState ID="DatabaseConnectivityLost" MonitorTypeStateID="FirstEventRaised" HealthState="Error"/>
<OperationalState ID="DatabaseConnectivityEstablished" MonitorTypeStateID="SecondEventRaised" HealthState="Success"/>
</OperationalStates>
<Configuration>
<FirstComputerName>.</FirstComputerName>
<FirstLogName>Operations Manager</FirstLogName>
<FirstExpression>
<And>
<Expression>
<SimpleExpression>
<ValueExpression>
<XPathQuery Type="Integer">EventDisplayNumber</XPathQuery>
</ValueExpression>
<Operator>Equal</Operator>
<ValueExpression>
<Value Type="Integer">26330</Value>
</ValueExpression>
</SimpleExpression>
</Expression>
<Expression>
<SimpleExpression>
<ValueExpression>
<XPathQuery Type="String">PublisherName</XPathQuery>
</ValueExpression>
<Operator>Equal</Operator>
<ValueExpression>
<Value Type="String">OpsMgr SDK Service</Value>
</ValueExpression>
</SimpleExpression>
</Expression>
</And>
</FirstExpression>
<SecondComputerName>.</SecondComputerName>
<SecondLogName>Operations Manager</SecondLogName>
<SecondExpression>
<And>
<Expression>
<SimpleExpression>
<ValueExpression>
<XPathQuery Type="Integer">EventDisplayNumber</XPathQuery>
</ValueExpression>
<Operator>Equal</Operator>
<ValueExpression>
<Value Type="Integer">26331</Value>
</ValueExpression>
</SimpleExpression>
</Expression>
<Expression>
<SimpleExpression>
<ValueExpression>
<XPathQuery Type="String">PublisherName</XPathQuery>
</ValueExpression>
<Operator>Equal</Operator>
<ValueExpression>
<Value Type="String">OpsMgr SDK Service</Value>
</ValueExpression>
</SimpleExpression>
</Expression>
</And>
</SecondExpression>
</Configuration>
</UnitMonitor>