Setup and Deployment - SQL Server Express 2008 R2

See more:

SQL

server

setup

deployment

I have an issue with setup and deployment project.

I have created a desktop application and and a setup file. I created a setup&deplyoment project and added SQL Express R2 as a prerequisite. I need to create a new Instance called "Galaxy"


Scenario 1:
When there is no other SQL Server installed, the setup completes smoothly.



Scenario 2:
If any other SQL installation exists, the setup fails because it tries to upgrade it.

However I dont want an upgrade in this scenario, instead I would like a new installation of 2008 R2 with instance named "Galaxy".

Scenario 3:
Express R2 Installation exists. "Galaxy" Instance doesnt exist. I want to create a new Galaxy Instance.


How can I achieve this through the package file or any other solution? I want to proceed with the setup if the instance already exists. How can I remove the action=Upgrade logic?

!-- Defines a new installation (x86) -->
Command PackageFile="SQLEXPR32_x86_ENU.EXE"
Arguments='/q /hideconsole /action=Install /features=SQL /instancename=GALAXY /SECURITYMODE=SQL /SAPWD=mypassword /enableranu=1 /sqlsvcaccount="NT Authority\Network Service" /AddCurrentUserAsSqlAdmin /skiprules=RebootRequiredCheck /IAcceptSQLServerLicenseTerms'
EstimatedInstalledBytes="225000000"
EstimatedInstallSeconds="420">

......................
......................

!-- Defines an upgrade installation (x86) -->
Command PackageFile="SQLEXPR32_x86_ENU.EXE"
Arguments="/q /hideconsole /action=Upgrade /instancename=GALAXY /SECURITYMODE=SQL /SAPWD=mypassword /skiprules=RebootRequiredCheck /IAcceptSQLServerLicenseTerms"
EstimatedInstalledBytes="225000000"
EstimatedInstallSeconds="420">