Tim Huffam

Dotting the I and crossing the T of I.T.
  Home  |   Contact  |   Syndication    |   Login
  139 Posts | 0 Stories | 1365 Comments | 659 Trackbacks

News

Archives

Post Categories

Interesting Blogs/Links

Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC.

Upon clicking on the SQL Server Enterprise Manager shortcut the following error occurs:

MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC.
This may be because the file does not exist, is not an MMC console, or was created by a later version of MMC. This may also be because you do not have sufficient access rights to the file.

The msc file did exist and I definately has permissions to it.  So I can only assume it some how got corrupt.

The solution to this is fairly simple... either get another copy of this file, or create one, as follows:

  1. Select Start - Run.
  2. At the Open prompt enter: mmc
  3. Click OK
  4. Select File - Add/Remove Snap-in...
  5. Click Add...
  6. Select Microsoft SQL Enterprise Manager
  7. Click Add, then Close
  8. Click Ok to return to the mmc.
  9. Select File - Save As...
  10. Delete or rename the original (offending) file out the way.
  11. Save the new msc file as C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC

Now your original shortcut should work.

Alternatively you can always access Enterprise Manager from within the Computer Management mmc.

HTH

Tim

posted on Tuesday, August 09, 2005 12:23 PM

Feedback

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 8/29/2005 9:13 AM Ajan
Thanks a lot. It works

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 9/8/2005 4:31 PM Jon Pastor
Worked like a charm! MS support site was (surprise) totally uninformative, and other sites recommended exhaustive searches for spyware, trojans -- fine, but not to the point.

Thanks!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 9/22/2005 12:54 PM pete
that didn't work for me but this did....

at command-line:

RegSvr32 MSXML.DLL
RegSvr32 MSXML2.DLL
RegSvr32 MSXML3.DLL

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 9/26/2005 6:05 AM f siebert
Another rescued says "Thanks"!!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 10/10/2005 8:58 AM ummm...
had the same problem, not sure why the file got corrupted but its working again now... thanks!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 10/12/2005 8:37 AM Sergey
Thank you very much. I've spent a lot of time trying to solve this problem. No success! Your recommendation solved the problem. By the way, I see that corrupted "SQL Server Enterprise Manager.MSC" had size 49,5 KB (50 688 bytes) and the resored - 30,1 KB (30 877 bytes). I tried to reinstall MS SQL server, but the "SQL Server Enterprise Manager.MSC" appeared again as a coruupted MMC. What is the reason? Who corrupts the "SQL Server Enterprise Manager.MSC"?

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 10/17/2005 7:07 AM jeje
very good tip

Thanks

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 10/18/2005 10:02 AM master
thanks a lot!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 11/3/2005 7:25 AM Sandeep
Thanks a ton !

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 11/4/2005 2:02 PM Caroline
Was going great guns until I tried to save it... I'm getting an error when I try to save - saying 'MMC cannot save the console' - any ideas? Thanks guys...

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 11/13/2005 12:56 AM Tullio Demasi - Brazil
Thank you very much for your tips.
The regsvr method worked well form me.
I was almost totally mad with this problem.
I tried all, but nothing worked. I have even reinstalled windows xp, but didnt work.

THAN YOU VERY MUCH!!!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 11/17/2005 9:09 AM Nick Van Raven
Thanx, megathanx for re-xml-ing ;)

fu##ing dumb micro$oft @rights management client" is reason, I think...

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 11/18/2005 8:10 AM NCT
anather saved soul. Thanks a lot.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 11/28/2005 6:14 PM Kevin
Thanks Pete. This happened to me after installing Goldmine 7.0.. The registering did it for me as well.. Thanks:)

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 11/29/2005 2:04 AM Kihtrak
Thanks for the tip! It worked great...

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 12/8/2005 1:09 AM Greg
Thank you!!! Your tip saved my school project that I have been working on for the past 7 weeks!!!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 12/12/2005 5:55 PM Rick H.
Thanks so Much!!!!!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 12/13/2005 11:03 AM Ciprian Ionut Lozonschi
thanks a lot pete.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 12/21/2005 7:08 PM Steve C
Very nice, Thanks alot for your work

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 12/23/2005 3:06 AM Mal
This had all our team stumpted. The only way was to format HHD & start again. You saved the day dude!!!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 1/5/2006 1:51 PM Gustavo
Thanks Pete!! Great tip.

And my friend Styvens that helped me to find the necessary dependency files.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 1/6/2006 10:56 PM Adaz
Thank your VERY VERY much!! It worked me too!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 1/9/2006 4:16 PM Eric
I was having problems opening any of of the .msc files including services.msc, event viewer. Also, the XP file search (Start->Search->For Files or Folders) would not launch.

This post helped me realize that I was missing msxml3.dll !!!

Once I found and replaced msxml3.dll, numerous mysterious XP errors seem resolved.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 1/12/2006 3:58 PM David Totzke
Awesome!! Pete the regsvr32 solution nailed it for me! I was going nuts. I'm pretty sure it was Navision Attain that caused the problem in the first place.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 1/22/2006 11:00 PM Marco
Not saying anything that hasn't already been said, but thanks for the fix. I tried it and it worked perfectly. Headache gone !

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 1/24/2006 6:01 AM aussie
regsvr32 did it for me. Thx!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 1/24/2006 2:02 PM Matt
The regsvr32 worked for me as well. Thank you so much. I was about to do something drastic!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 2/8/2006 5:22 AM Ravi
Worked very well for me. Thank you.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 2/11/2006 7:42 AM mueksh
it worked fine Thanks friend.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 2/28/2006 10:45 AM Ronny
Thanks. it worked

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 3/6/2006 8:23 AM Rajesh S. Chandan
Thank you very much for your nice tip. I was thinking to install the whole operationing system. But this worked for me..

