Installing SQL Express Silent with Defaults

[marketware]

Can anyone give me a simple example of how to install SQL Express silently where all of the installation defaults are selected and there is no user interface beyond a progress bar?

Thanks!!

bob

[KrisVanherck]

You can do this through command line arguments, the agruments depend on version though.

here is an example for SQL express:

SQLEXPRWT_x86_ENU.exe ACTION="Install" INSTANCEID=TEST INSTANCENAME="TEST" /QS /SECURITYMODE=SQL /SAPWD=password /NPENABLED=1 /TCPENABLED=1 /FEATURES=SQLENGINE,REPLICATION,SSMS,SNAC_SDK /ISSVCACCOUNT="NT AUTHORITY\NetworkService" /SQLCOLLATION="Latin1_General_CI_AS" /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" /ADDCURRENTUSERASSQLADMIN="True"

MSDN Article: "How to: Install SQL Server 2008 from the Command Prompt"
http://msdn.microsoft.com/en-us/library/ms144259.aspx

[marketware]

Totally cool. Thanks!