Downloads the installer for SQL Server 2014 Express Edition Service Pack 1 With Tools.

Package Specifics

The package uses default installation options for SQL Express. It will also install .NET Framework 3.5 (if necessary) which is required for this package.

Package Parameters

The following optional package parameters can be set (defaults will be used if no parameters are set):

• '/INSTANCEID' - specifies the SQL instance ID (default is SQLEXPRESS)
• '/INSTANCENAME' - specifies the SQL instance name (default is SQLEXPRESS)
• '/SECURITYMODE' - specifies the SQL security mode (SQL), if this parameter is not supplied, then Windows-only authentication mode is supported.
• '/SAPWD' - specifies the password for the SQL Server 'sa' account (required when /SECURITYMODE=SQL and ignored otherwise)
• '/SQLSYSADMINACCOUNTS' - specifies the logins to be members of the 'sysadmin' role
• '/SQLSVCACCOUNT' - specifies the startup account for the SQL service
• '/SQLSVCPASSWORD' - specifies the password for the 'SQLSVCACCOUNT'
• '/SQLCOLLATION' - specifies the collation settings for SQL server. For more information see "https://msdn.microsoft.com/library/ms143508(v=sql.105).aspx"
• '/SQLSVCSTARTUPTYPE' - specifies the SQL Server service statup type - Automatic, Disabled or Manual (default is 'Automatic')
• '/BROWSERSVCSTARTUPTYPE' - specifies the SQL Server Browser service startup mode - Automatic, Disabled or Manual (default is 'Manual')

NOTE: The current user is ALWAYS added to the SQL Server 'sysadmin' fixed server role regardless of the /SECURITYMODE parameter.

These parameters can be passed to the installer with the use of '-params'. For example: -params '"/INSTANCEID:SQLEXPRESS /INSTANCENAME:SQLEXPRESS2014"'

The default SQL Server Express 2014 installation parameters are (when no package parameters are specified):
"/Q /IAcceptSQLServerLicenseTerms /ACTION=install /UPDATEENABLED /TCPENABLED=1 /NPENABLED=1 /SQLSVCSTARTUPTYPE=Automatic /INSTANCEID=SQLEXPRESS /INSTANCENAME=SQLEXPRESS"

Refer to "https://msdn.microsoft.com/en-us/library/ms144259(v=sql.120).aspx" for further information with regards to the 'Installation Parameters'.