Setup and Deployment - SQL Server Express 2008 R2

Question

0.00/5 (No votes)

See more:

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

binoyjose

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

RelicV · Answer 1 · 2013-01-06T00:25:00

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

Posted 6-Jan-13 0:25am

RelicV

Comments

Thomas Daniels 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?

binoyjose · Answer 2 · 2013-01-06T03:38:00

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?