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

  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 **

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

Share This