Unable to access sql server configuration manager

I run on win 7 32 bit.

• open CMD and run :

  cd "C:\Program Files\Microsoft SQL Server\110\Shared"
  

• Then Run :

  mofcomp sqlmgmproviderxpsp2up.mof
  

If You run at win 64, the directory is different

Possible SQL version’s shared directory:

SQL 2008:  C:\Program Files (x86)\Microsoft SQL Server\90\Shared\
SQL 2008 R2:  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\

That's how port depicts your Sql version:-

 -80 = SQL Server 2000    
 -90 = SQL Server 2005   
 -100 = SQL Server 2008    
 -105 = SQL Server 2008 R2 
 -110 = SQL Server 2012    
 -120 = SQL Server 2014    
 -130 = SQL Server 2016   

1. Open Command prompt with Admin rights.
2. Generic command for all version:

mofcomp "%programfiles(x86)%\Microsoft SQL Server\[Number]\Shared\sqlmgmproviderxpsp2up.mof"

if you have SQL Server 2008 R2, please provide 105 instead of [Number].

Hope so it will help

These Are Steps Recorded By 'Steps Recorder' In Window 10 These Might Also Work In Windows 8

Step 1: User right click on "Start (list)"

Step 2: User left click on "Command Prompt (Admin) (menu item)"

Step 3: User left click on "Administrator: Command Prompt (window)" in "Administrator: Command Prompt"

Step 4: User keyboard input on "Administrator: Command Prompt (window)" in "Administrator: Command Prompt" [...]

Step 5: Type 'mofcomp '

Step 6: User right click on "Start (list)"

Step 7: User left click on "Run (menu item)"

Step 8: User left click on "Open (button)" in "Run"

Step 9: User left click on "C:\Program Files (x86)\Microsoft SQL Server (list item)"

Step 10: User left click on "OK (button)" in "Run"

Step 11: User left click on "Search Box (edit)" in "Microsoft SQL Server"

Step 12: User left click on "Sqlmgmproviderxpsp2up.mof (text)"

Step 13: User left click on "Name (edit)" in "Sqlmgmproviderxpsp2up.mof - Search Results in Microsoft SQL Server"

Step 14: User left click on "Home (tab item)" in "Sqlmgmproviderxpsp2up.mof - Search Results in Microsoft SQL Server"

Step 15: User left click on "Copy path (button)" in "Sqlmgmproviderxpsp2up.mof - Search Results in Microsoft SQL Server"

Step 16: User left click on "Administrator: Command Prompt (list item)"

Step 17: User right click on "Administrator: Command Prompt (window)" in "Administrator: Command Prompt"

Step 18: User left click on "Paste (menu item)"

Step 19: User keyboard input on "Administrator: Command Prompt (window)" in "Administrator: Command Prompt" [Enter]

Step 20: User left click on "Close (button)" in "Administrator: Command Prompt"

Guys I Suggest you to go to your "Microsoft SQL Server" folder in "C:\Program Files (x86)" and then go to all folders of "Microsoft SQL Server" Microsoft SQL Server

and check for "Shared" folder and if you found "sqlmgmproviderxpsp2up.mof" this file in your "Shared" folder then you have to copy the folder directory URL and open cmd(as Admin) and write "cd(space)" and paste your directory URL and press enter after just write "mofcomp sqlmgmproviderxpsp2up.mof" hope this will work enjoy and sorry for bad English.

Probably easiest is to completely remove all traces of SQL Server and start over. Save yourself some time by doing it this way:

https://sqlblog.org/2010/10/25/fun-with-software-uninstalling-sql-server-2008-r2-evaluation-edition

This thread on super user might help with the WMI problem (though that just might be a permissions issue or you've stopped the wmi service):

https://superuser.com/questions/190960/repair-wmi-on-windows-7

I got this error too and just for a laugh I decided to run my command line window in administrator mode.

Funnily enough, it worked! Not knowing what your user privilege setup looks like I can't really say that this is a definitive fix for it though

• Open CMD.exe as Admin
• Type this code mofcomp "%programfiles(x86)%\Microsoft SQL Server\140\Shared\sqlmgmproviderxpsp2up.mof" and press Enter
• Start your SQL Srever Configuration Manager

140 is the name of one of my SQL Server 2017 Folders. Replace it before using this code

I was unable to find the Shared folder on last version 17, I went into 140 but there was not Shared.

So I made a search on disk C: ant it turned to be on Program Files (x86)

So be aware of the installation path you choose to run this.

After run the command this will be the windows you will see:

If you are seeing this error

File 'sqlmgmproviderxpsp2up.mof' not found!

Then go to

C:\Program Files (x86)\Microsoft SQL Server

and check which folder has 'sqlmgmproviderxpsp2up.mof' file

In my case I have installed sql server 2017 so the file was inside 'sqlmgmproviderxpsp2up.mof' this folder

C:\Program Files (x86)\Microsoft SQL Server\140\Shared

Finally

C:\Program Files (x86)\Microsoft SQL Server\140\Shared

then

mofcomp sqlmgmproviderxpsp2up.mof

Alternatively

Go to run command type services.msc find Service Agent right click and Start