jesse.bearden1.5524927774925947E12 asked a question.
SQL Express Prerequisite
I'm trying to use the new feature conditional pre-reqs to install SQL Express and I'm having a little issue. I created a dummy install to test with and I'm running in to some issues.
First, my test machine has SQL server(Non-express) installed already. I'm assuming installing Express on top triggered a reboot request, but the installation just dissapears after the SQL Express pre-req. Rebooting manually will kick it back off(SetupResume). I haven't investigated that too much as it's not a big deal. The UI didn't handle this very gracefully by default though.
The main issue is trying to get it to install without further user interaction. I used the following command line on the pre-requisite:
/qn addlocal=all instancename=INSTANCENAME
The setup seems to complete successfully and SQL Express is installed, but my MSI reports an error saying, "The installation of Microsoft SQL Server 2005 Express SP2 appears to have failed. Do you want to continue the installation?"
The error logs for SQL setup(C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG) report no issues. The MSI log for my setup report the following:
[CODE]Action 16:36:51: Installing Microsoft SQL Server 2005 Express SP2. Installing Microsoft SQL Server 2005 Express SP2
MSI (c) (64!2C) [16:36:51:046]: PROPERTY CHANGE: Adding ISPREREQDIR property. Its value is 'C:\Documents and Settings\Jesse\Desktop\Temp\ISSetupPrerequisites\Microsoft SQL Server 2005 Express SP2\'.
The installation of Microsoft SQL Server 2005 Express SP2 appears to have failed. Do you want to continue the installation?
InstallShield 16:42:29: *** Prerequisites complete; return code 2
InstallShield 16:42:29: Destroyed Window {E9CB9FBC-3665-46D0-BEED-FC6A6DDB89ED}
Action ended 16:42:29: ISInstallPrerequisites. Return value 3.
MSI (c) (64:78) [16:42:29:078]: Doing action: SetupCompleteError
Action 16:42:29: SetupCompleteError. [/CODE]
I've tried a few different things, but can't seem to figure this out. Has anyone else gotten this to work successfully?
I think I had to tell it to ignore the error code and continue because on certain operating systems it would return failure even though the install worked. If it is important to test if the instance is installed properly to continue the setup then create an error custom action that tests for the instance.
NOTE: the attached file has been renamed from PRQ to TXT so that it can be uploaded to the forum. Just rename it to PRQ to view in the Prerequisite editor.Microsoft SQL Server 2005 Express(Altered) SP2
I'm still not completely sure why it just "dies" on my machine SQL server already installed, but that's probably a situation that can just be avoided.
More testing to go, but it's looking better.
This has been driving me CRAZY for weeks! I'm using IS 2008 Express, and I couldn't figure out why it kept saying it failed at the end either, even though it was successfully installed.
The answer was in the condition - I should have been checking for my instance name specifically.
Again, THANK YOU! :D
I tried to use Dan's prq file and install SQL Express sp2 in a XP machine.
Although SQL Express installed successfully, at the end Install shield gives an error stating the failure to install SQL Express.
I am using IS 10.5
Can some one help with this regards.
Sid
Is it possible that the INSTANCENAME value be set to a public property? I set it on my commandline to ... INSTANCENAME=[PROPERTYABC]. I also change under the Condition Tab to reflect that same changes. It now checks for HKLM\Software\Microsoft\Microsoft SQL Server\[PROPERTYABC].
The instance was created/installed correctly because I checked it on the registry. The problem that I have is that it pops up an error that it fails to install SQL Express. Is the structure on my Condition correct?
Thanks.
The answer was in the condition - I should have been checking for my instance name specifically.
"
I've been getting the error message "The installation of Microsoft SQL Server 2005 Express SP2 appears to have failed. Do you want to continue the installation?". But the installation did install correctly and my application is able to use work correctly.
It seems that I too have failed to correctly check a post-SQL Express-install condition. But how to do check for the instance name? Are you doing it in code or with at Redistruibutable level?
DISABLENETWORKPROTOCOLS=0 ADDLOCAL=ALL SQLBROWSERAUTOSTART=1l
Try this optionMicrosoft SQL Server 2005 Express SP2