Unable to open SQL Server Configuration Manager

 


cannot connect to WMI provider, you don’t 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]

In order to find the right version number, please check the below table:

SQL Server Version

Version Number

2019

150

2017

140

2016

130

2014

120

2012

110

2008/R2

100

2005

90


  1. The MOF file (sqlmgmproviderxpsp2up.mof) for your SQL instance is found in "%programfiles(x86)%\Microsoft SQL Server\nnn\Shared” folder.
  2.  Open an elevated command prompt, and change the directory to the folder location from Step1.
  3. Then type the following command, and then press ENTER:  mofcomp "%programfiles(x86)%\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof"
  4. After you run the mofcomp tool, restart the WMI service for the changes to take effect. The service name is Windows management Instrumentation.

 

 

 

No comments:

Post a Comment

Popular Posts