none
Uninstall problem with SQL Express 2008

    Question

  • We have an application which was using SQL Server MSDE 2000 for databse components earlier. Recently this is upgraded to use SQL Express 2008. After the change we are facing some issues in uninstalling the databse components during the application uninstall. There are two problems:

    1. With MSDE 2000, the databse instance was automatically uninstalled during the removal of the application from "Add/remove programs" in control panel.

    2. With SQL Express 2000, this doesn't happen automatically and the databse instance is left over as it is. Then we created a batch file to uninstall it ( using Msexec /x {Product Code of the instance}. This does not remove the instance cleanly and the installer fails with following exit code.

    SqlSetup.log

    ======================================================================
    01/30/2009 15:14:22.140 Setup launched
    01/30/2009 15:14:22.203 Attempting to determine media source
    01/30/2009 15:14:22.250 Media source value not specified on command line argument.
    01/30/2009 15:14:22.296 Setup is launched from media directly so default the value to the current folder.
    01/30/2009 15:14:22.343 Media source: c:\e6cef40f7d6f728467c73ca638821b\
    01/30/2009 15:14:22.390 Attempt to determine media layout based on file 'c:\e6cef40f7d6f728467c73ca638821b\mediainfo.xml'.
    01/30/2009 15:14:22.453 Media layout is detected as: Core
    01/30/2009 15:14:22.562 Media LCID is detected as: 1033
    01/30/2009 15:14:22.609 Current running setup.exe full path: c:\e6cef40f7d6f728467c73ca638821b\setup.exe
    01/30/2009 15:14:22.703 Media setup.exe file version detected: 2007.100.1600.22
    01/30/2009 15:14:22.765 Locally installed setup.exe full path: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release\setup.exe
    01/30/2009 15:14:22.796 Local setup.exe file version detected: 2007.100.1600.22
    01/30/2009 15:14:22.906 Local setup.exe version 2007.100.1600.22 is equal or greater than media version 2007.100.1600.22, so re-launching setup.exe from local
    01/30/2009 15:14:23.000 Media source: c:\e6cef40f7d6f728467c73ca638821b\
    01/30/2009 15:14:23.078 Install media path: c:\e6cef40f7d6f728467c73ca638821b\x86\setup\
    01/30/2009 15:14:23.140 Media layout: Core
    01/30/2009 15:14:23.171 Attempting to get execution timestamp
    01/30/2009 15:14:23.218 Timestamp: 20090130_151422
    01/30/2009 15:14:23.265 Attempting to launch local setup.exe
    01/30/2009 15:14:23.312 Attempting to launch process C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release\setup.exe
    01/30/2009 15:14:31.687 Process returned exit code: 0x84BE0BC2
    01/30/2009 15:14:31.718 Local setup.exe returned exit code: 0x84BE0BC2
    01/30/2009 15:14:31.734 Setup closed with exit code: 0x84C40013
    01/30/2009 15:14:31.734 ======================================================================

    SqlSetup_Local.log

    ======================================================================
    01/30/2009 15:14:23.515 Setup launched
    01/30/2009 15:14:23.531 Attempting to determine media source
    01/30/2009 15:14:23.531 Media source: c:\e6cef40f7d6f728467c73ca638821b\
    01/30/2009 15:14:23.546 Attempt to determine media layout based on file 'c:\e6cef40f7d6f728467c73ca638821b\mediainfo.xml'.
    01/30/2009 15:14:23.578 Media layout is detected as: Core
    01/30/2009 15:14:23.734 Media LCID is detected as: 1033
    01/30/2009 15:14:23.734 Setup.exe is running locally
    01/30/2009 15:14:23.750 /? or /HELP or /ACTION=HELP specified: false
    01/30/2009 15:14:23.750 Help display: false
    01/30/2009 15:14:23.765 Checking to see if we need to install .Net version 2.0
    01/30/2009 15:14:23.765 Determining the cluster status of the local machine.
    01/30/2009 15:14:23.781 The local machine is not configured as a cluster node.
    01/30/2009 15:14:23.781 Attempting to find media for .Net version 2.0
    01/30/2009 15:14:23.796 .Net version 2.0 is installed
    01/30/2009 15:14:23.812 RedistMSI::GetExpectedBuildRevision - Setup expects MSI 4.5.6001.22159 at the minimum
    01/30/2009 15:14:23.812 Attempting to get Windows Installer version
    01/30/2009 15:14:23.828 Windows Installer version detected: 4.5.6001.22159
    01/30/2009 15:14:23.828 RedistMSI::IsVistaRTM - Not Vista RTM build
    01/30/2009 15:14:23.843 Required version of Windows Installer is already installed
    01/30/2009 15:14:23.859 Strong name verification disabling is not required
    01/30/2009 15:14:23.890 /? or /HELP or /ACTION=HELP specified: false
    01/30/2009 15:14:23.906 Help display: false
    01/30/2009 15:14:23.906 Attempting to launch landing page workflow
    01/30/2009 15:14:23.921 Attempting to set setup mutex
    01/30/2009 15:14:23.937 Setup mutex has been set
    01/30/2009 15:14:23.937 Attempting to launch global rules workflow
    01/30/2009 15:14:23.953 Media source: c:\e6cef40f7d6f728467c73ca638821b\
    01/30/2009 15:14:23.953 Install media path: c:\e6cef40f7d6f728467c73ca638821b\x86\setup\
    01/30/2009 15:14:23.968 Media layout: Core
    01/30/2009 15:14:23.968 Attempting to get execution timestamp
    01/30/2009 15:14:23.984 Timestamp: 20090130_151422
    01/30/2009 15:14:23.984 Attempting to run workflow RUNRULES /RULES=GlobalRules
    01/30/2009 15:14:24.000 Attempting to launch process C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release\x86\setup100.exe
    01/30/2009 15:14:31.562 Process returned exit code: 0x84BE0BC2
    01/30/2009 15:14:31.578 Workflow RUNRULES /RULES=GlobalRules returned exit code: 0x84BE0BC2
    01/30/2009 15:14:31.640 Attempting to release setup mutex
    01/30/2009 15:14:31.656 Setup mutex has been released
    01/30/2009 15:14:31.656 Setup closed with exit code: 0x84C40013
    01/30/2009 15:14:31.671 ======================================================================

    However, if the system is rebooted prior to running the batch file, the uninstall is going through cleanly. But this adds to more complexity in the uninstall process which was not required with MSDE 2000 edition.

    I don't know how to decifer the error code. Is there a clean way to uninstall the datbase instance without forcing a reboot of the system? The problem is observed on Windows XP with SP2.

    Thanks in advance for your valuable guidance/feedback.

    Harikumar

    Friday, January 30, 2009 11:15 AM

All replies

  • Why don´t you upgrade the just the SQL instance using the /Action=Upgrade swítch ?

    Jens K. Suessmeyer

    Friday, January 30, 2009 1:23 PM
  • Jens

    Thanks for your suggestion. However the suggested method of upgrade doesn't work in our application since MSDE 2000 was not installed as an MSI setup. It doen't get listed in the "Add/remove programs" and SQL Express setup will not detect the instance.

    Earlier MSSDE 2000 was installed as a merge module and was handled by the application's installer script.  For that case the uninstall was working with "Msiexec /x " command without having to reboot . With SQL Express 2008, this command doesn't complete the uninstall cleanly with, without rebooting the system. The reasons for failure is unknown.

    I am puzzled with the failue of uninstall without reboot. Is there any resistry keys need to be cleaned up by the script, before calling the uninstall? Can I get some more information from the event log regarding the resons of failure?

    Note : Please read item 2 as "SQL EXPRESS 2008" and not 2000.

    Thanks & Regards

    Harikumar

    Monday, February 02, 2009 10:38 AM