The SQL Server 2005 Management Pack For OpsMgr 2007 allows you to discover SQL 2005 database engines, Instances and databases as well as allows you to discover Database File and Group objects.
Feature Summary:
• Active Directory Helper Service
• Agent jobs
• Backup
• Backup Query Engine
• Clustering
• Databases and Tables
• DB availability
• DBCC
• Full Text Search
• Log Shipping
• Replication
• Replication monitoring
• SQL Server Agent
• SQL XML
• Web Assistant
Download the SQL Server 2000-2005 Management Pack (SQL Server 2000-2005 System Center Operations Manager2007 Management Pack.Msi) and execute the Msi to extract the contents to C:\Program Files\System Center Management Packs. This will in turn create the C:\Program Files\System Center Management Packs\SQL Server 2000-2005 Management Pack directory.
Open the System Center Operations Manager 2007 Operations Console and from the Administration leaf open Actions: Import Management Packs and import the management packs in the following order:
1. Microsoft.SQLServer.Library.mp
2. Microsoft.SQLServer.2005.Discovery.mp
3. Microsoft.SQLServer.2005.Monitoring.mp
Microsoft SQL Server 2000/2005 Management Pack Download
http://www.microsoft.com/downloads/details.aspx?FamilyID=8C0F970E-C653-4C15-9E51-6A6CADFCA363&displaylang=en
No Comments