Friday, July 29, 2016

Cannot connect to WMI - SQL Server Configuration Manager

SQL Server Configuration Manager (an msc plug-in) will not start, with the following 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 namespace [0x8004100e]"

According to MSFT support (support - kb956013), it boils down to a problem with the WMI configuration - makes sense. To fix the problem, in a command prompt, you need to run this command:

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

Where \number\ is a function of the latest version install on the machine. As follows:

Microsoft SQL Server 2016 130
Microsoft SQL Server 2014 120
Microsoft SQL Server 2012 110
Microsoft SQL Server 2012 110
Microsoft SQL Server 2008 R2 100
Microsoft SQL Server 2008 100
Microsoft SQL Server 2005 90

Here are the results after running:

No comments: