Uninstall problem with SQL Express 2008

have application using sql server msde 2000 databse components earlier. upgraded use sql express 2008. after change facing issues in uninstalling databse components during application uninstall. there 2 problems:

1. msde 2000, databse instance automatically uninstalled during removal of application "add/remove programs" in control panel.

2. sql express 2000, doesn't happen automatically , databse instance left on is. created batch file uninstall ( using msexec /x {product code of instance}. not remove instance cleanly , installer fails following exit code.

sqlsetup.log

======================================================================
01/30/2009 15:14:22.140 setup launched
01/30/2009 15:14:22.203 attempting 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 launched media directly default value current folder.
01/30/2009 15:14:22.343 media source: c:\e6cef40f7d6f728467c73ca638821b\
01/30/2009 15:14:22.390 attempt determine media layout based on file 'c:\e6cef40f7d6f728467c73ca638821b\mediainfo.xml'.
01/30/2009 15:14:22.453 media layout detected as: core
01/30/2009 15:14:22.562 media lcid 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 equal or greater media version 2007.100.1600.22, re-launching setup.exe 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 execution timestamp
01/30/2009 15:14:23.218 timestamp: 20090130_151422
01/30/2009 15:14:23.265 attempting launch local setup.exe
01/30/2009 15:14:23.312 attempting 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 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 determine media source
01/30/2009 15:14:23.531 media source: c:\e6cef40f7d6f728467c73ca638821b\
01/30/2009 15:14:23.546 attempt determine media layout based on file 'c:\e6cef40f7d6f728467c73ca638821b\mediainfo.xml'.
01/30/2009 15:14:23.578 media layout detected as: core
01/30/2009 15:14:23.734 media lcid detected as: 1033
01/30/2009 15:14:23.734 setup.exe running locally
01/30/2009 15:14:23.750 /? or /help or /action=help specified: false
01/30/2009 15:14:23.750 display: false
01/30/2009 15:14:23.765 checking see if need install .net version 2.0
01/30/2009 15:14:23.765 determining cluster status of local machine.
01/30/2009 15:14:23.781 local machine not configured cluster node.
01/30/2009 15:14:23.781 attempting find media .net version 2.0
01/30/2009 15:14:23.796 .net version 2.0 installed
01/30/2009 15:14:23.812 redistmsi::getexpectedbuildrevision - setup expects msi 4.5.6001.22159 @ minimum
01/30/2009 15:14:23.812 attempting 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 installed
01/30/2009 15:14:23.859 strong name verification disabling not required
01/30/2009 15:14:23.890 /? or /help or /action=help specified: false
01/30/2009 15:14:23.906 display: false
01/30/2009 15:14:23.906 attempting launch landing page workflow
01/30/2009 15:14:23.921 attempting set setup mutex
01/30/2009 15:14:23.937 setup mutex has been set
01/30/2009 15:14:23.937 attempting 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 execution timestamp
01/30/2009 15:14:23.984 timestamp: 20090130_151422
01/30/2009 15:14:23.984 attempting run workflow runrules /rules=globalrules
01/30/2009 15:14:24.000 attempting 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 release setup mutex
01/30/2009 15:14:31.656 setup mutex has been released
01/30/2009 15:14:31.656 setup closed exit code: 0x84c40013
01/30/2009 15:14:31.671 ======================================================================

however, if system rebooted prior running batch file, uninstall going through cleanly. adds more complexity in uninstall process not required msde 2000 edition.

i don't know how decifer error code. there clean way uninstall datbase instance without forcing reboot of system? problem observed on windows xp sp2.

thanks in advance valuable guidance/feedback.

harikumar

why don´t upgrade sql instance using /action=upgrade swítch ?

jens k. suessmeyer

SQL Server  >  SQL Server Setup & Upgrade