Installing SQL 2014 using configuration file

Please refer the the following steps on how to install SQL 2014 on Windows 2012 R2 using configuration file

    • Enable .NET 3.5 SP1 in Windows 2012 R2
Import-Module ServerManager 
Install-WindowsFeature NET-Framework-Features
  1. Go through the normal SQL 2014 setup process to select what are the SQL components to be installed and Stop at “Ready To Install” 
  1. Get the configuration file from

C:\Program Files (x86)\Microsoft SQL Server\120\Setup Bootstrap\Log\20160122_022542\ConfigurationFile.ini

SQL2014-Install-01

  1. Modify the following value and save the configurationfile.ini to c:\temp
    • Change “QUIETSIMPLE” = “False” to “True”
    • Remove “UIMODE” = “Normal” by adding ;
    • SQLSVCACCOUNT=”MonsterBean\sqladmin”
      SQLSVCPASSWORD=”password” – specify the password 
    • AGTSVCACCOUNT=”MonsterBean\sqladmin”
      AGTSVCPASSWORD=”password” – specify the password 
  1. Go to D:\ (Where SQL 2014 ISO File located), and enter the following command in PowerShell **
.\setup /configurationfile="c:\temp\configurationfile.ini" /IACCEPTSQLSERVERLICENSETERMS

No input is required and it will take awhile to complete the installation

SQL2014-Install-02

Go to C:\Program Files (x86)\Microsoft SQL Server\120\Setup Bootstrap\Log\20160122_022542 and open Summary_M-SQL1_20160122_022542.txt to verify SQL 2014 is installed successfully without any error

SQL2014-Install-03

Attached is the SQL 2014 ConfigurationFile.ini and the Summary_M-SQL1_20160122_022542.txt for reference

;SQL Server 2014 Configuration File
[OPTIONS]

; Specifies a Setup work flow, like INSTALL, UNINSTALL, or UPGRADE. This is a required parameter. 

ACTION="Install"

; Use the /ENU parameter to install the English version of SQL Server on your localized Windows operating system. 

ENU="True"

; Parameter that controls the user interface behavior. Valid values are Normal for the full UI,AutoAdvance for a simplied UI, and EnableUIOnServerCore for bypassing Server Core setup GUI block. 

;UIMODE="Normal"

; Setup will not display any user interface. 

QUIET="False"

; Setup will display progress only, without any user interaction. 

QUIETSIMPLE="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"

; 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"

; If this parameter is provided, then this computer will use Microsoft Update to check for updates. 

USEMICROSOFTUPDATE="False"

; 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,BOL,SSMS,ADV_SSMS

; Specify the location where SQL Server Setup will obtain product updates. The valid values are "MU" to search Microsoft Update, a valid folder path, a relative path such as .\MyUpdates or a UNC share. By default SQL Server Setup will search Microsoft Update or a Windows Update service through the Window Server Update Services. 

UpdateSource="MU"

; Displays the command line parameters usage 

HELP="False"

; Specifies that the detailed Setup log should be piped to the console. 

INDICATEPROGRESS="False"

; Specifies that Setup should install into WOW64. This command line argument is not supported on an IA64 or a 32-bit system. 

X86="True"

; Specify the root installation directory for shared components.  This directory remains unchanged after shared components are already installed. 

INSTALLSHAREDDIR="C:\Program Files\Microsoft SQL Server"

; 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"

; 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 the Instance ID for the SQL Server features you have specified. SQL Server directory structure, registry structure, and service names will incorporate the instance ID of the SQL Server instance. 

INSTANCEID="MSSQLSERVER"

; Specify the installation directory. 

INSTANCEDIR="C:\Program Files (x86)\Microsoft SQL Server"

; Agent account name 

AGTSVCACCOUNT="MonsterBean\sqladmin"

; Auto-start service after installation.  

AGTSVCSTARTUPTYPE="Automatic"

; CM brick TCP communication port 

COMMFABRICPORT="0"

; How matrix will use private networks 

COMMFABRICNETWORKLEVEL="0"

; How inter brick communication will be protected 

COMMFABRICENCRYPTION="0"

; TCP port used by the CM brick 

MATRIXCMBRICKCOMMPORT="0"

; Startup type for the SQL Server service. 

SQLSVCSTARTUPTYPE="Automatic"

; Level to enable FILESTREAM feature at (0, 1, 2 or 3). 

FILESTREAMLEVEL="0"

; Set to "1" to enable RANU for SQL Server Express. 

ENABLERANU="False"

; Specifies a Windows collation or an SQL collation to use for the Database Engine. 

SQLCOLLATION="SQL_Latin1_General_CP1_CI_AS"

; Account for SQL Server service: Domain\User or system account. 

SQLSVCACCOUNT="MonsterBean\sqladmin"

; Windows account(s) to provision as SQL Server system administrators. 

SQLSYSADMINACCOUNTS="MonsterBean\administrator"

; Provision current user as a Database Engine system administrator for %SQL_PRODUCT_SHORT_NAME% Express. 

ADDCURRENTUSERASSQLADMIN="False"

; Specify 0 to disable or 1 to enable the TCP/IP protocol. 

TCPENABLED="1"

; Specify 0 to disable or 1 to enable the Named Pipes protocol. 

NPENABLED="0"

; Startup type for Browser Service. 

BROWSERSVCSTARTUPTYPE="Disabled"

Overall summary:
  Final result:                  Passed
  Exit code (Decimal):           0
  Start time:                    2016-01-22 02:25:42
  End time:                      2016-01-22 02:29:50
  Requested action:              Install
