Nesting An Installation of MSDE

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

Answers (2)

Posted by: geoffro79 14 years ago
Senior Yellow Belt
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.
Posted by: kkaminsk 14 years ago
9th Degree Black Belt
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.
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