Help: SQL Server

Sharing my knowlege about SQL Server Troubleshooting Skills

Solution: Unable to launch SQL Server Configuration Manager – Invalid class [0x80041010]

Posted by blakhani on September 4, 2014


While launching SQL Server Configuration Manager on one of my machine, I got below error

image

Here is the text of the error message:

—————————
SQL Server Configuration Manager
—————————
Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager.
Invalid class [0x80041010]
—————————
OK  
—————————

There might be various reason for this error. In this case our actual problem is “Invalid class” which I have highlighted above. I have looked further and found that below is the solution for me. Same solution also works for Invalid namespace [0x8004100e] error also. 

image

C:\WINDOWS\system32>mofcomp "C:\Program Files (x86)\Microsoft SQL Server\120\Shared\sqlmgmproviderxpsp2up.mof"
Microsoft (R) MOF Compiler Version 6.3.9600.16384
Copyright (c) Microsoft Corp. 1997-2006. All rights reserved.
Parsing MOF file: C:\Program Files (x86)\Microsoft SQL Server\120\Shared\sqlmgmproviderxpsp2up.mof
MOF file has been successfully parsed
Storing data in the repository…
Done!

MofComp is a command line utility to compile MOF (Managed Object Format) files and store the data in WMI repository. The MOF Compiler is available in the %Windir%\System32\wbem directory. So if you are getting “‘mofcomp’ is not recognized as an internal or external command then try changing current directory from command prompt to %Windir%\System32\wbem

Also note that in mof file on my machine is under 120 folder. Depends on SQL version installed, you may have it in different folder. The value of that number depends on the version of SQL Server.

Microsoft SQL Server 2014

120

Microsoft SQL Server 2012

110

Microsoft SQL Server 2008 R2

100

Microsoft SQL Server 2008

100

Microsoft SQL Server 2005

90

 

Hope this helps.

  • Cheers,
  • Balmukund Lakhani
  • Twitter @blakhani
  • Author: SQL Server 2012 AlwaysOnPaperback, Kindle
  • Advertisements

    18 Responses to “Solution: Unable to launch SQL Server Configuration Manager – Invalid class [0x80041010]”

    1. Aman said

      Thanks for sharing. Even i had also faced similar kind of issue in past and it was resolved in the same way.

      Details of MOF file in different SQL Server versions below is very much helpful.

    2. Hi. Is there any link between compatibility number

    3. […] to make sure that we have sqlmgmproviderxpsp2up.mof file present and complied. Refer my earlier blog for using mofcomp to compile the mof […]

    4. montaser mahadi said

      after implement the solution the result is:
      C:\Windows\System32>mofcomp “c:\program files (x86)\microsoft sql server \120\sh
      ared\sqlmgmproviderxpsp2up.mof”
      Microsoft (R) MOF Compiler Version 6.3.9600.16384
      Copyright (c) Microsoft Corp. 1997-2006. All rights reserved.
      File ‘c:\program files (x86)\microsoft sql server \120\shared\sqlmgmproviderxpsp
      2up.mof’ not found!

      • blakhani said

        What is the SQL version? You need to use proper path based on version. “120” is for SQL 2014.

        • Montaser Mahadi said

          I am using sql server 2012 and I used 120 for sql because it computable in sql server 2012, thus what happening to solve this problem and thanks M.s blakhani

    5. montaser mahadi said

      sorry M.r Blakhani i mean 110 not 120

      • blakhani said

        c:\program files (x86)\microsoft sql server \120\

        I am seeing a space between server and \
        can you please fix that and try?

    6. blakhani said

      SQL Server 2012 is actually under 110 folder

    7. sean said

      Wow, thanks for the fix. I run into this error with every server i have running SQL 2008 R2 along side SQL Server 2014 and I try to start SQL Server Configuration Manager 2014, not the 2008 one.

    8. Danish Rajput said

      C:\Windows\system32>mofcomp “C:\Program Files (x86)\Microssoift SQL Server\100\S
      hared\sqlmgmproviderxpsp2up.mof”
      Microsoft (R) MOF Compiler Version 6.1.7600.16385
      Copyright (c) Microsoft Corp. 1997-2006. All rights reserved.
      File ‘C:\Program Files (x86)\Microssoift SQL Server\100\Shared\sqlmgmproviderxps
      p2up.mof’ not found!

      Dear Sir, Kindly help urgent

    9. Danish Rajput said

      C:\Windows\system32>mofcomp “C:\Program Files (x86)\Microssoift SQL Server\100\S
      hared\sqlmgmproviderxpsp2up.mof”
      Microsoft (R) MOF Compiler Version 6.1.7600.16385
      Copyright (c) Microsoft Corp. 1997-2006. All rights reserved.
      File ‘C:\Program Files (x86)\Microssoift SQL Server\100\Shared\sqlmgmproviderxps
      p2up.mof’ not found!

    10. Armstrong said

      Worked for me!

    11. Luke said

      I am having the same problem with Microsoft server 2016. Any idea’s??

    Leave a Reply

    Fill in your details below or click an icon to log in:

    WordPress.com Logo

    You are commenting using your WordPress.com account. Log Out / Change )

    Twitter picture

    You are commenting using your Twitter account. Log Out / Change )

    Facebook photo

    You are commenting using your Facebook account. Log Out / Change )

    Google+ photo

    You are commenting using your Google+ account. Log Out / Change )

    Connecting to %s

     
    %d bloggers like this: