Tuesday, February 23, 2010

SQL Server 2008 Configuration Manager WMI Error

Recently, I was trying out few configuration changes in the SQL Server Configuration Manager to find out the impact of each change.  After sometime, I tried to open up the configuration manager but the following error showed up instead of the configuration manager mmc.

The error was “Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manager SQL Server 2005  or later servers with SQL Server Configuration Manager. Invalid class [0X80041010]”.

image

Upon searching, the below link explained a resolution for the same issue in SQL Server 2005.

http://blogs.msdn.com/echarran/archive/2006/01/03/509061.aspx

I followed the steps exactly as mentioned in the above blog post and it worked perfectly for SQL Server 2008 too. Here are the steps:

  1. Open up command prompt using elevated privileges (Vista, Windows 7, Windows Server 2008) or normally in Windows XP or Windows 2003.
  2. Navigate to the folder c:\Program Files (x86)\Microsoft SQL Server\100\Shared
  3. Run the following command:  mofcomp.exe "C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof"      (or just “mofcomp.exe  sqlmgmproviderxpsp2up.mof” )
  4. You should see a similar output in your command prompt:

Parsing MOF file: C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof

MOF file has been successfully parsed

Storing data in the repository…

Done!

Below is a snip of the results….

image

2 comments:

Haluk Tunç said...

Perfect solution , I have never seen this type error , but it is solved with your help. Appreciated.

Anonymous said...

rockstar!

Post a Comment