2019 Express Silent Install

[rajmuthusamy]

I'm trying to do a quiet install of the 2019 Express edition. Downloaded the installation application (SQL2019-SSEI-Expr.exe) and created a configuration file with the following parameters.

[OPTIONS]

ACTION="INSTALL"

ENU=True

QUIET=True

INDICATEPROGRESS=False

FEATURES=SQLENGINE

INSTANCENAME="SQLEXPRESS"

INSTANCEID="SQLEXPRESS"

SQLSVCSTARTUPTYPE="Automatic"

IACCEPTSQLSERVERLICENSETERMS=True

SQLSVCACCOUNT="NT ServiceMSSQL$SQLEXPRESS"

BROWSERSVCSTARTUPTYPE="Automatic"

ADDCURRENTUSERASSQLADMIN=True

TCPENABLED=1

SECURITYMODE="SQL"

SAPWD="MYPASSWORD"

SQLCOLLATION="SQL_Latin1_General_CP1_CI_AS"

ASCOLLATION="SQL_Latin1_General_CP1_CI_AS"

From the command prompt, running this command

SQL2019-SSEI-Expr.exe /ConfigurationFile="sql2019settings.ini"

I expect the 2019 express edition install without any user interface. But it keeps displaying the "Select an installation type" screen with three options (Basic, Custom & Download Media) to select. Attached this screen. I need to install with no user interface. 

Anyone solved this and ran the install silently from the command prompt? Any help would be appreciated.

Thanks

[#2]

Hi @rajmuthusamy ,

 this is because this is just an installer, not the actual installation file. You can use the installer to download the actual installation file namely "SQLEXPR_x64_ENU.exe". Then you can run this which extracts the files in a folder you specify. In there you can find the actual SETUP.EXE for the installation of SQL Server 2019 Express.

HTH

Vassilis