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

/error-cannot-connect-to-wmi-sql-server-configuration-manager-min.png

How do I resolve the above error?


Asked by:- neena
1
: 4323 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

cannot-connect-to-wmi-provider-min.png

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.

OR

If above solution doesn't work you can also uninstall the instance and reinstall a fresh instance. 

1
At:- 9/2/2020 3:34:55 PM Updated at:- 12/1/2022 6:52:27 AM


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

Thanks

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






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

Full Name *

Email *




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