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
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.
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.
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.
blakhani said
Thanks Aman.
bharathpammiramesh said
Hi. Is there any link between compatibility number
blakhani said
I didn’t understand the question.
Solution : SQL Server Configuration Manager – Cannot connect to WMI provider – Provider load failure [0x80041013] « Help: SQL Server said
[…] to make sure that we have sqlmgmproviderxpsp2up.mof file present and complied. Refer my earlier blog for using mofcomp to compile the mof […]
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
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?
blakhani said
SQL Server 2012 is actually under 110 folder
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.
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
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!
Armstrong said
Worked for me!
Armstrong said
PS, had to change 120 to 130, but not a problem. Thanks for posting!
Luke said
I am having the same problem with Microsoft server 2016. Any idea’s??
blakhani said
you need to change the path to proper version.
Immortal said
I ran this command as recommended: mofcomp “C:\Program Files (x86)\Microsoft SQL Server\120\Shared\sqlmgmproviderxpsp2up.mof”
I am now getting this error message:
MOF file has been successfully parsed
Storing data in the repository…
An error occurred while processing item 10 defined on lines 73 – 79 in file C:\Program Files (x86)\Microsoft SQL Server\120\Shared\sqlmgmproviderxpsp2up.mof:
Compiler returned error 0x80070005Error Number: 0x80070005, Facility: Win32
Description: Access is denied.
Can you please help me out, been 2 weeks sited with this problem
blakhani said
Make sure you are running it via elevated command prompt. “Run As Administrator” should be used.
Sonu Paswan said
Hi blakhani
Im facing the same error. Please get me out of it. How can i fix this error.
blakhani said
what happens when you follow the steps?
צקןרשהץרשאי said
You saved me! I was banging my head on this problem, and here this beautiful simple guide saved me. THANK YOU!!
Paul said
Hi, Has any one else had any further help I am getting the same error…..An error occurred while processing item 10 defined on lines 73 – 79 in file C:\Program Files (x86)\Microsoft SQL Server\120\Shared\sqlmgmproviderxpsp2up.mof….. please I am desperate
chirag prajapati said
HI,
Finally solve my issue this is good blog for us.
Thanks
Yusuf selcuk said
https://www.tek-tips.com/viewthread.cfm?qid=1432655
Microsoft (R) 32-bit MOF Compiler Version 5.2.3790.1830
Copyright (c) Microsoft Corp. 1997-2001. All rights reserved.
Parsing MOF file: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlmgmpr
oviderxpsp2up.mof
MOF file has been successfully parsed
Storing data in the repository…
An error occurred while opening the namespace for object 1 defined on lines 4 –
7:
Error Number: 0x80070005, Facility: Win32
Description: Access is denied.
Compiler returned error 0x80070005
I Google’d that error and ran across a thread on another forum that said to check the access and launch permissions via “Dcomcnfg”. I did that and it looked okay to me. Here’s what is set via Component services –> Computers –> Configure My Computer :
CODE
Access Permissions:
Edit Limits –> ANONYMOUS LOGON has Local Access and Everyone has Local and Remote Access
Edit Defaults –> SYSTEM, INTERACTIVE, NETWORK all have Local and Remote Access permissions
Default Launch Permissions:
Edit Limits –> MACHINE\Administrators has Local and Remote Launch, Local and Remote Activation. Everyone has Local Launch and Local Activation)
Edit Default –> SYSTEM, INTERACTIVE, NETWORK all have Local and Remote Launch permissions, as well as Local and Remote Activation
TroyQ79 said
I am getting this same error, and I am running as Administrator CMD. Has anyone got a solution? Please
MOF file has been successfully parsed
Storing data in the repository…
An error occurred while processing item 10 defined on lines 73 – 79 in file C:\Program Files (x86)\Microsoft SQL Server\120\Shared\sqlmgmproviderxpsp2up.mof:
Compiler returned error 0x80070005Error Number: 0x80070005, Facility: Win32
Description: Access is denied.
Peyman said
Thanks a lot! it helps 🙂
riya said
i follow the steps and executed mofcomp “C:\Program Files (x86)\Microsoft SQL Server\120\Shared\sqlmgmproviderxpsp2up.mof” this
bu still it gives sqlmgmproviderxpsp2up.mof not found even it exist in 120/shared folder i have 2014 ssms and windows 10
Baleseng said
thanks man ,this is working form..
Ali said
Thank you so much.
Also, in SQL server 2019:
mofcomp “C:\Program Files (x86)\Microsoft SQL Server\150\Shared\sqlmgmproviderxpsp2up.mof”
(“150″‘s directory) is right.