[wix-users] SQL fails on repair

[Carlos Sosa]

I found the command for repair and added it to the exe 
RepairCommand="/ACTION=Repair /QUIETSIMPLE /IACCEPTSQLSERVERLICENSETERMS /INSTANCENAME=MyInstance"

But it still fails, loks like it tries to install all over again.
Since I'm clicking the REPAIR button, shouldn't it use the repair command?

I'm going to implement the detect condition, this should skip the installation of SQL if its already there, but the repair function is still needed, If detect condition is not specified, will it always do Install first?
I'm just curios how the process works.
 
-CS


-----Original Message-----
From: Joseph L. Casale [mailto:jcasale at activenetwerx.com] 
Sent: Thursday, December 14, 2017 12:59 PM
To: 'WiX Toolset Users Mailing List' <wix-users at lists.wixtoolset.org>
Cc: Carlos Sosa <carlos.sosa.us at outlook.com>
Subject: RE: SQL fails on repair

-----Original Message-----
From: wix-users [mailto:wix-users-bounces at lists.wixtoolset.org] On Behalf Of Carlos Sosa via wix-users
Sent: Thursday, December 14, 2017 12:29 PM
To: WiX Toolset Users Mailing List <wix-users at lists.wixtoolset.org>
Cc: Carlos Sosa <carlos.sosa.us at outlook.com>
Subject: [wix-users] SQL fails on repair


> Hello, we have installed SQL just fine but when I select repair it fails:
> <ExePackage Id="SQL"
>                    Vital="yes"
>                   SourceFile="Lib\SQLEXPR_x64_ENU.exe"
>                   InstallCommand="/QUIETSIMPLE 
> /IACCEPTSQLSERVERLICENSETERMS /SAPWD=password /ACTION=Install 
> /FEATURES=SQL /SECURITYMODE=SQL /INSTANCENAME=MYINSTANCE"
> 
> Name="!(wix.SQL2016ExpPackageDirectory)SQLEXPR_x64_ENU.exe"
>                   Cache="no"
>                   DisplayName="SQL Configuration, this takes time, do 
> not interrupt the installation."
>                   Permanent="yes"/>

Use conditions, you are re-installing it on top of itself which is most certainly not supported with the same invocations arguments as the install set. See the SQL cli arguments doc for the repair set.