Troubleshooting: SQL MP 6.5.1 with SCOM 2007 R2 (SQL 2012 MP Imports Fail)

So on 6/30 a new SQL MP was released. It has some great new features and fixes:

http://www.microsoft.com/en-us/download/details.aspx?id=10631

and some awesome new instance level dashboards for both SQL 2008 and 2012 when used with SCOM 2012+

SQL MP

Unfortunately, the MP also doesn’t play nice with SCOM 2007 R2 and its predecessor 6.4.1 MP. When you try to import it into your 2007 R2 environment with the previous version of the SQL MP installed you will get failures of all the 2012 MP components

SQL01

This error is not particularly helpful but if you go to the OpsMgr Event log it helps narrow things down:

SQL02

So the workaround is to remove the SQL 2012 6.4.1 MPs and then reimport 6.5.1:

sql03

This should fix the issue, but ultimately you should really upgrade to 2012 R2 as 2007 R2 fell out of mainstream support on 7/8/2014 so any new MP’s going forward will likely be the 2.0 schema and completely incompatible.

Leave a Reply

Your email address will not be published. Required fields are marked *

The contents of this site are provided “AS IS” with no warranties, or rights conferred. Example code could harm your environment, and is not intended for production use. Content represents point in time snapshots of information and may no longer be accurate. (I work @ MSFT. Thoughts and opinions are my own.)