Install new instance...

[Matthew Wells]

Can anyone please tell me a simple command line statement to install a new
instance of sql 2k5? I've tried

<path>\setup.ext instancename=MyInstance

I've seen examples on microsoft's site, but when I try them I get Invalid
Switch errors.

Thanks.
--
Matthew.Wells
Ma***********@FirstByte.net

[Plamen Ratchev]

What options did you try and what error was reported? The following article
has description of the command line options that need to be provided:
http://msdn.microsoft.com/en-us/library/ms144259.aspx

Here is a copy/paste for the options for new instance with all options:
Start /wait <CD or DVD Drive>\servers\setup.exe /qb
INSTANCENAME=<InstanceNameADDLOCAL=All PIDKEY=<pidkey value with no "-">
SAPWD=<StrongPasswordSQLACCOUNT=<domain\user>
SQLPASSWORD=<DomainUserPasswordAGTACCOUNT=<domain\ user>
AGTPASSWORD=<DomainUserPasswordSQLBROWSERACCOUNT=< domain\user>
SQLBROWSERPASSWORD=<DomainUserPassword>

I find it easier to use an INI file with the /settings switch. The above
article describes how to do that, and on the SQL Server installation media
there is a template.ini file (I believe under both the Server and the Tools
folders). Here is one post that describes this approach:
http://www.haidongji.com/2006/02/05/...r-2005-part-4/

HTH,

Plamen Ratchev
http://www.SQLStudio.com