rncox73
Posts: 18
Joined: Thu Jun 17, 2010 11:39 pm

Installation of SQL Server 2008 Express during install

I am trying to build an installation that will install an application as well as SQL Server 2008 Express. I've made sure all the necessary prerequisites for SQL Server 2008 Express are included and run before the SQL Server 2008 Express installation is run. My problem is that at the end of the installation SQL Server 2008 starts installing and then quits. I've made sure that .NET 3.5 SP1, Windows Powershell, Windows Installer 4.5 and a few others are all installed properly first (these are the prerequisites for SQL Server 2008). The one wrinkle is that I am trying to install SQL Server 2008 Express completely silently so I've included a setup ini file so it knows what options to install it with. I've tried it as the last prerequisite and as a custom action and it always quits after getting started. If I just immediately copy the SQL Server 2008 Express install files to the PC that I've just run the installer on and run them, it installs correctly (in silent mode). I've attached the SQL Server 2008 Express setup log file and you can see where it exits but I can't figure out why.
Attachments
SqlSetup.log
SQL Server 2008 Express setup log file
(49.83 KiB) Downloaded 979 times
Cosmin
Posts: 5797
Joined: Tue Jul 10, 2007 6:39 pm
Contact: Website

Re: Installation of SQL Server 2008 Express during install

Hi,

Is the INI available when the SQL Server installer is launched? How did you add it to your project? Is it a temporary file or a additional prerequisite file? Also, did you specify a full path to the INI? Please note that relative paths are not supported.

Regards,
Cosmin
Cosmin Pirvu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
rncox73
Posts: 18
Joined: Thu Jun 17, 2010 11:39 pm

Re: Installation of SQL Server 2008 Express during install

It is an additional prerequisite file. It is a relative path however. How would I use an exact path in this case? The setup.exe file is the primary file and the ini file is just included in the file list after the setup.exe. The following is what I have for the "Command Line" option under the "Setup Files" section on the "Properties" tab of the "Edit Prerequisite" form.

/CONFIGURATIONFILE=sql-2008-express.ini /INDICATEPROGRESS /QS /HIDECONSOLE

"sql-2008-express.ini" is the configuration ini file. How would I specify an exact path in this case? Or is there a better way to do this?

Thank you.
Cosmin
Posts: 5797
Joined: Tue Jul 10, 2007 6:39 pm
Contact: Website

Re: Installation of SQL Server 2008 Express during install

Hi,

You can use the bootstrapper extraction path from the "Bootstrapper" tab of the "Media" page. This works only when including the installation files in EXE bootstrapper. The default path is "[AppDataFolder][|Manufacturer]\[|ProductName]\install", so the INI path would be:

Code: Select all

[AppDataFolder][|Manufacturer]\[|ProductName]\install\sql-2008-express.ini
Regards,
Cosmin
Cosmin Pirvu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
rncox73
Posts: 18
Joined: Thu Jun 17, 2010 11:39 pm

Re: Installation of SQL Server 2008 Express during install

Thank you. I've tried that and it still gets started and then exits prematurely and the installer program says SQL Server did not install correctly. Any ideas?
GabrielBarbu
Posts: 2146
Joined: Thu Jul 09, 2009 11:24 am
Contact: Website

Re: Installation of SQL Server 2008 Express during install

Hello,

Please follow the exact steps (all steps are mandatory for a successful installation):

- upgrade Advanced Installer to version 7.3 or higher if you haven't already done so.
- add SQL Express as a prerequisite in the Prerequisites page
- starting with this version, Advanced Installer will automatically set
the prerequisites as feature-based
- this will be installed during the main package installation, not
before it
- this is the default option that you can see in the "Options" tab if
you double click the prerequisite
- don't change this setting, it's perfect as it is
- on the Properties tab, make sure you are using a proper command line for installing MySQL express. It might look something like:

Code: Select all

/TCPENABLED=1 /ACTION="INSTALL" /QS /SQLSVCSTARTUPTYPE="automatic" /SECURITYMODE="SQL" /SAPWD="pa$$20O9"
You might want to read the article on installing sql server 2008 from the command line for proper command line parameters.
IMPORTANT: make sure the password is very very complicated, numbers, letters and other characters. Otherwise, the installer will fail without a proper error to inform you of what's wrong.

- one more setting is required for the installation to complete correctly
- this is done in the Media page, Bootstrapper tab
- here you should set the "Execution Level" combobox to "Require
Administrator"
- build and test the package

The installation of the prerequisite should now complete successfully.

Best regards,
Gabriel
Gabriel Barbu
Advanced Installer Team
http://www.advancedinstaller.com/
rncox73
Posts: 18
Joined: Thu Jun 17, 2010 11:39 pm

Re: Installation of SQL Server 2008 Express during install

Thank you. That works and SQL Server 2008 Express is installed correctly. However the installer program gives me an error saying "Warning 4154" and that SQL Server was not installed correctly. I tell it to continue and it finishes. I have verified that SQL Server is installed correctly and working. Any thoughts on why this message would come up? I've tried it several times from scratch (starting with a fresh untouched XP image) and it installs SQL Server 2008 (and everything else I included) correctly but always gives that message at the end.
GabrielBarbu
Posts: 2146
Joined: Thu Jul 09, 2009 11:24 am
Contact: Website

Re: Installation of SQL Server 2008 Express during install

Hello,

You might want to check the following thread on the warning:
http://www.advancedinstaller.com/forums ... =2&t=10535

It discusses its cause and how to fix it.

Best regards,
Gabriel
Gabriel Barbu
Advanced Installer Team
http://www.advancedinstaller.com/

Return to “Common Problems”