SQL Server 2012 Unattended installation (adding a new instance)

Source: Internet
Author: User
Tags failover mssqlserver alphanumeric characters strong password sql server express


    • 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)


Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.