As you should know, the SQL Server Management Pack has been released in version 6.3.173.0 and this new MP provides the capabilities for Operations Manager 2007 R2 and Operations Manager 2012 to discover SQL Server 2005, 2008, 2008 R2, and SQL Server 2012. It monitors SQL Server components such as database engine instances, databases, and SQL Server agents.
That means the librairy does not contain any more the classes dedicated to SQL 2000 monitoring... What a pitty when you always have SLQ 2000 instances and when the SQL team tell you they are ready for SQL 2012 installations !
Microsoft has also published in May 2011 a dedicated MP + it's library to monitor SQL 2000 instances ! See http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=15226
BUT what a surprise to see that both Library ( in the SQL 2000 MP and in the release 6.3.173.0) have the same name : Microsoft.SQLServer.Library.mp
Impossible to import both library... and also impossible to keep SQL 2000 monitoring after an upgrade to 6.3.173.0 MP version.
I've also decided to unseal the MPs and rename the Library to be able to import SQL 2000 MP in parallele of the release 6.3.173.0 MP.
Or you can download a .ZIP file here : >>>>>> Click to Download <<<<<<
Please reseal all 3 MPs before importing in SCOM.
NOTE this will be supported by Microsoft but it's the only way I've found to be able to always monitor the SQL 2000 instances and be ready for SQL 2012 monitoring.
Here is the result after import in SCOM :
Hope this will help you ! :)
This posting is provided "AS IS" with no warranties.
