Hello. I have searched the forums a lot about nested MSI's, but I couldn't quite find the answer I was looking for.

I have built an MSI in Wise 5.6 to install a web-based (.NET) application. The installation sets up the virtual directories and all of that stuff.

What I need is for the machine to also receive a copy of MSDE, which can be installed from an MSI. I copied all of the setup files for MSDE into my current MSI and I tried to run a custom action to install MSDE from the installed files.

The problems comes from the fact that MSDE is a setup.exe (with switches) that opens an MSI. So if I say "Run Program From Installation" it will eventually kick off a second MSI and an "install already in progress" error occurs. But I do not know the proper switches to call the MSDE MSI directly as a nested MSI.

Is there any way I can run the setup.exe and have it run just like a nested MSI? Or does anyone know the switches I need to send to the MSDE msi file that will set the SA password and set the security level to SQL server?

0 Comments   [ + ] Show Comments


Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.


If you say that the MSDE setup.exe calls an msi.
There might be 2 ways you can extract the msi from the setup.exe.

1. first method could be to generate an admin install from your setup.exe like you would for an msi, that is if there is a switch for it.
example setup.exe /[switch for extraction or admin install]
If the admin install works then theres your msi and folders/files in an umcomprssed format

2. second way could be to grab the msi from the TEMP folder after running the setup.exe
- clear TEMP folder
- launch setup.exe, but dont continue with the install, just let the first dialog window appear.
- go to TEMP folder. IF there was an msi in the setup.exe then it should be sitting there or in a subfolder in compressed format.

I generally use these 2 methods first when i want to extract MSI from a setup.exe which holds it within.
Answered 02/10/2006 by: geoffro79
Senior Yellow Belt

Please log in to comment
There is a merge module for MSDE that should be used for this purpose. If you are using the 2000 version of the MSDE the web download had a defective version up there that gave an Internet Explorer version error. I found the only non-defective one to be on the SQL2000 SP3 CD.
Answered 02/13/2006 by: kkaminsk
Ninth Degree Black Belt

Please log in to comment
Answer this question or Comment on this question for clarity