How to install SQL express automatic. OR Silent installation of SQL Express.

For installing the SQL server or SQL express automatically base on single click you have to run command in command prompt with some parameter given below

Command Syntax : 

<Setup Path> /QS /ACTION=Install /FEATURES=SQL /INSTANCENAME=<Instance Name> /SQLSVCACCOUNT=<DomainName\Username> /SQLSVCPASSWORD=<PC Password> /SQLSYSADMINACCOUNTS=<DomainName\Username> /AGTSVCACCOUNT="NT AUTHORITYNetwork Service" /SECURITYMODE="SQL" /SAPWD=<SQL Password for Sa>
Example : E:\Software\FV\SqlExpress2008\SQLEXPR_x64_ENU.EXE /QS /ACTION=Install /FEATURES=SQL /INSTANCENAME=SQLEXPRESS2008 /SQLSVCACCOUNT="nirav" /SQLSVCPASSWORD="n123456" /SQLSYSADMINACCOUNTS="nirav" /AGTSVCACCOUNT="NT AUTHORITYNetwork Service" /SECURITYMODE="SQL" /SAPWD="123456"

 

 Parameters :

a.  /QS :=   This will display installation wizard but not gives any type of control for change.

b.  /FEATURES=SQL  This will say that install all the feature of SQL express.

c.  /INSTANCENAME  := here you have to give any SQL instance name .

d.  /SQLSVCACCOUNT := here you have to pass your computer user name

e.  /SQLSVCPASSWORD := here you have top write you computer password for above mention              account

f.  /SQLSYSADMINACCOUNTS : here you have to pass your computer username.

g. /SECURITYMODE=”SQL”  := here you you wan to set password for "sa" user the put this                 parameter with values “SQL”

h. /SAPWD := here you have to write password for the SQL Express "Sa" account .