SQL Server Express Silent installation action method

The Silent SQL Server 2005 installation is a possible two steps:

1) Create a Setup.ini file

The template file contained in the SQL Server CD is called Template.ini. On this basis, you create another ". ini file" that contains a single [Options] section that contains multiple parameters, each involving different features or configuration settings.

Setup.ini file structure (general setup structure follows)

The red box settings are used to uninstall the build, if the installation failed to uninstall these components first, install the time do not "Remove=all"

2 Run Setup command prompt

At the command prompt, type the following script

Setup.exe/settings

The following figure:

If the location of the Sqlinstall.ini file is in the C:sqlsetup folder. Silent command to begin installation:

setup.exe/Setup C:sqlsetup Sqlinstall.ini

Specifies/QN switch to perform a silent install () without dialog box () or/QB switch to specify that only the progress dialog should be displayed.

Attention:

Unless otherwise stated, these issues apply only to the installation of a new SQL Server Express instance. An existing SQL Native client installation may cause an installation failure installation to fail and roll back with the following error message: "The installation package for the product Microsoft SQL Native client could not be found." Please try to use the install package "Sqlncli.msi" A valid copy of the. ". To resolve this issue, uninstall the SQL Native Client by using Add or Remove Programs.

The following is a silent installation effect display: