SQL Express Install

[goconrad]

Hello, I have a SQL Express 2005 application and I'm looking for anyone who can provide me the prerequsite configurations and command lines for:

windows installer 3.0
Dot net 3.0
SQL express 2005

The assumptions are:

1. each of the above .msi files will be downloaded from a URL and executed sliently
2. we have the downloads setup at http://www.blueskypos.com/install

I will provide a free licensed copy of our POS application to whoever can provide this

[Cosmin]

Hi,

windows installer 3.0

You can add Windows Installer 3.0 as a prerequisite by following these steps:
- go to the "Prerequisites" page and select the Software Prerequisites tab
- click the "New" button and then the "Cancel" button on the "Select a setup file" dialog
- in the "New Prerequisite" dialog configure the "Display" section to the prerequisite information you want to show to the user
- set the "Location" combo to "URL"
- set the "URL" field to the URL on your server which contains the Windows Installer 3.0 installation package
- in the "Integrity Check" section use the "Browse" button to select the Windows Installer 3.0 installation package
- go to the Install Conditions tab and double-click the existing search
- modify the "File to Find" field to [SystemFolder]msi.dll
- set the "Minimum version" field to 3

This prerequisite can be installed silently by using the "/quiet" parameter in the "Command Line" field in the "Properties" tab on the "New Prerequisite" dialog.

Dot net 3.0

Please note that Advanced Installer has a predefined prerequisite for .NET Framework 3.0 which can be added by using the "Add" button. After you add this prerequisite, you need to set a valid URL in the Properties tab which points to the .NET Framework 3.0 installation package.

This prerequisite can be installed silently by using the "/q" parameter in the "Command Line" field in the "Properties" tab on the "New Prerequisite" dialog.

SQL express 2005

This prerequisite can be added just like the Windows Installer 3.0 prerequisite, except you configure it for SQL Express 2005. The search in the Install Conditions tab can use this registry entry (the minimum value can be "9"):

Code: Select all

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion\CurrentVersion

Note that we have a prerequisite tutorial which may help you.

This prerequisite can be installed silently by using the command line of the SQL Express installation package.

Regards,
Cosmin

[Phobos]

Here is the commandline I used for SQL 2005 Express installation:

SQLEXPR_ADV.EXE /norebootchk /qb reboot=ReallySuppress addlocal=all RSCONFIGURATION=Default RSSQLLOCAL=1 instancename=SQLEXPRESS SCCCHECKLEVEL=IncompatibleComponents:1;MDAC25Version:0 ERRORREPORTING=2 SQLAUTOSTART=1

[goconrad]

Hi, I'm using SQL Express 2005 for my application. Using your recommendation as an example, since I'm not using the advanced version of SQL what would I use in place of "SQLEXPR_ADV.EXE"? And can you recommend a command line to add to this that would restore a .bak as part of the install? Thank you. I'm new at all this.

SQLEXPR_ADV.EXE /norebootchk /qb reboot=ReallySuppress addlocal=all RSCONFIGURATION=Default RSSQLLOCAL=1 instancename=SQLEXPRESS SCCCHECKLEVEL=IncompatibleComponents:1;MDAC25Version:0 ERRORREPORTING=2 SQLAUTOSTART=1

[Cosmin]

Hi,

since I'm not using the advanced version of SQL what would I use in place of "SQLEXPR_ADV.EXE"?

Please note that this is the executable which installs SQL Server Express and you don't need to specify it in the command line of the prerequisite. For the standard version of SQL Express the package is named SQLEXPR32.EXE and it is added as a prerequisite, not in the command line of a prerequisite.

For more details about installing SQL Server Express silently, please see the How to: Install SQL Server 2005 from the Command Prompt article in MSDN. This article explains the command line parameters which can be used for installing SQL Server Express.

Regards,
Cosmin

[Macy]

I cannot find an example of using a .ini file within Advanced Installer. I cannot grasp how you can reference a file during a prerequisite installation, when the installation of such a file cannot occur until after the prerequisites have been addressed. What am I missing?

[Cosmin]

Hi,

I'm not sure I understand what you are referring to. Can you please give me more details about this? What do you need to do?

Regards,
Cosmin

[Macy]

You reference links to the MSDN site that recommend that all of the install settings be placed in a .ini file, and use the /settings parameter on the SqlExpr.exe command line. I do not understand how it is possible to do that in this case because any .ini file that I would want to use would not have been installed yet.

[Cosmin]

Hi,

Please note that for any prerequisite you can use the Files tab of the "Edit Prerequisite" dialog to add additional files to the prerequisite setup. In this tab you can add the INI you use for the prerequisite installation. When the installation runs, the INI will be extracted next to the main setup file of the prerequisite.

Regards,
Cosmin

[Macy]

Thank you. That is what I was missing.