Forum Discussion

rajmuthusamy's avatar
rajmuthusamy
Copper Contributor
Jan 17, 2020

2019 Express Silent Install

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

  • vassilis-MSFT's avatar
    vassilis-MSFT
    Learn Expert
    Jan 18, 2020

    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

Resources