Thanks again..

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 3/21/2006 11:56 AM Mobashar Shaffiq
Worked a treat. Appreciated!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 3/22/2006 3:56 AM Paul.C
Help, it has not worked for me, MMC won't let me save the console ... have tried the regsrv32 and still getting the same problem ... any sugestions

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 3/29/2006 5:18 PM Pare
You made my Day!! Thank you very much for the tip.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 4/3/2006 3:39 PM SM
thanks Pete for the re-reg. I was going mad and it saved my day

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 4/11/2006 10:14 AM J.B.
After several days of trying different things, re-installing SQL Server, I finally stumbled into this solution. Thanks very much.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 4/21/2006 10:30 AM Davide Formica
Thank you !!!

# Cannot save MMC file 4/28/2006 6:03 AM Mike
I can add Snap Ins but I cannot save my MMC file

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 5/25/2006 4:46 AM Tejas Jagda
Thanks A Million. It has resovled the issue at first take.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 6/12/2006 3:31 AM Salman Zafar
Thanks a lot , it worked fine for me as well...
Salman Zafar (UET Lahore)

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 6/21/2006 4:30 PM Cathie
This worked for me the first time around! Thanx much, Tim. How much do I owe ya?

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 6/22/2006 7:52 PM Ashraf Nouri
Millions of Thanx

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 6/26/2006 1:21 PM MF-Tech
To resolve this issue, reregister the Msxml3.dll file. To do this, follow these steps:
1. Click Start, click Run, type CMD in the Open box, and then click OK.
2. Type the following command at the command prompt, where C:\Windows is the folder that Windows is installed in, and then press ENTER:
regsvr32 C:\Windows\system32\msxml3.dll
When the command completes successfully, you receive the following message:
DllRegisterServer in C:\Windows\system32\msxml3.dll succeeded.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 7/9/2006 11:02 AM cyril
Hey thanks so much! It saved me a night's worth of time. I reinstalled sql server but it didnt work. Your tip is a time-saver!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 7/11/2006 12:14 PM darksander
thanks siebert.. the re-registering worked like a charm..

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 7/14/2006 12:27 PM gitb
a million thanks

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 7/16/2006 1:31 PM AM
This problem appeared after I've uninstalled Navision Attain "client" ...
I've try:
RegSvr32 MSXML.DLL
RegSvr32 MSXML2.DLL
RegSvr32 MSXML3.DLL
and it worked fine!
Thanks a lot!
Microsoft response is like saying nothing!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 7/20/2006 9:25 AM himanshu
hi.. i tried to open the mmc console add snap in ...but it does not list sql as an available stand alone snap in ...
what to do ?..

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 7/25/2006 5:21 AM Abhi
Good tip. Worked beautifully. Thanks a lot

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 8/4/2006 7:24 AM QP
thx, I reinstalled 3 or 4 times

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 8/16/2006 8:30 AM Abey
Thanks man.. This one will be of gr8 help to many people

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 8/22/2006 3:42 PM Steve Malcolm
This was a big help. Thanks much.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 8/23/2006 1:48 PM Glenn
Running regsvr32 against the msxml3.dll solved the MMC error and the inability to create and save a new mmc. Terrific

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 9/1/2006 5:16 AM DIren
Thanks. Much appreciated.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 9/10/2006 1:06 PM STEVE D
This was a big help. Thanks

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 9/18/2006 7:54 AM Patrick Dupuis
Waouh.; Searching during so many weeks. I was desesperate.
Merci beaucoup..
fantastique !

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 9/27/2006 11:10 PM Charles Schmedling
Excelent help

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 10/2/2006 9:44 AM Rsoni
Many thanks, it worked!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 10/2/2006 1:16 PM Eric
OK pour moi super aide

thank's

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 10/4/2006 7:13 AM Laura
10x a lot, it realy works:)

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 10/12/2006 11:50 PM Tim
THANK YOU !!!!!!!!!!



# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 10/16/2006 8:17 PM nir
u r exceptional..thanks a lott...for a moment i was so scared with stupid microsoft hotfix page i found while googling!! thanks again!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 11/2/2006 2:44 AM Kamal
Thanx. Now it is working fine.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 11/3/2006 12:59 PM Nelik
I LOVE YOU!!! ;)))

After uninstalling Visual J# and .NET SDK I cannot execute no more all services like event viewer, services, etc

I was really near to format everything, since I met this post!!! :))

great, tnx again from Italy
Nelik

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 11/12/2006 8:44 AM Siddiq
Thnx a million bro !!!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 12/11/2006 8:23 AM daniel
thank you

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 12/14/2006 3:50 PM cglaves
Thanks for putting this out, works great now

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 12/21/2006 4:11 AM sudeep and shishira

Our enterprise manager was not accesible ,
ur solution realy worked for us thanks :-)


# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 12/21/2006 6:06 PM Raggaman
Thanks, you really rocks, thank you very much!!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 1/1/2007 6:53 AM Amar
I am neither able to re-register the dll not am I able to open the Enterprise manager from C:\program files\MS SQL Server\80\tools\binn

Can someone please help me

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 1/9/2007 3:37 PM Steve
Thanks for the easy fix. Enterprise Mgr worked up until today, I don't know what happened. But your fix got me back up and running!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 1/12/2007 3:02 PM Ryan
Awesome. You rule!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 1/16/2007 6:21 AM Darko
Yeap. Same problem same solution.
ty

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 1/18/2007 12:03 PM HeV
Thank You It's a good solution!!!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 1/26/2007 3:17 AM HTkhai
Thanks U a lot

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 2/5/2007 7:20 AM AndrewT
Ta muchly

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 2/7/2007 4:11 AM Rob
Great solutions come in small packages. Thanks Tim.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 2/21/2007 5:46 AM Balaji G
Thanks for ur suggestion,its working fine

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 3/4/2007 1:24 PM Ron
You're a genius!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 3/10/2007 3:33 AM T.Kingslin
Thanks for your suggestion,Now it is working fine.



# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 3/12/2007 6:02 PM Angie
Thank you so much for this post!! It saved me LOTS of time and headaches. *muah*

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 3/16/2007 3:39 PM Julie
Tim-- you rock the house! Thankyou!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 3/16/2007 5:30 PM Kevin
You rock! My colleage and I spent hours to find out why and fix it but nothing happened. After I tried you instruction the sql Server Enterprise Manager worked so perfect. Tim,You saved my day!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 3/23/2007 7:41 PM christopher lawless
you are my saviiour


# Cannot save MMC console!!!!!!!!!!!!!!!!!! 3/27/2007 6:55 AM somshekhar
thanks buddy,
I tried 1 to 11 steps but it has not resolved the problem, when tried to save the console it says Cannot save MMC console.
After registering the msxmll3.dll it worked fine. Thanks to all.....
regsvr32 C:\Windows\system32\msxml3.dll


# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 4/3/2007 10:07 AM mouse
very thank you.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 4/9/2007 6:20 PM Huy Chung
Thanks alot for helping me to solve this problem !

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 4/17/2007 12:11 AM parveen tomer
its work now fine like miracle

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 4/25/2007 9:04 AM Daniel Valero
Gracias por la ayuda, no encontraba como solucionar este problema. Desintalé, Reinstalé y nada.

Muchas Gracias.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 4/27/2007 11:09 AM Kampan
Thank You Very Much. It works

# re: Error: MMC cannot open the file C:\windows\system32\inetsrv\iis.msc 5/1/2007 5:13 AM rajesh
i wnat this one to be cleared


"MMC cannot open the file"
c:/windows/system32/inetsvr/iis.msc
this may be because the file does not exist,is not a MMC console,or was created by a later version of MMC. there may also be because you do not have sufficent access rights to the file.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 5/11/2007 8:35 AM kiran
Thanks A Bunch!!
That really helped!!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 5/14/2007 3:57 AM David Source
That got us out of a big hole - thank you.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 5/15/2007 8:24 AM Ramesh Katam
Thanks alot. It saved my time. --- Ramesh

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 5/15/2007 1:30 PM Lucas
Super easy and simple and fixed a big problem. Thank you.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 5/16/2007 9:21 AM Sam
Many thanks - saved us alot of hassle!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 5/24/2007 8:28 AM John Coleman
Thank you very much!!!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 5/24/2007 9:27 PM Donita Bala
Hi!!! Thanks heaps. Worked :-).

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 5/28/2007 7:35 AM VLAD
MAN... .I TRIED A LOT OF "AUTOMATIC TOOLS" THAT NEVER WORKED. THIS WAS AMAZING... SIMPLE AND QUICK. THANK YOU VERY MUCH

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 6/21/2007 6:20 AM Balaji V
Thanks a lots. Now its working fine.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 6/26/2007 4:57 AM manoj
thanks a ton!!!!!!!1111

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 6/27/2007 7:33 PM Goha
Thank you!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 6/29/2007 9:43 AM syed mustafa
hi very very thanks for give this method

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 7/2/2007 7:07 AM Keith Logan
Thanks! you just saved my job!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 7/16/2007 11:47 AM Fabio
We need theese kind of GENIUS in the web!!!
THANK YOU TIM!!!!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 8/2/2007 12:48 PM Chris
You rock - this worked like a charm!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 8/16/2007 11:21 AM Dewayne
Simple and effective... awseome help

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 8/17/2007 9:13 AM James
Thanks, one of the most useful solutions I've seen anywhere on the web. Shows it helps to actually understand how things work rather that just know how to use them.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 8/21/2007 9:19 AM George
The "regsvr32 C:\Windows\system32\msxml3.dll" trick worked like a charm. Thanks a bunch for the tip!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 8/24/2007 5:53 AM jazzy
after step 8 this error came:

The Procedure entry point ?trimright@sstring@qaexx could not be located in the dynamic library SFC.dll

please help

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 8/27/2007 3:52 AM linda
Thanks, it's great.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 8/29/2007 2:51 PM muadib
Great! thanks

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 9/8/2007 3:52 PM Juan Tarte
I try to do what you mention on step 7, but there is no SQL option to select. I have the file on C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC, so i think this is not the problem.

