Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. System Center Operations Manager 2007 is unable to monitor SQL Server replication status

System Center Operations Manager 2007 is unable to monitor SQL Server replication status

View products that this article applies to.

Symptom

When using Microsoft System Center Operations Manager Server 2007 R2 with the Microsoft SQL Server Management Pack, items within SQL Server Replication report a Not Monitored state under Publication State, Publisher State and Subscription State.

↑ Back to the top

Cause

This behavior is by design. There are no replication monitors in the Microsoft SQL Server Management Pack for Operations Manager 2007 SP1 and R2. http://www.microsoft.com/download/en/details.aspx?id=10631. If you check in Authoring Console Monitors for SQL replication you will see that when the SQL 2008 Publication\Entity Health\Availability entry is expanded there is no monitor to update information to rollup monitors.

↑ Back to the top

Resolution

Replication monitors are introduced in the SQL Server 2012 Management Pack that will be released following the release of System Center 2012 Operations Manager. 

↑ Back to the top

More Information

This article only applies to the Microsoft SQL Server Management Pack for Operations Manager 2007 SP1 and R2 . This Management Pack provides discovery and monitoring of SQL Server 2005, 2008, and 2008 R2.

↑ Back to the top

Keywords: kb

↑ Back to the top

Article Info
Article ID : 2673200
Revision : 1
Created on : 1/7/2017
Published on : 2/21/2012
Exists online : False
Views : 269