• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3723
  • Last Modified:

SQL Server 2000 MMC error

Hello,
I can not get into the Enterprise Manager on the sql server. I tried to uninstall and cleaned out the registry and installed again and it did not help at all i keep getting this error message I am using SQL Server 2000
There is no error number

MMC cannot open the file C:\Programs Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC
This may be because the file does not exist, is not a 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.
 
I was wondering if you know how i could solve this problem?
0
jvoros1
Asked:
jvoros1
  • 3
  • 3
  • 2
  • +1
4 Solutions
 
mdbdevCommented:
Does the file exist? Also did you install SQL with local admin rights?

Tim
0
 
jvoros1Author Commented:
I checked it is there, I was able to use it before and one day it just stopped
0
 
mdbdevCommented:
Check out this link:

http://www.computing.net/windowsxp/wwwboard/forum/76985.html

Sounds like corrupt system file

Tim
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
jvoros1Author Commented:
i tried to uninstall sql server and i cleaned out the registry and program files and installed it again and still same thing anything i can do to fix it?
0
 
mdbdevCommented:
According to above post and a couple of others I came across:

You could put your xp disk in the cdrom and go to start run type in cmd at prompt type exactly sfc /scannow

This will scan and fix corrupted system files. Then try it again.

Tim
0
 
rherguthCommented:
I've seen this error before and I sorta remember it being related to an MSXML update that I had installed on my computer.  Sometimes other software will install MSXML in the background.  There are two ways that it can be installed, side by side and replace mode.  Side by side is what you want because any previous versions are still available to applications, whereas the MMC I used crashed with this error when MSXML 3.0 was installed in replace mode.  I seem to recall the MMC version I was using requiring MSXML v1.0.

So, in short, my recommendation would be to reinstall MSXML v4.x:
http://www.microsoft.com/downloads/details.aspx?FamilyID=3144b72b-b4f2-46da-b4b6-c5d7485f2b42&DisplayLang=en
0
 
jvoros1Author Commented:
i tried sfc /scannow and now luck i will try the above from rherguth Thanks
0
 
Melih SARICAOwnerCommented:
Which MMC r u using ..

Try to download lates version of MMC ( release 1.2) from
http://www.microsoft.com/downloads/details.aspx?FamilyID=5a29c075-1637-4736-9688-faa8cc8b475b&DisplayLang=en
0
 
rherguthCommented:
Also make sure you install SQL Server SP3a on your workstation.  The RTM version has several annoying bugs.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

  • 3
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now