I run the regsvr32 C:\Windows\system32\msxml3.dll and still same, as soon i run the Enterprice Manager I keep same message "MMC could not create the snap-in."

We recently desinstall SQL 2005 because we never use it, our data base ias running on SQL 2000.

Query Analizer and Profiler are running well, Enterprice Manger not, could you help me???

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 9/14/2007 11:12 AM Sbolter
This occurs when you run SQL 2005 and SQL 2000 client tools from the same Server each uses a diff version of the MMC. If you go into your profile undre the documents and Settings folder and delete the MMC folder information for SQL 2005 or the folder for SQL 2005 under you hidden Application folder this tends to fix the problem.


# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 9/20/2007 10:27 AM Monica Sanchez
Thank you very much. My week has been crazy and this fix just work like a miracle. Thanks.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 9/20/2007 12:15 PM yohan rodriguez
thaks!! a looottttt!!!! this solution is great! it save me a lot of time and effort trying to solve this problem!

thank you from acuña mexico! a place for beers and girls.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 10/3/2007 11:02 AM snowshy
man, you are good

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 10/3/2007 4:14 PM Babu
Veerji, tussi great ho (roughly translated from Punjabi, it means that you are great!!). Helped me from a hopeless situation :o)

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 10/6/2007 4:15 AM Jacques Zetune
You didn't save my day, saved my week.
Thank you!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 10/6/2007 6:11 AM ekadim
Thank you very much. When I saw your solution, I said to myself, 'why did I not think it before?'! Anyway, thanks for the hint.

ekadim@Turkey

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 10/15/2007 2:35 AM Prashanth
Thanks a lot ,
i reinstalled SQL but i again got the same and i followed the above , and its works ...

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 10/15/2007 2:11 PM Ryan
Thanks a lot. Last time this happened I un-installed and re-installed MS SQL Server. This is a big time saver.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 10/18/2007 10:54 PM Bhama

When I try to follow the steps you have given above, (mmc on the command prompt, clicking on File, then Add/Remove files) , in the list of programs to select, there is no SQL Enterprise Manager. What does this mean? There is no Query Analyser too.
I would greatly appreciate any help on this as soon as possible, because I have been stuck for days..


# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 10/24/2007 3:12 PM Kit Cargile
delete file "SQL Server Enterprise Manager" under
C:\Documents and Settings\<login ID>\Application Data\Microsoft\MMC

and then try again.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 10/31/2007 3:22 PM ths
you freakin' rock dude. nice, this just saved my arse.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 10/31/2007 11:34 PM Craig Smith
I already new how to do this....I am a champion.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 11/5/2007 1:23 PM harry
Thanks for the EASY fix.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 11/6/2007 6:55 AM Priya
Thanks a lot.

It helped.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 11/15/2007 7:22 AM Warren
Thanks, that was a quick fix to a puzzling problem!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 11/20/2007 4:43 AM Chris
delete file "SQL Server Enterprise Manager" under
C:\Documents and Settings\<login ID>\Application Data\Microsoft\MMC

That solve all my problems, great!!!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 11/24/2007 9:39 PM Tara Danley
THANKS! Saved the day!!! Saved my life.... and prevented on big freak out :)

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 12/3/2007 12:56 AM Akshay
Thanks a Lot

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 1/2/2008 2:00 AM Greg Staples
Thanks. Valuable post with clear instructions that worked. Seeming rarity these days. Congratulations.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 1/3/2008 2:16 PM Majid
Thanks :>

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 1/5/2008 4:33 AM Zainub
Hi Tim,

I am getting the same error but in all the consoles, event, services, sql. I am running on Windows 2003 server and was wondering if the same advice below of registering the mx dll will help me.

To resolve this issue, reregister the Msxml3.dll file. I have seen pple registering the above dll for xp errors..will teh same dll help me in windows 2003 server? Please help me out as i dont know what went wrong and all of a sudden i could not open any consoles and i get teh same error on my win2k3 server.

Thanks in advance

ZL

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 1/7/2008 2:14 PM Tim Jordan
Thank you x 100
Looked all over the net for this (including Microsoft's "Support" Site)
- Tim

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 1/14/2008 7:42 AM Avraham
i tried the RegSvr method with great sucess1 It even restored for me my file search (assistant).
great tip - Pete.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 1/15/2008 4:49 AM Alison Bradbury
brilliant - thank you! I followed your original post instructions and it worked beautifully.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 1/16/2008 5:10 AM Ashish
I had also faced this problem. But now using above steps its fixed. thanks a lot!!!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 1/22/2008 8:46 AM CC
Worked like a charm .. Thanks :)

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 1/28/2008 9:43 AM Matt
Hey there guys I found another solution. I started having the issue shortly after I did a restore of my Domain Controller and had to do some repairs. After trial and error with the steps above I was still unsuccessful...Then I remembered... I had installed the new version of MMC prior to last backup. So I went and downloaded the MMC 3.0 edition again. reinstalled it and there ya go it all works again. Might give that a try and see if it works.

