Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
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">
Posted 5-Jan-13 7:28am
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Hi binoyjose,
 
You have neither specified your issue any where nor provided any errors also. So, I'll assume that your issue is to do the above installation.
 
I have a similar work related to this, but I'm yet to work on it. So, if you have not had a chance to go through this, then please take a stab at the link (here[^])
 
Hope it helps you.
 
Belated Happy New year...!
 
Regards,
Vamsi
  Permalink  
Comments
ProgramFOX at 6-Jan-13 10:17am
   
Comment from the OP, posted as a non-answer:
Vamsi,

Thanks a lot for the help.

My issue is mostly with the setup and deployment.

When I install using the setup file, where the SQL Server Express R2 is a prerequisit, everything works fine if it is a new installation.

But if there is already an installation of SQL Server 2005 or 2008 exist, the SQL Server Installation tries to Upgrade it instead of New installation of my GALAXY instance. (I can see the command is for Upgrade through log file)

How do I tell SQL Server to only install new even if there is a 2005 version?
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

Vamsi,
 
Thanks a lot for the help.
 
My issue is mostly with the setup and deployment.
 
When I install using the setup file, where the SQL Server Express R2 is a prerequisit, everything works fine if it is a new installation.
 
But if there is already an installation of SQL Server 2005 or 2008 exist, the SQL Server Installation tries to Upgrade it instead of New installation of my GALAXY instance. (I can see the command is for Upgrade through log file)
 
How do I tell SQL Server to only install new even if there is a 2005 version?
  Permalink  
Comments
ProgramFOX at 6-Jan-13 10:17am
   
If you've a comment to an answer, click on the "Have a Question or Comment?" button, but please don't post a comment as an answer.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Maciej Los 590
1 OriginalGriff 535
2 CPallini 285
3 Peter Leow 185
4 RyanDev 161
0 OriginalGriff 5,784
1 Sergey Alexandrovich Kryukov 4,838
2 Peter Leow 3,009
3 Maciej Los 2,894
4 DamithSL 2,465


Advertise | Privacy | Mobile
Web03 | 2.8.140721.1 | Last Updated 6 Jan 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100