//
you're reading...
Uncategorized

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.

.Net Framework 3.5 Feature is required

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

Generating SQL ConfigurationFile

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.

Advertisements

Discussion

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: