Installing SQL Server 2014 in Silent Mode

Installing SQL Server 2014 in Silent Mode

May 10, 2016

The below script is a a variant of a script which I have personally used to install SQL Server 2014 in silent mode:

setup.exe /Q /IACCEPTSQLSERVERLICENSETERMS /ACTION=install /UPDATESOURCE=C:\Install /FEATURES=SQL,Tools /INSTANCENAME=MSSQLSERVER /SQLSVCACCOUNT=”SIMPLEXTECH\sqlserverintr” /SQLSVCPASSWORD=”********” /SQLSYSADMINACCOUNTS=”SIMPLEXTECH\MSSQLDBAdmins” /AGTSVCACCOUNT=”SIMPLEXTECH\sqlagentintr” /AGTSVCPASSWORD=”********”

In this script I have chosen the /Q option and answered every question that SQL Server installer will ask including my acceptance of the license terms, what I want to do (install a single instance, install a cluster etc.), the features I want and even the accounts I would like to use.

It is important to note that all answers must be accurate otherwise your installation will fail so you need to test this and save the final script that works before you can slam it all on ten servers and go home.

Since the installer is silent, you will need to view the progress in the path C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log. Another matter worthy of note is that the data directories and tempdb location all default to drive C. You may want to change this along with all other post installation tasks.

A full list of options for installing SQL Server from command line can be retrieved by typing setup.exe /help are as follows:

ACTION Specifies a Setup work flow, like INSTALL,
  UNINSTALL, or UPGRADE. This is a required
  parameter.
ADDCURRENTUSERASSQLADMIN Provision current user as a Database Engine
  system administrator for SQL Server 2012 Express.
AGTDOMAINGROUP Either domain user name or system account
AGTSVCACCOUNT Either domain user name or system account
AGTSVCPASSWORD Password for domain user name. Not required for
  system account
AGTSVCSTARTUPTYPE Startup type for the SQL Server Agent service.
  Supported values are Manual, Automatic or
  Disabled.
ALLINSTANCES Specifies that all instances are to be included
  in the Setup operation. This parameter is
  supported only when applying a patch.
ALLOWUPGRADEFORSSRSSHAREPOIN  
  RSInputSettings_AllowUpgradeForSSRSSharePointMode_
Description  
ASBACKUPDIR The location for the Analysis Services backup
  files.
ASCOLLATION The collation used by Analysis Services.
ASCONFIGDIR The location for the Analysis Services
  configuration files.
ASDATADIR The location for the Analysis Services data
  files.
ASLOGDIR The location for the Analysis Services log files.
ASPROVIDERMSOLAP Specifies if the MSOLAP provider can run in
  process.
ASSERVERMODE Specifies the server mode of the Analysis
  Services instance. Valid values are
  MULTIDIMENSIONAL and TABULAR. The default value
  is MULTIDIMENSIONAL.
ASSVCACCOUNT The account used by the Analysis Services
  service.
ASSVCPASSWORD The password for the Analysis Services service
  account.
ASSVCSTARTUPTYPE Controls the service startup type setting for the
  service.
ASSYSADMINACCOUNTS Specifies the list of administrator accounts to
  provision.
ASTEMPDIR The location for the Analysis Services temporary
  files.
BROWSERSVCSTARTUPTYPE Startup type for Browser Service.
CLTCTLRNAME The computer name that the client communicates
  with for the Distributed Replay Controller
  service.
CLTRESULTDIR The result directory for the Distributed Replay
  Client service.
CLTSTARTUPTYPE The startup type for the Distributed Replay
  Client service.
CLTSVCACCOUNT The account used by the Distributed Replay Client
  service.
CLTSVCPASSWORD The password for the Distributed Replay Client
  service account.
CLTWORKINGDIR The working directory for the Distributed Replay
  Client service.
CLUSTERPASSIVE Specifies that SQL Server Setup should not manage
  the SQL Server services. This option should be
  used only in a non-Microsoft cluster environment.
