Cannot connect to WMI Provider SQL server configuration manager error

I am trying to open SQL server configuration manager, after following this question "How to open sql server configuration manager in windows 10?" and steps to show it on Start menu, but when opening configuration manager getting error pop-up with 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


How do I resolve the above error?

Asked by:- neena
: 2791 At:- 9/2/2020 3:23:28 PM
SQL sql server Cannot connect to WMI provider

2 Answers
profileImage Answered by:- vikas_jk

Open your CMD prompt as an Administrator and execute the below command (example for SQL server 2017 )

C:\WINDOWS\system32>cd C:\Program Files (x86)\Microsoft SQL Server\140\Shared

now, execute

mofcomp sqlmgmproviderxpsp2up.mof

Output should be below


Now you should be able to open SQL server configuration manager.

For other older versions, location for "cd" command must be

SQL 2008: C:\Program Files (x86)\Microsoft SQL Server\100\Shared\
SQL 2012: C:\Program Files (x86)\Microsoft SQL Server\110\Shared\
SQL 2014: C:\Program Files (x86)\Microsoft SQL Server\120\Shared\
SQL 2017: C:\Program Files (x86)\Microsoft SQL Server\140\Shared\
SQL 2019: C:\Program Files (x86)\Microsoft SQL Server\150\Shared\

Cause of error:

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.

At:- 9/2/2020 3:34:55 PM

profileImage Answered by:- bhanu

When you try to run above commands in CMD, always open it in Administrative mode.

  cd C:\Program Files (x86)\Microsoft SQL Server\110\Shared
  cd C:\Program Files (x86)\Microsoft SQL Server\140\Shared
  mofcomp sqlmgmproviderxpsp2up.mof


At:- 6/6/2021 7:07:29 PM

Login/Register to answer
Register directly by posting answer/details

Full Name *

Email *

By posting your answer you agree on privacy policy & terms of use