Add SQL Server Express 2008 to install package

[Pat4040]

Hi,
I have a question - hope it doesnt sound too stupid! We are packaging our solution, which requires SQL Express 2008. We are defining it as a feature based prerequisite, downloaded from MS. Because most of our current installs out in the wild have SQL Express 2008 SP2, we did not define R2, as I am unsure how to have SQL install silently *and* perform an upgrade if needed - however R2 is preferable as we would also like to install SQL Management Studio.

We've tried using the downloaded installation package with the command line variables needed, such as /ACTION=Install. However, some of the command lines don't run unless attached to the extracted "setup.exe" file which is extracted by the SQL installation file into a random temp directory on the users C: drive.

In addition, we are in both 32 and 64 bit environments, and would like to select the appropriate file for download and install.

My questions are:

1) How do we download the SQL installation file, have it extract AND THEN run the setup.exe with the command line parameters?
2) Do you know if there is a way to use R2 which will Install if not present or Upgrade if present?
3) Do you know of a way to have the proper 32 or 64 bit program installed?
4) It seems that SQL Express is wanting Windows Installer 4.5, which I do not see on your list of predefined prerequisites? Is this by design?

These may sound simple and I have searched but maybe am not using the right search questions. I'm fairly new so please excuse my ignorance. Thanks for your help...

PS We have purchased the Enterprise version, running most recent version.

[mihai.petcu]

Hello and welcome to Advanced Installer forums,

You can easily choose the appropriate "SQL Express 2008" edition from our predefined prerequisites' list.

How do we download the SQL installation file, have it extract AND THEN run the setup.exe with the command line parameters?

This can be configured from the "Install Command Lines" section of the prerequisite's Prerequisite Setup Files Tab.

Do you know if there is a way to use R2 which will Install if not present or Upgrade if present?

Usually this scenario is handled automatically by the prerequisite package (side by side or automatically upgrade). However, there are more things to consider when upgrading. Here's a relevant link you should consider.

Do you know of a way to have the proper 32 or 64 bit program installed?

You could add the "SQL Express 2008" 64-bit installer as a feature-based prerequisite (you can use the predefined one as a model) and condition its installation by following user guide article:
How do I install resources based on the Operating System version?

It seems that SQL Express is wanting Windows Installer 4.5, which I do not see on your list of predefined prerequisites? Is this by design?

This is actually a display bug in Advanced Installer, thank you for bringing it to our attention. Each of the "WI" predefined prerequisites refers to Windows Installer 4.5 as described in this article.
We'll fix this in a future release.

All the best,
Mihai

[Pat4040]

Thanks for the help, but I still keep getting an error when trying to install SQL Server Express 2008 R2 as a selected prerequisite in my install package.

I'm running on XP Pro and downloading the predefined prerequisite, but keep getting 4154 immediately after the download completes.

Here's the log....any help is appreciated - I'm at a standstill until I can install SQL.

