I discovered the cause. First, thanks - if you didn't reassure me that the service is not stopped by Windows Installer on 2008 I wouldn't have found the cause as soon.
We use WMI in the ATShutDownProcessor CA to shut down all processes that have our standard name. In an unfortunate decision during setup of SQL Server, I included our standard name as part of the SQL Server instance name. So (using WMI CIM Studio) I ran the query that lists processes that will be ended, and I see the SQL Server instance listed. The solution might be to filter the list, haven't decided yet. Thanks - Greg > From: g.swan...@hotmail.com > To: wix-users@lists.sourceforge.net > Date: Wed, 25 Feb 2009 13:01:09 -0700 > Subject: Re: [WiX-users] Uninstall on Windows 2008 Server > > > Thanks for the reply Joe. Here is an excerpt from InstallExecuteSequence. I > use a CA to drop the databases (ATDropDB), and at the point the CA is > executed the service is no longer running. In fact I watch the services > manager, refreshing as the uninstall begins, and the service is stopped early > on. > > > > By the way, the ServiceControl table has two entries: MSMQServiceControl, and > ATProcessorSC (a service we package with our MSI). I can explain the CAs > below if needed. > > > > <InstallExecuteSequence> > > <Custom Action='ATShutDownIIS' > After='CostFinalize'><![CDATA[ATINSTALLTYPE="1" OR Installed]]></Custom> > > <Custom Action='ATShutDownProcessor' > After='ATShutDownIIS'><![CDATA[ATINSTALLTYPE="1" OR Installed]]></Custom> > > <Custom Action='ATPromptStopServices' > After='ATShutDownProcessor'><![CDATA[ATINSTALLTYPE="1" OR > Installed]]></Custom> > > <Custom Action="UndeployATdacNet" > After="InstallInitialize"><![CDATA[ATINSTALLTYPE="1"]]></Custom> > > <Custom Action="GetATInstallStatus" > After="InstallFiles"><![CDATA[1]]></Custom> > > > > <!-- GregS at this point during uninstall on Windows 2008 Server, SQL Server > service is stopped --> > > > <Custom Action="ATSetDropDB" > After="UnpublishFeatures"><![CDATA[AT_DBSERV_SETUP=1 AND (!ATXS_DBServ=3) AND > (&ATXS_DBServ=2)]]></Custom> > > <Custom Action="ATDropDB" After="ATSetDropDB"><![CDATA[AT_DBSERV_SETUP=1 AND > (!ATXS_DBServ=3) AND (&ATXS_DBServ=2)]]></Custom> > > <Custom Action="ATSetDataForMSMQ2" > After="ATDropDB"><![CDATA[(!ATXS_AppServ=3) AND (&ATXS_AppServ=2)]]></Custom> > <Custom Action="ATDeleteMSMQ" > After="ATSetDataForMSMQ2"><![CDATA[(!ATXS_AppServ=3) AND > (&ATXS_AppServ=2)]]></Custom> > > <Custom Action="PreparingCleanRegistry" > After="InstallFiles"><![CDATA[((!ATXS_DaemonServ=3) AND (&ATXS_DaemonServ=2)) > OR ((!ATXS_DBServ=3) AND (&ATXS_DBServ=2)) OR ((!ATXS_AppServ=3) AND > (&ATXS_AppServ=2))]]></Custom> > <Custom Action="CleanRegistry" > After="PreparingCleanRegistry"><![CDATA[((!ATXS_DaemonServ=3) AND > (&ATXS_DaemonServ=2)) OR ((!ATXS_DBServ=3) AND (&ATXS_DBServ=2)) OR > ((!ATXS_AppServ=3) AND (&ATXS_AppServ=2))]]></Custom> > > <Custom Action="ConfigureSql" After="InstallFiles"><![CDATA[ATINSTALLTYPE="0" > AND NOT (!ATXS_DBServ=3) AND (&ATXS_DBServ=3)]]></Custom> > > <Custom Action="ATSetDataForDBServ1" > After="InstallFiles"><![CDATA[ATINSTALLTYPE="0" AND NOT (!ATXS_DBServ=3) AND > (&ATXS_DBServ=3)]]></Custom> > <Custom Action="ATSetDataForDBServ2" > After="ATSetDataForDBServ1"><![CDATA[ATINSTALLTYPE="0" AND NOT > (!ATXS_DBServ=3) AND (&ATXS_DBServ=3)]]></Custom> > > <Custom Action="ATRestoreDB" After="ATSetDataForDBServ2"><![CDATA[NOT > (!ATXS_DBServ=3) AND (&ATXS_DBServ=3) AND ATINSTALLTYPE=0 AND > VBSCRIPTERROR<>"1"]]></Custom> > <Custom Action="ATCreateUsers" After="ATRestoreDB"><![CDATA[NOT > (!ATXS_DBServ=3) AND (&ATXS_DBServ=3) AND ATINSTALLTYPE=0 AND > VBSCRIPTERROR<>"1"]]></Custom> > > <Custom Action="SetDBVersion" After="InstallFiles"><![CDATA[NOT > (!ATXS_DBServ=3) AND (&ATXS_DBServ=3) AND ATINSTALLTYPE=0 AND > AT_APPSERV_SETUP<>1 AND VBSCRIPTERROR<>"1"]]></Custom> > <Custom Action="StartSetDBVersion" After="SetDBVersion"><![CDATA[NOT > (!ATXS_DBServ=3) AND (&ATXS_DBServ=3) AND ATINSTALLTYPE=0 AND > AT_APPSERV_SETUP<>1 AND VBSCRIPTERROR<>"1"]]></Custom> > <!-- end Greg: ADD-LATER 08.13.2008 --> > > <Custom Action="ATSetDataForMSMQ1" After="GetATInstallStatus"><![CDATA[NOT > (!ATXS_AppServ=3) AND (&ATXS_AppServ=3) AND VBSCRIPTERROR<>"1"]]></Custom> > <Custom Action="ATConfigureMSMQ" After="ATSetDataForMSMQ1"><![CDATA[NOT > (!ATXS_AppServ=3) AND (&ATXS_AppServ=3) AND VBSCRIPTERROR<>"1"]]></Custom> > > > Thanks, > > Greg > > > > > Date: Thu, 26 Feb 2009 08:37:34 +1300 > > From: joe.os...@tait.co.nz > > To: wix-users@lists.sourceforge.net > > Subject: Re: [WiX-users] Uninstall on Windows 2008 Server > > > > This shouldn't happen. Our MSI installer run on Windows Server 2008 and > > creates a database on install and removed it on uninstall and it doesn't > > stop the service. Can you post your code ? > > > > Swandog wrote: > > > Hi: > > > > > > > > > > > > I have an MSI that is stopping the SQL Server service during uninstall on > > > Windows 2008 Server. Is this supposed to occur? > > > > > > > > > > > > Thanks, > > > > > > Greg > > > > > > _________________________________________________________________ > > > It’s the same Hotmail®. If by “same” you mean up to 70% faster. > > > http://windowslive.com/online/hotmail?ocid=TXT_TAGLM_WL_HM_AE_Same_022009 > > > > > > > ======================================================================= > > This email, including any attachments, is only for the intended > > addressee. It is subject to copyright, is confidential and may be > > the subject of legal or other privilege, none of which is waived or > > lost by reason of this transmission. > > If the receiver is not the intended addressee, please accept our > > apologies, notify us by return, delete all copies and perform no > > other act on the email. > > Unfortunately, we cannot warrant that the email has not been > > altered or corrupted during transmission. > > ======================================================================= > > > > _________________________________________________________________ > Access your email online and on the go with Windows Live Hotmail. > http://windowslive.com/online/hotmail?ocid=TXT_TAGLM_WL_HM_AE_Access_022009 > ------------------------------------------------------------------------------ > Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA > -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise > -Strategies to boost innovation and cut costs with open source participation > -Receive a $600 discount off the registration fee with the source code: SFAD > http://p.sf.net/sfu/XcvMzF8H > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users _________________________________________________________________ Windows Live™ Hotmail®:…more than just e-mail. http://windowslive.com/explore?ocid=TXT_TAGLM_WL_t2_hm_justgotbetter_explore_022009 ------------------------------------------------------------------------------ Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
