Home
  •  

SMS 2003 依赖服务故障: MSSQLSERVER 依赖于另一服务，但该服务无法启动或不存在

SMS_2003_dependent_service_failure__MSSQLSERVER_depends_on_another_service_which_failed_to_start_or_is_nonexistent_9_Rule (Rule)

Knowledge Base article:

摘要

当 Windows 服务控制管理器生成事件 ID 7001 或 7002 时，将触发此警报。这些消息并非 SMS 特有的。尽管服务控制管理器可能会尝试重新启动此服务，但在修复错误之前，此问题无法自行解决。

查找出现此警报的原因：

原因

有关此问题的原因的详细信息，请参阅事件 7001 或 7002 的详细描述。

解决方法

确保在 SQL Server 服务尝试启动之前成功启动依赖服务。

外部支持

若要获取进一步的帮助，请参阅 SMS 网站的支持部分 针对 Systems Management Server 的支持所提供的其他支持选项。

其他信息

最好由 SMS 管理员来处理此警报。

示例事件

7001: 与 %1 服务相依的 %2 服务因下列错误而无法启动: %3

7002: 与 %1 服务相依的组为 %2，该组中的组件均未启动。

Element properties:

TargetMicrosoft.SMS.2003.Microsoft_SMS_2003_Site_Database_Servers_Installation
CategoryEventCollection
EnabledFalse
Alert GenerateTrue
Alert SeverityError
Alert PriorityLow
RemotableTrue
Alert MessageSMS_2003_dependent_service_failure__MSSQLSERVER_depends_on_another_service_which_failed_to_start_or_is_nonexistent_9_Rule.AllertMessageBackwardCompatibility
Event LogSystem
CommentMom2005ID='{37927431-3798-4C2D-A309-50F3DC8567BB}';MOM2005ComputerGroupID={6E07E901-5EEF-4D43-ABC9-5A73BC9B072D}

Member Modules:

ID Module Type TypeId RunAs 
_907D4578_146C_11D3_AB21_00A0C98620CE_ DataSource Microsoft.Windows.EventProvider Default
CollectEventData WriteAction Microsoft.SystemCenter.CollectEvent Default
CollectEventDataWarehouse WriteAction Microsoft.SystemCenter.DataWarehouse.PublishEventData Default
GenerateAlert WriteAction System.Mom.BackwardCompatibility.AlertResponse Default

Source Code:

<Rule ID="SMS_2003_dependent_service_failure__MSSQLSERVER_depends_on_another_service_which_failed_to_start_or_is_nonexistent_9_Rule" Target="Microsoft.SMS.2003.Microsoft_SMS_2003_Site_Database_Servers_Installation" Enabled="false" ConfirmDelivery="true" Comment="Mom2005ID='{37927431-3798-4C2D-A309-50F3DC8567BB}';MOM2005ComputerGroupID={6E07E901-5EEF-4D43-ABC9-5A73BC9B072D}">

  <Category>EventCollection</Category>

  <DataSources>

    <DataSource ID="_907D4578_146C_11D3_AB21_00A0C98620CE_" Comment="{907D4578-146C-11D3-AB21-00A0C98620CE}" TypeID="WindowsLibrary!Microsoft.Windows.EventProvider">

      <ComputerName>$Target/Host/Property[Type="WindowsLibrary!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>

      <LogName>System</LogName>

      <Expression>

        <And>

          <Expression>

            <RegExExpression>

              <ValueExpression>

                <XPathQuery Type="Integer">EventDisplayNumber</XPathQuery>

              </ValueExpression>

              <Operator>MatchesMOM2005BooleanRegularExpression</Operator>

              <Pattern>^(7001|7003)$</Pattern>

            </RegExExpression>

          </Expression>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

                <XPathQuery Type="String">PublisherName</XPathQuery>

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value>Service Control Manager</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

                <XPathQuery Type="String">Params/Param[1]</XPathQuery>

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value>MSSQLSERVER</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

        </And>

      </Expression>

    </DataSource>

  </DataSources>

  <WriteActions>

    <WriteAction ID="GenerateAlert" TypeID="MomBackwardCompatibility!System.Mom.BackwardCompatibility.AlertResponse">

      <AlertGeneration>

        <GenerateAlert>true</GenerateAlert>

        <Owner/>

        <Description>

            $Data/LoggingComputer$

           - SMS 2003 dependent service failure: MSSQLSERVER depends on another service which failed to start or is nonexistent.



The MSSQLSERVER service running on 

            $Data/LoggingComputer$

           was detected as stopped at 

            $Data/@time$

          .</Description>

        <AlertLevel>70</AlertLevel>

        <ResolutionState/>

        <Source>

            $Data/PublisherName$

          </Source>

        <Name>SMS 2003 dependent service failure: MSSQLSERVER depends on another service which failed to start or is nonexistent</Name>

      </AlertGeneration>

      <InvokerType>0</InvokerType>

    </WriteAction>

    <WriteAction ID="CollectEventData" TypeID="SystemCenterLibrary!Microsoft.SystemCenter.CollectEvent"/>

    <WriteAction ID="CollectEventDataWarehouse" TypeID="DataWarehouseLibrary!Microsoft.SystemCenter.DataWarehouse.PublishEventData"/>

  </WriteActions>

</Rule>