SQL Server Configuration Manager WMI Error

Zack
Zack used Ask the Experts™
on
Hi EE,

I am getting the error which is described in this article:

http://tritoneco.com/2014/05/15/fix-sql-configuration-manager-cannot-connect-to-wmi-provider/

However when I apply the 'fix' described I get the following error message:

C:\Program Files\Microsoft SQL Server\90\Shared>mofcomp sqlmgmproviderxpsp2up.mo
f
Microsoft (R) 32-bit MOF Compiler Version 5.2.3790.3959
Copyright (c) Microsoft Corp. 1997-2001. All rights reserved.
Parsing MOF file: sqlmgmproviderxpsp2up.mof
MOF file has been successfully parsed
Storing data in the repository...
An error occurred while processing item 1 defined on lines 4 - 7 in file sqlmgmp
roviderxpsp2up.mof:
Error Number: 0x80041003, Facility: WMI
Description: Access denied
Compiler returned error 0x80041001

C:\Program Files\Microsoft SQL Server\90\Shared>

What permissions are causing this error to occur?

Any assistance is welcome.

Thank you.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
Zack, instead of providing us an article, I think it will be better if you provide us the information of what you originally tried to do for the error being thrown?
ZackGeneral IT Goto Guy

Author

Commented:
HI Vitor,

Can do please see the attached screenshot of the error message.

Thank you.
WMI-Error-message.PNG
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
That's the error message and we already know about it. My question is what kind of operation you're doing for the error appear.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

ZackGeneral IT Goto Guy

Author

Commented:
Hi Vitor,

In CMD I navigated to the C:\Program Files\Microsoft SQL Server\90\Shared folder
and ran the command: mofcomp sqlmgmproviderxpsp2up.mof

Error message:

Microsoft (R) 32-bit MOF Compiler Version 5.2.3790.3959
Copyright (c) Microsoft Corp. 1997-2001. All rights reserved.
Parsing MOF file: sqlmgmproviderxpsp2up.mof
MOF file has been successfully parsed
Storing data in the repository...
An error occurred while processing item 1 defined on lines 4 - 7 in file sqlmgmp
roviderxpsp2up.mof:
Error Number: 0x80041003, Facility: WMI
Description: Access denied
Compiler returned error 0x80041001

Thank you.
ZackGeneral IT Goto Guy

Author

Commented:
Hi Vitor,

Additional I was running in CMD as the administrator.

Thank you.
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
Ok.
Did you try to open the CMD prompt as Administrator? Usually this will give you admin rights and it may solve the access denied issue.
ZackGeneral IT Goto Guy

Author

Commented:
Hi Vitor,

I did open the CMD prompt as Administrator.

Thank you.
IT Engineer
Distinguished Expert 2017
Commented:
I don't know what MOF is so I went to check MSDN article about it and found that you also have a version in %Windir%\System32\wbem. Did you try to run from that version instead the one that's in SQL Server folder?
ZackGeneral IT Goto Guy

Author

Commented:
That got it running the mofcomp.exe command that from that folder fixed the issue.

Thank you.
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
So it might be some incompatible issue.
ZackGeneral IT Goto Guy

Author

Commented:
Hi Vitor,

I presume so it's old box. In either case, it's overdue for an OS install and upgrades.

Thank you.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial