:: infotechGuyz.com ::
> For the IT community by the IT community

• BlackBerry Server (BES)
• Excel Macro/VBA
• Exchange 2007
• Exchange 2010
• Lync 2010
• Scripting/Command-line
• SQL Server 2008
• SQL Server 2012
• Team Foundation Server
• VMware
• Windows 7
• Windows 8
• Windows Server 2008
• Windows Server 2012

SQL Server 2008 R2 Script Installation

 

 

When deploying SQL Server from the CLI, you may also stipulate what level of the installer boundary you want to run, options are silent, basic, or full interface. SQL Server supports full quiet mode by using the /Q parameter or Quiet Simple mode by using the /QS parameter. The /Q switch is intentional for running unattended installations. With this switch delivered, Setup runs in quiet mode without any UI. The /QS switch only displays progress via the GUI; it does not take any input and displays no error messages if met. For full unattended installations (using the /Q or /QS parameters) with SQL Server 2008 R2, you must include the /IACCEPTSQLSERVERLICENSETERMS parameter to avoid the show of the License Terms page. Subsequent is a example CLIfor running an unattended installation of SQL Server 2008:

C:\Documents and Settings\rrankins\My Documents\Downloads\SQL2008\R2 Nov CTP>setup.exe /configurationfile=customconfigurationfile.ini /Q /IACCEPTSQLSERVERLICENSETERMS /SQLSVCPASSWORD="riddler" / AGTSVCPASSWORD=yuoo /SAPWD=189

SQL Server 2008 R2 announces a new option to the setup.exe that permits you to run a somewhat more attended mode of the installation that gives you a bit more governor over the install than the /Q and /QS parameters, while streamlining the install slightly. You can now stipulate the /UIMODE parameter instead of the /Q or /QS switches. The /UIMODE parameter specifies whether to present the full set of Installer Wizard pages for review and validation while running the setup or to present a smallest number of pages during setup. /UIMODE=Normal, the default option, displays all setup dialog boxes for the designated features, letting you to review the values or manually enter values not provided in the config file.You can stipulate the /UIMODE=AutoAdvance option to skip supplementary dialogs and auto advances over a number of pages, plus the Ready to Install page.

 

Install SQL Server 2008 R2 SP1 from script

Like the SQL Server 2008 main install, SP1 can also be installed from the CLIwith no user interaction. This ability is useful if you need to install SP1 to a number of servers and want to avoid having to go through all the SP1 Install Wizard screens each time. To run SP1 from the CLI, you must first extract the setup files from the SP1 file, which is an executable archive file. You can do this by running the SQLServer2008SP1 -KB968369-x64-ENU.exe file with the /x option from the CLI. This opens the extractor, which stimuli you for a location to extract the files to. Instead you can stipulate a directory on a local drive to have it extract the setup files to automatically:

SQLServer2008SP1-KB968369-x64-ENU.exe /x:C:\SP1