HI One of two options. My recommendation would be don't use SQL Authentication unless you really need to, or only provide it as an advanced option for SQL upgrades. The SQL tool will use Integrated Auth if the SQL user and password are left blank. That would mean that the user running the upgrade needs access to the database server. Reason for this is that there is no guarantee that SQL Server is installed with the SQL Auth enabled.
Otherwise, it probably doesn't matter about the major or minor upgrade, you just need to pop a dialog on upgrade that asks for the SQL User and password - how you condition this dialog will depend on your upgrade type. Michael -----Original Message----- From: Thai-Hoa Nguyen [mailto:taiwa...@hotmail.com] Sent: Tuesday, 8 March 2011 8:26 AM To: wix-users@lists.sourceforge.net Subject: [WiX-users] Upgrade SQL Database Hello... I created an installation 1.0 which creates a database and insert data into it. This installation prompts the user to enter the SQL user and password. This installation doesn't remember the SQL user and password anywhere. I then created an MINOR UPGRADE installation to modify the database. I made the copy of the full installation project to the upgrade installation project with a couple changes--new product version and new SQL component. I installed the full installation first. Then the upgrade installation next. The upgrade installation does not ask me to enter the SQL user and password. What should my upgrade solution that modifies the current database be? Using MAJOR UPGRADE (change Product ID and version)? Thank you for your help. ------------------------------------------------------------------------------ What You Don't Know About Data Connectivity CAN Hurt You This paper provides an overview of data connectivity, details its effect on application quality, and explores various alternative solutions. http://p.sf.net/sfu/progress-d2d _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ What You Don't Know About Data Connectivity CAN Hurt You This paper provides an overview of data connectivity, details its effect on application quality, and explores various alternative solutions. http://p.sf.net/sfu/progress-d2d _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
