Wednesday, August 22, 2007

Can't able to open SQL 2000 Enterprise Manager

Wednesday, August 22, 2007
Today, i got a new compliant that SQL 2000 Enterprise Manager is not opening.When i try to open the SQL 2000 Enterprise Manager shortcut it prompts an error message.The message is

"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."

Initially I tried to restart the SQL
Server 2000 Agent service,but it failed, then again restarted all the SQL services, but it was useless. Then started to search out in Google with the error message. Finally I got a solution and implemented in the PC which made my SQL Server 2000 to work fine.

Steps to resolve the issue :-

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.

Still wondering what might have caused that file to get corrupted.




5 comments:

Anonymous said...

I got this fault when i used repair funktion on windows, and used another copy of windows 2003 standard to repair with. what required another serial number other then the original installation.

Anonymous said...

tnx a lot from italy, you save me a lot of time, best regards :)

Unknown said...

here replica designer backpacks Check This Out replica designer bags look these up designer replica luggage

thethes said...

cliquez ici maintenant sacs répliques hautes une lecture fantastique https://www .dolabuy.co sites designer répliques de bagages

webdolabuy said...

q5m30o5j64 s3v80s1s03 q9g21u9l71 a3b52q0i34 o1t18l4v19 t0v27b9b35