Just looking at it from a naïve point-of-view, and seeing what is on my own computer (I have two instances of SQLServer installed/running, one 2005 the other 2008), this is what I see:
If the dependency were local, it appears that the service name is MSSQL$<instancenamepart>. Local means that the <computername>\<instancenamepart> instance-identifier would match (ignoring case) with the property "ComputerName". You could then update the Dependencies column of the ServiceInstall table for your service. This would probably need to be done from an immediate action, and that action/addition would need to be performed every time you are not removing the service's component's feature (if not simply everytime) which would require that you preserve the instance-identifier you depend on. Wish I had some documentation to throw at you to prove that this is really the way to go, however. -----Original Message----- From: dB. [mailto:dbl...@dblock.org] Sent: Thursday, June 24, 2010 9:34 AM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Dependency on Sql Server We have the same problem, would love a solution. Did you try creating two components with services, one with a dependency and another without? Then condition them based on, say, SQLSERVER_IS_LOCAL. Try setting and not setting the property and see if that works. Once it does, you can start trying to figure out what a "local" instance means. It would go a long way checking for basic names (eg. (local)). We're using http://msiext.codeplex.com, it would be implementable to properly figure out whether the instance is actually local. Thx dB. dB. @ dblock.org Moscow|Geneva|Seattle|New York -----Original Message----- From: Will Sullivan [mailto:wsulli...@softdocs.com] Sent: Wednesday, June 23, 2010 2:21 PM To: General discussion for Windows Installer XML toolset. Subject: [WiX-users] Dependency on Sql Server My service uses an instance of Sql Server. Now, if that instance is on the current machine, I need to set a dependency on that service so that my service starts afterwards. I can foresee a hard time getting this into my installer. I need to determine if the sql server is on the current machine from the server/instance provided by the user, then determine the method of identifying the service in order to set a dependency on it, then dynamically adding this to my service during the install. So, is there a relatively easy way to do this? Or are there any guides out here for this situation? Looking for any help on this I can get! TIA. ---------------------------------------------------------------------------- -- ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ---------------------------------------------------------------------------- -- ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
