Solved

Enterprise Manger wont start

Posted on 2004-11-01
483 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
Question by:pastill
    5 Comments
     
    LVL 4

    Expert Comment

    by:chanito
    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
    I can run IIS and Local Security Policy.
    0
     
    LVL 4

    Expert Comment

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

    Accepted Solution

    by:
    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
    Nice one mcmonap. Worked perfectly.

    thanks
    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    APEX (Application Express) is used to develop a web application from Oracle. SQL Workshop is one of the tools that comes with Oracle APEX to query or modify the database objects or to make any changes to the structure.
    CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
    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…
    With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

    913 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

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now