SQL Server Express

This plug-in provided command installs an instance of Microsoft SQL Server Express 2005 or 2008 on the target system.

Select the version of SQL Express to install using the drop-down combo box on the top right corner of the plug-in dialog. If the combo box is not enabled, you have only installed support for a single (the pre-selected) version of SQL Express. To add support for more SQL Express versions, install them using InstallAware setup.

Automatically Generate Command Line

The fields in this region help you automatically form a setup command line for the SQL Express native installer. Please note that the command line is not generated until you have clicked the Generate Command Line button.

Options

Mixed mode (SQL) authentication

Check this box to allow mixed mode authentication in the new SQL Express instance.

Enable network protocols

Check this box to allow network connections in the new SQL Express instance. Only available with SQL Express 2005.

Sysadmin password

Enter a strong password for the sysadmin user here. A strong password must be specified for setup to succeed.

Instance name

Enter the name for your new instance here. To install the default instance, leave this field blank.

Features

Click to select each SQL Express feature you would like to install. If you would like to install all features, uncheck all features. The feature list varies by the selected version of SQL Express.

Accounts

This page is only available for SQL Express 2008.

SQL Server Service Account Name

Enter the name of the Windows account to associate with the SQL Server Service. Selecting one of the pre-defined system accounts NT AUTHORITY\NETWORK SERVICE or NT AUTHORITY\SYSTEM eliminates the need to enter a service account password in the next input field. SQL Express 2005 uses the pre-defined system accounts, but SQL Express 2008 permits you to use a custom account.

SQL Server Service Account Password

Enter the password for the Windows account to associate with the SQL Server Service. Not necessary and disabled when a pre-defined system account is used.

SQL Server Administrator Account Name

Enter the name of the Windows account to set as the database administrator account using the form domain\user. Click the Add Current User button to insert a script variable denoting the account name of the user installing your product. This script variable is pre-defined only when used in conjunction with the built-in Microsoft SQL Server Express 2008 runtime displayed on the Application Runtimes design view, but you may copy and paste the code from the built-in runtime scripts to re-define this variable elsewhere when necessary.

Setup Command Line

The actual command line that will be passed to the setup program. You may auto-generate this field visually using the Automatically Generate Command Line dialog region, or manually enter/update a command line here. When manually specifying a command line, do not provide install mode or quiet installation flags, as these are automatically added to the specified setup command line at runtime.

Return result in variable

If you specify a previously defined variable in this field, it will hold the numeric return code of the native SQL Express installation. Some return codes are:

• 0: Successful installation.
• 3010: Successful installation, but a reboot is required.

Any other return code designates an error. The numeric return codes are standard Windows Installer result codes.

 Notes

• When you request a new instance installation, the plug-in will fail if the named/default instance already exists on the system. Use the Check Service command to determine if your named/default instance already exists. The service name to check for is MSSQL$SQLEXPRESS for default instances, and MSSQL$MYINSTANCE for named instances (where MYINSTANCE represents your instance name).