Error message when you open SQL Server Configuration Manager in SQL Server 2008: “Cannot connect to WMI provider. You do not have permission or the server is unreachable”

Symptoms

On a 64-bit computer, you install an instance of the 32-bit (x86-based) version of Microsoft SQL Server 2008. On the same computer, you install an instance of the 64-bit version of SQL Server 2008. If you then uninstall the 64-bit instance, you receive the following error message when you open SQL Server Configuration Manager:

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]

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
Cause:

This problem occurs because the WMI provider is removed when you uninstall an instance of SQL Server 2008. The 32-bit instance and the 64-bit instance of SQL Server 2008 share the same WMI configuration file. This file is located in the %programfiles(x86)% folder.

Resolution:

To work around this problem, type the following command, and then press ENTER:

mofcomp “%programfiles(x86)%\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof”

Note: For this command to succeed, the sqlmgmproviderxpsp2up.mof file must be present in the %programfiles(x86)%\Microsoft\Microsoft SQL Server\100\Shared folder.


<<Click here to see all posts>>

1 comment on “Error message when you open SQL Server Configuration Manager in SQL Server 2008: “Cannot connect to WMI provider. You do not have permission or the server is unreachable””

  1. Jayesh Shetty Reply

    The same is observed in Windows Server 2012 R2 with SQL Server 2012 SP2 with latest patches . But as per the above scenario i have not removed or uninstalled SQL Server but I am still getting the same error. The above solution has been already been applied still the errror is persistent.

Leave a Reply

Your email address will not be published. Required fields are marked *

Prove You Are Human Time limit is exhausted. Please reload CAPTCHA.