SQLServer – unattended installation

I didn’t quite get to the end of doing this as YouTube video, so for now a summary:

Provided you have a correctly configured ConfigurationFile.ini, whose purpose is to supply all the required configuration points for a SQLServer installation (works for 2008,2012,2014, with minor differences), then you can execute a command line very similar to this, and after about 30 minutes, you have a full SQLServer installation (plus RS, IS, etc, depending on what you have included in the config file):

SqlSilentInstall05

setup.exe /configurationfile=”c:\scratch\ConfigurationFile2014.ini”

This is the configuration file content I used to achieve this:

;SQL Server 2014 Configuration File
[OPTIONS]

IACCEPTSQLSERVERLICENSETERMS="True"

ACTION="Install"

ROLE="AllFeatures_WithDefaults"

ENU="True"

QUIET="True"

QUIETSIMPLE="False"

UpdateEnabled="True"

ERRORREPORTING="False"

USEMICROSOFTUPDATE="False"

FEATURES=SQLENGINE,REPLICATION,FULLTEXT,DQ,RS,DQC,CONN,IS,BC,SDK,BOL,SSMS,ADV_SSMS,SNAC_SDK,MDS

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="FilesOnlyMode"

INSTANCEDIR="C:\Program Files\Microsoft SQL Server"

AGTSVCACCOUNT="NT Service\SQLSERVERAGENT"

AGTSVCSTARTUPTYPE="Manual"

ISSVCSTARTUPTYPE="Automatic"

ISSVCACCOUNT="NT Service\MsDtsServer120"

COMMFABRICPORT="0"

COMMFABRICNETWORKLEVEL="0"

COMMFABRICENCRYPTION="0"

MATRIXCMBRICKCOMMPORT="0"

SQLSVCSTARTUPTYPE="Automatic"

FILESTREAMLEVEL="0"

ENABLERANU="False"

SQLCOLLATION="SQL_Latin1_General_CP1_CI_AI"

SQLSVCACCOUNT="NT Service\MSSQLSERVER"

SQLSYSADMINACCOUNTS="NT AUTHORITY\SYSTEM"

SECURITYMODE="SQL"
SAPWD="Jones789"

ADDCURRENTUSERASSQLADMIN="False"

TCPENABLED="1"

NPENABLED="0"

BROWSERSVCSTARTUPTYPE="Disabled"

RSSVCACCOUNT="NT Service\ReportServer"

RSSVCSTARTUPTYPE="Automatic"

This msdn link gives meaning to the options:
https://msdn.microsoft.com/en-us/library/ms144259.aspx
on Windows 2012, this also requires Windows .net 3.5 framework to be installed

Advertisements

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