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

Extended support for SQL Server 2005 ended on April 12, 2016

If you are still running SQL Server 2005, you will no longer receive security updates and technical support. We recommend upgrading to SQL Server 2014 and Azure SQL Database to achieve breakthrough performance, maintain security and compliance, and optimize your data platform infrastructure. Learn more about the options for upgrading from SQL Server 2005 to a supported version here.

Symptoms
On a 64-bit computer, you install an instance of the 32-bit (x86-based) version of Microsoft SQL Server. 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]

This problem also occurs if you uninstall the 32-bit instance, and you then open SQL Server Configuration Manager.
Cause
This problem occurs because the WMI provider is removed when you uninstall an instance of SQL Server. The 32-bit instance and the 64-bit instance of SQL Server share the same WMI configuration file. This file is located in the %programfiles(x86)% folder.
Workaround
To work around this problem, open a command prompt, type the following command, and then press ENTER:
mofcomp "%programfiles(x86)%\Microsoft SQL Server\number\Shared\sqlmgmproviderxpsp2up.mof"
Note For this command to succeed, the Sqlmgmproviderxpsp2up.mof file must be present in the %programfiles(x86)%\Microsoft SQL Server\number\Shared folder.

The value of number depends on the version of SQL Server:nnn

Microsoft SQL Server 2012110
Microsoft SQL Server 2008 R2100
Microsoft SQL Server 2008100
Microsoft SQL Server 200590
After you run the Mofcomp tool, restart the WMI service for the changes to take effect. The service name is Windows management Instrumentation.


Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
More information
Installing a 32-bit instance of SQL Server 2008 in a 64-bit cluster environment is not supported. For more information about the Microsoft SQL Server support policy, click the following article number to view the article in the Microsoft Knowledge Base:
327518 The Microsoft SQL Server support policy for Microsoft Clustering
For additional information about Managed Object Compiler (Mofcomp) tool, consult the following page on MSDN:

http://msdn.microsoft.com/en-us/library/windows/desktop/aa392389(v=vs.85).aspx


x64 wow SQL2008RelNoteSetupConfiguration SQL2008RelNoteConfiguration
Properties

Article ID: 956013 - Last Review: 08/19/2013 20:08:00 - Revision: 4.0

Microsoft SQL Server 2005 Standard Edition, Microsoft SQL Server 2008 Standard, Microsoft SQL Server 2005 Enterprise Edition, Microsoft SQL Server 2005 Workgroup Edition, Microsoft SQL Server 2005 Developer Edition, Microsoft SQL Server 2008 Standard Edition for Small Business, Microsoft SQL Server 2008 Enterprise, Microsoft SQL Server 2008 Developer, Microsoft SQL Server 2012 Standard, Microsoft SQL Server 2012 Enterprise, Microsoft SQL Server 2012 Developer

  • sql2008relnoteconfiguration sql2008relnote kbtshoot kbexpertiseadvanced kbprb KB956013
Feedback