Matt

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 1/31/2008 9:56 AM Stuart
Damn thats fixed the problem, looks like I'll have to do some work again. Cheers

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 2/2/2008 1:23 PM sizo
Cant thank you enough. That worked like a magic. Thanks so much

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 2/3/2008 2:58 AM kaustubh
THANKS a TON!
It worked like a charm

If you are are ever in bahrain.... I'll have a couple of nice cold beers waiting for you!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 2/4/2008 8:49 PM Sharon C
Works for Websphere MQ Explorer too.
Got myself a reputation as a 'super techy guru', fixing this outstanding problem in 5 minutes flat. Thanks to Tim!
Sharon in Australia

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 2/6/2008 11:55 AM Siri
Hi,

I tried to add EM in MMC,but i couldn't find it and any of the regv32 doesn;t work.I am still hungup with the problem..........Could anybody can help me......Thanks in advance

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 2/9/2008 2:44 PM Nick
Thanks for the MMC fix - saved my a@#

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 2/12/2008 5:40 AM ali
thanks a lot....

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 2/13/2008 2:18 PM Don
THANK YOU SO MUCH!!!!!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 2/13/2008 3:26 PM A Tim huffam Fan
3 years later and this is still an issue =) (mine broke after an update, go figure!) thanks for saving me!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 2/13/2008 4:32 PM Erin
Thank you, I asked my co-worker to send me the file but I followed your instructions and I got it to work before my co-worker was able to reply.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 2/19/2008 2:48 AM Randy (The Netherlands)
YAYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY!

Thanks!
And when you look back at it: It's SO easy.....



# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 2/20/2008 9:14 AM james murrell
You had so many thank yous, heres another you just saved my job

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 2/27/2008 5:38 AM Steve
Everyone is so happy! Neither of these approaches worked for me!

When I try and add the snap in I get error: Connection to application object failed. Ensure no program modules have been deleted.

Tried the regserv and still no joy!

Anymore help anywhere?!?!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 3/7/2008 12:11 AM raj
Hi Friends,
my system had sql server 200 installed and i was using it nicely suddenly i could open the enterprise manager, even computer management also. if i type mmc in run it does nto show anything, even i could not run cmd prompt also in my system, please try to solve the problem.

thanks,
raj.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 3/18/2008 6:43 AM phil
great tip! it work for me! thanks a lot!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 3/19/2008 7:00 AM trac
I love you. Thanks!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 4/4/2008 8:16 AM RJB
Had one of the desktop support fellas at my company tell me my computer needed to be re-imaged. Told him to go away before I re-imaged him. Tried this solution. Worked like a charm.

Thankx a bunch. I should forward this to Mr. Re-image but I won't.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 4/13/2008 6:33 AM hodhod
thanks a lot it works

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 4/18/2008 3:47 PM BinDin
Thank you verry much!

# a. Thanks =) 5/1/2008 5:29 AM Jennifer Islas
PERFECT !!

It work´s PERFECT !!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 5/9/2008 8:37 PM vijay
thanks it works for me, when i delete mmc file from
"C:\Documents and Settings\<login ID>\Application Data\Microsoft\MMC"

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 5/9/2008 8:39 PM vijay kumar
thanks it works for me, when i delete mmc folder from
"C:\Documents and Settings\<login ID>\Application Data\Microsoft\MMC"

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 5/12/2008 4:11 AM Roy Goh
Thanks A Zillion!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 5/14/2008 8:06 PM suren
Thank u very much .................

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 5/22/2008 4:21 AM Lukas
Thanks !!!!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 5/23/2008 7:28 PM dattatray jadhav
thanks a lot for solve my problem regarding sql server enterprise manager!!!!!!!!!!!!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 5/24/2008 9:07 AM WolfShade
AWESOME!! Fixed it right up, NO PROBLEMS!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 5/26/2008 6:38 AM rgosal
Can't thank you enough; would have been totally screwed without the help.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 5/29/2008 12:29 AM Frdrik
-Thx a mill... tusen tack!
You made it work so great!!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 5/31/2008 3:37 AM Lauren Glenn
Finally, another Microsoft cryptic error message solved by something so simple. Thx. :)


# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 6/11/2008 8:46 AM Tejas Patel
Thanks this works great.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 6/16/2008 11:55 PM Praveen
Thanks a lot... It worked!!!!!!!!!!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 6/17/2008 5:09 AM anom
Thanks, It saved a lot of my time !!!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 6/19/2008 4:36 PM Rajendra Boddu
Thank your VERY........ much!! It worked for me too!


# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 6/25/2008 7:24 PM coco
thanks Bro...

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 6/25/2008 10:45 PM Sudhi
Thank you very much.It worked for me too.I was about to reinstall SQL Server.Your tip saved my time.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 7/2/2008 8:09 PM sukh
thanks now my prolem is solve

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 7/6/2008 7:46 AM Ade Omoboya
Voila , Perfect Thanks

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 7/11/2008 4:17 AM Anonymous
4. Select File - Add/Remove Snap-in...
5. Click Add...
6. Select Microsoft SQL Enterprise Manager

...
What if Microsoft SQL Enterprise Manager does not exist?

# re: Error: MMC cannot open the file *.MSC. 7/12/2008 4:49 PM anonymous
updated winxp sp2 to sp3 and *.msc files stopped working with error "MMC cannot open the file ... was created by a later version of MMC."

at command-line executed the following as mentioned in the forum:

