views:

166

answers:

2

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.

A: 

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>
Aseem Gautam
well this is the documentation from msdn... but frankly this is not working ! The instance cannot be accessed... have u tried this yourself?
HotTester
I have not tried it.. but since its from Microsoft this should work.What instance name did you provide?.
Aseem Gautam
A: 

I finally got the accurate script that installs the sql-server 2005 express edition the link of which is this

What i was getting wrong was that the remote connections was set for local connections only.

HotTester