Looking at the logs I see this

[10:30:32]:           Info:      :GetSqlVersion: Collecting SQL Instance information for vscomsql1
[10:30:34]:           Error:     :GetSqlVersion(): Threw Exception.Type: System.Management.ManagementException, Exception Error Code: 0×80131501, Exception.Message: Invalid class
[10:30:34]:           Error:     :StackTrace:   at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode) at System.Management.ManagementObjectCollection.ManagementObjectEnumerator.MoveNext() at Microsoft.EnterpriseManagement.OperationsManager.Setup.Common.SetupValidationHelpers.GetSqlVersion(String sqlServerInstance)
[10:30:34]:           Always:                :Current Version of SQL=0.0   Required Version=10.1.0.0

Looking at http://technet.microsoft.com/en-us/library/hh205996.aspx I found this note

You might receive a message about having the wrong version of SQL Server, or you might encounter a problem with the SQL Server Windows Management Instrumentation (WMI) provider. To resolve this problem, open a Command Prompt window, select Run as administrator, and then run the following command. In the command, replace the <path> placeholder with the location of SQL Server:

mofcomp.exe “<path>\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof”.

I tried running the “mofcomp.exe” command on the SQL Server but it doesn’t even seem to execute correctly.

mofcomp.exe "C:\Program Files\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof

Finally I figured out what this issue was.  I was running the command using the wrong path.  Thinking it was a 64-bit OS and SQL 64-bit I assumed 64-bit path.  Turns out the command needs the x86 Path “C:\Program Files (x86)”

I ran the following command and this fixed my issue

mofcomp.exe "C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof

System Center Operations Manager 2012 Release Candidate is now available for download here.  http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=27974

It’s got a slick new look.  Check it out!

*Note prerequisites may change when SCOM 2012 RTMs

I need the Web Server (IIS) role with the follow server role services:  According to http://technet.microsoft.com/en-us/library/hh205990.aspx#BKMK_RBF_WebConsole

• Static Content
• Default Document
• Directory Browsing
• HTTP Errors
• HTTP Logging
• Request Monitor
• Request Filtering
• Static Content Compression
• Web Server (IIS) Support
• IIS 6 Metabase Compatibility
• ASP.NET
• Windows Authentication

I could go to Server Manager and add the individual roles and features, but I am running Server 2008 R2 so lets make it super simple with PowerShell.

1. Launch the PowerShell command prompt

2. Run this command

Import-Module ServerManager

3. Press Enter

4. Run this command

Add-WindowsFeature NET-Framework-Core,Web-Static-Content,Web-Default-Doc,Web-Dir-Browsing,Web-Http-Errors,Web-Http-Logging,Web-Request-Monitor,Web-Filtering,Web-Stat-Compression,AS-Web-Support,Web-Metabase,Web-Asp-Net,Web-Windows-Auth –restart

5. Press Enter

I then see

6. If you already installed .net 4.0 then you will need to run this command from PowerShell to register IIS with .net 4.0

c:\windows\Microsoft.NET\Framework64\v4.0.30319\aspnet_regiis.exe -r

7.  Now I need to enable IIS to work with .net 4.0

c:\windows\system32\inetsrv\appcmd set config /section:isapiCgiRestriction /[path=`'C:\Windows\Microsoft.NET\Framework64\v4.0.30319\aspnet_isapi.dll`'].allowed:True

A quick check of IIS and its it looks like it’s ready to go.

MP2XMLPRO is a GUI based tool I created to export MP files to XML.

Currently you can do this with Boris’s PowerShell script or the MPDumper tool.  I only need to convert management packs once in a while and I often find myself wasting time trying to remember the correct syntax for these tools.  This new GUI based tool makes it simple.

Download: Link

There have been a few scripts and programs for doing this in the community but none were officially supported.  Now we finally have a supported method!

http://support.microsoft.com/kb/2626670