Phil, Rob, Thanks for your replies.
It of course pays to read the installer code before asking a question (I dip in an out of this installer when I have the time). Here is what I really want to do: 1. Install MyService1 2. Install MyService2 3. Execute a series of SQL Scripts (setting up a user on the DB, seting some install specific DB entries etc.) 4. Change SQLExpress Login type (from default windows authentaication to mixed - ie SQLServer) - this is just a registry change. 5. Restart (Start/Stop) SQLExpress 6. Start MyService1 7. Start MyService2 There is other stuff going on but this is what is stalling me right now. MyService1 and MyService2 are dependent on MSSQL$SQLEXPRESS If I use: <ServiceControl Id="MSSQLSERVER.Start" Name="MSSQL$SQLEXPRESS" Stop="install" Start="install" Wait="yes" /> then I get a MSSQL$SQLEXPRESS at the ServicesStop event and at the ServicesStartEvent this then means that my SQL Scripts fail. Obviously I need SQLExpress to be running while running the scripts. I have tried playing around with custom actions using CAQuietExec and calling the "net stop/start" command but to no avail. Thanks for your help so far. Peter >From: "Wilson, Phil" <[EMAIL PROTECTED]> >To: "Rob Hamflett" <[EMAIL PROTECTED]>, <wix-users@lists.sourceforge.net> >Subject: Re: [WiX-users] Restarting an existing service (SQLEXPRESS) >Date: Fri, 7 Sep 2007 12:37:05 -0700 > >I suspect a single component would work (or just the existing component >that requires the service to stop and start) with ServiceControl because >the usual sequence during an install is StopServices.... >WriteRegistryValues... StartServices. You'd have a ServiceControl for >Sql Express that does both start and stop on install with your registry >update in between. > >Phil Wilson > > >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Rob >Hamflett >Sent: Friday, September 07, 2007 2:35 AM >To: wix-users@lists.sourceforge.net >Subject: Re: [WiX-users] Restarting an existing service (SQLEXPRESS) > >The ServiceControl element may help. There's no option to restart a >service, only to stop or start >on install/uninstall/both. I'm pretty sure that the StopServices action >occurs before the >StartServices action, so you could create 2 components, one to stop the >service on install, and >another to start the service on install. You would then have to make >you're modifications between >these events. I've no clue how valid an idea this is, but it's a >starting point. > >Rob > >Peter Conlon wrote: > > All, > > > > I need to change a configuration parameter on a existing service as >part of > > a product install. > > > > I can easily change the registry value concerned but I have been >unable to > > restart the service after the change has been made. > > > > Any ideas as to how to do this in WIX? (have tried using the 'net' >command > > in a custome action). > > > > Thanks for any help. > > > > Peter > > > > _________________________________________________________________ > > Download the latest version of Windows Live Messenger NOW! > > http://get.live.com/en-ie/messenger/overview > > > > > > >------------------------------------------------------------------------ >- > > This SF.net email is sponsored by: Splunk Inc. > > Still grepping through log files to find problems? Stop. > > Now Search log events and configuration files using AJAX and a >browser. > > Download your FREE copy of Splunk now >> http://get.splunk.com/ > > >------------------------------------------------------------------------ >- >This SF.net email is sponsored by: Splunk Inc. >Still grepping through log files to find problems? Stop. >Now Search log events and configuration files using AJAX and a browser. >Download your FREE copy of Splunk now >> http://get.splunk.com/ >_______________________________________________ >WiX-users mailing list >WiX-users@lists.sourceforge.net >https://lists.sourceforge.net/lists/listinfo/wix-users > > > >------------------------------------------------------------------------- >This SF.net email is sponsored by: Splunk Inc. >Still grepping through log files to find problems? Stop. >Now Search log events and configuration files using AJAX and a browser. >Download your FREE copy of Splunk now >> http://get.splunk.com/ >_______________________________________________ >WiX-users mailing list >WiX-users@lists.sourceforge.net >https://lists.sourceforge.net/lists/listinfo/wix-users _________________________________________________________________ Download the latest version of Windows Live Messenger NOW! http://get.live.com/en-ie/messenger/overview ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
