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"
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.
h. /SAPWD := here you have to write password for the SQL Express "Sa" account .
0 comments:
Post a Comment
Thanks for comment