_Copyright Statement: This is an original article created by a blogger and may not be reproduced without the permission of the blogger.
1. Tools needed
Requires 7Z decompression tool, SQLserver 2014 disc image file, sxs(.net3.5 related component package)
2. Preparations
An installation profile ConfigurationFile.ini needs to be exported via sqlserver
Here's how to configure the parameters of sql2014 you need to install
;SQL Server 2014 Configuration File [OPTIONS] ; Specify the workflow for the installer, such as INSTALL,UNINSTALL or UPGRADE. This is a required parameter. ACTION="Install" ; Use /ENU Parameters can be localized Windows English version installed on operating system SQL Server. ENU="False" ; Setup will not display any user interface. QUIET="False" ; Setup will only show progress without any user interaction. QUIETSIMPLE="False" ; Appoint SQL Server Whether the installer 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="True" ; Specify whether errors can be reported to Microsoft In order to improve the future SQL Server Edition.Specify 1 or True This feature will be enabled, specifying 0 or False This feature will be disabled. ERRORREPORTING="False" ; If this parameter is provided, the computer will use Microsoft Update Check for updates. USEMICROSOFTUPDATE="False" ; Specify features to install, uninstall, or upgrade.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 Services (DQS)The server.Tools feature will install management tools, online book components, SQL Server Data Tools And other shared components. FEATURES=SQLENGINE,REPLICATION,FULLTEXT,DQ,DQC,CONN,BC,SDK,BOL,SSMS,SNAC_SDK,MDS ; Appoint SQL Server Setup will get the location of product updates.Valid values are "MU" (To search for product updates),Valid folder path and .\MyUpdates or UNC Relative paths such as shared directories.By default, SQL Server The setup program will pass through the Window Server Update Services search Microsoft Update or Windows Update Service. UpdateSource="MU" ; Show command line parameter usage HELP="False" ; Specifies that the detailed setup log should be sent to the console. INDICATEPROGRESS="False" ; Specifies that the installer should be installed to WOW64 Medium. IA64 This command line parameter is not supported on 32-bit systems. X86="False" ; Specify the installation root directory for shared components.This directory remains unchanged after shared components have been installed. INSTALLSHAREDDIR="C:\Program Files\Microsoft SQL Server" ; Appoint WOW64 Installation root directory for shared components.Installed WOW64 This directory remains unchanged after sharing components. INSTALLSHAREDWOWDIR="C:\Program Files (x86)\Microsoft SQL Server" ; Specify a default or named instance. MSSQLSERVER Yes and No Express Default instance of version, SQLExpress then is Express Default instance of version.Installing SQL Server database engine(SQL),Analysis Services (AS)or Reporting Services (RS)This parameter is required. INSTANCENAME="MSSQLSERVER" ; Specify that you can collect SQL Server Function usage data and send data to Microsoft. Specify 1 or True This feature will be enabled, specifying 0 or False This feature will be disabled. SQMREPORTING="False" ; For what you have specified SQL Server Function Specified Instances ID. SQL Server The directory structure, registry structure, and service name will include SQL Server Instances of instances ID. INSTANCEID="MSSQLSERVER" ; Specify the installation directory. INSTANCEDIR="C:\Program Files\Microsoft SQL Server" ; Proxy account name AGTSVCACCOUNT="NT Service\SQLSERVERAGENT" ; Start the service automatically after installation. AGTSVCSTARTUPTYPE="Manual" ; CM Block TCP Communication Port COMMFABRICPORT="0" ; How matrix uses private networks COMMFABRICNETWORKLEVEL="0" ; How to protect communication between program blocks COMMFABRICENCRYPTION="0" ; CM Block Usage TCP port MATRIXCMBRICKCOMMPORT="0" ; SQL Server Start type of service. SQLSVCSTARTUPTYPE="Automatic" ; Enable FILESTREAM Level of functionality(0,1,2 Or 3). FILESTREAMLEVEL="0" ; Set to "1" Can be SQL Server Express Enable RANU. ENABLERANU="False" ; Specifies the Windows Collation or SQL Collation. SQLCOLLATION="Chinese_PRC_CI_AS" ; SQL Server Accounts for Services: field\User or system account. SQLSVCACCOUNT="NT Service\MSSQLSERVER" ; To set to SQL Server Administrator's Windows Account. SQLSYSADMINACCOUNTS="WIN-J54KKU3LQPE\Administrator" ; Default value is Windows Authentication.Use "SQL" Indicates mixed mode authentication. SECURITYMODE="SQL" ;sa Password SAPWD=Aw810618 ; Set the current user to %SQL_PRODUCT_SHORT_NAME% Express Database Engine System Administrator. ADDCURRENTUSERASSQLADMIN="False" ; Specify 0 to disable TCP/IP Protocol, specify 1 to enable the protocol. TCPENABLED="1" ; Specify 0 to disable Named Pipes Protocol, specify 1 to enable the protocol. NPENABLED="0" ; Browser Start type of service. BROWSERSVCSTARTUPTYPE="Disabled" ; Add Input Parameters FTSVCACCOUNT Description FTSVCACCOUNT="NT Service\MSSQLFDLauncher"
Write automatic installation (SQL version).bat
The details are as follows
Batch instructions:
#Win server 2012 install sqlserver 2014 x64 one-click script @Sungeek#
#Auto Install (SQL Version). bat or Auto Install (Component Library Version). Ba Right-click text open, change the following variable parameters, and make the changes you need. #
set Predir=C:\Sql_Server2014_Auto Installsql_server_2014 x64
Predir=The database installation package directory needs to be changed according to your actual directory.
②set Localusr=Administrator
Localusr=Change to the name of your computer system administrator.
③set Sapwd=Sg1838370
Sapwd=sa password, you must add a number in English, not a pure digital password.
Explain:
1. Auto-install (SQL version). bat; Auto-install SQL server 2014 does not install.NET component library;
2. Auto Install (Component Library Edition). bat; is Auto Install.NET 3.5 + SQL SERVER 2014 X64
3. After installation, the window will be automatically closed to generate sqlinfo files.
4. Successfully installed sqlinfo file contents:
Microsoft (R) SQL Server 2014 12.00.2000.08 Copyright (C) Microsoft Corporation.All rights reserved.
(4) The installation can be completed by double-clicking the automatic installation (SQL version) of.Net library.
Double-click Automatic Installation (Component Library Edition). bat to install automatically if there is no.Net3.5 Component Library.
@echo off title Install sqlserver 2014 x64@Sungeek COLOR 0A set Predir=E:\Sql_Server2014_Auto Installsql_server_2014 x64 set Localusr=Administrator set Sapwd=Sg1838370 echo "Extract sqlserver2014 iso..." echo "Unzipping the SQL server 2014 mirror" 7z.exe x %Predir%\sqlserver2014.iso -aos -o%Predir%\sqlserver2014 echo "installing SqlServer 2014 x64@Sungeek..." echo "After installation, the window will automatically close to generate sqlinfo file. Please be patient!" %Predir%\sqlserver2014\setup.exe /Q /ACTION=Install /ConfigurationFile=.\MyConfigurationFile.ini /IACCEPTSQLSERVERLICENSETERMS /SAPWD=.\%Sapwd% /SQLSYSADMINACCOUNTS=.\%Localusr% > .\sqlinfo.txt ping -n 10 127.0.0.1 > null