Home
  •  

ConfigMgr 2007 Consolidated Status: Management Point failed to receive SQL Server connection settings

SMSv4_Consolidated_Status__Management_Point_failed_to_receive_SQL_Server_connection_settings_1_Rule (Rule)

Knowledge Base article:

Summary

The management point could not write out the CCMexec setting to Windows Management Instrumentation (WMI). Configuration Manager status message 5432 was detected.

Causes

This condition could occur because the management point did not get installed properly.

Resolutions

Ensure that the management point setup succeeded. If the management point did not succeed, reinstall the management point.

Additional

This alert is best handled by Configuration Manager administrators.

To investigate status messages:

1. In the Configuration Manager console, navigate to System Center Configuration Manager > Site Database > System Status, and then click Status Message Queries.

2. Right-click the All Status Messages from a Specific System, and then select Show Messages.

3. In the All Status Messages from a Specific System dialog box you can either specify the Machine Name and Time, or you can load existing machine names from the database, and then click OK. The status messages for the appropriate selected parameters are displayed.

External

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

Element properties:

TargetMicrosoft.SystemCenter.ConfigurationManager.2007.Microsoft_SMSv4_Site_Database_Servers_Installation
CategoryEventCollection
EnabledFalse
Alert GenerateFalse
RemotableTrue
CommentMom2005ID='{DDD9AE7A-CF40-4F4E-8615-6A2B882612A1}';MOM2005ComputerGroupID={15348338-2E39-4B34-9DFF-4719AE7F1CCE}

Member Modules:

ID Module Type TypeId RunAs 
_F320DA51_13BF_11D3_B2CD_00A0C92A28B4_ DataSource System.Mom.BackwardCompatibility.FilteredEvent.DataProvider Default
ConsolidatedEventWriteAction WriteAction System.Mom.BackwardCompatibility.ConsolidatedEventResponse Default

Source Code:

<Rule ID="SMSv4_Consolidated_Status__Management_Point_failed_to_receive_SQL_Server_connection_settings_1_Rule" Target="Microsoft.SystemCenter.ConfigurationManager.2007.Microsoft_SMSv4_Site_Database_Servers_Installation" Enabled="false" ConfirmDelivery="false" Comment="Mom2005ID='{DDD9AE7A-CF40-4F4E-8615-6A2B882612A1}';MOM2005ComputerGroupID={15348338-2E39-4B34-9DFF-4719AE7F1CCE}">

  <Category>EventCollection</Category>

  <DataSources>

    <DataSource ID="_F320DA51_13BF_11D3_B2CD_00A0C92A28B4_" Comment="{F320DA51-13BF-11D3-B2CD-00A0C92A28B4}" TypeID="MomBackwardCompatibility!System.Mom.BackwardCompatibility.FilteredEvent.DataProvider">

      <Expression>

        <And>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

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

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value>5432</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

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

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value>ConfigMgr 2007 Monitor SMS Status Messages</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

        </And>

      </Expression>

    </DataSource>

  </DataSources>

  <WriteActions>

    <WriteAction ID="ConsolidatedEventWriteAction" TypeID="MomBackwardCompatibility!System.Mom.BackwardCompatibility.ConsolidatedEventResponse">

      <ConsolidationProperties>

        <PropertyXPathQuery>EventDisplayNumber</PropertyXPathQuery>

        <PropertyXPathQuery>PublisherName</PropertyXPathQuery>

        <PropertyXPathQuery>EventDescription</PropertyXPathQuery>

      </ConsolidationProperties>

      <Interval>3600</Interval>

    </WriteAction>

  </WriteActions>

</Rule>