Data Access-service: databaseverbinding

Microsoft.ServiceManager.SDKService.DatabaseConnectivity (UnitMonitor)

Hiermee wordt de databaseverbinding van de Data Access-service bewaakt.

Knowledge Base article:

Samenvatting

De Data Access-service kan geen verbinding maken met de Service Manager-database. Wanneer de Data Access-service niet wordt uitgevoerd, kunnen gebruikers de Service Manager-console niet gebruiken. Connectoren die met andere beheersystemen communiceren, functioneren ook niet.

Oorzaken

De Service Manager-databaseserver is offline of niet bereikbaar.
De Service Manager-database is offline of ontkoppeld.
De Data Access-service beschikt niet over voldoende rechten om verbinding te maken met de database.

Oplossingen

Controleer de databaseserver waarop de Service Manager-database is geïnstalleerd en ga na of beide online zijn.
Controleer of de databaseserver bereikbaar is vanaf de server waarop de Data Access-service is geïnstalleerd.
Controleer met SQL Server Configuration Manager of de SQL-server externe verbindingen accepteert.
Controleer of het account dat door de Data Access-service wordt gebruikt over voldoende rechten beschikt om toegang te krijgen tot de Service Manager-database en of het wachtwoord niet is verlopen.

Element properties:

Target

Microsoft.SystemCenter.ServiceManager.ManagementServer

Parent Monitor

Microsoft.ServiceManager.SDKService.AvailabilityHealthRollup

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

Public

Alert Message

De databaseverbinding is verbroken

De verbinding van de Data Access-service met de database is verbroken.

RunAs

Default

Source Code:

<UnitMonitor ID="Microsoft.ServiceManager.SDKService.DatabaseConnectivity" Accessibility="Public" Enabled="true" Target="SM!Microsoft.SystemCenter.ServiceManager.ManagementServer" ParentMonitorID="Microsoft.ServiceManager.SDKService.AvailabilityHealthRollup" Remotable="true" Priority="Normal" TypeID="Windows!Microsoft.Windows.2SingleEventLog2StateMonitorType" ConfirmDelivery="true">

  <Category>StateCollection</Category>

  <AlertSettings AlertMessage="Microsoft.ServiceManager.SDKService.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>