SQL Server 2014 – Creating ConfigurationFile.ini

This post will show to create and configure your SQL ConfigurationFile.ini for unattended installation or deployment(s).

Download  SQL Server 2014 at http://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2014

For this exercise, I’am using Windows Server Technical Preview: http://www.microsoft.com/en-us/evalcenter/evaluate-windows-server-technical-preview and make sure that the .Net Framework 3.5 Feature is installed.

Run the setup.exe file and go through the normal installation process.

You can then fetch the ConfigurationFile.ini from  path shown when you reach the Ready to Install screen. Open the .ini file to do some editing on it, then close the SQL Server 2014 Setup Wizard by clicking the Cancel button. In my case, I am installing SQL Server 2014 for System Center Technical Preview Operations Manager so below is my Configurationfile which can also be download here: http://1drv.ms/13koQkt

;SQL Server 2014 Configuration File
[OPTIONS]
ACTION=”Install”
ENU=”True”
QUIET=”False”
QUIETSIMPLE=”True”
UpdateEnabled=”True”
ERRORREPORTING=”False”
USEMICROSOFTUPDATE=”False”
FEATURES=SQLENGINE,FULLTEXT,DQ,RS,SSMS,ADV_SSMS
UpdateSource=”MU”
HELP=”False”
INDICATEPROGRESS=”False”
X86=”False”
INSTALLSHAREDDIR=”C:\Program Files\Microsoft SQL Server”
INSTALLSHAREDWOWDIR=”C:\Program Files (x86)\Microsoft SQL Server”
INSTANCENAME=”MSSQLSERVER”
SQMREPORTING=”False”
INSTANCEID=”MSSQLSERVER”
RSINSTALLMODE=”DefaultNativeMode”
INSTANCEDIR=”C:\Program Files\Microsoft SQL Server”
AGTSVCACCOUNT=”YourDomain\sqlsvc”
AGTSVCPASSWORD=”Password Here”
AGTSVCSTARTUPTYPE=”Automatic”
COMMFABRICPORT=”0″
COMMFABRICNETWORKLEVEL=”0″
COMMFABRICENCRYPTION=”0″
MATRIXCMBRICKCOMMPORT=”0″
SQLSVCSTARTUPTYPE=”Automatic”
FILESTREAMLEVEL=”0″
ENABLERANU=”False”
SQLCOLLATION=”SQL_Latin1_General_CP1_CI_AS”
SQLSVCACCOUNT=”YourDomain\sqlsvc”
SQLSVCPASSWORD=”Password”
SQLSYSADMINACCOUNTS=”YourDomain\Administrator” “BUILTIN\Administrators”
ADDCURRENTUSERASSQLADMIN=”False”
TCPENABLED=”1″
NPENABLED=”0″
BROWSERSVCSTARTUPTYPE=”Disabled”
RSSVCACCOUNT=”YourDomain\sqlsvc”
RSSVCPASSWORD=”Password”
RSSVCSTARTUPTYPE=”Automatic”
IACCEPTSQLSERVERLICENSETERMS=”True”
FTSVCACCOUNT=”NT Service\MSSQLFDLauncher”

To do an unattended installation of  SQL Server 2014 here’s a sample syntax: Setup.exe /ConfigurationFile=ConfigurationFile.INI or to specify service account passwords at the command prompt instead of in the configuration file: Setup.exe /SQLSVCPASSWORD=”passwordhere” /AGTSVCPASSWORD=”passwordhere” /ASSVCPASSWORD=”passwordhere” /ISSVCPASSWORD=”passwordhere” /RSSVCPASSWORD=”passwordhere” /ConfigurationFile=ConfigurationFile.INI.

For more information about SQL 2014 Config file and unattended installation go to Install SQL Server 2014 Using a Configuration File and Install SQL Server 2014 from the Command Prompt.