CMD command to install sql server 2005 express edition via command prompt (silent install)

Question

How to install sql server 2005 express edition via command prompt (silent install). Further the installed instance should be accessible via lan

instance name: test username : sa password : admin123

Can you plz generate the required script for it. Thanks in advance.

Here is my script: start /wait C:\SQLSERVER2005\SQLEXPR32.EXE /qb username="CustomerUsername" companyname="OurCompany" addlocal=ALL disablenetworkprotocols="0" instancename="MSSQLSERVER" SECURITYMODE="SQL" SAPWD="cyborg" But when I connect it using cmd it does not connect — HotTester

Aseem Gautam Aseem Gautam · Accepted Answer · 2010-02-11T07:49:41

Script can be found here:

How to: Install SQL Server 2005 from the Command Prompt

Start /wait <CD or DVD Drive>\servers\setup.exe /qb INSTANCENAME=<InstanceName> 
ADDLOCAL=All PIDKEY=<pidkey value with no "-"> SAPWD=<StrongPassword> 
SQLACCOUNT=<domain\user> SQLPASSWORD=<DomainUserPassword> AGTACCOUNT=<domain\user> 
AGTPASSWORD=<DomainUserPassword> SQLBROWSERACCOUNT=<domain\user> 
SQLBROWSERPASSWORD=<DomainUserPassword>

CMD command to install sql server 2005 express edition via command prompt (silent install)

1 Answers