[wix-users] Installing windows SQL 2016 Express fails to extract

[Carlos Sosa]

Hello, I got this to work and this is my report back.
Thanks for all your help and comments:

The reason (I do not know why, maybe someone can explain) is that the name of my exe was too long?  
No indication on the logs that this was the problem:

*****
Applying execute package: SQL, action: Install, path: C:\ProgramData\Package Cache\1FDD945052F4A4B0CC9C8F1CC12385F85EB80D96\en_sql_server_2016_express_with_service_pack_1_x64_9540756.exe, arguments: '"C:\ProgramData\Package Cache\1FDD945052F4A4B0CC9C8F1CC12385F85EB80D96\en_sql_server_2016_express_with_service_pack_1_x64_9540756.exe" /Q /IACCEPTSQLSERVERLICENSETERMS /SAPWD=XXXXXXXXXXXXX /ACTION=Install /FEATURES=SQL /SECURITYMODE=SQL /INSTANCENAME=MYINSTANCENAME'
[0B08:0B0C][2017-06-02T09:58:41]e000: Error 0x84be0009: Process returned error: 0x84be0009
[0B08:0B0C][2017-06-02T09:58:41]e000: Error 0x84be0009: Failed to execute EXE package.
[0AE0:0AE4][2017-06-02T09:58:41]e000: Error 0x84be0009: Failed to configure per-machine EXE package.
[0AE0:0AE4][2017-06-02T09:58:41]i319: Applied execute package: SQL, result: 0x84be0009, restart: None
[0AE0:0AE4][2017-06-02T09:58:41]e000: Error 0x84be0009: Failed to execute EXE package.
*****

By the way There you can see the command line that you can use to install SQL 2016 express in silent mode :) (for which I couldn't find an example anywhere)

As you can see the name of the exe is en_sql_server_2016_express_with_service_pack_1_x64_9540756.exe this FAILS using WIX, if I run the command (using the long name) in cmd by itself, it works just fine.
I changed the name of the exe to test.exe and created my bundle and it ran just fine.

So my conclusion: Long names are not supported on the  <ExePackage> or something is just not quite right.

I hope it helps someone in the future.
Best.


-----Original Message-----
From: wix-users [mailto:wix-users-bounces at lists.wixtoolset.org] On Behalf Of Hoover, Jacob
Sent: Wednesday, May 31, 2017 1:31 PM
To: WiX Toolset Users Mailing List <wix-users at lists.wixtoolset.org>
Subject: Re: [wix-users] Installing windows SQL 2016 Express fails to extract

The EXE will be extracted from the bundle, to the identified location.  You can't change this by design (short of a policy which would redirect the package cache for every WiX based install). The en_sql_server_2016_express_with_service_pack_1_x64_9540756.exe file will be an exact copy of what you authored in your bundle at compile/link time, but when it is executed it should do its own extraction.

You say that it tries to install to program data, do you have logs of this? Both burn and SQL Server should have its own logs, which will tell us what is really happening and what the error is if any.

-----Original Message-----
From: wix-users [mailto:wix-users-bounces at lists.wixtoolset.org] On Behalf Of Carlos Sosa
Sent: Wednesday, May 31, 2017 2:04 PM
To: WiX Toolset Users Mailing List <wix-users at lists.wixtoolset.org>
Subject: Re: [wix-users] Installing windows SQL 2016 Express fails to extract

I tried that because it was the only reference to "a" for in the documentation, but that didn't work. I removed that (I forgot to remove it from the example)

Still tries to install to the programdata.

Get Outlook for Android<https://aka.ms/ghei36>



From: Hoover, Jacob
Sent: Wednesday, May 31, 12:59 PM
Subject: Re: [wix-users] Installing windows SQL 2016 Express fails to extract
To: WiX Toolset Users Mailing List


Why are you doing this? /INSTALLSHAREDDIR=C:\ /INSTALLSHAREDWOWDIR=C:\ A) Your assuming that a C drive exists. B) Your saying that both the 64 bit and 32 bit shared components should go in the root of the C drive. https://docs.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-2016-from-the-command-prompt -----Original Message----- From: wix-users [mailto:wix-users-bounces at lists.wixtoolset.org] On Behalf Of Carlos Sosa Sent: Wednesday, May 31, 2017 11:34 AM To: WiX Toolset Users Mailing List Subject: [wix-users] Installing windows SQL 2016 Express fails to extract Hello I'm trying to install SQL 2016 express but it fails What I can find is that when I run the exe by itself, the default directory to extract to is: C:\c4b06d43e620d8498596a0060e\ But when I run it with WIX: C:\ProgramData\Package Cache\1FDD945052F4A4B0CC9C8F1CC12385F85EB80D96\Installing SQL Server Express 2016\ Installing on ProgramData Fails, I can't find where to change this, any idea, 
  please? Best. ____________________________________________________________________ WiX Toolset Users Mailing List provided by FireGiant http://www.firegiant.com/ ____________________________________________________________________ WiX Toolset Users Mailing List provided by FireGiant http://www.firegiant.com/


____________________________________________________________________
WiX Toolset Users Mailing List provided by FireGiant http://www.firegiant.com/

____________________________________________________________________
WiX Toolset Users Mailing List provided by FireGiant http://www.firegiant.com/