How-to create an unattended SQL Install mode.
1-Create cmd file with below Code text and save it as
c:\SQLSilentInstall\InstallSQL.CMD
<CD Drive letter>:\setup.exe /Configurationfile=”ConfigurationFile.ini” /IAcceptSQLServerLicenseTerms
2-Create ConfigurationFile.ini file below with the Code text below, and saved it in c:\SQLSilentInstall\
Configure the parameters highlighted in red.
Code:
;SQL SERVER 2012 Configuration File [OPTIONS] ; Specifies a Setup work flow, like INSTALL, UNINSTALL, or UPGRADE. This is a required parameter. ACTION="Install" ; Detailed help for command line argument ROLE has not been defined yet. ROLE="AllFeatures_WithDefaults" ; Detailed help for command line argument ENU has not been defined yet. ENU="True" ; Setup will not display any user interface. QUIET="True" ; 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. UpdateEnabled="True" ; 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. FEATURES=SQLENGINE,REPLICATION,FULLTEXT,DQ,AS,RS,DQC,BIDS,CONN,IS,BC,SDK,BOL,SSMS,ADV_SSMS,SNAC_SDK,MDS; Specifies the list of administrator accounts that need to be provisioned. ASSYSADMINACCOUNTS="<ASSYSADMINACCOUNT>" ; Windows account(s) to provision as SQL Server system administrators. SQLSYSADMINACCOUNTS="<SYSADMINACCOUNT>" ; 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. SQMREPORTING="False" ; 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. ERRORREPORTING="FALSE" ; 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). INSTANCENAME="MSSQLSERVER" ; RSInputSettings_RSInstallMode_Description RSINSTALLMODE="FilesOnlyMode" ; Don't provision current user as a Database Engine system administrator. ADDCURRENTUSERASSQLADMIN="False"
3-Run cmd prompt as Administrator, cd to c:\SQLSilentInstall\
4-Run InstallSQL.cmd