RegSvr32 MSXML.DLL
RegSvr32 MSXML2.DLL
RegSvr32 MSXML3.DLL

resolved the problem. Thanks a lot


# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 7/19/2008 8:13 PM Fuad Ahmed Hasni
Salute 2 you.. It worked like a charm

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 7/22/2008 3:01 AM P
Absolutely SQLliant!!!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 7/31/2008 12:40 AM govindarajan
thanks a lot. it really worked

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 7/31/2008 10:29 PM Bibhash Mishra
thnks really its a amazing and working fine

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 8/1/2008 1:46 AM Eric Lake
I am another person that does not see Microsoft SQL Enterprise Manager in the list of available snap ins. I have tried all of the things listed here:

Reregister all 3 .dll's
Remove "C:\Documents and Settings\<login ID>\Application Data\Microsoft\MMC"
Copied the .msc from a machine that does work.
Compared versions of mmc.exe with a machine that does work.

I am running Win2k3 with SQL 2000. The system is in a cluster and only one node is seeing this issue.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 8/13/2008 11:05 PM julie
Spent the last two hours reinstalling SQL and I should have just googled first - thank you for the help!! The console route worked just fine for me.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 8/16/2008 2:08 AM Simon
Ta - "Regsvr MSXML3.DLL" just helped me resolve a support call :)

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 8/25/2008 11:37 PM Pravin Chimawekar
Thank you so much...
It works very fine....

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 8/26/2008 8:52 AM Christine
it worked for me - but now i keep getting a message everytime i go to close the manager - Save Console settings to sql server enterprise manager.msc

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 8/29/2008 10:01 PM SIT
Thanks. It work 100%. To remove the message when u close the manager just setting it from File-Option, choose console mode : user mode-full access. And then checked the option [v] do not save change to this console. Save and close it. And then re-open it.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 9/3/2008 6:33 AM maht
It's posts like these that help me look good which results in me getting paid $$$ Thanks a lot!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 9/16/2008 11:14 PM Giovanni Brogi
I think the problem arised after installation of visual studio 2005 with embebbed SQL. Now I've fixed it. thanks!!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 9/22/2008 3:56 PM Sibe
I lost it after installing visio 2003.

Works like magic. Thanks Tim

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 9/26/2008 2:24 AM gho3t
Deleting File from Profile worked for me
Thanks

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 9/30/2008 9:00 PM Prabhat Ranjan
Thanks.It works like a rock!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 10/4/2008 9:07 AM BMF
this worked for me:

A regsvr32.exe to Sqlmmc.dll file which is typically located in the C:\Program Files\Microsoft SQL Server\80\Tools\Binn\ folder fixed the problem for me


# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 10/6/2008 6:50 PM Ashutosh Agrahari
thanks
You have solved my problem
but this is not working with Server2003

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 10/8/2008 10:33 PM Aferdita Thaci
Thank you very much for your tips. You have solved my problem



# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 10/10/2008 9:26 AM PG
Excellent. It works.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 10/11/2008 7:16 AM anthony
this worked but every time i am closing enterprise manager i am being prompted to save changes to console

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 10/16/2008 4:43 AM cm
Thank you -- worked perfectly for me

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 10/17/2008 11:40 AM PATEL_POWER
Thanks!! Worked for me. It asks me to save changes every time. I don't mind, there are other microsoft bugs bothers me more.. :-)

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 10/17/2008 4:52 PM antoni
Thank's... God Bless u..... Success 4 u...

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 10/17/2008 11:33 PM Alan Davidson
wowwwwwwwwwwwwwwwwwww! it really works!
thanks alot :-)

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 10/26/2008 3:00 AM tuekc
thanks very much.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 10/28/2008 2:12 PM vish
Thanks alot..mmc thing worked very well..it gives different look than original SQL EM.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 10/31/2008 5:33 PM TungTh
Thanks alot. Such a good tip

# mmc cannot open the file c:\windows\system32\inetsrv\iis.msc. 11/1/2008 1:10 AM ambadas
Please guide me

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 11/8/2008 5:13 PM marias
Its, very useful and THANQQQQQQQ very much

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 11/14/2008 4:26 AM Patrick
This advice works great on 32-bit operating systems. However, on 64-bit operating systems, such as MS Windows Server 2003, the 'Microsoft SQL Enterprise Manager' plugin doesn't appear as an option in MMC and RegSvr32 doesn't help. I believe this is because MS SQL Server is installed as a 32-bit program on a 64-bit OS. I did some further research and discovered that on 64-bit OSs one needs to run MMC in 32-bit mode.

If your OS is 64-bit, add the '/32' argument in step 2 of Tim's original post:

2. At the Open prompt enter: mmc /32

This will run MMC in 32-bit mode. You can then follow the remaining steps to save a new SQL .MSC file.

My error message looked like this:

MMC cannot open the file C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\SQL Server Enterprise Manager.MSC.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 11/18/2008 6:41 PM Darshan Gooneratne
Thank you very much for your tips.
The regsvr method worked well form me.
I tried all, but nothing worked.
Keep up the good work

THAN YOU VERY MUCH!!!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 12/1/2008 6:54 PM Abhijeet
thanks a lot ...................

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 12/3/2008 9:31 PM Zinabu Dargie
It Works perfectly

Thank you very much


# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 12/15/2008 10:03 PM programmer
thanks, life saver

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 1/2/2009 6:17 PM Hemant Kamble
Thnx a lot....this is great solution.It worked.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 1/10/2009 5:28 AM Ramdass
Thanks Dude.... Saved my ass after so much struggle.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 1/12/2009 11:48 PM Abdul Mahboob Waziry
Thank you very much for this tip you know thrught this tip i fixed my kaspersky administration kit which give problem and the kaspersky team didn't fixed it.

Thank you very much Dude,
Mahboob



# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 1/12/2009 11:49 PM Debasis Chakraborty
You really deserve a BIG thanks

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 1/14/2009 11:40 AM Sandhya
Thank U So Much!!! I had this problem after my computer shut down following a RAM failure.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 1/19/2009 2:43 AM jerry
Thank U Very Much It IS Working

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 1/23/2009 10:18 AM ibrahim
the solution is good:)
Thanks a lot
best regards

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 1/28/2009 2:26 AM Julian Serrano
It worked for me, but the existent shortcut didnt work, i had to make a new one for the new console...

Thanks a lot!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 1/30/2009 9:03 PM free sms
thanks dear
regsvr32 is works for me.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 1/30/2009 11:34 PM Soban
Great job !
Thanks man, it works !

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 2/2/2009 8:03 AM venu
Thank you, good one.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 2/12/2009 3:46 AM Florin
1. regsvr32 does'nt help
2. delete mmc files from profile: same problem
3. tried to install mmc 3.0: impossible because win2003 told me
the current version is better than 3.0!



# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 2/12/2009 5:00 AM Oscar
That worked great! The problem came when uninstalling the SP2, and we couldn't fix it. This worked out great!!! MILLION THANKS!!!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 2/17/2009 7:49 PM Shital
Thank-you. It works.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 2/25/2009 6:52 PM Vibhuti
Thanks loooottttttttttt................

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 2/26/2009 1:15 AM Brightson
Thank you very much guys. you are save my time and money...

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 3/6/2009 6:18 AM rk
I tried adding mmc file as instructions on the top but can not find "Microsoft SQL Enterprise Manager" in list to add. what should I do, repair the Microsoft SQL Enterprise Manager ?
use if regsvr32 did not help either

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 3/27/2009 2:42 AM ani
Thanks Man.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 3/27/2009 5:46 AM Raj Mahi
this was fanytastic and saved me a lot of time and it worked like a charm

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 3/27/2009 11:36 AM JJ
I had to add the plugin to a new mmc console. Copying a working msc and re-registering the dlls did not work.

I did get an error though when installing the enterprise manager tool to my workstation. Something about a string variable not being long enough. Perhaps it has something to do with the path statement?

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 3/31/2009 8:34 AM BYork
Server had 2000 before, I installled 2005, QA rest fine, since then EM "MMC snapin not found"... EM not a option in MMC add/remove options...regsvr 32 the 3 commands , getting EM.msc from different machine, delete from profile, nogo...

WHAT WORKED : Start-run-cmd, RegSvr32 sqlmmc.DLL

THX A LOT , BMF


# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 3/31/2009 11:30 PM Matt Langley
hmmm, same error, possibly same problem, another solution:

Simply rename the .msc file!

This worked for me. I'm going to try your method so that I can open it using it's given name, but if anyone has any further problems with this file, a rename is worth a go. The .msc file itself does not seem to be corrupted, MMC just can't open a file of that name.

I don't know why, but your insight about re-adding it to the console app seems to hint that the console app's setup for this file is corrupted rather than the file itself.

btw, in my case the failure was spontaneous rather than following an unprepared termination or a reboot. I am using the same network profile on 2 PCs and the other one (which was logged off around the time the first PC stopped being able to run Enterprise Manager) does not yet have SQL Server installed so this may have been the cause. We also have regular Delayed Write errors on our network which may have corrupted a file during profile synchronisation.


# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 4/2/2009 12:05 AM NAFEES
THANKS BRU

U A GENIUS

IT WORKED....

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 4/5/2009 8:50 PM sinan
you save me....thanks xoxoxoxox

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 4/7/2009 11:27 PM Dave
BYORK: Thanks for the solution! Your tip about RegSvr32 sqlmmc.DLL did the job!!!!



# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 5/5/2009 8:12 AM Woo
Thanks! I re-registered the 3 dlls and deleted file "SQL Server Enterprise Manager" under
C:\Documents and Settings\<login ID>\Application Data\Microsoft\MMC
and that worked great!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 5/6/2009 12:49 AM epeneth
i dont know how to save the mmc file

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 5/7/2009 6:11 PM HLG
Thanks heaps - used this to solve a similar problem with sqlservermanager.msc.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 5/22/2009 4:58 PM hanuman
thanks! dude

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 5/30/2009 6:09 AM thomas k daniel
what i get is mmc cannot open the file the file doesnt not exist or is not an mmc console or not enough access rights nothing ive tried has worked i got some kinda deal about installing but cannot figure it out

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 6/4/2009 7:00 AM jack c
works great. thanks you!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 6/5/2009 4:45 AM Roger
Thanks ! it was making me crazy ! another microshit bullshit.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 6/5/2009 1:27 AM Ruchir
Thanks - this worked perfectly!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 6/5/2009 12:10 PM Sheila
You saved me, too! Thanks!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 6/11/2009 4:33 AM Amila Perera
Thanks a Lot
The first method worked successfully...

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 6/12/2009 7:35 PM synbad
Thanks a lot.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 6/16/2009 12:17 AM vasanth
thanks a lot
it is worked successfully

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 6/16/2009 10:45 PM Suresh
Thanks I applied the following steps to recover my Enterprise Manager.

