SQL SERVER2014 Enterprise Edition unattended Installation

1; SQL Server theConfigurationFile2 [OPTIONS]3 4 ; Specifies the workflow for the installer, such as install, UNINSTALL, or UPGRADE. This is a required parameter. 5 6ACTION="Install"7 8 the command line parameter ROLE has not been defined in detail for help. 9 TenROLE="Allfeatures_withdefaults" One  A; Use/The ENU parameter installs the English version of SQL Server on a localized Windows operating system.  -  -ENU="False" the  - the Setup program will not display any user interface.  -  -QUIET="False" +  - , the installer will only show progress without any user interaction.  +  AQuietsimple="True" at  -; Specifies whether the SQL Server Setup program should discover and include product updates. Valid values are True and False or1And0. By default, SQL Server Setup includes the updates that are found.  -  -UpdateEnabled="True" -  -; Specifies whether errors can be reported to Microsoft in order to improve future versions of SQL Server. Specified1Or True to enable this feature to specify0or False to disable this feature.  in  -Errorreporting="False" to  +; If this parameter is provided, this computer will use the MicrosoftUpdateCheck for updates.  -  theUsemicrosoftupdate="False" *  $; Specifies the features to install, uninstall, or upgrade. The top-level feature list includes SQL, asRs is, MDS, and tools. The SQL feature installs the database engine, replication, full-text, and Data quality Services (DQS) servers. The Tools feature installs Administrative tools, Books Online components, SQL Server Data Tools, and other shared components. Panax Notoginseng  -FEATURES=SQLEngine,REPLICATION, Fulltext,rs,conn,bc,sdk,bol,ssms,adv_ssms,snac_sdk,localdb the  +; Specifies the location where SQL Server Setup will get the product updates. Valid values are "MU" (to search for product updates), valid folder paths, and relative paths such as. \myupdates or UNC shared directories. By default, SQL Server Setup passes through the Window serverUpdateServices Search MicrosoftUpdateor WindowsUpdateservice.  A  theUpdatesource="MU" +  - ; show command line parameter usage $  $Help="False" -  - ; Specifies that detailed setup logs should be delivered to the console.  the  -Indicateprogress="False"Wuyi  the; Specifies that the installer should be installed in WOW64. IA64 or +This command-line parameter is not supported by the bit system.  -  WuX86="False" -  About ; Specifies the installation root of the shared component. This directory remains the same after the shared component has been installed.  $  -Installshareddir="C:\Program Files\Microsoft SQL Server" -  - ; Specifies the installation root of the WOW64 shared component. This directory remains intact after the WOW64 shared component has been installed.  A  +Installsharedwowdir="C:\Program Files (x86) \microsoft SQL Server" the  -; Specifies the default instance or named instance. MSSQLSERVER is the default instance of the non-Express version, and SQLExpress is the default instance of the Express version. When you install SQL Server Database Engine (SQL), Analysis Services ( as) or Reporting Services (RS), this parameter is required.  $  theInstanceName="MSSQLSERVER" the  the; Specifies that you can collect SQL Server feature usage data and send data to Microsoft. Specified1Or True to enable this feature to specify0or False to disable this feature.  the  -Sqmreporting="False" in  the ; Specify the instance ID for the SQL Server feature that you have specified. The SQL Server directory structure, registry structure, and service name will contain the instance ID of the instance of SQL Server.  the  AboutINSTANCEID="MSSQLSERVER" the  the ; Rsinputsettings_rsinstallmode_description the  +Rsinstallmode="Defaultnativemode" -  the ; Specify the installation directory. Bayi  theInstancedir="C:\Program Files\Microsoft SQL Server" the  - ; proxy account name -  theAgtsvcaccount="NT authority\network SERVICE" the  the ; Start the service automatically after installation.  the  -Agtsvcstartuptype="Disabled" the  the ; CM program block TCP communication Port the 94Commfabricport="0" the  the how the matrix uses the private network the 98Commfabricnetworklevel="0" About  - ; How to protect the communication between program blocks101 102Commfabricencryption="0"103 104 ; The TCP port used by the CM program block the 106Matrixcmbrickcommport="0"107 108 ; The startup type of the SQL Server service. 109  theSqlsvcstartuptype="Automatic"111  the; Enable the level of the FILESTREAM feature (0、1、2Or3). 113  theFilestreamlevel="0" the  the; Set to "1"RANU can be enabled for SQL Server Express. 117 118Enableranu="True"119  - ; Specifies the Windows collation or SQL collation to use for the database engine. 121 122Sqlcollation="Chinese_prc_ci_as"123 124 ; account for the SQL Server service: domain \ User or SYSTEM account.  the 126Sqlsvcaccount="NT service\mssqlserver"127  - ; The Windows account to be set as the SQL Server system administrator. 129  theSqlsysadminaccounts="WIN-J54kku3lqpe\administrator "131  the ; The default value is Windows authentication. Using "SQL" means mixed-mode authentication. 133 134SecurityMode="SQL"135 136 ; sa password137 138Sapwd=Aw810618139  $; Sets the current user to%Sql_product_short_name%Express's Database engine system administrator. 141 142Addcurrentuserassqladmin="True"143 144; Specified0disabling TCP/IP protocol, specifying1the protocol is enabled. 145 146Tcpenabled="0"147 148; Specified0Disable the Named Pipes protocol and specify1the protocol is enabled. 149  MaxNpenabled="0"151  the ; The startup type of the Browser service. 153 154Browsersvcstartuptype="Disabled"155 156 Specifies the account that the report Server NT service should use when executing. If this value is omitted or the value is an empty string, the default built-in account for the current operating system will be used. 157; The user name portion of the Rssvcaccount has a maximum length of -characters,158; The maximum length of the domain portion of the rssvcaccount is254a character. 159  theRssvcaccount="NT service\reportserver"161 162 Specifies the startup mode of the report Server NT service. 163; Manual-start the service in manual mode (the default value). 164; Automatic-start the service in automatic mode. 165; is disabled-service is in a disabled state166 167Rssvcstartuptype="Automatic"168 169 ; Add the description of the input parameter Ftsvcaccount the 171Ftsvcaccount="NT Service\mssqlfdlauncher"

Configurationfile.ini

1 @echo off2Title Install SQL Server the[email protected]3 COLOR 0A4 5Set predir=C:\Users\Administrator\Desktop\Sql_Server2014_ Automatic installation \sql_server_2014x646Set localusr=Administrator7 8 9 Echo "Installing SQL Server X64 ..."Ten%predir%\sql_server2014\setup.exe/qs/action=install/configurationfile=.\configurationfile.ini/ iacceptsqlserverlicenseterms/sqlsysadminaccounts=.\%localusr% >. \sqlinfo.txt One  APause>NULL

Autoinstall.bat

# #首先需要下载sql Server x64 Enterprise Edition

# #win Server R2 Install SQL Server x64 One-click Script @Sungeek

1. Current directory autoinstall.bat modify variable%predir% to the location of SQL Server X64 file, variable%localusr% to current system user.
2. Double-click Autoinstall.bat to complete the installation.
3. Install the patch files manually.
4.configurationfile.ini file modification; assysadminaccounts= "Win-j54kku3lqpe\administrator" Win-j54kku3lqpe is currently the calculated name Administrator is the current system user, needs to be modified to your current computer name and system user name
; Sqlsysadminaccounts= "Win-j54kku3lqpe\administrator" as above modified!
5.configurationfile.ini file modification; sa password is Aw810618; can be modified by itself;
6.autoinstall2.bat is automatically installed. NET 3.5 + SQL SERVER X64

SQL SERVER2014 Enterprise Edition unattended Installation