Hello, I try to create a Bootstrapper to install SQL EXPRESS 2012
I have create a custom UI to ask the user to Password and Instancename.
If I put hardcoded the Instancename and Password then it works. But I didn´t
find the correct syntax to use the new Variables. Here are my package
definition:
<Fragment>
<!-- Installationsparameter von SQL-Server Express:
http://msdn.microsoft.com/de-de/library/ms144259.aspx -->
<?define SqlInstallCommand=/ACTION=Install /QS
/IACCEPTSQLSERVERLICENSETERMS /UpdateEnabled=0 /FEATURES=SQL,RS,SSMS,Conn,BC
/ADDCURRENTUSERASSQLADMIN=True /AGTSVCACCOUNT="NT
AUTHORITY\NetworkService" /BROWSERSVCSTARTUPTYPE=Automatic
/SECURITYMODE=SQL /SQLSVCACCOUNT="NT AUTHORITY\NetworkService"
/SQLSVCSTARTUPTYPE=Automatic /TCPENABLED=1
/RSINSTALLMODE="FilesOnlyMode" /RSSVCACCOUNT="NT
AUTHORITY\NetworkService" /RSSVCStartupType=Automatic ?>
<PackageGroup Id ="PG_MsSqlSrv2012Express">
<ExePackage Id="SQLExpressx64"
DisplayName="Microsoft® SQL Server® 2012 - Express Edition
x64"
SourceFile="$(var.PreReqFolder)SQLEXPRADV_x64_DEU.exe"
Name="Redist\SQLEXPRADV_x64_ENU.exe"
InstallCommand='$(var.SqlInstallCommand) /SAPWD=[Password]
/INSTANCENAME=[InstanceName]'
InstallCondition="Not SqlInstanceFoundx64Express AND Not
SqlInstanceFoundExpress AND VersionNT64 AND Package="ALL""
DetectCondition="SqlInstanceFoundx64"
Cache="no"
Compressed="no"
PerMachine="yes"
Permanent="yes"/>
</Packagegroup>
</Fragment>
If I remove the brackets around Password and InstanceName then the SQL will
installed. But othertime the Log show an Apply/Cancel without any helpful
information
[04D0:0914][2013-11-18T20:13:01]i000: Loading managed bootstrapper
application.
[04D0:0914][2013-11-18T20:13:01]i000: Creating BA thread to run
asynchronously.
[04D0:0B70][2013-11-18T20:13:01]i000: Setting string variable 'InstanceName'
to value 'SQLEXPRESS110'
[04D0:0B70][2013-11-18T20:13:01]i000: Setting string variable 'Username' to
value 'SA'
[04D0:0B70][2013-11-18T20:13:01]i000: Setting string variable 'Password' to
value 'SuperSQL2012'
[04D0:0914][2013-11-18T20:13:02]i100: Detect begin, 6 packages
[04D0:0914][2013-11-18T20:13:02]i000: Registry key not found. Key =
'SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL'
[04D0:0914][2013-11-18T20:13:02]i000: Setting numeric variable
'SqlInstanceFoundExpress' to value 0
[04D0:0914][2013-11-18T20:13:02]i000: Registry key not found. Key =
'SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL'
[04D0:0914][2013-11-18T20:13:02]i000: Setting numeric variable
'SqlInstanceFoundExpress' to value 0
[04D0:0914][2013-11-18T20:13:02]i000: Registry key not found. Key =
'SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL'
[04D0:0914][2013-11-18T20:13:02]i000: Setting numeric variable
'SqlInstanceFoundExpress' to value 0
[04D0:0914][2013-11-18T20:13:02]i000: Registry key not found. Key =
'SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL'
[04D0:0914][2013-11-18T20:13:02]i000: Setting numeric variable
'SqlInstanceFoundx64Express' to value 0
[04D0:0914][2013-11-18T20:13:02]i000: Registry key not found. Key =
'SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL'
[04D0:0914][2013-11-18T20:13:02]i000: Setting numeric variable
'SqlInstanceFoundx64Express' to value 0
[04D0:0914][2013-11-18T20:13:02]i000: Registry key not found. Key =
'SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL'
[04D0:0914][2013-11-18T20:13:02]i000: Setting numeric variable
'SqlInstanceFoundx64Express' to value 0
[04D0:0914][2013-11-18T20:13:02]i102: Detected related bundle:
{2c98b1f7-242f-4daf-870d-6eb15ba7d083}, type: Upgrade, scope: PerMachine,
version: 1.0.0.0, operation: None
[04D0:0914][2013-11-18T20:13:02]i102: Detected related bundle:
{93c55f27-2c71-4096-ab43-3dccc5e1db80}, type: Upgrade, scope: PerMachine,
version: 1.0.0.0, operation: None
[04D0:0914][2013-11-18T20:13:02]i102: Detected related bundle:
{9a3d0056-d397-4931-ada4-92d739cd79c4}, type: Upgrade, scope: PerMachine,
version: 1.0.0.0, operation: None
[04D0:0914][2013-11-18T20:13:02]i102: Detected related bundle:
{aa07a58c-0d74-4a98-aabe-78a09b7c42f9}, type: Upgrade, scope: PerMachine,
version: 1.0.0.0, operation: None
[04D0:0914][2013-11-18T20:13:02]i052: Condition 'SqlInstanceFoundx64'
evaluates to false.
[04D0:0914][2013-11-18T20:13:02]i052: Condition 'SqlInstanceFound' evaluates
to false.
[04D0:0914][2013-11-18T20:13:02]i052: Condition 'SqlInstanceFoundx64'
evaluates to false.
[04D0:0914][2013-11-18T20:13:02]i052: Condition 'SqlInstanceFound' evaluates
to false.
[04D0:0914][2013-11-18T20:13:02]i052: Condition 'SqlInstanceFoundx64'
evaluates to false.
[04D0:0914][2013-11-18T20:13:02]i052: Condition 'SqlInstanceFound' evaluates
to false.
[04D0:0914][2013-11-18T20:13:02]i101: Detected package: SQLExpressx64,
state: Absent, cached: Complete
[04D0:0914][2013-11-18T20:13:02]i101: Detected package: SQLExpressx86,
state: Absent, cached: None
[04D0:0914][2013-11-18T20:13:02]i101: Detected package: SQLExpressx64Only,
state: Absent, cached: Complete
[04D0:0914][2013-11-18T20:13:02]i101: Detected package: SQLExpressx86Only,
state: Absent, cached: None
[04D0:0914][2013-11-18T20:13:02]i101: Detected package: SQLExpressx64RSOnly,
state: Absent, cached: Complete
[04D0:0914][2013-11-18T20:13:02]i101: Detected package: SQLExpressx86RSOnly,
state: Absent, cached: None
[04D0:0914][2013-11-18T20:13:02]i199: Detect complete, result: 0x0
[04D0:0B70][2013-11-18T20:13:05]i000: Setting string variable 'Package' to
value 'ALL'
[04D0:0914][2013-11-18T20:13:08]i200: Plan begin, 6 packages, action:
Install
[04D0:0914][2013-11-18T20:13:08]i052: Condition 'Not
SqlInstanceFoundx64Express AND Not SqlInstanceFoundExpress AND VersionNT64
AND Package="ALL"' evaluates to true.
[04D0:0914][2013-11-18T20:13:08]w321: Skipping dependency registration on
package with no dependency providers: SQLExpressx64
[04D0:0914][2013-11-18T20:13:08]i000: Setting string variable
'WixBundleLog_SQLExpressx64' to value
'C:\Benutzer\ADMINI~1\AppData\Local\Temp\Daten-Infrastruktur-Installer_(MS_S
QL_2012_Express)_20131118201301_0_SQLExpressx64.log'
[04D0:0914][2013-11-18T20:13:08]i052: Condition 'Not SqlInstanceFoundExpress
AND Not VersionNT64 AND Package="ALL"' evaluates to false.
[04D0:0914][2013-11-18T20:13:08]w321: Skipping dependency registration on
package with no dependency providers: SQLExpressx86
[04D0:0914][2013-11-18T20:13:08]i052: Condition 'Not
SqlInstanceFoundx64ExpressOnly AND Not SqlInstanceFoundExpressOnly AND
VersionNT64 AND Package="MSSQL"' evaluates to false.
[04D0:0914][2013-11-18T20:13:08]w321: Skipping dependency registration on
package with no dependency providers: SQLExpressx64Only
[04D0:0914][2013-11-18T20:13:08]i052: Condition 'Not
SqlInstanceFoundExpressOnly AND Not VersionNT64 AND Package="MSSQL"'
evaluates to false.
[04D0:0914][2013-11-18T20:13:08]w321: Skipping dependency registration on
package with no dependency providers: SQLExpressx86Only
[04D0:0914][2013-11-18T20:13:08]i052: Condition 'Not
SqlInstanceFoundx64ExpressRSOnly AND Not SqlInstanceFoundExpressRSOnly AND
VersionNT64 AND Package="RS"' evaluates to false.
[04D0:0914][2013-11-18T20:13:08]w321: Skipping dependency registration on
package with no dependency providers: SQLExpressx64RSOnly
[04D0:0914][2013-11-18T20:13:08]i052: Condition 'Not
SqlInstanceFoundExpressRSOnly AND Not VersionNT64 AND Package="RS"'
evaluates to false.
[04D0:0914][2013-11-18T20:13:08]w321: Skipping dependency registration on
package with no dependency providers: SQLExpressx86RSOnly
[04D0:0914][2013-11-18T20:13:08]i201: Planned package: SQLExpressx64, state:
Absent, default requested: Present, ba requested: Present, execute: Install,
rollback: None, cache: No, uncache: Yes, dependency: None
[04D0:0914][2013-11-18T20:13:08]i201: Planned package: SQLExpressx86, state:
Absent, default requested: Absent, ba requested: Absent, execute: None,
rollback: None, cache: No, uncache: No, dependency: None
[04D0:0914][2013-11-18T20:13:08]i201: Planned package: SQLExpressx64Only,
state: Absent, default requested: Absent, ba requested: Absent, execute:
None, rollback: None, cache: No, uncache: Yes, dependency: None
[04D0:0914][2013-11-18T20:13:08]i201: Planned package: SQLExpressx86Only,
state: Absent, default requested: Absent, ba requested: Absent, execute:
None, rollback: None, cache: No, uncache: No, dependency: None
[04D0:0914][2013-11-18T20:13:08]i201: Planned package: SQLExpressx64RSOnly,
state: Absent, default requested: Absent, ba requested: Absent, execute:
None, rollback: None, cache: No, uncache: Yes, dependency: None
[04D0:0914][2013-11-18T20:13:08]i201: Planned package: SQLExpressx86RSOnly,
state: Absent, default requested: Absent, ba requested: Absent, execute:
None, rollback: None, cache: No, uncache: No, dependency: None
[04D0:0914][2013-11-18T20:13:08]i207: Planned related bundle:
{2c98b1f7-242f-4daf-870d-6eb15ba7d083}, type: Upgrade, default requested:
None, ba requested: None, execute: None, rollback: None, dependency: None
[04D0:0914][2013-11-18T20:13:08]i207: Planned related bundle:
{93c55f27-2c71-4096-ab43-3dccc5e1db80}, type: Upgrade, default requested:
None, ba requested: None, execute: None, rollback: None, dependency: None
[04D0:0914][2013-11-18T20:13:08]i207: Planned related bundle:
{9a3d0056-d397-4931-ada4-92d739cd79c4}, type: Upgrade, default requested:
None, ba requested: None, execute: None, rollback: None, dependency: None
[04D0:0914][2013-11-18T20:13:08]i207: Planned related bundle:
{aa07a58c-0d74-4a98-aabe-78a09b7c42f9}, type: Upgrade, default requested:
None, ba requested: None, execute: None, rollback: None, dependency: None
[04D0:0914][2013-11-18T20:13:08]i299: Plan complete, result: 0x0
[04D0:0914][2013-11-18T20:13:08]i300: Apply begin
[04D0:0B70][2013-11-18T20:13:08]i000: Cancelling...
[0700:010C][2013-11-18T20:13:09]i360: Creating a system restore point.
[0700:010C][2013-11-18T20:13:34]i361: Created a system restore point.
Did someone a good idea how I can find out what is wrong? I thing that
should be the right uing of the quotes but I have try much combinations
and no one works
Freundliche Grüße / Best regards
Michael
------------------------------------------------------------------------------
Shape the Mobile Experience: Free Subscription
Software experts and developers: Be at the forefront of tech innovation.
Intel(R) Software Adrenaline delivers strategic insight and game-changing
conversations that shape the rapidly evolving mobile landscape. Sign up now.
http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
