æ¤ç›£è¦–器指出 Federation Service ç„¡æ³•å‘ SQL 資料庫註冊通知。如果 15 分é˜å…§æ²’有å†æ¬¡ç™¼ç”Ÿç›¸åŒå•é¡Œï¼Œæ¤ç›£è¦–器的å¥å…¨ç‹€æ³ç‹€æ…‹æœƒè®Šå›žç¶ 色狀態。æ¤ç›£è¦–器產生的è¦ç¤ºå¿…é ˆæ‰‹å‹•è§£æ±ºã€‚
AdfsConfiguration 資料庫已åœç”¨ SQL Server æœå‹™ä»£ç†äººï¼Œæˆ–是 SQL Server éŽæ–¼å¿™ç¢Œã€‚
æ¤äº‹ä»¶çš„å¯èƒ½è§£æ±ºæ–¹å¼å¦‚下:
é€éŽåœ¨åŸ·è¡Œ SQL Server 的目標電腦上執行下列 SQL 查詢,確èªå·²å•Ÿç”¨ Service Broker:SELECT is_broker_enabled FROM sys.databases WHERE name = 'AdfsConfiguration'
如果未啟用 Service Broker,請在執行 SQL Server 的目標電腦上,執行下列 SQL 指令碼:ALTER DATABASE AdfsConfiguration SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE
如果已啟用 Service Broker,請考慮é‡æ–°å•Ÿå‹•åŒç›Ÿæœå‹™ã€‚
Target | Microsoft.ActiveDirectoryFederationServices.2016.FederationServer | ||
Parent Monitor | System.Health.ConfigurationState | ||
Category | ConfigurationHealth | ||
Enabled | True | ||
Alert Generate | True | ||
Alert Severity | Warning | ||
Alert Priority | Normal | ||
Alert Auto Resolve | True | ||
Monitor Type | Microsoft.Windows.SingleEventLogTimer2StateMonitorType | ||
Remotable | True | ||
Accessibility | Public | ||
Alert Message |
| ||
RunAs | Default |
<UnitMonitor ID="Microsoft.ActiveDirectoryFederationServices.2016.FederationServerSqlNotificationRegistrationErrorMonitor" Accessibility="Public" Enabled="true" Target="Microsoft.ActiveDirectoryFederationServices.2016.FederationServer" ParentMonitorID="Health!System.Health.ConfigurationState" Remotable="true" Priority="Normal" TypeID="Windows!Microsoft.Windows.SingleEventLogTimer2StateMonitorType" ConfirmDelivery="true">
<Category>ConfigurationHealth</Category>
<AlertSettings AlertMessage="Microsoft.ActiveDirectoryFederationServices.2016.FederationServerSqlNotificationRegistrationErrorMonitor_AlertMessageResourceID">
<AlertOnState>Warning</AlertOnState>
<AutoResolve>true</AutoResolve>
<AlertPriority>Normal</AlertPriority>
<AlertSeverity>Warning</AlertSeverity>
<AlertParameters>
<AlertParameter1>$Data/Context/Params/Param[1]$</AlertParameter1>
<AlertParameter2>$Data/Context/Params/Param[2]$</AlertParameter2>
</AlertParameters>
</AlertSettings>
<OperationalStates>
<OperationalState ID="EventRaised" MonitorTypeStateID="EventRaised" HealthState="Warning"/>
<OperationalState ID="TimerEventRaised" MonitorTypeStateID="TimerEventRaised" HealthState="Success"/>
</OperationalStates>
<Configuration>
<ComputerName>$Target/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>
<LogName>$Target/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">356</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>