- Method 1, install by specifying a bar parameter
setup.exe /Q /IACCEPTSQLSERVERLICENSETERMS /ACTION=install /PID=<validpid> /FEAT
URES=SQL,AS,RS,IS,Tools
/INSTANCENAME=MSSQLSERVER /SQLSVCACCOUNT="MyDomain\MyAccount"
/SQLSVCPASSWORD="************" /SQLSYSADMINACCOUNTS="MyDomain\MyAccount "
/AGTSVCACCOUNT="MyDomain\MyAccount" /AGTSVCPASSWORD="************"
/ASSVCACCOUNT="MyDomain\MyAccount" /ASSVCPASSWORD="************"
/RSSVCACCOUNT="MyDomain\MyAccount" /RSSVCPASSWORD="************"
/ISSVCAccount="MyDomain\MyAccount" /ISSVCPASSWORD="************"
/ASSYSADMINACCOUNTS="MyDomain\MyAccount"
- Method 2, specify the configuration file installation
I: \> Setup.exe /ConfigurationFile="d:\ConfigurationFile.ini "
Microsoft (R) SQL Server 2012 11.00.2100.60
Copyright (c) Microsoft Corporation. all rights reserved.
Install with the second method,
Here is my profile, add an instance named I01 to SQL Server 2012, note that the place is bold.; is a comment, like
; Required to acknowledge acceptance of the license terms. Iacceptsqlserverlicenseterms= "True"
Attention
; UIMODE = "False"
note
Choose one, or give an error
; The installer will not display any user interface.
QUIET = "False"
; The installer will only show progress without any user interaction.
QUIETSIMPLE = "True" <
Note; the default is Windows Authentication. Use "SQL" for mixed mode authentication.
SECURITYMODE = "SQL"
SAPWD = "1qaz2WSX"
The following is the full file,
; SQL Server 2012 Configuration File
[OPTIONS]
; Required to acknowledge acceptance of the license terms.
IACCEPTSQLSERVERLICENSETERMS = "True"
; Specify the installer workflow, such as INSTALL, UNINSTALL, or UPGRADE. This is a required parameter.
ACTION = "Install"
; Detailed help for command line parameter ENU has not been defined.
ENU = "False"
; Parameters used to control user interface behavior. Valid values are Normal for full UI, AutoAdvance for simplified UI, and Skip Server Core installer GUI blocks for EnableUIOnServerCore.
; UIMODE = "False"
; The installer will not display any user interface.
QUIET = "False"
; The installer will only show progress without any user interaction.
QUIETSIMPLE = "True"
; Specify whether SQL Server Setup should discover and include product updates. Valid values are True and False or 1 and 0. By default, SQL Server Setup will include the updates found.
UpdateEnabled = "False"
; Specify features to install, uninstall, or upgrade. The top-level feature list includes SQL, AS, RS, IS, MDS, and tools. The SQL feature installs the database engine, replication, full text, and Data Quality Services (DQS) server. The tools feature installs management tools, Books Online components, SQL Server Data Tools, and other shared components.
FEATURES = SQLENGINE, REPLICATION, FULLTEXT, DQ
; Specify where SQL Server Setup will get product updates. Valid values are "MU" (for searching for product updates), valid folder paths, and relative paths such as. \ MyUpdates or UNC shared directories. By default, SQL Server Setup will search for Microsoft Update or Windows Update services through Window Server Update Services.
UpdateSource = "MU"
; Display command line parameter usage
HELP = "False"
; Specifies that detailed installer logs should be transferred to the console.
INDICATEPROGRESS = "False"
; Specifies that the installer should be installed into WOW64. This command line parameter is not supported on IA64 or 32-bit systems.
X86 = "False"
; Specify the installation root directory for shared components. This directory remains unchanged after the shared components have been installed.
INSTALLSHAREDDIR = "C: \ Program Files \ Microsoft SQL Server"
; Specify the installation root directory for WOW64 shared components. This directory remains unchanged after the WOW64 shared components have been installed.
INSTALLSHAREDWOWDIR = "C: \ Program Files (x86) \ Microsoft SQL Server"
; Specify the default or named instance. MSSQLSERVER is the default instance of the non-Express version, and SQLExpress is the default instance of the Express version. This parameter is required when installing the SQL Server Database Engine (SQL), Analysis Services (AS), or Reporting Services (RS).
INSTANCENAME = "I01"
; Specify the instance ID for the SQL Server feature you have specified. The SQL Server directory structure, registry structure, and service name will contain the instance ID of the SQL Server instance.
INSTANCEID = "I01"
; Specify that SQL Server feature usage data can be collected and sent to Microsoft. Specifying 1 or True will enable this feature, and specifying 0 or False will disable it.
SQMREPORTING = "False"
; Specify whether errors can be reported to Microsoft to improve future versions of SQL Server. Specifying 1 or True will enable this feature, and specifying 0 or False will disable it.
ERRORREPORTING = "False"
; Specify the installation directory.
INSTANCEDIR = "e: \ Program Files \ Microsoft SQL Server"
; Proxy Account Name
AGTSVCACCOUNT = "NT Service \ SQLAgent $ I01"
; Start the service automatically after installation.
AGTSVCSTARTUPTYPE = "Manual"
; CM program block TCP communication port
COMMFABRICPORT = "0"
How the Matrix Uses a Private Network
COMMFABRICNETWORKLEVEL = "0"
; How to protect communication between program blocks
COMMFABRICENCRYPTION = "0"
; TCP port used by CM blocks
MATRIXCMBRICKCOMMPORT = "0"
; SQL Server service startup type.
SQLSVCSTARTUPTYPE = "Manual"
; The level (0, 1, 2, or 3) at which the FILESTREAM function is enabled.
FILESTREAMLEVEL = "0"
; Set to "1" to enable RANU for SQL Server Express.
ENABLERANU = "False"
; Specify the Windows collation or SQL collation to use for the database engine.
SQLCOLLATION = "Chinese_PRC_CI_AS"
; SQL Server service account: domain \ user or system account.
SQLSVCACCOUNT = "NT Service \ MSSQL $ I01"
; Windows account to be set as SQL Server system administrator.
SQLSYSADMINACCOUNTS = "ADMINISTRATOR"
; The default is Windows Authentication. Use "SQL" for mixed mode authentication.
SECURITYMODE = "SQL"
SAPWD = "1qaz2WSX"
; Set the current user as the database engine system administrator for SQL Server 2012 Express.
ADDCURRENTUSERASSQLADMIN = "False"
; Specify 0 to disable the TCP / IP protocol, and specify 1 to enable the protocol.
TCPENABLED = "1"
; Specify 0 to disable the Named Pipes protocol, and specify 1 to enable the protocol.
NPENABLED = "0"
; Start type of Browser service.
BROWSERSVCSTARTUPTYPE = "Manual"
; Add description of input parameter FTSVCACCOUNT
FTSVCACCOUNT = "NT Service \ MSSQLFDLauncher $ I01"
1 Mount Image
2 Enter the command line:
3 run
I:\>setup.exe/configurationfile= "D:\ConfigurationFile.ini"
4 Installation Complete
How to quickly write a configuration file, by modifying the wizard during the UI installation process, the first configuration file of the native, configure the path to be persisted, open and modify it as follows
Add to
; Required to acknowledge acceptance of the license terms. Iacceptsqlserverlicenseterms= "True"
Do not display UI
; UIMODE = "False"
note
Choose one, or give an error
; The installer will not display any user interface.
QUIET = "False"
; The installer will only show progress without any user interaction.
QUIETSIMPLE = "True"
Note; the default is Windows Authentication. Use "SQL" for mixed mode authentication.
SECURITYMODE = "SQL"
SAPWD = "1qaz2WSX"
Help
Microsoft Windows [version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. all rights reserved.
C: \ Users \ Patrick> I:
I: \> setup.exe / help
Microsoft (R) SQL Server 2012 11.00.2100.60
Copyright (c) Microsoft Corporation. all rights reserved.
usage:
setup.exe / [options] = {value} / [options] = {value} ...
Options:
ACTION specifies the workflow of the installer, such as INSTALL, UNINSTALL, or UPG
RADE. 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 will be included in the installation operation. Only when applying patch
This parameter is only supported during programming.
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 Specify if the MSOLAP provider can run in
process.
ASSERVERMODE Specify 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 Specify 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 SQL Server services.
This option should only be used in non-
Used in a Microsoft cluster environment.
COMMFABRICENCRYPTION MATRIXCOMMMESSAGEPROTECTION {0,1}
COMMFABRICNETWORKLEVEL MATRIXCOMMNETWORKISOLATION {0,1}
COMMFABRICPORT MATRIXCOMMPORT <port>
CONFIGURATIONFILE specifies the configuration file that will be used for the installer.
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 has not yet defined detailed help for command line parameters ENU.
ERRORREPORTING specifies whether errors can be reported to Microsoft to improve future SQ
L Server version. Specify 1
Or True will enable this feature, specifying 0 or False will disable this feature
.
FAILOVERCLUSTERDISKS Specify a cluster shared disk to associate with
the SQL Server failover cluster instance.
FAILOVERCLUSTERGR
OUP Specify the name of the cluster group for the
SQL Server failover cluster instance.
FAILOVERCLUSTERIPADDRESSES Specify 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 Specify 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 Specify 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 be installed, uninstalled, or upgraded. Top-level feature list includes SQL
, AS, RS, IS, MDS, and tools. SQL
Features will install the database engine, replication, full text and Data Quality Se
rvices
(DQS) server. 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 display command line parameter usage
IACCEPTSQLSERVERLICENSETERMS By specifying this parameter and accepting the SQL Server license terms, you confirm that you have
Read and understand the terms of use.
INDICATEPROGRESS specifies that detailed installer logs should be transferred to the console.
INSTALLSHAREDDIR Specifies the installation root directory for shared components. After the shared components have been installed, this
Records remain unchanged.
INSTALLSHAREDWOWDIR Specifies the installation root directory for WOW64 shared components. After having installed WOW64
After sharing components, this directory remains unchanged.
INSTALLSQLDATADIR The Database Engine root data directory.
INSTANCEDIR specifies the instance root directory.
INSTANCEID specifies the instance ID for the SQL Server feature you have specified. SQL Serve
r
The directory structure, registry structure, and service name will contain the SQL Server
The instance ID of the instance.
INSTANCENAME specifies the default or named instance. MSSQLSERVER is non-Express
Version of the default instance, SQLExpress is the default version of Express
Instance. Installing SQL
Server Database Engine (SQL), Analysis Services (AS), or
This parameter is required for 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 specifies the SQL Server product key to configure which version you want to use.
The QUIET installer will not display any user interface.
The QUIETSIMPLE installer will only show progress without any user interaction.
ROLE has not yet defined detailed help for the command line parameter ROLE.
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 Specify the startup mode for the Report Server
s
SQL Server 2012 Unattended installation (adding a new instance)