SQL Server Configuration Manager WMI Error

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.
ZackGeneral IT Goto GuyAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vitor MontalvãoMSSQL Senior EngineerCommented:
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?
0
ZackGeneral IT Goto GuyAuthor Commented:
HI Vitor,

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

Thank you.
WMI-Error-message.PNG
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
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.
0
The Five Tenets of the Most Secure Backup

Data loss can hit a business in any number of ways. In reality, companies should expect to lose data at some point. The challenge is having a plan to recover from such an event.

ZackGeneral IT Goto GuyAuthor 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.
0
ZackGeneral IT Goto GuyAuthor Commented:
Hi Vitor,

Additional I was running in CMD as the administrator.

Thank you.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
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.
0
ZackGeneral IT Goto GuyAuthor Commented:
Hi Vitor,

I did open the CMD prompt as Administrator.

Thank you.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
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?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ZackGeneral IT Goto GuyAuthor Commented:
That got it running the mofcomp.exe command that from that folder fixed the issue.

Thank you.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
So it might be some incompatible issue.
0
ZackGeneral IT Goto GuyAuthor Commented:
Hi Vitor,

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

Thank you.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.