I'm trying to install SQL Server 2005 Express SP3 on two of my machines. When I try to do this I get this error message: "None of the selected features can be installed or upgraded. Setup cannot proceed since no effective change is being made to the machine. To continue, click Back and then select features to install." And of course it won't let me go any further. When I get to the "Existing components" screen (which is before the error message), the only item that's listed is "SQL Server Database Services 9.2.3042.00" and it's grayed out (can't be checked). I'm assuming this is the "none of the selected features" it's talking about in the error message.
我正在尝试在我的两台机器上安装SQL Server 2005 Express SP3。当我尝试这样做时,我收到以下错误消息:“无法安装或升级所选功能。由于未对计算机进行任何有效更改,因此无法继续安装。要继续,请单击上一步,然后选择要安装的功能。 “当然,它不会让我继续前进。当我到达“现有组件”屏幕(在错误消息之前)时,列出的唯一项目是“SQL Server数据库服务9.2.3042.00”并且它显示为灰色(无法检查)。我假设这是在错误消息中讨论的“没有选定的功能”。
I tried this on two different computers, both running Windows Server 2003. Both also have MSDE (SQL server 2000), not sure if this matters. The reported SQL 2005 version is 9.0.3068 for both machines. The link I used to download the service pack is:
我在两台运行Windows Server 2003的不同计算机上试过这个。两者都有MSDE(SQL server 2000),不确定这是否重要。两台计算机报告的SQL 2005版本均为9.0.3068。我用来下载服务包的链接是:
Any ideas? Thanks.
有任何想法吗?谢谢。
EDIT:
If I click on details, this is what I get:
如果我点击详细信息,这就是我得到的:
Name: Microsoft SQL Server 2005 (SQLEXPRESS) Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
名称:Microsoft SQL Server 2005(SQLEXPRESS)原因:您的升级已被阻止。有关升级支持的详细信息,请参阅SQL Server 2005安装帮助或SQL Server 2005联机丛书中的“版本和版本升级”和“硬件和软件要求”主题。
Edition check: Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
版本检查:由于版本升级规则,您的升级被阻止。有关版本升级的详细信息,请参阅SQL Server 2005安装帮助或SQL Server 2005联机丛书中的版本和版本升级主题。
2 个解决方案
#1
It's probably trying to upgrade the MSDE instances. Are they default instances? - this is not what you want (but for others' sake, if it was what you wanted, you would run d:\setup.exe SKUUPGRADE=1).
它可能正在尝试升级MSDE实例。它们是默认实例吗? - 这不是你想要的(但是为了别人的缘故,如果它是你想要的,你将运行d:\ setup.exe SKUUPGRADE = 1)。
I suggest using the INSTANCENAME command line argument to setup to specify that you want the 2005 server upgraded. Check out some of the examples on:
我建议使用INSTANCENAME命令行参数进行设置,以指定您希望升级2005服务器。查看以下一些示例:
http://msdn.microsoft.com/en-us/library/ms403393(SQL.90).aspx
-Oisin
#2
The solution, in my case, was to use this installation package instead:
在我的例子中,解决方案是使用此安装包:
#1
It's probably trying to upgrade the MSDE instances. Are they default instances? - this is not what you want (but for others' sake, if it was what you wanted, you would run d:\setup.exe SKUUPGRADE=1).
它可能正在尝试升级MSDE实例。它们是默认实例吗? - 这不是你想要的(但是为了别人的缘故,如果它是你想要的,你将运行d:\ setup.exe SKUUPGRADE = 1)。
I suggest using the INSTANCENAME command line argument to setup to specify that you want the 2005 server upgraded. Check out some of the examples on:
我建议使用INSTANCENAME命令行参数进行设置,以指定您希望升级2005服务器。查看以下一些示例:
http://msdn.microsoft.com/en-us/library/ms403393(SQL.90).aspx
-Oisin
#2
The solution, in my case, was to use this installation package instead:
在我的例子中,解决方案是使用此安装包: