I know you probably don't want to hear this, but I've Seen: <Condition 1><Server Authentication AND NOT WindowsAuthentication</Condition 1> <Condition 2><Windows Authentication AND NOT ServerAuthentication</Condition 2>
then Choose A condition based on what the user chose in your setup dialog, ie condition 1 is what you've described and condition 2 is Windows Authentication. Carter Quoting Levi Wilson <l...@leviwilson.com>: > I have a component that has multiple <SqlScript /> elements. In my dialog > sequence I allow the user to choose whether or not they want to use SQL or > Windows Authentication for the connection. > > Each <SqlScript /> references my <SqlDatabase /> that currently looks like > this: > > <util:User Id='SqlInstallerUserId' > Name='[SQL_ADMIN_USERNAME]' > Password='[SQL_ADMIN_PASSWORD]' /> > > <sql:SqlDatabase Id="CompassFrameworkDatabase" > Server="[SQL_SERVER]" Database="[SQL_DATABASE]" > User="SqlInstallerUserId" /> > > The problem is that will never work with Windows Authentication :-) > > I've seen some have two different components that specified different > <SqlDatabase /> elements, but I would rather not do that. > > Is there a way to basically "clear" the "User_" record in the > SqlDatabase table in the MSI to force it to use Windows Authentication > depending on what the user chose in the dialog? > > Thanks in advance. > > Levi > ------------------------------------------------------------------------------ > Learn Graph Databases - Download FREE O'Reilly Book > "Graph Databases" is the definitive new guide to graph databases and their > applications. Written by three acclaimed leaders in the field, > this first edition is now available. Download your free book today! > http://p.sf.net/sfu/13534_NeoTech > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > > ------------------------------------------------------------------------------ Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/13534_NeoTech _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
