This is what I have done for all of my database installs. I took the standard FeatureTree and extended it with some additional screens. I use a third party custom action to get a list of db servers that are available. Hope this helps.
Also, see http://wix.mindcapers.com/wiki/WiX_and_SQLServer In my main WIX file: <sql:SqlDatabase Id="SqlDb" Database="$(var.DatabaseName)" Server="[SELECTEDSQLSERVER]" User="SQLAdminUser"/> <sql:SqlDatabase Id="SqlDbWindows" Database="$(var.DatabaseName)" Server="[SELECTEDSQLSERVER]"/> <Component Id="CreateDatabaseTablesAndDataServer" DiskId="1" KeyPath="yes" Guid="{YOUR_GUID_HERE}"> <Condition>SQLSERVER_AUTHENTICATION = "Server"</Condition> <sql:SqlScript Id="create_db_1_server" BinaryKey="CreateDbSqlScript" SqlDb="SqlDb" User="SQLAdminUser" ExecuteOnInstall="yes" ExecuteOnUninstall="no" ContinueOnError="no" Sequence="1"/> </Component> <Component Id="CreateDatabaseTablesAndDataWindows" DiskId="1" KeyPath="yes" Guid="{YOUR_GUID_HERE}"> <Condition>SQLSERVER_AUTHENTICATION = "Windows"</Condition> <sql:SqlScript Id="create_db_1_windows" BinaryKey="CreateDbSqlScript" SqlDb="SqlDbWindows" ExecuteOnInstall="yes" ExecuteOnUninstall="no" ContinueOnError="no" Sequence="1"/> </Component> I took Feature Tree wix source and added custom screens to it. This is in a separate include file. <?xml version="1.0" encoding="UTF-8"?> <Include xmlns="http://schemas.microsoft.com/wix/2006/wi";> <!-- This is the UI from the <wix-path>\src\ext\UIExtension\wixlib\WixUI_FeatureTree.wxs file. It has the custom dialog to get the database admin username and password inserted into the sequence of dialogs between CustomizeDlg and VerifyReadyDlg. --> <!-- Make sure that these tables get created in the installer, even if they are empty --> <EnsureTable Id="ComboBox"/> <EnsureTable Id="ListBox"/> <UIRef Id="WixUI_Common"/> <UI> <!-- <ProgressText Action="D4WFillSQLServersListbox">Getting the local database servers, please wait...</ProgressText>--> <ProgressText Action="D4WFillSQLServersListbox">Getting a list of available database servers, please wait...</ProgressText> <ProgressText Action="D4WFillSQLServersListboxNetwork">Getting a list of network database servers, please wait...</ProgressText> <!-- DBA Login dialog text - My properties for the DBA login dialog page --> <Property Id="DbServerText" Value="Select database server and connection method"/> <Property Id="DbServerExplainText1" Value="Select the database server to install to from the list below."/> <Property Id="DbServerExplainText2" Value=" You can also specify the way to authenticate your login using your "/> <Property Id="DbServerExplainText3" Value="current Windows credentials or a SQL Login ID and Password."/> <Property Id="DbaLoginTitle" Value="Database Admin Login"/> <Property Id="DbaLoginText" Value="Please enter the DBA username and password for your database server"/> <Property Id="DbaUsernameLabel" Value="DBA Username: "/> <Property Id="DbaPasswordLabel" Value="DBA Password:"/> <Property Id="DbaLoginBackButtonText" Value="&Back"/> <Property Id="DbaLoginNextButtonText" Value="&Next"/> <Property Id="DBAUSERNAME" Secure="yes"/> <Property Id="DBAPASSWORD" Hidden="yes" Secure="yes"/> <Property Id="DBSERVERNAME" Value="Express"/> <Property Id="SQLSERVER_AUTHENTICATION" Value="Server"/> <ComboBox Property="SQLSERVER_SERVER_TO_USE"> <ListItem Value="TestValue" /> </ComboBox> <ComboBox Property="D4WSQLSERVER"> <!--<ListItem Value="(local)" />--> </ComboBox> <RadioButtonGroup Property="SQLSERVER_AUTHENTICATION"> <RadioButton Height="14" Text="Windows authentication credentials of current user" Value="Windows" Width="250" X="0" Y="0" /> <RadioButton Height="19" Text="Server authentication using the Login ID and password below" Value="Server" Width="250" X="0" Y="14" /> </RadioButtonGroup> <TextStyle Id="WixUI_Font_Normal" FaceName="Tahoma" Size="8"/> <TextStyle Id="WixUI_Font_Bigger" FaceName="Tahoma" Size="12"/> <TextStyle Id="WixUI_Font_Title" FaceName="Tahoma" Size="9" Bold="yes"/> <Property Id="DefaultUIFont" Value="WixUI_Font_Normal"/> <Property Id="WixUI_Mode" Value="FeatureTree"/> <DialogRef Id="ErrorDlg"/> <DialogRef Id="FatalError"/> <DialogRef Id="FilesInUse"/> <DialogRef Id="MsiRMFilesInUse"/> <DialogRef Id="PrepareDlg"/> <DialogRef Id="ProgressDlg"/> <DialogRef Id="ResumeDlg"/> <DialogRef Id="UserExit"/> <Publish Dialog="ExitDialog" Control="Finish" Event="EndDialog" Value="Return" Order="999">1</Publish> <Publish Dialog="WelcomeDlg" Control="Next" Event="NewDialog" Value="LicenseAgreementDlg">1</Publish> <Publish Dialog="LicenseAgreementDlg" Control="Back" Event="NewDialog" Value="WelcomeDlg">1</Publish> <Publish Dialog="LicenseAgreementDlg" Control="Next" Event="NewDialog" Value="CustomizeDlg">LicenseAccepted = "1"</Publish> <Publish Dialog="CustomizeDlg" Control="Back" Event="NewDialog" Value="MaintenanceTypeDlg" Order="1">OLDERVERSIONBEINGUPGRADED</Publish> <Publish Dialog="CustomizeDlg" Control="Back" Event="NewDialog" Value="LicenseAgreementDlg" Order="2">NOT OLDERVERSIONBEINGUPGRADED</Publish> <Publish Dialog="CustomizeDlg" Control="Next" Event="NewDialog" Value="DatabaseServerDlg">1</Publish> <Publish Dialog="DatabaseServerDlg" Control="Back" Event="NewDialog" Value="CustomizeDlg">1</Publish> <Publish Dialog="DatabaseServerDlg" Control="Next" Event="NewDialog" Value="VerifyReadyDlg">1</Publish> <Publish Dialog="VerifyReadyDlg" Control="Back" Event="NewDialog" Value="DatabaseServerDlg" Order="1">(NOT OLDERVERSIONBEINGUPGRADED) OR (WixUI_InstallMode = "Change")</Publish> <Publish Dialog="VerifyReadyDlg" Control="Back" Event="NewDialog" Value="MaintenanceTypeDlg" Order="2">OLDERVERSIONBEINGUPGRADED</Publish> <Publish Dialog="MaintenanceWelcomeDlg" Control="Next" Event="NewDialog" Value="MaintenanceTypeDlg">1</Publish> <Publish Dialog="MaintenanceTypeDlg" Control="ChangeButton" Event="NewDialog" Value="CustomizeDlg">1</Publish> <Publish Dialog="MaintenanceTypeDlg" Control="RepairButton" Event="NewDialog" Value="VerifyReadyDlg">1</Publish> <Publish Dialog="MaintenanceTypeDlg" Control="RemoveButton" Event="NewDialog" Value="VerifyReadyDlg">1</Publish> <Publish Dialog="MaintenanceTypeDlg" Control="Back" Event="NewDialog" Value="MaintenanceWelcomeDlg">1</Publish> <Dialog Id="DatabaseServerDlg" Width="370" Height="270" Title="[ProductName] Database Server"> <Control Id="Title" Type="Text" X="15" Y="6" Width="200" Height="15" Transparent="yes" NoPrefix="yes" Text="{\WixUI_Font_Title}Database Server Information"/> <Control Id="Description" Type="Text" X="25" Y="23" Width="280" Height="15" Transparent="yes" NoPrefix="yes" Text="Enter the following information to facilitate the installation"/> <Control Id="BannerBitmap" Type="Bitmap" X="0" Y="0" Width="370" Height="44" TabSkip="no" Text="!(loc.InstallDirDlgBannerBitmap)"/> <Control Id="BannerLine" Type="Line" X="0" Y="44" Width="370" Height="0"/> <!-- My code added to the stock look and feel for a dialog --> <Control Id="DatabaseServerPurposeText" Type="Text" Height="20" Width="320" X="20" Y="50" Text="[DlgTitleFont][DbServerText]" Transparent="yes" NoPrefix="yes"/> <Control Id="DatabaseServerLabel" Type="Text" Height="20" Width="75" X="20" Y="67" Text="Database Server: " Transparent="yes" NoPrefix="yes"/> <Control Id="ServerComboBoxList" Type="ListBox" Height="80" Width="270" X="20" Y="81" Property="D4WSQLSERVER" TabSkip="no" Sorted="yes"/> <Control Id="ConnectTypeRadioButtons" Type="RadioButtonGroup" Height="50" Width="250" X="25" Y="161" Property="SQLSERVER_AUTHENTICATION" TabSkip="no"/> <Control Id="AuthLoginIdLabelText" Type="Text" Height="20" Width="60" X="50" Y="196" Text="[LoginIdLabel]" Transparent="yes" NoPrefix="yes"> <Condition Action="disable">SQLSERVER_AUTHENTICATION="Windows"</Condition> <Condition Action="enable">SQLSERVER_AUTHENTICATION="Server"</Condition> </Control> <Control Id="AuthUsernameDataEntry" Type="Edit" Height="17" Width="130" X="95" Y="194" Property="DBAUSERNAME" TabSkip="no"> <Condition Action="disable">SQLSERVER_AUTHENTICATION="Windows"</Condition> <Condition Action="enable">SQLSERVER_AUTHENTICATION="Server"</Condition> </Control> <Control Id="AuthPasswordLabelText" Type="Text" Height="20" Width="60" X="50" Y="216" Text="[PasswordLabel]" Transparent="yes" NoPrefix="yes"> <Condition Action="disable">SQLSERVER_AUTHENTICATION="Windows"</Condition> <Condition Action="enable">SQLSERVER_AUTHENTICATION="Server"</Condition> </Control> <Control Id="AuthPasswordDataEntry" Type="Edit" Password="yes" Height="17" Width="130" X="95" Y="214" Property="DBAPASSWORD" TabSkip="no"> <Condition Action="disable">SQLSERVER_AUTHENTICATION="Windows"</Condition> <Condition Action="enable">SQLSERVER_AUTHENTICATION="Server"</Condition> </Control> <!-- End of my code --> <Control Id="BottomLine" Type="Line" X="0" Y="234" Width="370" Height="0"/> <Control Id="Next" Type="PushButton" X="236" Y="243" Width="56" Height="17" Default="yes" Text="&Next"> <Publish Event="SpawnDialog" Value="NoDatabaseServerSelectedDlg"><![CDATA[D4WSQLSERVER = ""]]></Publish> <Publish Event="SpawnDialog" Value="NoAdminPasswordEnteredDlg"><![CDATA[(DBAPASSWORD = "") AND (SQLSERVER_AUTHENTICATION = "Server")]]></Publish> <Publish Property="D4WSQLSERVER" Value="[D4WSQLSERVER]"><![CDATA[NOT (D4WSQLSERVER="")]]></Publish> <Publish Event="DoAction" Value="SetSelectedSqlServer">1</Publish> </Control> <Control Id="Back" Type="PushButton" X="180" Y="243" Width="56" Height="17" Text="&Back"/> <Control Id="Cancel" Type="PushButton" X="304" Y="243" Width="56" Height="17" Cancel="yes" Text="&Cancel"> <Publish Event="SpawnDialog" Value="CancelDlg">1</Publish> </Control> </Dialog> <Dialog Id="NoDatabaseServerSelectedDlg" Width="370" Height="270" Title="[ProductName] No Database Server Selected"> <Control Id="Title" Type="Text" X="15" Y="6" Width="200" Height="15" Transparent="yes" NoPrefix="yes" Text="{\WixUI_Font_Title}No Database Server Selected"/> <Control Id="Description" Type="Text" X="25" Y="23" Width="280" Height="15" Transparent="yes" NoPrefix="yes" Text="Select the database sever on which to install the CATSA CID database"/> <Control Id="BannerBitmap" Type="Bitmap" X="0" Y="0" Width="370" Height="44" TabSkip="no" Text="!(loc.InstallDirDlgBannerBitmap)"/> <Control Id="BannerLine" Type="Line" X="0" Y="44" Width="370" Height="0"/> <!-- My code added to the stock look and feel for a dialog --> <Control Id="InvalidServerText" Type="Text" X="30" Y="70" Width="194" Height="30" Transparent="yes" NoPrefix="yes"> <Text>{\WixUI_Font_Title}No database server has been selected.</Text> </Control> <!-- End of my code --> <Control Id="BottomLine" Type="Line" X="0" Y="234" Width="370" Height="0"/> <Control Id="OK" Type="PushButton" X="236" Y="243" Width="56" Height="17" Default="yes" Text="&OK"> <Publish Event="EndDialog" Value="Return">1</Publish> </Control> <Control Id="Cancel" Type="PushButton" X="304" Y="243" Width="56" Height="17" Cancel="yes" Text="&Cancel"> <Publish Event="EndDialog" Value="Return">1</Publish> </Control> </Dialog> <Dialog Id="NoAdminPasswordEnteredDlg" Width="370" Height="270" Title="[ProductName] No Database Login Password Was Entered"> <Control Id="Title" Type="Text" X="15" Y="6" Width="200" Height="15" Transparent="yes" NoPrefix="yes" Text="{\WixUI_Font_Title}No Database Login Password Was Entered"/> <Control Id="Description" Type="Text" X="25" Y="23" Width="280" Height="15" Transparent="yes" NoPrefix="yes" Text="Enter the password for the database administrative user"/> <Control Id="BannerBitmap" Type="Bitmap" X="0" Y="0" Width="370" Height="44" TabSkip="no" Text="!(loc.InstallDirDlgBannerBitmap)"/> <Control Id="BannerLine" Type="Line" X="0" Y="44" Width="370" Height="0"/> <!-- My code added to the stock look and feel for a dialog --> <Control Id="InvalidServerText" Type="Text" X="30" Y="70" Width="194" Height="30" Transparent="yes" NoPrefix="yes"> <Text>{\WixUI_Font_Title}No database login password was entered.</Text> </Control> <!-- End of my code --> <Control Id="BottomLine" Type="Line" X="0" Y="234" Width="370" Height="0"/> <Control Id="OK" Type="PushButton" X="236" Y="243" Width="56" Height="17" Default="yes" Text="&OK"> <Publish Event="EndDialog" Value="Return">1</Publish> </Control> <Control Id="Cancel" Type="PushButton" X="304" Y="243" Width="56" Height="17" Cancel="yes" Text="&Cancel"> <Publish Event="EndDialog" Value="Return">1</Publish> </Control> </Dialog> </UI> </Include> On Tue, Feb 23, 2010 at 12:01 AM, Peter Joseph Solomon < pe...@nextsteps.co.za> wrote: > I have the following example which uses two components each with a > condition to select which component to run. One component uses a > database linked to an SQL Authenticated User and the other to no user > (Integrated Authentication). > > Command line options are passed, either USEINTEGRATEDSECURITY=1 or > USER=sa and PASSWORD=superadmin for either Integrated Authentication > or SQL Authentication respectivly. > > This works fine, except it will be error prone maintaining the MSI. > > I am looking for a way to achieve the same result, but with out having > to use two components. So just one component, but a way to instruct > the database/user to which authentication type it will use. > Any suggestions? > > Kind regards > Peter > > Example: > <Binary Id="CreateTable" SourceFile="$(var.SolutionDir)\CreateTable.sql" > /> > > <util:User Id='SQLUser' Name='[USER]' Password='[PASSWORD]' /> > > <sql:SqlDatabase Id='SqlDatabase.SQLAuthentication' > Database='IMAGETEST' User='SQLUser' Server='server' /> > <sql:SqlDatabase Id='SqlDatabase.IntegratedAuthentication' > Database='IMAGETEST' Server='server' /> > > <Directory Id='TARGETDIR' Name='SourceDir'> > <Directory Id='ProgramFilesFolder' Name='PFiles'> > <Directory Id='InstallDir' Name='Acme'> > > <Component Id='SqlComponent.SQLAuthentication' > Guid='665D641C-3570-4b96- 9CA5-2B4C12594A35' KeyPath='yes'> > <Condition><![CDATA[USEINTEGRATEDSECURITY<>1]]></Condition> > <sql:SqlScript Id='CreateTable' BinaryKey='CreateTable' > SqlDb='SqlDatabase.SQLAuthentication' ExecuteOnInstall='yes' /> > </Component> > > <Component Id='SqlComponent.IntegratedAuthentication' > Guid='E5DF48AE-2338-4029-9FDF-8DAA6AD0216D' KeyPath='yes'> > <Condition>USEINTEGRATEDSECURITY = 1</Condition> > <sql:SqlScript Id='IntegratedAuthentication.CreateTable' > BinaryKey='CreateTable' SqlDb='SqlDatabase.IntegratedAuthentication' > ExecuteOnInstall='yes' /> > </Component> > > </Directory> > </Directory> > </Directory> > > <Feature Id='SqlFeature' Title='SqlFeature' Level='1'> > <ComponentRef Id='SqlComponent.SQLAuthentication' /> > <ComponentRef Id='SqlComponent.IntegratedAuthentication' /> > </Feature> > > > ------------------------------------------------------------------------------ > Download Intel® Parallel Studio Eval > Try the new software tools for yourself. Speed compiling, find bugs > proactively, and fine-tune applications for parallel performance. > See why Intel Parallel Studio got high marks during beta. > http://p.sf.net/sfu/intel-sw-dev > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > The information contained in this transmission contains potentially privileged, export controlled and/or confidential information of Imageware Systems, Inc. or its customers or partners. It is intended only to be read by the person(s) named above and for no other purpose. You are hereby notified that any dissemination, distribution, duplication of this communication or use of its contents for any purpose not authorized expressly by Imageware Systems, Inc. is strictly prohibited and could lead to both civil and/or criminal penalties. If you are not the intended recipient, you are prohibited to review the contents herein and please contact the sender by reply e-mail and destroy all copies of the original message. To reply to our e-mail administrator directly, please send an e-mail to emailad...@iwsinc.com ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
