Monday, 13 July 2015

SQL Server Configuration Manager - QuickFix - Cannot connect to WMI Provider

Sometimes it reminds of Murphy's Law when people complain about issues which in fact can be solved in a minute or two.

I was working in a environment where my client also have full access to all DB servers, databases like DBA and he sent a weird email stating that SQL Server Configuration manager is not working and the error screen.

It reminded me again that whoever having elevated privileges should have good understanding of the tools they use, otherwise, we end up with disaster sometimes. Somehow my client doesn't have SQL background however he was expert in SharePoint development . And yes, I took this an advantage , somehow convinced him explaining the cause of the issue and explained the consequences having too many people with elevated privileges.

So to my readers, here is the explanation:

By any chance , WMI provider is removed from the server where your installed SQL Server Instance,causes this error.

  1. Open command prompt and
    Navigate to %programfiles(x86)%\Microsoft SQL Server\100\shared  -- SQL Server 2008/R2 
    %programfiles(x86)%\Microsoft SQL Server\110\shared  -- SQL Server 2012
 2. Execute the command - mofcomp sqlmgmproviderxpsp2up.mof

Now try to open the SQL Server Configuration manager, it works.
Have a nice day !!

No comments:

Post a Comment