Uninstalling SQL Server 2005 from Windows 2003 Server

Posted on 2006-03-30
Last Modified: 2012-06-21
I'm having some issues uninstalling SQL Server 2005 Enterprise from my Win2k3 server.  Here are the errors I'm getting when attempting to uninstall.  The parts of SQL Server 2005 that won't uninstall say "Setup failed.  Refer to the Setup log for details.  Here are the strange errors I'm getting:

1) The setup has encountered an unexpected error while Setting Internal Properties.  The error is: Fatal error during installation.

2) The setup failed to read IIsMimeMap table.  The error code is -2147024893.  T
his appears as the second error.  The installer then rolls back (Internet Information Services Transaction.)  I've tried stopping all SQL services, as well as IIS, then trying to uninstall - same errors.  I'm trying to avoid rebuilding the server.

Can anyone tell me where the setup logs are, and how I might be able to uninstall this server?
Question by:jpipitone
    LVL 1

    Author Comment

    I went through and deleted all of the items - but the services are still active - how can I remove the services?
    LVL 20

    Accepted Solution

    >>but the services are still active  <<

    Go to Component services and stop the services
    LVL 1

    Author Comment

    Can I remove the services? Why have them in there if they aren't needed?
    LVL 1

    Author Comment

    Can anyone help?

    Expert Comment

    Microsoft suggests the you recreate the virtual directories using the Reporting Services Manager

    We had a broken Reporting Services Manager.  In addition we had so many websites that it confused the uninstaller.  So we backed up our current IIS Metabase, restored the original (from Install) IIS Metabase configuration, added the virtual directories manually then the uninstall worked.  Afterwards we restored our IIS Metabase and deleted the virtual directories manually.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

    755 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