creating a new instacnce

Hi I'm tyring to redistribute SQL Express edition with my product.

I'm using installShiald 12 to create my install using the using the Redistributable
wizard

I'm trying to install a new instance of of SQL Server that will be used only by my
product.

When i'm install the SQL server on a clean computer (without SQL Server) i have
no problem, but when i'm installing SQL server on a computer wich all ready have
SQL server installed on it I get a massage :

"Name: Microsoft SQL Server 2005 Express Edition (ISHAY)
Allowed Action: Maintain (Action is only available from Add or Remove Programs)
Reason: Cannot maintain product, to maintain the product go to Add or Remove
Programs".

If using the '/qn' flag I get an error code returned from SQL server install.

but the install did create a new instance by the name "ishay".

how can i prevent this from happening?

the commmand line u use is:

"UPGRADE=SQL_Engine INSTANCENAME=ishay
SQLBROWSERAUTOSTART=1 SQLACCOUNT="NT AUTHORITY\SYSTEM"
SKIPUPGRADEBLOCKERS=1".

thank ishay

The reason you are seeing this is because you are using the UPGRADE parameter on your command line, which attempts to upgrade an existing instance on the machine. Switch that to ADDLOCAL and you will then install a new instance (named ishay) on the machine regardless of whether there are existing SQL instances on the machine already.

Thanks,
Sam Lester (MSFT)