Machine Properties:
Machine name: M-SQL1
Machine processor count: 1
OS version: Windows Server 2012
OS service pack:
OS region: United States
OS language: English (United States)
OS architecture: x64
Process architecture: 32 Bit
OS clustered: No

Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered Configured

Package properties:
Description: Microsoft SQL Server 2014
ProductName: SQL Server 2014
Type: RTM
Version: 12
Installation location: D:\x86\setup\
Installation edition: Evaluation

Slipstream: True
SP Level 1

Product Update Status:
Success: KB 3058865

Product Updates Selected for Installation:
Title: Microsoft SQL Server 2014 with SP1
Knowledge Based Article: KB 3058865
Version: 12.1.4100.0
Architecture: x86
Language: 1033

Update Source: Slipstream

User Input Settings:
ACTION: Install
ADDCURRENTUSERASSQLADMIN: false
AGTSVCACCOUNT: MonsterBean\sqladmin
AGTSVCPASSWORD: *****
AGTSVCSTARTUPTYPE: Automatic
ASBACKUPDIR: Backup
ASCOLLATION: Latin1_General_CI_AS
ASCONFIGDIR: Config
ASDATADIR: Data
ASLOGDIR: Log
ASPROVIDERMSOLAP: 1
ASSERVERMODE: MULTIDIMENSIONAL
ASSVCACCOUNT: <empty>
ASSVCPASSWORD: <empty>
ASSVCSTARTUPTYPE: Automatic
ASSYSADMINACCOUNTS: <empty>
ASTEMPDIR: Temp
BROWSERSVCSTARTUPTYPE: Disabled
CLTCTLRNAME: <empty>
CLTRESULTDIR: <empty>
CLTSTARTUPTYPE: 0
CLTSVCACCOUNT: <empty>
CLTSVCPASSWORD: <empty>
CLTWORKINGDIR: <empty>
COMMFABRICENCRYPTION: 0
COMMFABRICNETWORKLEVEL: 0
COMMFABRICPORT: 0
CONFIGURATIONFILE: C:\Program Files (x86)\Microsoft SQL Server\120\Setup Bootstrap\Log\20160122_022542\ConfigurationFile.ini
CTLRSTARTUPTYPE: 0
CTLRSVCACCOUNT: <empty>
CTLRSVCPASSWORD: <empty>
CTLRUSERS: <empty>
ENABLERANU: false
ENU: true
ERRORREPORTING: false
FEATURES: SQLENGINE, BOL, SSMS, ADV_SSMS
FILESTREAMLEVEL: 0
FILESTREAMSHARENAME: <empty>
FTSVCACCOUNT: <empty>
FTSVCPASSWORD: <empty>
HELP: false
IACCEPTSQLSERVERLICENSETERMS: false
INDICATEPROGRESS: false
INSTALLSHAREDDIR: C:\Program Files\Microsoft SQL Server
INSTALLSHAREDWOWDIR: C:\Program Files (x86)\Microsoft SQL Server\
INSTALLSQLDATADIR: <empty>
INSTANCEDIR: C:\Program Files (x86)\Microsoft SQL Server
INSTANCEID: MSSQLSERVER
INSTANCENAME: MSSQLSERVER
ISSVCACCOUNT: NT AUTHORITY\Network Service
ISSVCPASSWORD: <empty>
ISSVCSTARTUPTYPE: Automatic
MATRIXCMBRICKCOMMPORT: 0
MATRIXCMSERVERNAME: <empty>
MATRIXNAME: <empty>
NPENABLED: 0
PID: *****
QUIET: false
QUIETSIMPLE: true
ROLE:
RSINSTALLMODE: DefaultNativeMode
RSSHPINSTALLMODE: DefaultSharePointMode
RSSVCACCOUNT: <empty>
RSSVCPASSWORD: <empty>
RSSVCSTARTUPTYPE: Automatic
SAPWD: <empty>
SECURITYMODE: <empty>
SQLBACKUPDIR: <empty>
SQLCOLLATION: SQL_Latin1_General_CP1_CI_AS
SQLSVCACCOUNT: MonsterBean\sqladmin
SQLSVCPASSWORD: *****
SQLSVCSTARTUPTYPE: Automatic
SQLSYSADMINACCOUNTS: MonsterBean\administrator
SQLTEMPDBDIR: <empty>
SQLTEMPDBLOGDIR: <empty>
SQLUSERDBDIR: <empty>
SQLUSERDBLOGDIR: <empty>
SQMREPORTING: false
TCPENABLED: 1
UIMODE: Normal
UpdateEnabled: true
UpdateSource: Slipstream
USEMICROSOFTUPDATE: false
X86: true

Configuration file: C:\Program Files (x86)\Microsoft SQL Server\120\Setup Bootstrap\Log\20160122_022542\ConfigurationFile.ini

Detailed results:
Feature: Management Tools - Complete
Status: Passed

Feature: Management Tools - Basic
Status: Passed

Feature: Database Engine Services
Status: Passed

Feature: SQL Browser
Status: Passed

Feature: Documentation Components
Status: Passed

Feature: SQL Writer
Status: Passed

Feature: SQL Client Connectivity
Status: Passed

Feature: SQL Client Connectivity SDK
Status: Passed

Feature: Setup Support Files
Status: Passed

Rules with failures:

Global rules:

Scenario specific rules:

Rules report file: C:\Program Files (x86)\Microsoft SQL Server\120\Setup Bootstrap\Log\20160122_022542\SystemConfigurationCheck_Report.htm