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
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 **
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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 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" |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 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 |