授權管理員 Hotfix

Microsoft.ServiceManager.SDKService.AzManDatabaseConnectivity (UnitMonitor)

若未取得授權管理員 Hotfix,授權管理員與 SQL 之間的連線將會中斷。

Knowledge Base article:

摘要

當您嘗試存取儲存在授權管理員中的授權規則時,使用授權儲存區的 AzMan API 傳回 ERROR_ACCESS_DENIED 錯誤。例如,在授權管理員物件上叫用 UpdateCache 或 Submit 方法時,可能會傳回此錯誤。 當授權管理員和 SQL Server 資料庫之間的連線中斷時,現有的 API 仍會失敗。不過,在建立新連線後下一個 AzMan API 呼叫將會成功。

原因

解決方式

Element properties:

TargetMicrosoft.SystemCenter.ServiceManager.ManagementServer
Parent MonitorMicrosoft.ServiceManager.SDKService.AvailabilityHealthRollup
CategoryStateCollection
EnabledTrue
Alert GenerateTrue
Alert SeverityError
Alert PriorityHigh
Alert Auto ResolveTrue
Monitor TypeMicrosoft.Windows.2SingleEventLog2StateMonitorType
RemotableTrue
AccessibilityPublic
Alert Message
AzMan 資料庫連線已中斷
AzMan 與資料庫的連線已中斷。
RunAsDefault

Source Code:

<UnitMonitor ID="Microsoft.ServiceManager.SDKService.AzManDatabaseConnectivity" Accessibility="Public" Enabled="true" Target="SM!Microsoft.SystemCenter.ServiceManager.ManagementServer" ParentMonitorID="Microsoft.ServiceManager.SDKService.AvailabilityHealthRollup" Remotable="true" Priority="Normal" TypeID="Windows!Microsoft.Windows.2SingleEventLog2StateMonitorType" ConfirmDelivery="true">
<Category>StateCollection</Category>
<AlertSettings AlertMessage="Microsoft.ServiceManager.SDKService.AzManDatabaseConnectivity.AlertMessage">
<AlertOnState>Error</AlertOnState>
<AutoResolve>true</AutoResolve>
<AlertPriority>High</AlertPriority>
<AlertSeverity>Error</AlertSeverity>
</AlertSettings>
<OperationalStates>
<OperationalState ID="AzManDatabaseConnectivityLost" MonitorTypeStateID="FirstEventRaised" HealthState="Error"/>
<OperationalState ID="AzManDatabaseConnectivityEstablished" MonitorTypeStateID="SecondEventRaised" HealthState="Success"/>
</OperationalStates>
<Configuration>
<FirstComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</FirstComputerName>
<FirstLogName>Operations Manager</FirstLogName>
<FirstExpression>
<And>
<Expression>
<SimpleExpression>
<ValueExpression>
<XPathQuery Type="Integer">EventDisplayNumber</XPathQuery>
</ValueExpression>
<Operator>Equal</Operator>
<ValueExpression>
<Value Type="Integer">26340</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>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</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>