Lets start with a simple issue that I have struggled with a few times. I try to start SQL Server Configuration Manager and is met with this puzzling message:

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]
Who cannot appreciate a error message blaming someone else for their mess?

The Internet list many culprits and most agree that WMI is not to blame this time. Exactly what causes the error seems to be somewhat random. Someone blames 32 vs. 64-bit mixed installations. I have experienced it after patching or installing multiple different instances on the same server, or even just patching an instance. Lets all agree it is caused by change of some kind.


Usually this issue is rather easy to resolve. Open CMD as administrator and type (copy) the following (take care to replace 000 with your SQL Server version number (check the table below if you are uncertain). If you also installed SQL Server to some other location than the “Program Files” folder you will have to correct that in the statement below.

mofcomp "%programfiles(x86)%\Microsoft SQL Server\000\Shared\sqlmgmproviderxpsp2up.mof"

If you have the simple problem, then this will resolve your issue, and it might look something like the screenshot below. Your luck might vary. If the the easy to remember file name sqlmgmproviderxpsp2up.mof is not in the catalog, you might need to search a bit on your server to see if you have it lying around somewhere else.

If you do not recall version number, there is a list below. However you are always welcome to do as me and impress someone looking over your shoulder by trying and failing a few times.

SQL Server list of versions

Version NameVersion Number

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s