=== Verbose logging started: 5/1/2012 16:15:11 Build type: SHIP UNICODE 4.05.6001.00 Calling process: C:\WINDOWS\system32\msiexec.exe ===
MSI (c) (54:30) [16:15:11:949]: Resetting cached policy values
MSI (c) (54:30) [16:15:11:949]: Machine policy value 'Debug' is 0
MSI (c) (54:30) [16:15:11:949]: ******* RunEngine:
******* Product: C:\Documents and Settings\XPMUser\Application Data\Your Company\ST Test 050112 1200\install\Test SQL Install.msi
******* Action:
******* CommandLine: **********
MSI (c) (54:30) [16:15:11:949]: Machine policy value 'DisableUserInstalls' is 0
MSI (c) (54:30) [16:15:11:949]: SOFTWARE RESTRICTION POLICY: Verifying package --> 'C:\Documents and Settings\XPMUser\Application Data\Your Company\ST Test 050112 1200\install\Test SQL Install.msi' against software restriction policy
MSI (c) (54:30) [16:15:11:949]: Note: 1: 2262 2: DigitalSignature 3: -2147287038
MSI (c) (54:30) [16:15:11:949]: SOFTWARE RESTRICTION POLICY: C:\Documents and Settings\XPMUser\Application Data\Your Company\ST Test 050112 1200\install\Test SQL Install.msi is not digitally signed
MSI (c) (54:30) [16:15:11:949]: SOFTWARE RESTRICTION POLICY: C:\Documents and Settings\XPMUser\Application Data\Your Company\ST Test 050112 1200\install\Test SQL Install.msi is permitted to run at the 'unrestricted' authorization level.
MSI (c) (54:30) [16:15:11:949]: Cloaking enabled.
MSI (c) (54:30) [16:15:11:949]: Attempting to enable all disabled privileges before calling Install on Server
MSI (c) (54:30) [16:15:11:959]: End dialog not enabled
MSI (c) (54:30) [16:15:11:959]: Original package ==> C:\Documents and Settings\XPMUser\Application Data\Your Company\ST Test 050112 1200\install\Test SQL Install.msi
MSI (c) (54:30) [16:15:11:959]: Package we're running from ==> C:\DOCUME~1\XPMUser\LOCALS~1\Temp\37e91f.msi
MSI (c) (54:30) [16:15:11:959]: APPCOMPAT: looking for appcompat database entry with ProductCode '{7581D08A-4EC1-47E0-A12F-962874950D8B}'.
MSI (c) (54:30) [16:15:11:959]: APPCOMPAT: no matching ProductCode found in database.
MSI (c) (54:30) [16:15:11:959]: MSCOREE not loaded loading copy from system32
MSI (c) (54:30) [16:15:11:959]: Machine policy value 'TransformsSecure' is 0
MSI (c) (54:30) [16:15:11:959]: User policy value 'TransformsAtSource' is 0
MSI (c) (54:30) [16:15:11:959]: Note: 1: 2262 2: File 3: -2147287038
MSI (c) (54:30) [16:15:11:959]: Note: 1: 2205 2: 3: MsiFileHash
MSI (c) (54:30) [16:15:11:959]: Machine policy value 'DisablePatch' is 0
MSI (c) (54:30) [16:15:11:959]: Machine policy value 'AllowLockdownPatch' is 0
MSI (c) (54:30) [16:15:11:959]: Machine policy value 'DisableLUAPatching' is 0
MSI (c) (54:30) [16:15:11:959]: Machine policy value 'DisableFlyWeightPatching' is 0
MSI (c) (54:30) [16:15:11:959]: APPCOMPAT: looking for appcompat database entry with ProductCode '{7581D08A-4EC1-47E0-A12F-962874950D8B}'.
MSI (c) (54:30) [16:15:11:959]: APPCOMPAT: no matching ProductCode found in database.
MSI (c) (54:30) [16:15:11:959]: Transforms are not secure.
MSI (c) (54:30) [16:15:11:959]: PROPERTY CHANGE: Adding MsiLogFileLocation property. Its value is 'C:\DOCUME~1\XPMUser\LOCALS~1\Temp\MSI7e91e.LOG'.
MSI (c) (54:30) [16:15:11:959]: Command Line: AI_SETUPEXEPATH=C:\Documents and Settings\XPMUser\Desktop\Test SQL Install.exe SETUPEXEDIR=C:\Documents and Settings\XPMUser\Desktop\ EXE_CMD_LINE=/exenoupdates /exelang 0 /noprereqs CURRENTDIRECTORY=C:\Documents and Settings\XPMUser\Desktop CLIENTUILEVEL=0 CLIENTPROCESSID=3412
MSI (c) (54:30) [16:15:11:959]: PROPERTY CHANGE: Adding PackageCode property. Its value is '{AA23DBCC-6002-4B80-9C54-1170AA2739BE}'.
MSI (c) (54:30) [16:15:11:959]: Product Code passed to Engine.Initialize: ''
MSI (c) (54:30) [16:15:11:959]: Product Code from property table before transforms: '{7581D08A-4EC1-47E0-A12F-962874950D8B}'
MSI (c) (54:30) [16:15:11:959]: Product Code from property table after transforms: '{7581D08A-4EC1-47E0-A12F-962874950D8B}'
MSI (c) (54:30) [16:15:11:959]: Product not registered: beginning first-time install
MSI (c) (54:30) [16:15:11:959]: PROPERTY CHANGE: Adding ProductState property. Its value is '-1'.
MSI (c) (54:30) [16:15:11:959]: Entering CMsiConfigurationManager::SetLastUsedSource.
MSI (c) (54:30) [16:15:11:959]: User policy value 'SearchOrder' is 'nmu'
MSI (c) (54:30) [16:15:11:959]: Adding new sources is allowed.
MSI (c) (54:30) [16:15:11:959]: PROPERTY CHANGE: Adding PackagecodeChanging property. Its value is '1'.
MSI (c) (54:30) [16:15:11:959]: Package name extracted from package path: 'Test SQL Install.msi'
MSI (c) (54:30) [16:15:11:959]: Package to be registered: 'Test SQL Install.msi'
MSI (c) (54:30) [16:15:11:959]: Note: 1: 2262 2: AdminProperties 3: -2147287038
MSI (c) (54:30) [16:15:11:959]: Machine policy value 'DisableMsi' is 0
MSI (c) (54:30) [16:15:11:959]: Machine policy value 'AlwaysInstallElevated' is 0
MSI (c) (54:30) [16:15:11:959]: User policy value 'AlwaysInstallElevated' is 0
MSI (c) (54:30) [16:15:11:959]: Product installation will be elevated because user is admin and product is being installed per-machine.
MSI (c) (54:30) [16:15:11:959]: Running product '{7581D08A-4EC1-47E0-A12F-962874950D8B}' with elevated privileges: Product is assigned.
MSI (c) (54:30) [16:15:11:959]: PROPERTY CHANGE: Adding AI_SETUPEXEPATH property. Its value is 'C:\Documents and Settings\XPMUser\Desktop\Test SQL Install.exe'.
MSI (c) (54:30) [16:15:11:959]: PROPERTY CHANGE: Adding SETUPEXEDIR property. Its value is 'C:\Documents and Settings\XPMUser\Desktop\'.
MSI (c) (54:30) [16:15:11:959]: PROPERTY CHANGE: Adding EXE_CMD_LINE property. Its value is '/exenoupdates /exelang 0 /noprereqs '.
MSI (c) (54:30) [16:15:11:959]: PROPERTY CHANGE: Adding CURRENTDIRECTORY property. Its value is 'C:\Documents and Settings\XPMUser\Desktop'.
MSI (c) (54:30) [16:15:11:959]: PROPERTY CHANGE: Adding CLIENTUILEVEL property. Its value is '0'.
MSI (c) (54:30) [16:15:11:959]: PROPERTY CHANGE: Adding CLIENTPROCESSID property. Its value is '3412'.
MSI (c) (54:30) [16:15:11:959]: TRANSFORMS property is now:
MSI (c) (54:30) [16:15:11:959]: PROPERTY CHANGE: Adding VersionDatabase property. Its value is '200'.
MSI (c) (54:30) [16:15:11:959]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\XPMUser\Application Data
MSI (c) (54:30) [16:15:11:959]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\XPMUser\Favorites
MSI (c) (54:30) [16:15:11:959]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\XPMUser\NetHood
MSI (c) (54:30) [16:15:11:959]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\XPMUser\My Documents
MSI (c) (54:30) [16:15:11:959]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\XPMUser\PrintHood
MSI (c) (54:30) [16:15:11:959]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\XPMUser\Recent
MSI (c) (54:30) [16:15:11:959]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\XPMUser\SendTo
MSI (c) (54:30) [16:15:11:959]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\XPMUser\Templates
MSI (c) (54:30) [16:15:11:959]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\All Users\Application Data
MSI (c) (54:30) [16:15:11:959]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\XPMUser\Local Settings\Application Data
MSI (c) (54:30) [16:15:11:959]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\XPMUser\My Documents\My Pictures
MSI (c) (54:30) [16:15:11:959]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\All Users\Start Menu\Programs\Administrative Tools
MSI (c) (54:30) [16:15:11:959]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\All Users\Start Menu\Programs\Startup
MSI (c) (54:30) [16:15:11:959]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\All Users\Start Menu\Programs
MSI (c) (54:30) [16:15:11:959]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\All Users\Start Menu
MSI (c) (54:30) [16:15:11:959]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\All Users\Desktop
MSI (c) (54:30) [16:15:11:959]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\XPMUser\Start Menu\Programs\Administrative Tools
MSI (c) (54:30) [16:15:11:959]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\XPMUser\Start Menu\Programs\Startup
MSI (c) (54:30) [16:15:11:959]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\XPMUser\Start Menu\Programs
MSI (c) (54:30) [16:15:11:959]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\XPMUser\Start Menu
MSI (c) (54:30) [16:15:11:959]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\XPMUser\Desktop
MSI (c) (54:30) [16:15:11:959]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\All Users\Templates
MSI (c) (54:30) [16:15:11:959]: SHELL32::SHGetFolderPath returned: C:\WINDOWS\Fonts
MSI (c) (54:30) [16:15:11:959]: Note: 1: 2898 2: MS Sans Serif 3: MS Sans Serif 4: 0 5: 16
MSI (c) (54:30) [16:15:11:959]: PROPERTY CHANGE: Adding Privileged property. Its value is '1'.
MSI (c) (54:30) [16:15:11:959]: Note: 1: 1402 2: HKEY_CURRENT_USER\Software\Microsoft\MS Setup (ACME)\User Info 3: 2
MSI (c) (54:30) [16:15:11:959]: PROPERTY CHANGE: Adding USERNAME property. Its value is 'Windows XP Mode'.
MSI (c) (54:30) [16:15:11:959]: Note: 1: 1402 2: HKEY_CURRENT_USER\Software\Microsoft\MS Setup (ACME)\User Info 3: 2
MSI (c) (54:30) [16:15:11:959]: PROPERTY CHANGE: Adding DATABASE property. Its value is 'C:\DOCUME~1\XPMUser\LOCALS~1\Temp\37e91f.msi'.
MSI (c) (54:30) [16:15:11:959]: PROPERTY CHANGE: Adding OriginalDatabase property. Its value is 'C:\Documents and Settings\XPMUser\Application Data\Your Company\ST Test 050112 1200\install\Test SQL Install.msi'.
MSI (c) (54:30) [16:15:11:959]: Machine policy value 'MsiDisableEmbeddedUI' is 0
MSI (c) (54:30) [16:15:11:959]: PROPERTY CHANGE: Adding SourceDir property. Its value is 'C:\Documents and Settings\XPMUser\Application Data\Your Company\ST Test 050112 1200\install\'.
MSI (c) (54:30) [16:15:11:959]: PROPERTY CHANGE: Adding SOURCEDIR property. Its value is 'C:\Documents and Settings\XPMUser\Application Data\Your Company\ST Test 050112 1200\install\'.
MSI (c) (54:44) [16:15:11:959]: PROPERTY CHANGE: Adding VersionHandler property. Its value is '4.05'.
=== Logging started: 5/1/2012 16:15:11 ===
MSI (c) (54:30) [16:15:11:959]: Note: 1: 2262 2: PatchPackage 3: -2147287038
MSI (c) (54:30) [16:15:11:959]: Note: 1: 2262 2: Media 3: -2147287038
MSI (c) (54:30) [16:15:11:959]: Machine policy value 'DisableRollback' is 0
MSI (c) (54:30) [16:15:11:959]: User policy value 'DisableRollback' is 0
MSI (c) (54:30) [16:15:11:959]: PROPERTY CHANGE: Adding UILevel property. Its value is '5'.
MSI (c) (54:30) [16:15:11:959]: PROPERTY CHANGE: Adding ACTION property. Its value is 'INSTALL'.
MSI (c) (54:30) [16:15:11:959]: Doing action: INSTALL
Action start 16:15:11: INSTALL.
MSI (c) (54:30) [16:15:11:969]: UI Sequence table 'InstallUISequence' is present and populated.
MSI (c) (54:30) [16:15:11:969]: Running UISequence
MSI (c) (54:30) [16:15:11:969]: PROPERTY CHANGE: Adding EXECUTEACTION property. Its value is 'INSTALL'.
MSI (c) (54:30) [16:15:11:969]: Doing action: AI_SET_INSTALL
Action start 16:15:11: AI_SET_INSTALL.
MSI (c) (54:30) [16:15:11:969]: PROPERTY CHANGE: Adding AI_INSTALL property. Its value is '1'.
Action ended 16:15:11: AI_SET_INSTALL. Return value 1.
MSI (c) (54:30) [16:15:11:969]: Skipping action: AI_SET_MAINT (condition is false)
MSI (c) (54:30) [16:15:11:969]: Skipping action: AI_SET_RESUME (condition is false)
MSI (c) (54:30) [16:15:11:969]: Skipping action: AI_SET_PATCH (condition is false)
MSI (c) (54:30) [16:15:11:969]: Skipping action: AI_CORRECT_INSTALL (condition is false)
MSI (c) (54:30) [16:15:11:969]: Doing action: AI_ResolveKnownFolders
Action start 16:15:11: AI_ResolveKnownFolders.
MSI (c) (54:28) [16:15:11:979]: Invoking remote custom action. DLL: C:\DOCUME~1\XPMUser\LOCALS~1\Temp\MSI5F.tmp, Entrypoint: AI_ResolveKnownFolders
MSI (c) (54:AC) [16:15:11:979]: Cloaking enabled.
MSI (c) (54:AC) [16:15:11:979]: Attempting to enable all disabled privileges before calling Install on Server
MSI (c) (54:AC) [16:15:11:979]: Connected to service for CA interface.
MSI (c) (54!D8) [16:15:12:399]: PROPERTY CHANGE: Adding PublicDocumentsFolder property. Its value is 'C:\Documents and Settings\All Users\Documents'.
Action ended 16:15:12: AI_ResolveKnownFolders. Return value 1.
MSI (c) (54:30) [16:15:12:399]: Doing action: PrepareDlg
Action start 16:15:12: PrepareDlg.
Info 2898. For DlgFont8 textstyle, the system created a 'Tahoma' font, in 0 character set.
Info 2898. For VerdanaBold13 textstyle, the system created a 'Verdana' font, in 0 character set.
Info 2826. Control BottomLine on dialog PrepareDlg extends beyond the boundaries of the dialog to the right by 3 pixels.
Action ended 16:15:12: PrepareDlg. Return value 1.
MSI (c) (54:30) [16:15:12:429]: Doing action: AppSearch
Action start 16:15:12: AppSearch.
MSI (c) (54:30) [16:15:12:429]: Note: 1: 2262 2: Signature 3: -2147287038
MSI (c) (54:30) [16:15:12:429]: Note: 1: 1402 2: HKEY_CURRENT_USER\Software\Caphyon\Advanced Installer\LZMA\{7581D08A-4EC1-47E0-A12F-962874950D8B}\1.0.0 3: 2
MSI (c) (54:30) [16:15:12:429]: Note: 1: 2262 2: Signature 3: -2147287038
MSI (c) (54:30) [16:15:12:429]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Caphyon\Advanced Installer\LZMA\{7581D08A-4EC1-47E0-A12F-962874950D8B}\1.0.0 3: 2
Action ended 16:15:12: AppSearch. Return value 1.
MSI (c) (54:30) [16:15:12:429]: Doing action: AI_AppSearchEx
Action start 16:15:12: AI_AppSearchEx.
MSI (c) (54:E0) [16:15:12:459]: Invoking remote custom action. DLL: C:\DOCUME~1\XPMUser\LOCALS~1\Temp\MSI60.tmp, Entrypoint: DoAppSearchEx
MSI (c) (54!EC) [16:15:12:780]: PROPERTY CHANGE: Adding AI_SQL_2008_R2_ORIGINAL_PREREQSEARCH_1_PROPAiVerMin property. Its value is '10.50'.
MSI (c) (54!EC) [16:15:12:780]: PROPERTY CHANGE: Adding AI_SQL_2008_R2_ORIGINAL_SEARCH_2_PROPAiVerMin property. Its value is '10.50'.
Action ended 16:15:12: AI_AppSearchEx. Return value 1.
MSI (c) (54:30) [16:15:12:780]: Doing action: FindRelatedProducts
Action start 16:15:12: FindRelatedProducts.
Action ended 16:15:12: FindRelatedProducts. Return value 1.
MSI (c) (54:30) [16:15:12:780]: Skipping action: AI_DOWNGRADE (condition is false)
MSI (c) (54:30) [16:15:12:780]: Doing action: LaunchConditions
Action start 16:15:12: LaunchConditions.
Action ended 16:15:12: LaunchConditions. Return value 1.
MSI (c) (54:30) [16:15:12:790]: Doing action: CCPSearch
Action start 16:15:12: CCPSearch.
MSI (c) (54:30) [16:15:12:790]: Note: 1: 2205 2: 3: CCPSearch
MSI (c) (54:30) [16:15:12:790]: Note: 1: 2228 2: 3: CCPSearch 4: SELECT `Signature_` FROM `CCPSearch`
Action ended 16:15:12: CCPSearch. Return value 0.
MSI (c) (54:30) [16:15:12:790]: Doing action: RMCCPSearch
Action start 16:15:12: RMCCPSearch.
MSI (c) (54:30) [16:15:12:790]: Note: 1: 2205 2: 3: CCPSearch
MSI (c) (54:30) [16:15:12:790]: Note: 1: 2228 2: 3: CCPSearch 4: SELECT `Signature_` FROM `CCPSearch`
Action ended 16:15:12: RMCCPSearch. Return value 0.
MSI (c) (54:30) [16:15:12:790]: Doing action: AI_RESTORE_LOCATION
Action start 16:15:12: AI_RESTORE_LOCATION.
MSI (c) (54:CC) [16:15:12:810]: Invoking remote custom action. DLL: C:\DOCUME~1\XPMUser\LOCALS~1\Temp\MSI61.tmp, Entrypoint: RestoreLocation
Action ended 16:15:12: AI_RESTORE_LOCATION. Return value 1.
MSI (c) (54:30) [16:15:12:980]: Doing action: SET_APPDIR
Action start 16:15:12: SET_APPDIR.
MSI (c) (54:30) [16:15:12:980]: PROPERTY CHANGE: Adding APPDIR property. Its value is 'C:\Program Files\Your Company\ST Test 050112 1200'.
Action ended 16:15:12: SET_APPDIR. Return value 1.
MSI (c) (54:30) [16:15:12:980]: Doing action: SET_SHORTCUTDIR
Action start 16:15:12: SET_SHORTCUTDIR.
MSI (c) (54:30) [16:15:12:980]: PROPERTY CHANGE: Adding SHORTCUTDIR property. Its value is 'C:\Documents and Settings\All Users\Start Menu\Programs\ST Test 050112 1200'.
Action ended 16:15:12: SET_SHORTCUTDIR. Return value 1.
MSI (c) (54:30) [16:15:12:980]: Doing action: CostInitialize
Action start 16:15:12: CostInitialize.
MSI (c) (54:30) [16:15:12:980]: Machine policy value 'MaxPatchCacheSize' is 10
MSI (c) (54:30) [16:15:12:990]: PROPERTY CHANGE: Adding ROOTDRIVE property. Its value is 'C:\'.
MSI (c) (54:30) [16:15:12:990]: PROPERTY CHANGE: Adding CostingComplete property. Its value is '0'.
Action ended 16:15:12: CostInitialize. Return value 1.
MSI (c) (54:30) [16:15:12:990]: Doing action: FileCost
Action start 16:15:12: FileCost.
MSI (c) (54:30) [16:15:12:990]: Note: 1: 2205 2: 3: MsiAssembly
MSI (c) (54:30) [16:15:12:990]: Note: 1: 2205 2: 3: Class
MSI (c) (54:30) [16:15:12:990]: Note: 1: 2205 2: 3: Extension
MSI (c) (54:30) [16:15:12:990]: Note: 1: 2205 2: 3: TypeLib
Action ended 16:15:12: FileCost. Return value 1.
MSI (c) (54:30) [16:15:12:990]: Doing action: CostFinalize
Action start 16:15:12: CostFinalize.
MSI (c) (54:30) [16:15:12:990]: PROPERTY CHANGE: Adding OutOfDiskSpace property. Its value is '0'.
MSI (c) (54:30) [16:15:12:990]: PROPERTY CHANGE: Adding OutOfNoRbDiskSpace property. Its value is '0'.
MSI (c) (54:30) [16:15:12:990]: PROPERTY CHANGE: Adding PrimaryVolumeSpaceAvailable property. Its value is '0'.
MSI (c) (54:30) [16:15:12:990]: PROPERTY CHANGE: Adding PrimaryVolumeSpaceRequired property. Its value is '0'.
MSI (c) (54:30) [16:15:12:990]: PROPERTY CHANGE: Adding PrimaryVolumeSpaceRemaining property. Its value is '0'.
MSI (c) (54:30) [16:15:12:990]: Note: 1: 2262 2: Patch 3: -2147287038
MSI (c) (54:30) [16:15:12:990]: PROPERTY CHANGE: Adding TARGETDIR property. Its value is 'C:\'.
MSI (c) (54:30) [16:15:12:990]: PROPERTY CHANGE: Modifying APPDIR property. Its current value is 'C:\Program Files\Your Company\ST Test 050112 1200'. Its new value: 'C:\Program Files\Your Company\ST Test 050112 1200\'.
MSI (c) (54:30) [16:15:12:990]: Target path resolution complete. Dumping Directory table...
MSI (c) (54:30) [16:15:12:990]: Note: target paths subject to change (via custom actions or browsing)
MSI (c) (54:30) [16:15:12:990]: Dir (target): Key: TARGETDIR , Object: C:\
MSI (c) (54:30) [16:15:12:990]: Dir (target): Key: WindowsFolder , Object: C:\WINDOWS\
MSI (c) (54:30) [16:15:12:990]: Dir (target): Key: APPDIR , Object: C:\Program Files\Your Company\ST Test 050112 1200\
Action ended 16:15:12: CostFinalize. Return value 1.
MSI (c) (54:30) [16:15:12:990]: Doing action: MigrateFeatureStates
Action start 16:15:12: MigrateFeatureStates.
Action ended 16:15:12: MigrateFeatureStates. Return value 0.
MSI (c) (54:30) [16:15:12:990]: Doing action: WelcomeDlg
Action start 16:15:12: WelcomeDlg.
Info 2826. Control BottomLine on dialog WelcomeDlg extends beyond the boundaries of the dialog to the right by 3 pixels.
MSI (c) (54:F4) [16:15:13:010]: Note: 1: 2205 2: 3: MsiAssembly
MSI (c) (54:F4) [16:15:13:010]: Note: 1: 2228 2: 3: MsiAssembly 4: SELECT `MsiAssembly`.`Attributes`, `MsiAssembly`.`File_Application`, `MsiAssembly`.`File_Manifest`, `Component`.`KeyPath` FROM `MsiAssembly`, `Component` WHERE `MsiAssembly`.`Component_` = `Component`.`Component` AND `MsiAssembly`.`Component_` = ?
MSI (c) (54:F4) [16:15:13:010]: PROPERTY CHANGE: Modifying CostingComplete property. Its current value is '0'. Its new value: '1'.
MSI (c) (54:F4) [16:15:13:010]: Note: 1: 2205 2: 3: BindImage
MSI (c) (54:F4) [16:15:13:010]: Note: 1: 2205 2: 3: ProgId
MSI (c) (54:F4) [16:15:13:010]: Note: 1: 2205 2: 3: PublishComponent
MSI (c) (54:F4) [16:15:13:010]: Note: 1: 2205 2: 3: SelfReg
MSI (c) (54:F4) [16:15:13:010]: Note: 1: 2205 2: 3: Extension
MSI (c) (54:F4) [16:15:13:010]: Note: 1: 2205 2: 3: Font
MSI (c) (54:F4) [16:15:13:010]: Note: 1: 2205 2: 3: Shortcut
MSI (c) (54:F4) [16:15:13:010]: Note: 1: 2205 2: 3: Class
MSI (c) (54:F4) [16:15:13:010]: Note: 1: 2727 2:
Info 2898. For DlgFontBold8 textstyle, the system created a 'Tahoma' font, in 0 character set.
Info 2826. Control BannerLine on dialog FolderDlg extends beyond the boundaries of the dialog to the right by 3 pixels.
Info 2826. Control BottomLine on dialog FolderDlg extends beyond the boundaries of the dialog to the right by 3 pixels.
MSI (c) (54:44) [16:15:14:432]: Note: 1: 2727 2:
MSI (c) (54:44) [16:15:14:943]: Note: 1: 2727 2:
MSI (c) (54:44) [16:15:15:434]: Note: 1: 2727 2:
Info 2826. Control BannerLine on dialog VerifyReadyDlg extends beyond the boundaries of the dialog to the right by 3 pixels.
Info 2826. Control BottomLine on dialog VerifyReadyDlg extends beyond the boundaries of the dialog to the right by 3 pixels.
MSI (c) (54:44) [16:15:16:205]: Note: 1: 2727 2:
Action ended 16:15:16: WelcomeDlg. Return value 1.
MSI (c) (54:30) [16:15:16:515]: Skipping action: ResumeDlg (condition is false)
MSI (c) (54:30) [16:15:16:515]: Skipping action: MaintenanceWelcomeDlg (condition is false)
MSI (c) (54:30) [16:15:16:515]: Skipping action: PatchWelcomeDlg (condition is false)
MSI (c) (54:30) [16:15:16:515]: Doing action: ProgressDlg
Action start 16:15:16: ProgressDlg.
Info 2826. Control BannerLine on dialog ProgressDlg extends beyond the boundaries of the dialog to the right by 3 pixels.
Info 2826. Control BottomLine on dialog ProgressDlg extends beyond the boundaries of the dialog to the right by 3 pixels.
Action ended 16:15:16: ProgressDlg. Return value 1.
MSI (c) (54:30) [16:15:16:575]: Doing action: AI_DownloadPrereq
Action start 16:15:16: AI_DownloadPrereq.
MSI (c) (54:40) [16:15:16:796]: Invoking remote custom action. DLL: C:\DOCUME~1\XPMUser\LOCALS~1\Temp\MSI62.tmp, Entrypoint: DownloadPrereq
MSI (c) (54!70) [16:15:17:066]: PROPERTY CHANGE: Adding AI_PREREQDIRS property. Its value is 'C:\Documents and Settings\XPMUser\Application Data\Your Company\ST Test 050112 1200\install'.
MSI (c) (54!70) [16:15:17:076]: PROPERTY CHANGE: Adding AI_PREREQFILES property. Its value is 'C:\Documents and Settings\XPMUser\Application Data\Your Company\ST Test 050112 1200\install\CFEB55_E155_4C34_ACDD_F2302CF52CB1\SQLEXPR.EXE'.
Action ended 16:19:33: AI_DownloadPrereq. Return value 1.
MSI (c) (54:30) [16:19:33:184]: Doing action: AI_ExtractPrereq
Action start 16:19:33: AI_ExtractPrereq.
MSI (c) (54:94) [16:19:33:214]: Invoking remote custom action. DLL: C:\DOCUME~1\XPMUser\LOCALS~1\Temp\MSI64.tmp, Entrypoint: ExtractPrereq
Action ended 16:19:33: AI_ExtractPrereq. Return value 1.
MSI (c) (54:30) [16:19:33:385]: Doing action: AI_InstallPrerequisite
Action start 16:19:33: AI_InstallPrerequisite.
MSI (c) (54:30) [16:19:33:435]: Invoking remote custom action. DLL: C:\DOCUME~1\XPMUser\LOCALS~1\Temp\MSI65.tmp, Entrypoint: InstallPrereq
Action ended 16:19:33: AI_InstallPrerequisite. Return value 1.
MSI (c) (54:30) [16:19:33:765]: Doing action: ExecuteAction
Action start 16:19:33: ExecuteAction.
MSI (c) (54:30) [16:19:33:765]: PROPERTY CHANGE: Adding SECONDSEQUENCE property. Its value is '1'.
MSI (c) (54:30) [16:19:33:765]: Grabbed execution mutex.
MSI (c) (54:30) [16:19:33:765]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (c) (54:30) [16:19:33:765]: Switching to server: AI_INSTALL="1" APPDIR="C:\Program Files\Your Company\ST Test 050112 1200\" TARGETDIR="C:\" SHORTCUTDIR="C:\Documents and Settings\All Users\Start Menu\Programs\ST Test 050112 1200" AI_SETUPEXEPATH="C:\Documents and Settings\XPMUser\Desktop\Test SQL Install.exe" SETUPEXEDIR="C:\Documents and Settings\XPMUser\Desktop\" EXE_CMD_LINE="/exenoupdates /exelang 0 /noprereqs " CURRENTDIRECTORY="C:\Documents and Settings\XPMUser\Desktop" CLIENTUILEVEL="0" CLIENTPROCESSID="3412" USERNAME="Windows XP Mode" SOURCEDIR="C:\Documents and Settings\XPMUser\Application Data\Your Company\ST Test 050112 1200\install\" ACTION="INSTALL" EXECUTEACTION="INSTALL" AI_PREREQDIRS="C:\Documents and Settings\XPMUser\Application Data\Your Company\ST Test 050112 1200\install" ROOTDRIVE="C:\" SECONDSEQUENCE="1" AI_PREREQFILES="C:\Documents and Settings\XPMUser\Application Data\Your Company\ST Test 050112 1200\install\CFEB55_E155_4C34_ACDD_F2302CF52CB1\SQLEXPR.EXE" ADDLOCAL=MainFeature,CFEB55_E155_4C34_ACDD_F2302CF52CB1
MSI (s) (E8:E4) [16:19:33:775]: Running installation inside multi-package transaction C:\Documents and Settings\XPMUser\Application Data\Your Company\ST Test 050112 1200\install\Test SQL Install.msi
MSI (s) (E8:E4) [16:19:33:775]: Grabbed execution mutex.
MSI (s) (E8:AC) [16:19:33:775]: Resetting cached policy values
MSI (s) (E8:AC) [16:19:33:775]: Machine policy value 'Debug' is 0
MSI (s) (E8:AC) [16:19:33:775]: ******* RunEngine:
******* Product: C:\Documents and Settings\XPMUser\Application Data\Your Company\ST Test 050112 1200\install\Test SQL Install.msi
******* Action: INSTALL
******* CommandLine: **********
MSI (s) (E8:AC) [16:19:33:775]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (E8:AC) [16:19:33:775]: File will have security applied from OpCode.
MSI (s) (E8:AC) [16:19:33:785]: SOFTWARE RESTRICTION POLICY: Verifying package --> 'C:\Documents and Settings\XPMUser\Application Data\Your Company\ST Test 050112 1200\install\Test SQL Install.msi' against software restriction policy
MSI (s) (E8:AC) [16:19:33:785]: Note: 1: 2262 2: DigitalSignature 3: -2147287038
MSI (s) (E8:AC) [16:19:33:785]: SOFTWARE RESTRICTION POLICY: C:\Documents and Settings\XPMUser\Application Data\Your Company\ST Test 050112 1200\install\Test SQL Install.msi is not digitally signed
MSI (s) (E8:AC) [16:19:33:785]: SOFTWARE RESTRICTION POLICY: C:\Documents and Settings\XPMUser\Application Data\Your Company\ST Test 050112 1200\install\Test SQL Install.msi is permitted to run at the 'unrestricted' authorization level.
MSI (s) (E8:AC) [16:19:33:785]: End dialog not enabled
MSI (s) (E8:AC) [16:19:33:785]: Original package ==> C:\Documents and Settings\XPMUser\Application Data\Your Company\ST Test 050112 1200\install\Test SQL Install.msi
MSI (s) (E8:AC) [16:19:33:785]: Package we're running from ==> C:\WINDOWS\Installer\5cc9f.msi
MSI (s) (E8:AC) [16:19:33:785]: APPCOMPAT: looking for appcompat database entry with ProductCode '{7581D08A-4EC1-47E0-A12F-962874950D8B}'.
MSI (s) (E8:AC) [16:19:33:785]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (E8:AC) [16:19:33:785]: MSCOREE not loaded loading copy from system32
MSI (s) (E8:AC) [16:19:33:785]: Machine policy value 'TransformsSecure' is 0
MSI (s) (E8:AC) [16:19:33:785]: User policy value 'TransformsAtSource' is 0
MSI (s) (E8:AC) [16:19:33:785]: Note: 1: 2262 2: File 3: -2147287038
MSI (s) (E8:AC) [16:19:33:785]: Note: 1: 2205 2: 3: MsiFileHash
MSI (s) (E8:AC) [16:19:33:785]: Machine policy value 'DisablePatch' is 0
MSI (s) (E8:AC) [16:19:33:785]: Machine policy value 'AllowLockdownPatch' is 0
MSI (s) (E8:AC) [16:19:33:785]: Machine policy value 'DisableLUAPatching' is 0
MSI (s) (E8:AC) [16:19:33:785]: Machine policy value 'DisableFlyWeightPatching' is 0
MSI (s) (E8:AC) [16:19:33:785]: APPCOMPAT: looking for appcompat database entry with ProductCode '{7581D08A-4EC1-47E0-A12F-962874950D8B}'.
MSI (s) (E8:AC) [16:19:33:785]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (E8:AC) [16:19:33:785]: Transforms are not secure.
MSI (s) (E8:AC) [16:19:33:785]: PROPERTY CHANGE: Adding MsiLogFileLocation property. Its value is 'C:\DOCUME~1\XPMUser\LOCALS~1\Temp\MSI7e91e.LOG'.
MSI (s) (E8:AC) [16:19:33:785]: Command Line: AI_INSTALL=1 APPDIR=C:\Program Files\Your Company\ST Test 050112 1200\ TARGETDIR=C:\ SHORTCUTDIR=C:\Documents and Settings\All Users\Start Menu\Programs\ST Test 050112 1200 AI_SETUPEXEPATH=C:\Documents and Settings\XPMUser\Desktop\Test SQL Install.exe SETUPEXEDIR=C:\Documents and Settings\XPMUser\Desktop\ EXE_CMD_LINE=/exenoupdates /exelang 0 /noprereqs CURRENTDIRECTORY=C:\Documents and Settings\XPMUser\Desktop CLIENTUILEVEL=0 CLIENTPROCESSID=3412 USERNAME=Windows XP Mode SOURCEDIR=C:\Documents and Settings\XPMUser\Application Data\Your Company\ST Test 050112 1200\install\ ACTION=INSTALL EXECUTEACTION=INSTALL AI_PREREQDIRS=C:\Documents and Settings\XPMUser\Application Data\Your Company\ST Test 050112 1200\install ROOTDRIVE=C:\ SECONDSEQUENCE=1 AI_PREREQFILES=C:\Documents and Settings\XPMUser\Application Data\Your Company\ST Test 050112 1200\install\CFEB55_E155_4C34_ACDD_F2302CF52CB1\SQLEXPR.EXE ADDLOCAL=MainFeature,CFEB55_E155_4C34_ACDD_F2302CF52CB1 ACTION=INSTALL
MSI (s) (E8:AC) [16:19:33:785]: PROPERTY CHANGE: Adding PackageCode property. Its value is '{AA23DBCC-6002-4B80-9C54-1170AA2739BE}'.
MSI (s) (E8:AC) [16:19:33:785]: Product Code passed to Engine.Initialize: ''
MSI (s) (E8:AC) [16:19:33:785]: Product Code from property table before transforms: '{7581D08A-4EC1-47E0-A12F-962874950D8B}'
MSI (s) (E8:AC) [16:19:33:785]: Product Code from property table after transforms: '{7581D08A-4EC1-47E0-A12F-962874950D8B}'
MSI (s) (E8:AC) [16:19:33:785]: Product not registered: beginning first-time install
MSI (s) (E8:AC) [16:19:33:785]: Product {7581D08A-4EC1-47E0-A12F-962874950D8B} is not managed.
MSI (s) (E8:AC) [16:19:33:785]: MSI_LUA: Credential prompt functionality not available on this operating system
MSI (s) (E8:AC) [16:19:33:785]: PROPERTY CHANGE: Adding ProductState property. Its value is '-1'.
MSI (s) (E8:AC) [16:19:33:785]: Entering CMsiConfigurationManager::SetLastUsedSource.
MSI (s) (E8:AC) [16:19:33:785]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (E8:AC) [16:19:33:785]: Adding new sources is allowed.
MSI (s) (E8:AC) [16:19:33:785]: PROPERTY CHANGE: Adding PackagecodeChanging property. Its value is '1'.
MSI (s) (E8:AC) [16:19:33:785]: Package name extracted from package path: 'Test SQL Install.msi'
MSI (s) (E8:AC) [16:19:33:785]: Package to be registered: 'Test SQL Install.msi'
MSI (s) (E8:AC) [16:19:33:785]: Note: 1: 2262 2: AdminProperties 3: -2147287038
MSI (s) (E8:AC) [16:19:33:785]: Machine policy value 'DisableMsi' is 0
MSI (s) (E8:AC) [16:19:33:785]: Machine policy value 'AlwaysInstallElevated' is 0
MSI (s) (E8:AC) [16:19:33:785]: User policy value 'AlwaysInstallElevated' is 0
MSI (s) (E8:AC) [16:19:33:785]: Product installation will be elevated because user is admin and product is being installed per-machine.
MSI (s) (E8:AC) [16:19:33:785]: Running product '{7581D08A-4EC1-47E0-A12F-962874950D8B}' with elevated privileges: Product is assigned.
MSI (s) (E8:AC) [16:19:33:785]: PROPERTY CHANGE: Adding AI_INSTALL property. Its value is '1'.
MSI (s) (E8:AC) [16:19:33:785]: PROPERTY CHANGE: Adding APPDIR property. Its value is 'C:\Program Files\Your Company\ST Test 050112 1200\'.
MSI (s) (E8:AC) [16:19:33:785]: PROPERTY CHANGE: Adding TARGETDIR property. Its value is 'C:\'.
MSI (s) (E8:AC) [16:19:33:785]: PROPERTY CHANGE: Adding SHORTCUTDIR property. Its value is 'C:\Documents and Settings\All Users\Start Menu\Programs\ST Test 050112 1200'.
MSI (s) (E8:AC) [16:19:33:785]: PROPERTY CHANGE: Adding AI_SETUPEXEPATH property. Its value is 'C:\Documents and Settings\XPMUser\Desktop\Test SQL Install.exe'.
MSI (s) (E8:AC) [16:19:33:785]: PROPERTY CHANGE: Adding SETUPEXEDIR property. Its value is 'C:\Documents and Settings\XPMUser\Desktop\'.
MSI (s) (E8:AC) [16:19:33:785]: PROPERTY CHANGE: Adding EXE_CMD_LINE property. Its value is '/exenoupdates /exelang 0 /noprereqs '.
MSI (s) (E8:AC) [16:19:33:785]: PROPERTY CHANGE: Adding CURRENTDIRECTORY property. Its value is 'C:\Documents and Settings\XPMUser\Desktop'.
MSI (s) (E8:AC) [16:19:33:785]: PROPERTY CHANGE: Adding CLIENTUILEVEL property. Its value is '0'.
MSI (s) (E8:AC) [16:19:33:785]: PROPERTY CHANGE: Adding CLIENTPROCESSID property. Its value is '3412'.
MSI (s) (E8:AC) [16:19:33:785]: PROPERTY CHANGE: Adding USERNAME property. Its value is 'Windows XP Mode'.
MSI (s) (E8:AC) [16:19:33:785]: PROPERTY CHANGE: Adding SOURCEDIR property. Its value is 'C:\Documents and Settings\XPMUser\Application Data\Your Company\ST Test 050112 1200\install\'.
MSI (s) (E8:AC) [16:19:33:785]: PROPERTY CHANGE: Adding ACTION property. Its value is 'INSTALL'.
MSI (s) (E8:AC) [16:19:33:785]: PROPERTY CHANGE: Adding EXECUTEACTION property. Its value is 'INSTALL'.
MSI (s) (E8:AC) [16:19:33:785]: PROPERTY CHANGE: Adding AI_PREREQDIRS property. Its value is 'C:\Documents and Settings\XPMUser\Application Data\Your Company\ST Test 050112 1200\install'.
MSI (s) (E8:AC) [16:19:33:785]: PROPERTY CHANGE: Adding ROOTDRIVE property. Its value is 'C:\'.
MSI (s) (E8:AC) [16:19:33:785]: PROPERTY CHANGE: Adding SECONDSEQUENCE property. Its value is '1'.
MSI (s) (E8:AC) [16:19:33:785]: PROPERTY CHANGE: Adding AI_PREREQFILES property. Its value is 'C:\Documents and Settings\XPMUser\Application Data\Your Company\ST Test 050112 1200\install\CFEB55_E155_4C34_ACDD_F2302CF52CB1\SQLEXPR.EXE'.
MSI (s) (E8:AC) [16:19:33:785]: PROPERTY CHANGE: Adding ADDLOCAL property. Its value is 'MainFeature,CFEB55_E155_4C34_ACDD_F2302CF52CB1'.
MSI (s) (E8:AC) [16:19:33:785]: Machine policy value 'DisableAutomaticApplicationShutdown' is 0
MSI (s) (E8:AC) [16:19:33:785]: DisableAutomaticApplicationShutdown system policy is ignored on this version of Windows.
MSI (s) (E8:AC) [16:19:33:785]: Engine has iefSecondSequence set to true.
MSI (s) (E8:AC) [16:19:33:785]: TRANSFORMS property is now:
MSI (s) (E8:AC) [16:19:33:785]: PROPERTY CHANGE: Deleting SOURCEDIR property. Its current value is 'C:\Documents and Settings\XPMUser\Application Data\Your Company\ST Test 050112 1200\install\'.
MSI (s) (E8:AC) [16:19:33:785]: PROPERTY CHANGE: Adding VersionDatabase property. Its value is '200'.
MSI (s) (E8:AC) [16:19:33:785]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\XPMUser\Application Data
MSI (s) (E8:AC) [16:19:33:795]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\XPMUser\Favorites
MSI (s) (E8:AC) [16:19:33:795]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\XPMUser\NetHood
MSI (s) (E8:AC) [16:19:33:795]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\XPMUser\My Documents
MSI (s) (E8:AC) [16:19:33:795]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\XPMUser\PrintHood
MSI (s) (E8:AC) [16:19:33:795]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\XPMUser\Recent
MSI (s) (E8:AC) [16:19:33:795]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\XPMUser\SendTo
MSI (s) (E8:AC) [16:19:33:795]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\XPMUser\Templates
MSI (s) (E8:AC) [16:19:33:795]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\All Users\Application Data
MSI (s) (E8:AC) [16:19:33:795]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\XPMUser\Local Settings\Application Data
MSI (s) (E8:AC) [16:19:33:795]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\XPMUser\My Documents\My Pictures
MSI (s) (E8:AC) [16:19:33:795]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\All Users\Start Menu\Programs\Administrative Tools
MSI (s) (E8:AC) [16:19:33:795]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\All Users\Start Menu\Programs\Startup
MSI (s) (E8:AC) [16:19:33:795]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\All Users\Start Menu\Programs
MSI (s) (E8:AC) [16:19:33:795]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\All Users\Start Menu
MSI (s) (E8:AC) [16:19:33:795]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\All Users\Desktop
MSI (s) (E8:AC) [16:19:33:795]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\XPMUser\Start Menu\Programs\Administrative Tools
MSI (s) (E8:AC) [16:19:33:795]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\XPMUser\Start Menu\Programs\Startup
MSI (s) (E8:AC) [16:19:33:805]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\XPMUser\Start Menu\Programs
MSI (s) (E8:AC) [16:19:33:805]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\XPMUser\Start Menu
MSI (s) (E8:AC) [16:19:33:805]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\XPMUser\Desktop
MSI (s) (E8:AC) [16:19:33:805]: SHELL32::SHGetFolderPath returned: C:\Documents and Settings\All Users\Templates
MSI (s) (E8:AC) [16:19:33:805]: SHELL32::SHGetFolderPath returned: C:\WINDOWS\Fonts
MSI (s) (E8:AC) [16:19:33:805]: Note: 1: 2898 2: MS Sans Serif 3: MS Sans Serif 4: 0 5: 16
MSI (s) (E8:AC) [16:19:33:805]: PROPERTY CHANGE: Adding Privileged property. Its value is '1'.
MSI (s) (E8:AC) [16:19:33:805]: Note: 1: 1402 2: HKEY_CURRENT_USER\Software\Microsoft\MS Setup (ACME)\User Info 3: 2
MSI (s) (E8:AC) [16:19:33:805]: PROPERTY CHANGE: Adding DATABASE property. Its value is 'C:\WINDOWS\Installer\5cc9f.msi'.
MSI (s) (E8:AC) [16:19:33:805]: PROPERTY CHANGE: Adding OriginalDatabase property. Its value is 'C:\Documents and Settings\XPMUser\Application Data\Your Company\ST Test 050112 1200\install\Test SQL Install.msi'.
MSI (s) (E8:AC) [16:19:33:805]: Machine policy value 'MsiDisableEmbeddedUI' is 0
MSI (s) (E8:AC) [16:19:33:805]: EEUI - Disabling MsiEmbeddedUI for service because it's not a quiet/basic install
MSI (s) (E8:AC) [16:19:33:805]: Note: 1: 2262 2: PatchPackage 3: -2147287038
MSI (s) (E8:AC) [16:19:33:805]: Note: 1: 2262 2: Media 3: -2147287038
MSI (s) (E8:AC) [16:19:33:805]: Machine policy value 'DisableRollback' is 0
MSI (s) (E8:AC) [16:19:33:805]: User policy value 'DisableRollback' is 0
MSI (s) (E8:AC) [16:19:33:805]: PROPERTY CHANGE: Adding UILevel property. Its value is '5'.
MSI (s) (E8:AC) [16:19:33:805]: PROPERTY CHANGE: Adding Preselected property. Its value is '1'.
MSI (s) (E8:AC) [16:19:33:805]: Doing action: INSTALL
Action start 16:19:33: INSTALL.
MSI (s) (E8:AC) [16:19:33:805]: Running ExecuteSequence
MSI (s) (E8:AC) [16:19:33:805]: Doing action: AI_ResolveKnownFolders
Action start 16:19:33: AI_ResolveKnownFolders.
MSI (s) (E8:F8) [16:19:33:815]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI66.tmp, Entrypoint: AI_ResolveKnownFolders
MSI (s) (E8:60) [16:19:33:815]: Generating random cookie.
MSI (s) (E8:60) [16:19:33:825]: Created Custom Action Server with PID 900 (0x384).
MSI (s) (E8:24) [16:19:33:835]: Running as a service.
MSI (s) (E8:24) [16:19:33:835]: Hello, I'm your 32bit Impersonated custom action server.
MSI (s) (E8!34) [16:19:34:226]: PROPERTY CHANGE: Adding PublicDocumentsFolder property. Its value is 'C:\Documents and Settings\All Users\Documents'.
Action ended 16:19:34: AI_ResolveKnownFolders. Return value 1.
MSI (s) (E8:AC) [16:19:34:226]: Doing action: AppSearch
Action start 16:19:34: AppSearch.
MSI (s) (E8:AC) [16:19:34:226]: Skipping AppSearch action: already done on client side
Action ended 16:19:34: AppSearch. Return value 0.
MSI (s) (E8:AC) [16:19:34:226]: Doing action: AI_AppSearchEx
Action start 16:19:34: AI_AppSearchEx.
MSI (s) (E8:E8) [16:19:34:256]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI67.tmp, Entrypoint: DoAppSearchEx
MSI (s) (E8!C8) [16:19:34:546]: PROPERTY CHANGE: Adding AI_SQL_2008_R2_ORIGINAL_PREREQSEARCH_1_PROPAiVerMin property. Its value is '10.50'.
MSI (s) (E8!C8) [16:19:34:546]: PROPERTY CHANGE: Adding AI_SQL_2008_R2_ORIGINAL_SEARCH_2_PROPAiVerMin property. Its value is '10.50'.
Action ended 16:19:34: AI_AppSearchEx. Return value 1.
MSI (s) (E8:AC) [16:19:34:546]: Skipping action: AI_FindExeLzma (condition is false)
MSI (s) (E8:AC) [16:19:34:546]: Skipping action: AI_ExtractCadLzma (condition is false)
MSI (s) (E8:AC) [16:19:34:546]: Skipping action: AI_DeleteRCadLzma (condition is false)
MSI (s) (E8:AC) [16:19:34:546]: Skipping action: AI_DeleteCadLzma (condition is false)
MSI (s) (E8:AC) [16:19:34:546]: Doing action: FindRelatedProducts
Action start 16:19:34: FindRelatedProducts.
MSI (s) (E8:AC) [16:19:34:546]: Skipping FindRelatedProducts action: already done on client side
Action ended 16:19:34: FindRelatedProducts. Return value 0.
MSI (s) (E8:AC) [16:19:34:546]: Skipping action: AI_DOWNGRADE (condition is false)
MSI (s) (E8:AC) [16:19:34:546]: Doing action: LaunchConditions
Action start 16:19:34: LaunchConditions.
Action ended 16:19:34: LaunchConditions. Return value 1.
MSI (s) (E8:AC) [16:19:34:546]: Doing action: CCPSearch
Action start 16:19:34: CCPSearch.
MSI (s) (E8:AC) [16:19:34:546]: Skipping CCPSearch action: already done on client side
Action ended 16:19:34: CCPSearch. Return value 0.
MSI (s) (E8:AC) [16:19:34:546]: Doing action: RMCCPSearch
Action start 16:19:34: RMCCPSearch.
MSI (s) (E8:AC) [16:19:34:556]: Skipping RMCCPSearch action: already done on client side
Action ended 16:19:34: RMCCPSearch. Return value 0.
MSI (s) (E8:AC) [16:19:34:556]: Doing action: ValidateProductID
Action start 16:19:34: ValidateProductID.
Action ended 16:19:34: ValidateProductID. Return value 1.
MSI (s) (E8:AC) [16:19:34:556]: Skipping action: AI_RESTORE_LOCATION (condition is false)
MSI (s) (E8:AC) [16:19:34:556]: Skipping action: SET_APPDIR (condition is false)
MSI (s) (E8:AC) [16:19:34:556]: Skipping action: SET_SHORTCUTDIR (condition is false)
MSI (s) (E8:AC) [16:19:34:556]: Doing action: SET_TARGETDIR_TO_APPDIR
Action start 16:19:34: SET_TARGETDIR_TO_APPDIR.
MSI (s) (E8:AC) [16:19:34:556]: PROPERTY CHANGE: Modifying TARGETDIR property. Its current value is 'C:\'. Its new value: 'C:\Program Files\Your Company\ST Test 050112 1200\'.
Action ended 16:19:34: SET_TARGETDIR_TO_APPDIR. Return value 1.
MSI (s) (E8:AC) [16:19:34:556]: Doing action: CostInitialize
Action start 16:19:34: CostInitialize.
MSI (s) (E8:AC) [16:19:34:556]: Machine policy value 'MaxPatchCacheSize' is 10
MSI (s) (E8:AC) [16:19:34:556]: PROPERTY CHANGE: Adding CostingComplete property. Its value is '0'.
MSI (s) (E8:AC) [16:19:34:556]: Note: 1: 2262 2: Patch 3: -2147287038
MSI (s) (E8:AC) [16:19:34:556]: Note: 1: 2262 2: PatchPackage 3: -2147287038
MSI (s) (E8:AC) [16:19:34:556]: Note: 1: 2205 2: 3: MsiPatchHeaders
MSI (s) (E8:AC) [16:19:34:556]: Note: 1: 2205 2: 3: __MsiPatchFileList
MSI (s) (E8:AC) [16:19:34:556]: Note: 1: 2262 2: Media 3: -2147287038
Action ended 16:19:34: CostInitialize. Return value 1.
MSI (s) (E8:AC) [16:19:34:556]: Doing action: FileCost
Action start 16:19:34: FileCost.
MSI (s) (E8:AC) [16:19:34:556]: Note: 1: 2205 2: 3: MsiAssembly
MSI (s) (E8:AC) [16:19:34:556]: Note: 1: 2205 2: 3: Class
MSI (s) (E8:AC) [16:19:34:556]: Note: 1: 2205 2: 3: Extension
MSI (s) (E8:AC) [16:19:34:556]: Note: 1: 2205 2: 3: TypeLib
Action ended 16:19:34: FileCost. Return value 1.
MSI (s) (E8:AC) [16:19:34:556]: Doing action: IsolateComponents
Action start 16:19:34: IsolateComponents.
Action ended 16:19:34: IsolateComponents. Return value 0.
MSI (s) (E8:AC) [16:19:34:566]: Doing action: CostFinalize
Action start 16:19:34: CostFinalize.
MSI (s) (E8:AC) [16:19:34:566]: PROPERTY CHANGE: Adding OutOfDiskSpace property. Its value is '0'.
MSI (s) (E8:AC) [16:19:34:566]: PROPERTY CHANGE: Adding OutOfNoRbDiskSpace property. Its value is '0'.
MSI (s) (E8:AC) [16:19:34:566]: PROPERTY CHANGE: Adding PrimaryVolumeSpaceAvailable property. Its value is '0'.
MSI (s) (E8:AC) [16:19:34:566]: PROPERTY CHANGE: Adding PrimaryVolumeSpaceRequired property. Its value is '0'.
MSI (s) (E8:AC) [16:19:34:566]: PROPERTY CHANGE: Adding PrimaryVolumeSpaceRemaining property. Its value is '0'.
MSI (s) (E8:AC) [16:19:34:566]: Target path resolution complete. Dumping Directory table...
MSI (s) (E8:AC) [16:19:34:566]: Note: target paths subject to change (via custom actions or browsing)
MSI (s) (E8:AC) [16:19:34:566]: Dir (target): Key: TARGETDIR , Object: C:\Program Files\Your Company\ST Test 050112 1200\
MSI (s) (E8:AC) [16:19:34:566]: Dir (target): Key: WindowsFolder , Object: C:\WINDOWS\
MSI (s) (E8:AC) [16:19:34:566]: Dir (target): Key: APPDIR , Object: C:\Program Files\Your Company\ST Test 050112 1200\
Action ended 16:19:34: CostFinalize. Return value 1.
MSI (s) (E8:AC) [16:19:34:566]: Doing action: SetODBCFolders
Action start 16:19:34: SetODBCFolders.
MSI (s) (E8:AC) [16:19:34:566]: Note: 1: 2205 2: 3: ODBCDriver
MSI (s) (E8:AC) [16:19:34:566]: Note: 1: 2228 2: 3: ODBCDriver 4: SELECT `ComponentId`,`Description`,`Directory_`, `ActionRequest`, `Installed`, `Attributes` FROM `ODBCDriver`, `Component` WHERE `ODBCDriver`.`Component_` = `Component` AND (`ActionRequest` = 1 OR `ActionRequest` = 2)
MSI (s) (E8:AC) [16:19:34:566]: Note: 1: 2205 2: 3: ODBCTranslator
MSI (s) (E8:AC) [16:19:34:566]: Note: 1: 2228 2: 3: ODBCTranslator 4: SELECT `ComponentId`,`Description`,`Directory_`, `ActionRequest`, `Installed`, `Attributes` FROM `ODBCTranslator`, `Component` WHERE `ODBCTranslator`.`Component_` = `Component` AND (`ActionRequest` = 1 OR `ActionRequest` = 2)
Action ended 16:19:34: SetODBCFolders. Return value 0.
MSI (s) (E8:AC) [16:19:34:566]: Doing action: MigrateFeatureStates
Action start 16:19:34: MigrateFeatureStates.
MSI (s) (E8:AC) [16:19:34:566]: Skipping MigrateFeatureStates action: already done on client side
Action ended 16:19:34: MigrateFeatureStates. Return value 0.
MSI (s) (E8:AC) [16:19:34:566]: Doing action: AI_VerifyPrereq
Action start 16:19:34: AI_VerifyPrereq.
MSI (s) (E8:70) [16:19:34:606]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI68.tmp, Entrypoint: VerifyPrereq
Action ended 16:19:39: AI_VerifyPrereq. Return value 3.
Action ended 16:19:39: INSTALL. Return value 3.
MSI (s) (E8:AC) [16:19:39:013]: MainEngineThread is returning 1603
MSI (s) (E8:E4) [16:19:39:013]: No System Restore sequence number for this installation.
MSI (s) (E8:E4) [16:19:39:013]: User policy value 'DisableRollback' is 0
MSI (s) (E8:E4) [16:19:39:013]: Machine policy value 'DisableRollback' is 0
MSI (s) (E8:E4) [16:19:39:013]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (E8:E4) [16:19:39:013]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2
MSI (s) (E8:E4) [16:19:39:013]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\Rollback\Scripts 3: 2
MSI (s) (E8:E4) [16:19:39:013]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\InProgress 3: 2
MSI (s) (E8:E4) [16:19:39:013]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Installer\InProgress 3: 2
MSI (s) (E8:E4) [16:19:39:013]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (s) (E8:E4) [16:19:39:013]: Restoring environment variables
MSI (s) (E8:E4) [16:19:39:013]: Destroying RemoteAPI object.
MSI (s) (E8:60) [16:19:39:013]: Custom Action Manager thread ending.
MSI (c) (54:30) [16:19:39:023]: Back from server. Return value: 1603
MSI (c) (54:30) [16:19:39:023]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (54:30) [16:19:39:023]: PROPERTY CHANGE: Deleting SECONDSEQUENCE property. Its current value is '1'.
Action ended 16:19:39: ExecuteAction. Return value 3.
MSI (c) (54:30) [16:19:39:023]: Doing action: FatalError
Action start 16:19:39: FatalError.
Info 2826. Control BottomLine on dialog FatalError extends beyond the boundaries of the dialog to the right by 3 pixels.
MSI (c) (54:44) [16:19:40:815]: Doing action: AI_SHOW_LOG
Action start 16:19:40: AI_SHOW_LOG.
MSI (c) (54:20) [16:19:40:845]: Invoking remote custom action. DLL: C:\DOCUME~1\XPMUser\LOCALS~1\Temp\MSI69.tmp, Entrypoint: LaunchLogFile
Action ended 16:19:41: AI_SHOW_LOG. Return value 1.
MSI (c) (54:44) [16:19:41:156]: Doing action: AI_CleanPrereq
Action start 16:19:41: AI_CleanPrereq.
MSI (c) (54:CC) [16:19:41:196]: Invoking remote custom action. DLL: C:\DOCUME~1\XPMUser\LOCALS~1\Temp\MSI6A.tmp, Entrypoint: CleanPrereq

[Daniel]

Hi,

It seems this behavior is caused by a bug in Advanced Installer, thank you for bringing it to our attention. I notified the development team and they will investigate the reason. The fix will be included in a future version.
As a workaround, in the "Prerequisite" page you can add SQL Server 2008 Express R2 as a file from disk to your packet using [New Package Prerequisite] toolbar button.

Regards,
Daniel

[Pat4040]

Hi Daniel,

We experienced this "bug" while also trying to use the prerequisite for SQL Express 2008 SP2. Unfortunately, because we have to offer both 32 and 64 bit SQL Express along with our program, the installation package is far too large if we included the SQL files. In fact, the AI won't even compile because of the size. Additionally, even if we create separate installers for 32 and 64 bit, the 500+ MB download size makes it far too large. Do you have any other suggestions or at least a time frame for the fix?

Thank you

[Daniel]

Hi,

This bug fix will be included in our future version. Until then, as a workaround in the "Prerequisite" page you should simply drag SQL Server 2008 Express R2 predefined prerequisite on "Pre-install" folder, then build and run your package.
If you have any questions let me know.

Regards,
Daniel

[Pat4040]

Setting it up in Pre-install worked like a charm! Thanks for your help.