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 2	Import-Module ServerManager Install-WindowsFeature NET-Framework-Features

Go through the normal SQL 2014 setup process to select what are the SQL components to be installed and Stop at “Ready To Install”

Get the configuration file from

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

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

Go to D:\ (Where SQL 2014 ISO File located), and enter the following command in PowerShell **

.\setup /configurationfile="c:\temp\configurationfile.ini" /IACCEPTSQLSERVERLICENSETERMS

1	.\setup /configurationfile="c:\temp\configurationfile.ini" /IACCEPTSQLSERVERLICENSETERMS

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

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

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. 

<span style="color: #ff0000;">;UIMODE="Normal"</span>

; Setup will not display any user interface. 

QUIET="False"

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

<span style="color: #ff0000;">QUIETSIMPLE="True"</span>

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

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

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

<span style="color: #ff0000;">;UIMODE="Normal"</span>

; Setup will not display any user interface.

QUIET="False"

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

<span style="color: #ff0000;">QUIETSIMPLE="True"</span>

; 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

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

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

Related Posts