COMMFABRICENCRYPTION MATRIXCOMMMESSAGEPROTECTION {0,1}
COMMFABRICNETWORKLEVEL MATRIXCOMMNETWORKISOLATION {0,1}
COMMFABRICPORT MATRIXCOMMPORT <port>
CONFIGURATIONFILE Specifies the configuration file to be used for
  Setup.
CONFIRMIPDEPENDENCYCHANGE Indicates that the change in IP address resource
  dependency type for the SQL Server multi-subnet
  failover cluster is accepted.
CTLRSTARTUPTYPE The startup type for the Distributed Replay
  Controller service.
CTLRSVCACCOUNT The account used by the Distributed Replay
  Controller service.
CTLRSVCPASSWORD The password for the Distributed Replay
  Controller service account.
CTLRUSERS The Windows account(s) used to grant permission
  to the Distributed Replay Controller service.
ENABLERANU Set to “1” to enable RANU for SQL Server Express.
ENU Detailed help for command line argument ENU has
  not been defined yet.
ERRORREPORTING Specify if errors can be reported to Microsoft to
  improve future SQL Server releases. Specify 1 or
  True to enable and 0 or False to disable this
  feature.
FAILOVERCLUSTERDISKS Specifies a cluster shared disk to associate with
  the SQL Server failover cluster instance.
FAILOVERCLUSTERGROUP Specifies the name of the cluster group for the
  SQL Server failover cluster instance.
FAILOVERCLUSTERIPADDRESSES Specifies an encoded IP address. The encodings
  are semicolon-delimited (;), and follow the
  format <IP Type>;<address>;<network name>;<subnet
  mask>. Supported IP types include DHCP, IPV4, and
  IPV6.
FAILOVERCLUSTERNETWORKNAME Specifies the name of the SQ LServer failover
  cluster instance.  This name is the network name
  that is used to connect to SQL Server services.
FAILOVERCLUSTERROLLOWNERSHIP Specifies whether the upgraded nodes should take
  ownership of the failover instance group or not.
  Use 0 to retain ownership in the legacy nodes, 1
  to make the upgraded nodes take ownership, or 2
  to let SQL Server Setup decide when to move
  ownership.
FEATURES Specifies features to install, uninstall, or
  upgrade. The list of top-level features include
  SQL, AS, RS, IS, MDS, and Tools. The SQL feature
  will install the Database Engine, Replication,
  Full-Text, and Data Quality Services (DQS)
  server. The Tools feature will install Management
  Tools, Books online components, SQL Server Data
  Tools, and other shared components.
FILESTREAMLEVEL Level to enable FILESTREAM feature at (0, 1, 2 or
  3).
FILESTREAMSHARENAME Name of Windows share to be created for
  FILESTREAM File I/O.
FTSVCACCOUNT User account for Full-text Filter Daemon Host.
FTSVCPASSWORD User password for Full-text Filter Daemon Host
  account.
FTUPGRADEOPTION Full-text catalog upgrade option.
HELP Displays the command line parameters usage
IACCEPTSQLSERVERLICENSETERMS By specifying this parameter and accepting the
  SQL Server license terms, you acknowledge that
  you have read and understood the terms of use.
INDICATEPROGRESS Specifies that the detailed Setup log should be
  piped to the console.
INSTALLSHAREDDIR Specify the root installation directory for
  shared components.  This directory remains
  unchanged after shared components are already
  installed.
INSTALLSHAREDWOWDIR Specify the root installation directory for the
  WOW64 shared components.  This directory remains
  unchanged after WOW64 shared components are
  already installed.
INSTALLSQLDATADIR The Database Engine root data directory.
INSTANCEDIR Specify the instance root directory.
INSTANCEID Specify the Instance ID for the SQL Server
  features you have specified. SQL Server directory
  structure, registry structure, and service names
  will incorporate the instance ID of the SQL
  Server instance.
INSTANCENAME Specify a default or named instance. MSSQLSERVER
  is the default instance for non-Express editions
  and SQLExpress for Express editions. This
  parameter is required when installing the SQL
  Server Database Engine (SQL), Analysis Services
  (AS), or Reporting Services (RS).
