?
Solved

Enterprise Manger wont start

Posted on 2004-11-01
5
Medium Priority
?
528 Views
Last Modified: 2008-02-01
Hi
I have managed to break my enterprise manager.

The error I get is 'Unhandled exception in mmc.exe: 0xC0000005: Access Violation.

I was thinking of running sfc.exe but don't want to make things worse.

any suggestions?

thanks

Paul
0
Comment
Question by:pastill
  • 2
  • 2
5 Comments
 
LVL 4

Expert Comment

by:chanito
ID: 12464579
Maybe you should reinstall the SQL Server tools, but before you do check if it's a problem with MMC or just the Enterprise Manager.  Open another MMC snippet like Internet Information Services or Local Security Policity (in administrative tools).  0xC0000005 is a nasty error generally due to file corruption.  Make sure to run an anti-virus scan before you do anything else.
0
 

Author Comment

by:pastill
ID: 12464656
I can run IIS and Local Security Policy.
0
 
LVL 4

Expert Comment

by:chanito
ID: 12465047
Is your PC also the SQL Server?  If not, just uninstall and re-install SQL Server Tools.
0
 
LVL 15

Accepted Solution

by:
mcmonap earned 2000 total points
ID: 12466449
Hi pastill,

Run up mmc with no snap-ins, then add the sql snap, if this works save it and delete your existing one.

Steps for the above:
1. start, run  - mmc
2. select file, add/remove snap-in, sellect add
3. scroll down to "Microsoft SQL Enterpsie Manager", select it and click add
4. click close, then okay, the EM snap-in should now hopefully work
5. to save this click file save-as and chose your location.

The location of the pre-consigured msc file is usually: "C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC" you could just overwrite this when you save
0
 

Author Comment

by:pastill
ID: 12472572
Nice one mcmonap. Worked perfectly.

thanks
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
Microsoft Jet database engine errors can crop up out of nowhere to disrupt the working of the Exchange server. Decoding why a particular error occurs goes a long way in determining the right solution for it.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

598 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question