SQL Server express Silent Installation Procedure

 

SilentSQL Server 2005There are two possible steps for installation:

1)CreateSetup. iniFile
The template file contained in the SQL Server CD is called template. ini. Create another required ". ini file". This file contains a single [Options] section containing multiple parameters, each involving different functions or configuration settings.

Setup. iniFile structure (the general structure is as follows)

The setting in the red box is used to uninstall the components. If the installation fails, uninstall these components first. Do not "Remove = all" during installation"

2)Run the installer Command Prompt
Enter the following script at the command prompt
Setup.exe/Settings <path to. INI File>

For example:

If the sqlinstall. ini file is in the C: \ sqlsetup folder. Start installation with a silent command:

Setup.exe / Set c: \ sqlsetup \ sqlinstall. ini
Specify the/Qn switch to perform a Silent Installation () or/QB switch without a dialog box. Only the progress dialog box should be displayed.

Note:

Unless otherwise stated, these issues only apply to the installation of a new SQL Server express instance. the installation of the existing SQL native client may fail and roll back. The following error message is displayed: "The installation package of the product Microsoft SQL native client cannot be found. please try to use the installation package "sqlncli. the valid copy of MSI is reinstalled. ". to solve this problem, use "add or delete programs" to uninstall SQL native client.

 

The following shows the Silent Installation result: