mO SharemO Share

"Cannot connect to WMI provider..." while opening SQL Server Configuration Manager

SYMPTOMS


While opening SQL Server configuration manager following error may appear.

"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]"


CAUSE


This error occurs as the WMI provider gets uninstalled during previous uninstallation of any SQL Server component from the machine

RESOLUTION


The workaround can be found from the Microsoft support article https://support.microsoft.com/en-in/help/956013/error-message-when-you-open-sql-server-configuration-manager-in-sql-se

  1. To workaround this problem, open a command prompt in Run as Administrator mode, type the following command, and then press ENTER:

    • For 64bit system:

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

    • For 32bit system:

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

    The value of number depends on the version of SQL Server version as mentioned in following table.

    Microsoft SQL Server 2016130
    Microsoft SQL Server 2012110
    Microsoft SQL Server 2008 R2100
    Microsoft SQL Server 2008100



  2. After you run the Mofcomp tool, restart the WMI service for the changes to take effect. The service name is Windows management Instrumentation.

This should resolve your issue, in case you face it again please contact our Ginesys Care portal - https://care.ginesys.in/