设置和部署 - SQL Server Express 2008 R2 [英] Setup and Deployment - SQL Server Express 2008 R2

问题描述

我的安装和部署项目存在问题。



我创建了一个桌面应用程序和一个安装文件。我创建了一个设置和deplyoment项目，并添加了SQL Express R2作为先决条件。我需要创建一个名为Galaxy的新实例





场景1：

如果没有安装了其他SQL Server，设置顺利完成。







场景2：

如果存在任何其他SQL安装，则安装失败，因为它尝试升级它。



但是我不希望在这种情况下进行升级，而是我想要一个名为Galaxy的实例的2008 R2新安装。



场景3：

Express R2安装存在。 银河实例不存在。我想创建一个新的Galaxy实例。





如何通过包文件或任何其他解决方案实现这一目标？如果实例已经存在，我想继续进行设置。如何删除操作=升级逻辑？



！ - 定义新安装（x86） - >

命令包文件=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>



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

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



！ - 定义升级安装（x86） - >

命令PackageFile =SQLEXPR32_x86_ENU.EXE

Arguments =/ q / hideconsole / action = Upgrade / instancename = GALAXY / SECURITYMODE = SQL / SAPWD = mypassword / skiprules = RebootRequiredCheck / IAcceptSQLServerLicenseTerms

EstimatedInstalledB ytes =225000000

EstimatedInstallSeconds =420>

解决方案

您好binoyjose，



您既没有在任何地方指定您的问题，也没有提供任何错误。所以，我会假设您的问题是进行上述安装。



我有类似的工作，但我还没有完成它。所以，如果你没有机会通过这个，那么请抓住链接（此处 [ ^ ]）



希望它可以帮到你。



迟来的新年快乐......！



问候，

Vamsi

Vamsi，



非常感谢您的帮助。



我的问题主要是设置和部署。



当我使用安装文件进行安装时，SQL Server Express R2是一个先决条件，一切正常如果是新安装。



但是如果已经安装了SQL Server 2005或2008，则SQL Server安装会尝试升级它而不是新安装我的GALAXY实例。 （我可以看到该命令用于通过日志文件升级）



如果有2005版本，​​我如何告诉SQL Server只安装新版本？

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">

解决方案

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

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?

这篇关于设置和部署 - SQL Server Express 2008 R2的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！