[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now


Enterprise Manger wont start

Posted on 2004-11-01
Medium Priority
Last Modified: 2008-02-01
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?


Question by:pastill
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2

Expert Comment

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.

Author Comment

ID: 12464656
I can run IIS and Local Security Policy.

Expert Comment

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

Accepted Solution

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

Author Comment

ID: 12472572
Nice one mcmonap. Worked perfectly.


Featured Post

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

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

This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
Recently I was talking with Tim Sharp, one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. While doing some quick training with some of the Percona team, Tim brought something to my attention...
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

656 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