Archive for November 2011

Fix SCOM 2012 Install error “The version of SQL Server on this computer is either not supported or could not be validated because of an issue connecting to the WMI provider. “

 

clip_image002

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

 

clip_image002[4]

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

 

image

 

Operations Manager 2012 Release Candidate is available for download

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!

image