I’m back; it has been too long!

So I was stuck attempting to open the SQL Server Configuration Manager Application on my Configuration Manager Server.

Error Below;

Cause;

This problem would have arose when we uninstalled an instance of SQL server; the WMI provider would have been removed during this process. From what I’ve researched, both the 32bit and 64bit instance of SQL Server share the same WMI configuration file.

Location – %programfiles(x86)% directory.

Resolution;

Open a CMD prompt as an Administrator.

Now browse to the following location, which would be the version of SQL you’re using on your SCCM server (or where the DB resides for your SCCM environment).

We’re using SQL 2012 so the directory below responds to our requirements;

cd “c:\Program Files (x86)\Microsoft SQL Server\110\Shared”

Now, once in the appropriate location, run the following command;

mofcomp sqlmgmproviderxpsp2up.mof

We’re now able to re-open the SQL Server Configuration Manager Window!

Hope this is helpful!