ISSVCACCOUNT Either domain user name or system account.
ISSVCPASSWORD Password for domain user.
ISSVCSTARTUPTYPE Automatic, Manual or Disabled.
MATRIXCMBRICKCOMMPORT MATRIXCMBRICKCOMMPORT portNumber
MATRIXCMSERVERNAME MATRIXCMSERVERNAME hostName\instanceName
MATRIXNAME MATRIXNAME=<name>
NPENABLED Specify 0 to disable or 1 to enable the Named
  Pipes protocol.
PID Specify the SQL Server product key to configure
  which edition you would like to use.
QUIET Setup will not display any user interface.
QUIETSIMPLE Setup will display progress only, without any
  user interaction.
ROLE Detailed help for command line argument ROLE has
  not been defined yet.
RSCATALOGSERVERINSTANCENAME The SQL Server server for the report server
  catalog database.
RSINSTALLMODE RSInputSettings_RSInstallMode_Description
RSSHPINSTALLMODE RSInputSettings_RSInstallMode_Description
RSSVCACCOUNT Specify the service account of the report server.
  This value is required. If you omit this value,
  Setup will use the default built-in account for
  the current operating system (either
  NetworkService or LocalSystem). If you specify a
  domain user account, the domain must be under 254
  characters and the user name must be under 20
  characters. The account name cannot contain the
  following characters:
  ” / \ [ ] : ; | = , + * ? < >
RSSVCPASSWORD Specify a strong password for the account. A
  strong password is at least 8 characters and
  includes a combination of upper and lower case
  alphanumeric characters and at least one symbol
  character. Avoid spelling an actual word or name
  that might be listed in a dictionary.
RSSVCSTARTUPTYPE Specifies the startup mode for the Report Server
  service. Valid values include Manual, Automatic,
  and Disabled. The default value for StartupType
  is Manual, where the server is started when a
  request is received.
RSUPGRADEDATABASEACCOUNT RSInputSettings_RSInstallMode_Description
RSUPGRADEPASSWORD RSInputSettings_RSInstallMode_Description
RULES Specifies the list of rule IDs or rule group IDs
  to run.
SAPWD Password for SQL Server sa account.
SECURITYMODE The default is Windows Authentication. Use “SQL”
  for Mixed Mode Authentication.
SQLBACKUPDIR Default directory for the Database Engine backup
  files.
SQLCOLLATION Specifies a Windows collation or an SQL collation
  to use for the Database Engine.
SQLSVCACCOUNT Account for SQL Server service: Domain\User or
  system account.
SQLSVCPASSWORD A SQL Server service password is required only
  for a domain account.
SQLSVCSTARTUPTYPE Startup type for the SQL Server service.
SQLSYSADMINACCOUNTS Windows account(s) to provision as SQL Server
  system administrators.
SQLTEMPDBDIR Directory for Database Engine TempDB files.
SQLTEMPDBLOGDIR Directory for the Database Engine TempDB log
  files.
SQLUSERDBDIR Default directory for the Database Engine user
  databases.
SQLUSERDBLOGDIR Default directory for the Database Engine user
  database logs.
SQMREPORTING Specify that SQL Server feature usage data can be
  collected and sent to Microsoft. Specify 1 or
  True to enable and 0 or False to disable this
  feature.
TCPENABLED Specify 0 to disable or 1 to enable the TCP/IP
  protocol.
UIMODE Parameter that controls the user interface
  behavior. Valid values are Normal for the full
  UI,AutoAdvance for a simplied UI, and
  EnableUIOnServerCore for bypassing Server Core
  setup GUI block.
UpdateEnabled Specify whether SQL Server Setup should discover
  and include product updates. The valid values are
  True and False or 1 and 0. By default SQL Server
  Setup will include updates that are found.
UpdateSource Specify the location where SQL Server Setup will
  obtain product updates. The valid values are “MU”
  to search Microsoft Update, a valid folder path,
  a relative path such as .\MyUpdates or a UNC
  share. By default SQL Server Setup will search
  Microsoft Update or a Windows Update service
  through the Window Server Update Services.
X86 Specifies that Setup should install into WOW64.
  This command line argument is not supported on an
  IA64 or a 32-bit system.

Igiri Books © Copyright 2016. All Rights Reserved. Site Credits: AppWorld