Re: [WiX-users] How to select between SQL Authentication and Integrated Authentication during the install of the msi?
Hi Rob I have noticed that you have fixed the SQLDatabase element in release: WixBuild: Version 3.5.1630.0 RobMen: SFBUG:1520745 - allow the SqlDatabase/@User to be a property. Could you provide me with an example of how to use the component to select either Integrated Authentication or SQL Authentication? Thanks Peter --- Peter Solomon pe...@nextsteps.co.za On Wed, Feb 24, 2010 at 3:20 PM, Bob Arnson b...@joyofsetup.com wrote: On 2/24/2010 2:25 AM, Peter Joseph Solomon wrote: I have come across this bug posted on the wix bug list: SqlDatabase/@User - Change to formatted element - ID: 1520745 The bug was closed; I reopened it. -- sig://boB http://joyofsetup.com/ -- Download Intel#174; 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 -- Nokia and ATT present the 2010 Calling All Innovators-North America contest Create new apps games for the Nokia N8 for consumers in U.S. and Canada $10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store http://p.sf.net/sfu/nokia-dev2dev ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] How to select between SQL Authentication and Integrated Authentication during the install of the msi?
On 2/24/2010 2:25 AM, Peter Joseph Solomon wrote: I have come across this bug posted on the wix bug list: SqlDatabase/@User - Change to formatted element - ID: 1520745 The bug was closed; I reopened it. -- sig://boB http://joyofsetup.com/ -- Download Intel#174; 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
[WiX-users] How to select between SQL Authentication and Integrated Authentication during the install of the msi?
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[USEINTEGRATEDSECURITY1]]/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' ConditionUSEINTEGRATEDSECURITY = 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#174; 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
Re: [WiX-users] How to select between SQL Authentication and Integrated Authentication during the install of the msi?
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}
ConditionSQLSERVER_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}
ConditionSQLSERVER_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=D4WFillSQLServersListboxGetting the
local database servers, please wait.../ProgressText--
ProgressText Action=D4WFillSQLServersListboxGetting a list of
available database servers, please wait.../ProgressText
ProgressText Action=D4WFillSQLServersListboxNetworkGetting 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=amp;Back/
Property Id=DbaLoginNextButtonText Value=amp;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=9991/Publish
Publish Dialog=WelcomeDlg Control=Next Event=NewDialog
Value=LicenseAgreementDlg1/Publish
Publish Dialog=LicenseAgreementDlg Control=Back
Event=NewDialog Value=WelcomeDlg1/Publish
Re: [WiX-users] How to select between SQL Authentication and Integrated Authentication during the install of the msi?
Mike, I'm not sure if you read Peter's question correctly. Your solution has the same problem the he's looking to fix - two conditional components, one for integrated authentication and one for SQL authentication. He only wants one component to maintain. Peter - I'm looking for a solution to this as well, I'm doing it the exact same way as you. -- View this message in context: http://n2.nabble.com/How-to-select-between-SQL-Authentication-and-Integrated-Authentication-during-the-install-of-the-msi-tp4617547p4620235.html Sent from the wix-users mailing list archive at Nabble.com. -- Download Intel#174; 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
Re: [WiX-users] How to select between SQL Authentication and Integrated Authentication during the install of the msi?
Hi all, I have come across this bug posted on the wix bug list: SqlDatabase/@User - Change to formatted element - ID: 1520745 You can view it at this link: http://sourceforge.net/tracker/index.php?func=detailaid=1520745group_id=105970atid=642714 Also posts on Wix-Devs relating to the feature: http://www.mail-archive.com/wix-d...@lists.sourceforge.net/msg02216.html If this can be used or resolved then I am sure it will solve the issue of having 2 components for two different methods of authentication. Does anyone have anyone have any experience with this feature, or know if this is something which will actually be resolved? Kind regards --- Peter Joseph Solomon 082 535 1844 pe...@nextsteps.co.za On Tue, Feb 23, 2010 at 7:07 PM, pmdarrow pdar...@metaworks.com wrote: Mike, I'm not sure if you read Peter's question correctly. Your solution has the same problem the he's looking to fix - two conditional components, one for integrated authentication and one for SQL authentication. He only wants one component to maintain. Peter - I'm looking for a solution to this as well, I'm doing it the exact same way as you. -- View this message in context: http://n2.nabble.com/How-to-select-between-SQL-Authentication-and-Integrated-Authentication-during-the-install-of-the-msi-tp4617547p4620235.html Sent from the wix-users mailing list archive at Nabble.com. -- Download Intel#174; 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 -- Download Intel#174; 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
