Data Access Service - Database Connectivity

Microsoft.SystemCenter.DataAccessService.DatabaseConnectivity (UnitMonitor)

Monitors the database connectivity of the Data Access service.

Knowledge Base article:

Summary

The Data Access service is unable to connect to the Operations Manager database. When the Data Access service is not running, users will not be able to use the Operations Console, Web Console, or Command Shell. Any connectors to 3rd party management systems will not work as well.

Resolutions

Check the database server on which the Operations Manager database is installed to make sure its online and the Operations Manager database is online.
Make sure the database server is reachable from the server where the Data Access service is installed.
Make sure the SQL server accepts remote connections using SQL Server Configuration Manager.
Make sure the account used by the Data Access service has sufficient privileges to access the Operations Manager database.

Configuration

The Operations Manager database server is offline or unreachable.
The Operations Manager database is offline or detached.
The Data Access service does not sufficient privileges to connect to the database.

Element properties:

Target

Microsoft.SystemCenter.ManagementDataAccessService

Parent Monitor

System.Health.AvailabilityState

Category

StateCollection

Enabled

True

Alert Generate

True

Alert Severity

Error

Alert Priority

High

Alert Auto Resolve

True

Monitor Type

Microsoft.Windows.2SingleEventLog2StateMonitorType

Remotable

True

Accessibility

Internal

Alert Message

Database connectivity is lost

The Data Access service has lost connectivity to the database.

RunAs

Default

Source Code:

<UnitMonitor ID="Microsoft.SystemCenter.DataAccessService.DatabaseConnectivity" Accessibility="Internal" Enabled="true" Target="Microsoft.SystemCenter.ManagementDataAccessService" ParentMonitorID="Health!System.Health.AvailabilityState" Remotable="true" Priority="Normal" TypeID="Windows!Microsoft.Windows.2SingleEventLog2StateMonitorType" ConfirmDelivery="true">

  <Category>StateCollection</Category>

  <AlertSettings AlertMessage="Microsoft.SystemCenter.DataAccessService.DatabaseConnectivity.AlertMessage">

    <AlertOnState>Error</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>High</AlertPriority>

    <AlertSeverity>Error</AlertSeverity>

  </AlertSettings>

  <OperationalStates>

    <OperationalState ID="DatabaseConnectivityLost" MonitorTypeStateID="FirstEventRaised" HealthState="Error"/>

    <OperationalState ID="DatabaseConnectivityEstablished" 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">26330</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>