I added SQL 2008 to BootStrapper and it works on new Install. But when I try to
install on a system that already has SQL 2008 installed, it tries to re-install
again, I can't find where the problem might be Can someone help?
This is the code in package.xml - I have added registry check for SQL Server
installed.
<InstallChecks>
<RegistryFileCheck Property="DefaultSQLInstalled"
Key="HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion"
Value="CurrentVersion"/>
</InstallChecks>
<Commands Reboot="Defer">
<!-- Defines a new installation (x86) -->
<Command PackageFile="SQLEXPR32_x86_ENU.EXE"
Arguments='/q /hideconsole /action=Install
/features=SQL /INSTANCENAME=MSSQLSERVER /TCPENABLED=1 /SECURITYMODE=SQL
/SAPWD="w...@13456789" /enableranu=1 /sqlsvcaccount= "NT Authority\System"
/SQLSYSADMINACCOUNTS="BUILTIN\ADMINISTRATORS" /skiprules=RebootRequiredCheck'
EstimatedInstalledBytes="225000000"
EstimatedInstallSeconds="420">
<InstallConditions>
<BypassIf Property="DefaultSQLInstalled"
Compare="ValueExists" Value="90"/>
<BypassIf Property="ProcessorArchitecture"
Compare="ValueNotEqualTo" Value="Intel"/>
<!--<BypassIf Property="SQLExpressInstalled"
Compare="ValueNotEqualTo" Value="0"/>-->
<FailIf Property="Version9x" Compare="ValueExists"
String="InvalidPlatformXP"/>
<FailIf Property="VersionNT"
Compare="VersionLessThan" Value="5.1.2" String="InvalidPlatformXP"/>
<FailIf Property="VersionNT"
Compare="VersionEqualTo" Value="5.2.0" String="InvalidPlatform2K3"/>
<FailIf Property="VersionNT"
Compare="VersionEqualTo" Value="5.2.1" String="InvalidPlatform2K3"/>
<FailIf Property="AdminUser" Compare="ValueEqualTo"
Value="false" String="AdminRequired"/>
</InstallConditions>
<ExitCodes>
<ExitCode Value="0" Result="Success"/>
<ExitCode Value="1641" Result="SuccessReboot"/>
<ExitCode Value="3010" Result="SuccessReboot"/>
<!-- 0x84BE0BC2 (1214,3010) -->
<ExitCode Value="-2067919934" Result="FailReboot"/>
<!-- 0x84C10BC2 (1217,3010) -->
<ExitCode Value="-2067723326" Result="FailReboot"/>
<!-- 0x84BE0007 (1214,7) -->
<ExitCode Value="-2067922937" Result="Fail"
String="AdminRequired"/>
<!-- 0x84C4001F (1220,31) -->
<ExitCode Value="-2067529697" Result="Fail"
String="AdminRequired"/>
<!-- 0x84BE0001 (1214,1)-->
<ExitCode Value="-2067922943" Result="Fail"
String="InvalidPlatformOSServicePacks"/>
<!-- 0x84C4000B (1220,11) -->
<ExitCode Value="-2067529717" Result="Fail"
String="AnotherInstanceRunning"/>
<!-- 0x84BE01F8 (1214,504) -->
<ExitCode Value="-2067922440" Result="Fail"
String="BetaComponentsFailure"/>
<!-- 0x84BE01FA (1214,506) -->
<ExitCode Value="-2067922438" Result="Fail"
String="BetaComponentsFailure"/>
<!-- 0x84BE0202 (1214,514) -->
<ExitCode Value="-2067922430" Result="Fail"
String="InvalidPlatformArchitecture"/>
<!-- 0x84BE0203 (1214,515) -->
<ExitCode Value="-2067922429" Result="Fail"
String="InvalidPlatformArchitecture"/>
<ExitCode Value="216" Result="Fail"
String="InvalidPlatformArchitecture"/>
<DefaultExitCode Result="Fail"
FormatMessageFromSystem="true" String="GeneralFailure" />
</ExitCodes>
</Command>
===============
====================================== This is the log from
install.log=========================================================
Running checks for package 'SQL Server 2008 Express Edition', phase BuildList
Running external check with command
'D:\DOCUME~1\APERRE~1\LOCALS~1\Temp\VSD713.tmp\SQLExpress2008\SqlExpressChk.exe'
and parameters ''
Process exited with code 9023073
Setting value '9023073 {int}' for property 'SQLExpressInstalled'
Reading value 'CurrentVersion' of registry key
'HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion'
Read string value '9.00.3042.00'
Running check with folder '' and file '9.00.3042.00'
Unable to find directory ''
Not setting value for property 'DefaultSQLInstalled'
The following properties have been set for package 'SQL Server 2008 Express
Edition':
Property: [SQLExpressInstalled] = 9023073 {int}
Running checks for command 'SQLExpress2008\SQLEXPR32_x86_ENU.EXE'
Result of running operator 'ValueExists' on property 'DefaultSQLInstalled':
false
Result of running operator 'ValueNotEqualTo' on property
'ProcessorArchitecture' and value 'Intel': false
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value
'5.1.2': false
Result of running operator 'VersionEqualTo' on property 'VersionNT' and value
'5.2.0': false
Result of running operator 'VersionEqualTo' on property 'VersionNT' and value
'5.2.1': false
Result of running operator 'ValueEqualTo' on property 'AdminUser' and value
'false': false
Result of checks for command 'SQLExpress2008\SQLEXPR32_x86_ENU.EXE' is 'Install'
Running checks for command 'SQLExpress2008\SQLEXPR32_x86_ENU.EXE'
Result of running operator 'ValueExists' on property 'DefaultSQLInstalled':
false
Result of running operator 'ValueNotEqualTo' on property
'ProcessorArchitecture' and value 'Intel': false
Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and
value '0': false
Result of running operator 'ValueLessThan' on property 'SQLExpressInstalled'
and value '0': false
Result of running operator 'ValueGreaterThanEqualTo' on property
'SQLExpressInstalled' and value '10001600': false
Result of running operator 'ValueExists' on property 'Version9x': false
Result of running operator 'VersionLessThan' on property 'VersionNT' and value
'5.1.2': false
Result of running operator 'VersionEqualTo' on property 'VersionNT' and value
'5.2.0': false
Result of running operator 'VersionEqualTo' on property 'VersionNT' and value
'5.2.1': false
Result of running operator 'ValueEqualTo' on property 'AdminUser' and value
'false': false
Result of checks for command 'SQLExpress2008\SQLEXPR32_x86_ENU.EXE' is 'Install'
Running checks for command 'SQLExpress2008\SQLEXPR_x64_ENU.EXE'
Result of running operator 'ValueExists' on property 'DefaultSQLInstalled':
false
Result of running operator 'ValueNotEqualTo' on property
'ProcessorArchitecture' and value 'amd64': true
Result of checks for command 'SQLExpress2008\SQLEXPR_x64_ENU.EXE' is 'Bypass'
Running checks for command 'SQLExpress2008\SQLEXPR_x64_ENU.EXE'
Result of running operator 'ValueNotEqualTo' on property
'ProcessorArchitecture' and value 'amd64': true
Result of checks for command 'SQLExpress2008\SQLEXPR_x64_ENU.EXE' is 'Bypass'
'SQL Server 2008 Express Edition' RunCheck result: Install Needed
Arun Perregattur
------------------------------------------------------------------------------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
