I have asked a similar question previously but it was never resolved so here I am again!
我之前问了一个类似的问题,但它从未解决过,所以我又来了!
I have an unattended installation of SQL Server 2005 that works great when installing SQL Server on a machine that does not have it already installed.
我有无人参与的SQL Server 2005安装,在没有安装SQL Server的计算机上安装SQL Server时效果很好。
I use the following parameters when I perform the installation (this is installed automatically via Inno Setup):
我在执行安装时使用以下参数(通过Inno Setup自动安装):
#define SQL_SILENT "/passive /qb"
#define SQL_USERNAME "username=MyUserName"
#define SQL_COMPANYNAME "companyname=MyCompanyName"
#define SQL_ADDLOCAL "ADDLOCAL=SQL_Engine"
#define SQL_UPGRADE ""
#define SQL_DISABLENETWORKPROTOCOLS "disablenetworkprotocols=0"
#define SQL_INSTANCENAME "instancename=MYSQLINSTANCE"
#define SQL_SQLAUTOSTART "SQLAUTOSTART=1"
#define SQL_SECURITYMODE "SECURITYMODE=SQL"
#define SQL_SAPWD "SAPWD=StrongPassword"
#define SQL_SQLACCOUNT "SQLACCOUNT="""""
#define SQL_SQLPASSWORD "SQLPASSWORD="""""
It installs the instance of SQL Server Express without a problem. However, when I attempt to install SQL Server on a machine that already has another instance with workstation components I get the following error:
它安装SQL Server Express的实例没有问题。但是,当我尝试在已经有另一个带有工作站组件的实例的计算机上安装SQL Server时,我收到以下错误:
"A component that you have specified in the ADD_LOCAL property is already installed. To upgrade the existing component, refer to the template.ini and set the UPGRADE property to the name of the component."
“已经安装了在ADD_LOCAL属性中指定的组件。要升级现有组件,请参阅template.ini并将UPGRADE属性设置为组件的名称。”
I have also tried using the UPGRADE method as per the error message
我也尝试使用UPGRADE方法根据错误消息
#define SQL_UPGRADE "UPGRADE=SQL_Engine INSTANCENAME=MYSQLINSTANCE"
but get the following error:
但得到以下错误:
"SQL Server Setup cannot perform the upgrade because the component is not installed on the computer. To proceed, verify the component to be upgraded in currently installed, and that the component to be upgraded is specified in the ADDLOCAL property."
“SQL Server安装程序无法执行升级,因为计算机上未安装该组件。要继续,请在当前安装的位置验证要升级的组件,并在ADDLOCAL属性中指定要升级的组件。”
I can manually remove the workstation components from Add/Remove programs (Program and Features in Vista) and the installation works fine but this is not something I want to manually do everytime. Especially if this is being installed on a PC that makes use of these components.
我可以从添加/删除程序(Vista中的程序和功能)手动删除工作站组件,安装工作正常,但这不是我想要每次手动执行的操作。特别是如果将其安装在使用这些组件的PC上。
I would be very grateful for any advise on how I can stop this error from being displayed during the unattended install.
我非常感谢有关如何在无人参与安装期间阻止显示此错误的任何建议。
Thank you
1 个解决方案
#1
To fix the above problem I had to make sure components and tools un-installed first.
要解决上述问题,我必须先确保卸载组件和工具。
However, this is no longer relevant as I will be installing SQL Server 2008 which I am sure will have many more problems!
但是,这不再相关,因为我将安装SQL Server 2008,我相信它会有更多问题!
#1
To fix the above problem I had to make sure components and tools un-installed first.
要解决上述问题,我必须先确保卸载组件和工具。
However, this is no longer relevant as I will be installing SQL Server 2008 which I am sure will have many more problems!
但是,这不再相关,因为我将安装SQL Server 2008,我相信它会有更多问题!