This monitor checks the site server connectivity to SQL database server.
This monitor checks the database connection between the ConfigMgr site server and the Site database server. It generates an alert when the site server fails to connect to the site database server.
There are many possible root causes, including:
The Site database server is offline.
The network between the site server and the site database server is offline.
The database credentials used by the site server are expired or incorrect.
The database credentials used by the site server do not have sufficient permissions.
The database connection configuration is incorrect.
View SQL Server Alerts to check the status of the database server.
Check the network between site server and site database server.
Check the credentials used by site server.
Check whether the account has permissions.
Check the database connection configuration.
Target | MECM.SiteServerRoleBaseClass | ||
Parent Monitor | MECM.SiteRole.AggregateRollup.Monitor | ||
Category | Custom | ||
Enabled | True | ||
Alert Generate | True | ||
Alert Severity | MatchMonitorHealth | ||
Alert Priority | Normal | ||
Alert Auto Resolve | True | ||
Monitor Type | MECM.RoleAvailability.MT | ||
Remotable | True | ||
Accessibility | Public | ||
Alert Message |
| ||
RunAs | Default |
<UnitMonitor ID="MECM.Database.Connectivity.RoleAvailability.Monitor" Accessibility="Public" Enabled="true" Target="MECM.SiteServerRoleBaseClass" ParentMonitorID="MECM.SiteRole.AggregateRollup.Monitor" Remotable="true" Priority="Normal" TypeID="MECM.RoleAvailability.MT" ConfirmDelivery="true">
<Category>Custom</Category>
<AlertSettings AlertMessage="MECM.Database.Connectivity.RoleAvailability.Monitor.AlertMessage">
<AlertOnState>Warning</AlertOnState>
<AutoResolve>true</AutoResolve>
<AlertPriority>Normal</AlertPriority>
<AlertSeverity>MatchMonitorHealth</AlertSeverity>
<AlertParameters>
<AlertParameter1>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/PrincipalName$</AlertParameter1>
</AlertParameters>
</AlertSettings>
<OperationalStates>
<OperationalState ID="UIGeneratedOpStateId56dbc36a28e84523ad1e7abfe018e0ef" MonitorTypeStateID="Good" HealthState="Success"/>
<OperationalState ID="UIGeneratedOpStateId23cc4916522a4a9e8f14b55c969bb363" MonitorTypeStateID="Warning" HealthState="Warning"/>
<OperationalState ID="UIGeneratedOpStateId182294f9f9324cdcbe681eb19d7f32d1" MonitorTypeStateID="Error" HealthState="Error"/>
</OperationalStates>
<Configuration>
<ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/PrincipalName$</ComputerName>
<RoleName>SMS SQL Server</RoleName>
<IntervalSeconds>360</IntervalSeconds>
<MatchCount>3</MatchCount>
</Configuration>
</UnitMonitor>