ConfigMgr 2007 Status: Discovery Data Manager failed to connect to the discovery database

SMSv4_Status__Discovery_Data_Manager_failed_to_connect_to_the_discovery_database_1_Rule (Rule)

Knowledge Base article:

Summary

Discovery Data Manager failed to connect to the discovery database. Configuration Manager status message 2601 was detected.

Causes

This condition could be caused by a SQL Server problem.

Resolutions

1. Review the immediately preceding status messages from this component about SQL Server errors.

2. Verify that this computer can reach the SQL Server computer.

3. Verify that SQL Server services are running.

4. Verify that Configuration Manager can access the Configuration Manager site database.

5. Verify that the Configuration Manager site database, transaction log, and tempdb are not full.

6. Verify that there are at least 50 SQL Server user connections, plus 5 for each Configuration Manager console.

If the problem persists, check the SQL Server error logs.

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 / 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 parameters selected is displayed.

External

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

Element properties:

Target	Microsoft.SystemCenter.ConfigurationManager.2007.Microsoft_SMSv4_Site_Database_Servers_Installation
Category	EventCollection
Enabled	False
Alert Generate	False
Remotable	True
Comment	Mom2005ID='{DC9C57A3-3199-47E4-AEAF-E14252A7504D}';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
GenerateAlert	WriteAction	System.Mom.BackwardCompatibility.AlertResponse	Default

Source Code:

<Rule ID="SMSv4_Status__Discovery_Data_Manager_failed_to_connect_to_the_discovery_database_1_Rule" Target="Microsoft.SystemCenter.ConfigurationManager.2007.Microsoft_SMSv4_Site_Database_Servers_Installation" Enabled="false" ConfirmDelivery="false" Comment="Mom2005ID='{DC9C57A3-3199-47E4-AEAF-E14252A7504D}';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>2601</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="GenerateAlert" TypeID="System.Mom.BackwardCompatibility.AlertResponse">

      <GenerateAlert>true</GenerateAlert>

      <Owner/>

      <Description>

            $Data/Params/Param[1]$

           - ConfigMgr 2007 Status: Discovery Data Manager failed to connect to the discovery database.





            $Data/EventDescription$

          



The status message contains message properties



Machine Name: 

            $Data/Params/Param[1]$

          

Module Name: 

            $Data/Params/Param[2]$

          

Component: 

            $Data/Params/Param[3]$

          

Message ID: 

            $Data/Params/Param[4]$

          

Win32 Error: 

            $Data/Params/Param[5]$

          

Top Level Site Code: 

            $Data/Params/Param[6]$

          

Database Record ID: 

            $Data/Params/Param[7]$

          </Description>

      <AlertLevel>40</AlertLevel>

      <ResolutionState/>

      <Source>

            $Data/PublisherName$

          </Source>

      <Name>ConfigMgr 2007 Status: Discovery Data Manager failed to connect to the discovery database</Name>

      <InvokerType>0</InvokerType>

    </WriteAction>

  </WriteActions>

</Rule>