How to Install SQL Server using Command Prompt (OR) Unattended Installation (OR) Silent Installation.

We can install the SQL Server through command Prompt.

when we install the SQL Server through command prompt, we need to specify the following steps.

  1. Specify the SQL Server media software.
  2. Open the command prompt and change to SQL Server media directory.
  3. First specify setup.exe file and mention the parameters what you required, but some of parameters are mandatory to passed it.
  4. The installation of SQL Server 2008/2008R2/2012/2014 are same, but SQL Server 2005 is little different.
Parameter Description
/Q Optional. Specifies to run Setup in quiet mode for unattended installations.
/QS Optional. Specifies to run Setup and show progress through the UI. No input is accepted or errors displayed.
/UIMODE Optional. Specifies whether to display only essential dialog boxes during Setup.
/ACTION Required. Specifies a workflow.
Supported values: Install, Uninstall, or Upgrade.
/IACCEPTSQLSERVERLICENSETERMS Required. Accepts licensing terms.
/UPDATEENABLED Optional. Specifies whether to look for product updates.
Supported values: true and false or 1 and 0.
/UPDATESOURCE Optional. Specifies location of product updates.
Supported values: MU to search the Microsoft Update server, a folder path, a relative path, or a UNC share.
/CONFIGURATIONFILE Optional. Specifies a configuration file to be used.
/ERRORREPORTING Optional. Specifies error reporting opt-in option to Microsoft or a corporate report server.
Supported values: 1 = enabled; 0 = disabled.
/FEATURES or /ROLE Required. Specifies components to install or specifies a predetermined configuration known as the setup role.
/INSTALLSHAREDDIR Optional. Specifies a nondefault installation directory for 64-bit shared components.
/INSTANCEDIR Optional. Specifies a nondefault installation directory for instance-specific components.
/INSTANCEID Optional. Specifies a nondefault instance id.
/INSTANCENAME Required. Specifies an instance name.
/PID Optional. Specifies product key for the edition to be installed. If not specified, the Evaluation edition is installed.
/INSTALLSQLDATADIR Optional. Specifies the directory for SQL Server data (.mdf) files.
/SECURITYMODE Optional. Specifies security mode for SQL Server.
Default value: Windows-only authentication.Supported value: SQL.
/SAPWD Required if /SECURITYMODE=SQL. Specifies sa SQL Server account password.
/SQLUSERDBLOGDIR Optional. Specifies directory for SQL Server log files (*.ldf).
/SQLTEMPDBDIR Optional. Specifies directory for SQL Server tempdb data file.
/SQLTEMPDBLOGDIR Optional. Specifies directory for SQL Server tempdb log file.
/SQLBACKUPDIR Optional. Specifies directory for SQL Server backup files (*.bak, *.trn).
/SQLCOLLATION Optional. Specifies collation settings.
/SQLSVCACCOUNT Required. Specifies the startup account for the SQL Server service.
/SQLSVCPASSWORD Required. Specifies the password for the SQL Server service account.
/SQLSVCSTARTUPTYPE Optional. Specifies the startup mode of the SQL Server service.
Supported values: Automatic, Manual, and Disabled.
/SQLSYSADMINACCOUNTS Required. Specifies accounts to be added to the sysadmin role.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s