Freigeben über

"SQL Server Configuration Manager" gives "Invalid class [0x80041010]” when starting.

  • Artikel

Ok, so it happened  to me again today.  

I simply wanted to open the SQL Server Configuration Manager.    

Start -> Microsoft SQL Server 2008 -> Configuration Tools -> SQL Server Configuration Manager

and was greeted with the following error:

”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]”

For some reason I always forget how to fix this. So time to write it down (and share it).
Simply start a command prompt (as administrator) and navigate to:

"C:\ProgramFiles(x86)\MicrosoftSQLServer\100\Shared\"

then run:

mofcomp sqlmgmproviderxpsp2up.mof

this should give an output like so:

C:\Windows\system32>cd "C:\Program Files (x86)\Microsoft SQL Server\100\Shared\"

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

and SQL Server Configuration Manager should start fine.

Comments

  • Anonymous
    May 14, 2012
    Thanks a lot .. we have experienced similar issue and this article helped me to resolve this..Thanks Michael

  • Anonymous
    December 13, 2012
    thanks for this solution! works for me! :)

  • Anonymous
    March 08, 2013
    Thanks.  Come across the same thing on a brand new setup of win2012 and sql2012.  This fixed my problem.

  • Anonymous
    December 20, 2013
    Please change the path to "C:Program Files (x86)Microsoft SQL Server110Shared" For SQL Server 2012 SP1 Thanks Rajesh Sarathy

  • Anonymous
    December 21, 2013
    I run cm mofcomp sqlmgmproviderxpsp2up.mof success but still not fix this error

  • Anonymous
    April 29, 2014
    Hi I have sql 2008R2 on 64 bit system but do not have the mofcomp sqlmgmproviderxpsp2up.mof file and getting the same errors stated here by others. I can not get the SQL Server Configuration Manager working. Can someone please post a link to a secure  download site for the mop file. Many thanks

  • Anonymous
    May 21, 2014
    Hi I have sql 2008R2 on 32 bit system but do not have the mofcomp sqlmgmproviderxpsp2up.mof file and getting the same errors stated here by others. I can not get the SQL Server Configuration Manager working.

  • Anonymous
    July 01, 2014
    Thanks Michael you are a life saver,was experiencing the same issue with my 2012 CLUSTER,it works perfect now

  • Anonymous
    July 29, 2014
    Huge Help! If you have a different version i.e. SQL2012, I found the *.mof file in a different directory.  In my case C:Program Files (x86)Microsoft SQL Server110Shared.

  • Anonymous
    October 20, 2014
    Thanks a lot for the tip. This saved me a fair bit of time and headache.

  • Anonymous
    November 30, 2014
    So what do you do when this doesn't work?  (Configuration Manager was working until this morning)  No uninstall/install since the initial install of 2012 SP1. I ran the following as Administrator and I still get the error. C:Program Files (x86)Microsoft SQL Server110Shared>mofcomp sqlmgmproviderxpsp2up.mof Microsoft (R) MOF Compiler Version 6.1.7600.16385 Copyright (c) Microsoft Corp. 1997-2006. All rights reserved. Parsing MOF file: sqlmgmproviderxpsp2up.mof MOF file has been successfully parsed Storing data in the repository... Done!

  • Anonymous
    February 04, 2015
    Thanks, used this on a SQL 2012 server, worked like a charm!  Thanks for sharing! C:WindowsSystem32wbemmofcomp C:WindowsSystem32wbemmofcomp sqlmgmproviderxpsp2up.mofsqlmgmproviderxpsp2up.mof

  • Anonymous
    February 13, 2015
    Correct for SQL 2012, run cmd as Admin, paste into command window: C:WindowsSystem32wbemmofcomp "C:Program Files (x86)Microsoft SQL Server110Sharedsqlmgmproviderxpsp2up.mof"

  • Anonymous
    April 05, 2015
    Good..

  • Anonymous
    April 05, 2015
    MSSQL 2014 . I ran the following as Administrator and I still get the error. C:Program Files (x86)Microsoft SQL Server120Shared>mofcomp sqlmgmproviderxpsp2up.mof Microsoft (R) MOF Compiler Version 6.1.7600.16385 Copyright (c) Microsoft Corp. 1997-2006. All rights reserved. Parsing MOF file: sqlmgmproviderxpsp2up.mof MOF file has been successfully parsed Storing data in the repository..

  • Anonymous
    July 20, 2015
    Thanks. For SQL 2014, use this folder location. C:Program Files (x86)Microsoft SQL Server120Shared.

  • Anonymous
    August 30, 2015
    Hi I couldnt find the location in the SQL 2014. please advice. In my setup im trying to monitor the sccm 2012 servers and SQl DB(2014) servers. all the sccm servers are monitoring but SQL 2014 servers are not monitored.Thanks In Advance.

  • Anonymous
    September 13, 2015
    thanks mate, saved me a lot of time

  • Anonymous
    January 06, 2016
    I Have no clue what this command prompt actually did but it worked like a charm... :) thx