ConfigMgr 2007 dependent service running: MSSQLSERVER

SMSv4_dependent_service_running__MSSQLSERVER_3_Rule (Rule)

Knowledge Base article:

Summary

The SQL Server service has stopped. Configuration Manager requires this service to record and access necessary data. This condition does not repair itself and must be resolved before Configuration Manager can resume some of its core functions.

Causes

This condition could occur because:

The computer that is running SQL Server is shut down or is restarted.
Configuration Manager is being upgraded with Configuration Manager hotfixes or with Configuration Manager service packs.
SQL Server is being upgraded with SQL Server hotfixes, with SQL Server service packs, or with a later version of SQL Server.
MSSQLServer service is manually shut down.

Additional

The SQLSERVERAGENT service is dependent on MSSQLServer service.

This alert is best handled by SQL Server administrators. Configuration Manager administrators can also help.

External

For more information about SQL Server, see the SQL Server product documentation.

For more assistance, see a list of additional support options in the support section of Configuration Manager Web site at Support for Configuration Manager.

Element properties:

Target	Microsoft.SystemCenter.ConfigurationManager.2007.Microsoft_SMSv4_Software_Update_Point_Servers_Installation
Category	EventCollection
Enabled	False
Alert Generate	False
Remotable	True
Comment	Mom2005ID='{E35E4269-72BB-4047-B711-C9502D867D5A}';MOM2005ComputerGroupID={2C48D0EE-B910-4E4F-99E4-5A95F1C1F24E}

Member Modules:

ID	Module Type	TypeId	RunAs
_A82B9550_241C_11D3_B2CF_00A0C92A28B4_	DataSource	System.Mom.BackwardCompatibility.FilteredEvent.DataProvider	Default
GenerateAlert	WriteAction	System.Mom.BackwardCompatibility.AlertResponse.WithServerRole	Default

Source Code:

<Rule ID="SMSv4_dependent_service_running__MSSQLSERVER_3_Rule" Target="Microsoft.SystemCenter.ConfigurationManager.2007.Microsoft_SMSv4_Software_Update_Point_Servers_Installation" Enabled="false" ConfirmDelivery="false" Comment="Mom2005ID='{E35E4269-72BB-4047-B711-C9502D867D5A}';MOM2005ComputerGroupID={2C48D0EE-B910-4E4F-99E4-5A95F1C1F24E}">

  <Category>EventCollection</Category>

  <DataSources>

    <DataSource ID="_A82B9550_241C_11D3_B2CF_00A0C92A28B4_" Comment="{A82B9550-241C-11D3-B2CF-00A0C92A28B4}" TypeID="MomBackwardCompatibility!System.Mom.BackwardCompatibility.FilteredEvent.DataProvider">

      <Expression>

        <And>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

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

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value>21207</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

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

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value>MSSQLSERVER</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

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

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value>Microsoft Operations Manager</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

        </And>

      </Expression>

    </DataSource>

  </DataSources>

  <WriteActions>

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

      <GenerateAlert>true</GenerateAlert>

      <Owner/>

      <Description>

            $Data/LoggingComputer$

           - ConfigMgr 2007 service running: MSSQLSERVER.





            $Data/EventDescription$

          </Description>

      <AlertLevel>10</AlertLevel>

      <ResolutionState/>

      <Source>

            $Data/PublisherName$

          </Source>

      <Name>ConfigMgr 2007 dependent service running: MSSQLSERVER</Name>

      <ServerRole>SMS Server</ServerRole>

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

      <Component>SUP</Component>

      <ProblemState>1</ProblemState>

      <InvokerType>0</InvokerType>

    </WriteAction>

  </WriteActions>

</Rule>