Select Start - Run.
At the Open prompt enter: mmc
Click OK
Select File - Add/Remove Snap-in...
Click Add...
Select Microsoft SQL Enterprise Manager
Click Add, then Close
Click Ok to return to the mmc.
Select File - Save As...
Delete or rename the original (offending) file out the way.
Save the new msc file as C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC


# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 6/17/2009 2:28 AM Swanty
Thanks a lot ,

It works fine now :)

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 6/25/2009 4:17 PM Paulette
The weird thing about this is that it happened on a colleague's machine seemingly out of nowhere. After uninstalling and reinstalling SQL 2K and svc pack 4, I added myself to admin group on the machine, did it again, and it worked under my logon. Rejoice. Then, when she logged back into the machine as herself, same problem. Your solution took care of it. You deserve a medal!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 6/29/2009 2:42 AM mma anga
Thanks a lot, it works.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 7/1/2009 2:25 AM Sulaiman
thanks...great job.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 7/3/2009 2:36 AM Mayank Gupta
Thanks Buddy it really amazine and really works.........

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 7/7/2009 1:31 AM Venkatapathi Raju
Thanks a lot.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 7/7/2009 2:20 PM n30x
Great!!! Thanks pal. It work perfectly...

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 7/8/2009 4:01 PM Innocent Bystander
For those who failed all the steps described above. This one will work:

1. Click Start, click Run, type regedit, and then click OK.
2. Locate the following registry subkey:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80\Tools\ClientSetup
3. Right-click the ClientSetup registry subkey, point to New, and then click String Value.
4. Rename the registry subkey that you just created SqlPath, and then press ENTER.
5. Double-click the SqlPath registry subkey, and then type C:\Program Files\Microsoft SQL Server\80\Tools in the Value data box.
6. Click OK, and then close Registry Editor.
7. Click Start, click Run, type regsvr32 "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlmmc.dll", and then click OK.

Source: http://support.microsoft.com/kb/914157


# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 7/16/2009 3:16 AM Damianz
thx a bunch!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 7/21/2009 12:05 PM V
Thanks a lot , i tried to fix it from a year.. with no hope .. it works now

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 8/18/2009 12:52 AM Crystal
Thxs...:) It works!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 8/20/2009 2:22 PM G Money
You the man!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 8/26/2009 10:38 AM iche_careca
FINALLY I FOUND A SOLUTION!!!!!!! IS VERY EASY only do this..
1.- Click on Start
2.- RUN
3.- Ejecute mmc
4.- on mmc console click on archive then en options
5.- Select Disk Clean Up
6.- Click on the button that say, DELETE FILES!!!!
7.- CLOSE MMC console and then you can open ALL MSC Files..
Tested on Windows 2003 Server

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 8/28/2009 12:22 AM Laurence
That sorted it

Thank you

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 9/8/2009 8:45 AM christophe
as all previous
thanks it works perfectly

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 9/12/2009 3:13 AM scizure
MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 9/21/2009 7:33 PM CARLOS STUWE
Is great!!! thanks you very much!! you are fantastic man!!!

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 9/29/2009 7:37 AM Ramith Jaikaran
Worked like a charm
Thanks Man

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 9/29/2009 11:35 PM sulolt
thanks a lot

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 9/29/2009 11:36 PM sulolt
thanks a lot from mos


# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 10/13/2009 12:22 AM klbia
i really works to me.. thanks man .. i thought its not gonna work bcoz a msgbox says failed to initialized something. but thank you..

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 10/21/2009 9:46 AM gigiduru
Thanks dude, it seems that msxml issues on my WIndows XP caused all these.... First Enterprise Manager, then a few hours ago, SQL Server Configuration Manager for SQL 2005.
I had previously installed SP3 on my Win XP box, and then uninstalled it due to SQL Server 2005 installation issues with the msxml version that comes with SP3. Following this, EM and SSCM failed one by one, with this error :)

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 10/28/2009 2:25 AM Kamran Riaz
Thankx millions dear

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 10/28/2009 2:33 AM Thomas Kamau
Woa!
This solution worked for me in no time.
Thonks.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 10/29/2009 11:15 AM essien
Thanks. We're in a terminal server environment and only 1 user was experiencing this problem. Logged in as that user and ran the disk cleanup option, now enterprise manager works for that user again.

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 11/3/2009 12:20 AM maryam shiravi
Thank you for your kindness.
It solved my problem and i saw it has solved many problems from 3 years ago...

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 11/4/2009 2:18 AM jitendra
it worked but when we close manager it asked me to save the changes that we made

# re: Error: MMC cannot open the file C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC. 11/13/2009 2:14 PM Drew
HELP!
I tried the 11 steps listed first, then the 3 regsvr32 commands, then the Disk Cleanup option. Still cannot run SQL 2000 Ent. Mgr.

Post A Comment
Title:
Name:
Email:
Website:
Comment:
Verification: