å°è¯•æ‰§è¡Œ SQL 属性å˜å‚¨æŸ¥è¯¢æ—¶å‡ºçŽ°é”™è¯¯ã€‚
如果在 15 分钟之内没有å†æ¬¡å‘生åŒæ ·çš„问题,æ¤ç›‘视器的è¿è¡ŒçŠ¶å†µçŠ¶æ€å°†å˜å›žç»¿è‰²çŠ¶æ€ã€‚è¦æŠ¥è§„则生æˆç›¸åº”çš„è¦æŠ¥å¿…须手动解除。
访问é…置的基于 SQL 的属性å˜å‚¨å¤±è´¥ã€‚
检查éšæ¤äº‹ä»¶æ供的异常详细信æ¯ï¼Œç¡®å®šä¸€ä¸ªè¿˜æ˜¯å¤šä¸ªä»¥ä¸‹æ“作适用:
éªŒè¯ SQL 属性å˜å‚¨çš„连接å—符串是å¦æœ‰æ•ˆã€‚
ç¡®ä¿è¿žæŽ¥å—符串å¯ä»¥è¿žæŽ¥åˆ° SQL 属性å˜å‚¨ï¼Œå¹¶ä¸” SQL 属性å˜å‚¨å˜åœ¨ã€‚å¦‚æžœä½ ä½¿ç”¨çš„æ˜¯è‡ªå®šä¹‰å±žæ€§å˜å‚¨ï¼Œåˆ™éªŒè¯æ¤è‡ªå®šä¹‰å±žæ€§å˜å‚¨æ˜¯å¦å·²é€šè¿‡ AD FS 管ç†å•å…ƒæ£ç¡®é…置。æ¤å¤–,验è¯è‡ªå®šä¹‰å±žæ€§å˜å‚¨ç¨‹åºé›†æ˜¯å¦å¯ä»¥è¿›è¡Œè®¿é—®ã€‚
éªŒè¯ SQL 查询和å‚数是å¦æœ‰æ•ˆã€‚
Target | Microsoft.ActiveDirectoryFederationServices.2016.TokenIssuance |
Parent Monitor | System.Health.ConfigurationState |
Category | ConfigurationHealth |
Enabled | True |
Alert Generate | False |
Alert Auto Resolve | True |
Monitor Type | Microsoft.Windows.SingleEventLogTimer2StateMonitorType |
Remotable | True |
Accessibility | Public |
RunAs | Default |
<UnitMonitor ID="Microsoft.ActiveDirectoryFederationServices.2016.TokenIssuanceSqlAttributeStoreQueryExecutionErrorMonitor" Accessibility="Public" Enabled="true" Target="Microsoft.ActiveDirectoryFederationServices.2016.TokenIssuance" ParentMonitorID="Health!System.Health.ConfigurationState" Remotable="true" Priority="Normal" TypeID="Windows!Microsoft.Windows.SingleEventLogTimer2StateMonitorType" ConfirmDelivery="true">
<Category>ConfigurationHealth</Category>
<OperationalStates>
<OperationalState ID="EventRaised" MonitorTypeStateID="EventRaised" HealthState="Warning"/>
<OperationalState ID="TimerEventRaised" MonitorTypeStateID="TimerEventRaised" HealthState="Success"/>
</OperationalStates>
<Configuration>
<ComputerName>$Target/Host/Host/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>
<LogName>$Target/Host/Host/Property[Type="Microsoft.ActiveDirectoryFederationServices.2016.FederationServer"]/ADFSEventLog$</LogName>
<Expression>
<And>
<Expression>
<SimpleExpression>
<ValueExpression>
<XPathQuery Type="UnsignedInteger">EventDisplayNumber</XPathQuery>
</ValueExpression>
<Operator>Equal</Operator>
<ValueExpression>
<Value Type="UnsignedInteger">376</Value>
</ValueExpression>
</SimpleExpression>
</Expression>
<Expression>
<RegExExpression>
<ValueExpression>
<XPathQuery Type="String">PublisherName</XPathQuery>
</ValueExpression>
<Operator>MatchesMOM2005RegularExpression</Operator>
<Pattern>(^AD FS$)</Pattern>
</RegExExpression>
</Expression>
</And>
</Expression>
<TimerWaitInSeconds>900</TimerWaitInSeconds>
</Configuration>
</UnitMonitor>