Home
  •  

SQL Database Connection Failed

Microsoft.SharePoint.2016.SPDatabase.Connection (UnitMonitor)


A critical state of this Monitor indicates that a SQL Database connection attempt failed for a specified connection string.

Note:
This Monitor is disabled by default, enable this Monitor if you want this Management Pack to monitor the SQL Database Connection for SharePoint 2016.

Knowledge Base article:

Summary

To get the most current Knowledge Article from the Microsoft TechNet site, visit:

http://go.microsoft.com/fwlink/?LinkId=245008

Causes

View all current alerts from this object using this link:

View Alerts

Element properties:

TargetMicrosoft.SharePoint.Library.SPDatabase
Parent MonitorSystem.Health.AvailabilityState
CategoryAvailabilityHealth
EnabledTrue
Alert GenerateTrue
Alert SeverityError
Alert PriorityHigh
Alert Auto ResolveTrue
Monitor TypeMicrosoft.SharePoint.2016.OleDbCheckConnectionMonitorType
RemotableTrue
AccessibilityPublic
Alert Message
SharePoint: Database Connection Failed
A critical incident has occurred where the connection to database {0} failed.
RunAsDefault

Source Code:

<UnitMonitor ID="Microsoft.SharePoint.2016.SPDatabase.Connection" Accessibility="Public" Enabled="true" Target="MOSS!Microsoft.SharePoint.Library.SPDatabase" ParentMonitorID="Health!System.Health.AvailabilityState" Priority="Normal" TypeID="Microsoft.SharePoint.2016.OleDbCheckConnectionMonitorType">

  <Category>AvailabilityHealth</Category>

  <AlertSettings AlertMessage="Microsoft.SharePoint.2016.SPDatabase.Connection_AlertMessageResourceID">

    <AlertOnState>Error</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>High</AlertPriority>

    <AlertSeverity>Error</AlertSeverity>

    <AlertParameters>

      <AlertParameter1>$Target/Property[Type="MOSS!Microsoft.SharePoint.Library.SPDatabase"]/LegacyConnectionString$</AlertParameter1>

    </AlertParameters>

  </AlertSettings>

  <OperationalStates>

    <OperationalState ID="NoConnectionFailure" MonitorTypeStateID="NoConnectionFailure" HealthState="Success"/>

    <OperationalState ID="ConnectionFailure" MonitorTypeStateID="ConnectionFailure" HealthState="Error"/>

  </OperationalStates>

  <Configuration>

    <ConnectionString>Provider=SQLOLEDB;$Target/Property[Type="MOSS!Microsoft.SharePoint.Library.SPDatabase"]/LegacyConnectionString$</ConnectionString>

    <IntervalSeconds>1800</IntervalSeconds>

  </Configuration>

</UnitMonitor>