The SQL Server 2000 database engine health is not monitored in System Center Operations Manager 2007

In Microsoft System Center Operations Manager 2007, you view the Microsoft SQL Server state view for a computer that has SQL Server 2000 installed. The SQL Server 2000 database engine health is not monitored.

By default, the SQL DB Engine Service Health Rollup monitor is not enabled.

Note This aggregate monitor includes the SQL Service State terminated unexpected monitor and the SQL Service terminated unexpectedly monitor.

To work around this issue, follow these steps:

1. In the System Center Operations Manager 2007 Operator Console, click Authoring in the navigation pane.
2. Under Management Pack objects, click Monitors.
3. Press CTRL+M to display the Scope Management Pack Objects by target(s) dialog box.
4. In the Look for search box, type SQL 2000 DB Engine, and then click Find now.
5. Click to select the SQL 2000 DB Engine check box, and then click OK to display the SQL 2000 DB Engine target.
6. Expand SQL 2000 DB Engine, expand Entity Health, expand Availability, and then click SQL DB Engine Service Health Rollup.
   
   This aggregate monitor displays No in the Enabled by default column.
7. To enable this aggregate monitor, right-click SQL DB Engine Service Health Rollup, point to Overrides, point to Override the monitor, and then click For all objects of type: SQL 2000 DB Engine.
8. In the list of overrides, click to select the Override check box for the Enabled parameter.
9. Click True in the Override Setting box, and then click OK.

Microsoft regularly releases software updates and service packs. Visit this article in the future to determine whether the issue that is described in this article has been fixed in an update or in a service pack.