Monday, December 12, 2016

SSMS vNext and "Cannot connect to WMI provider"

Problem:  


After installing SQL Server Management Studio for vNext, the Configuration Manager no longer opens, with a message similar to the following:


             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]



Steps to correct:



  1. Search for the file:  sqlmgmproviderxpsp2up.mof
    You will probably find it in the folder:

       C:\Program Files (x86)\Microsoft SQL Server\140\Shared

  1. Run the following command, adjusted using the file location from the search above.

    C:\WINDOWS\system32>mofcomp "%programfiles(x86)%\Microsoft SQL Server\140\Shared\sqlmgmproviderxpsp2up.mof"



Based on Microsoft support - kb966013: