将 SQL Server 2005 Express 升级到 Standard
我直接安装了带有命名实例 (SENSE) 和单个数据库 (sense) 的 SQL Server 2005 Express，我希望在其上执行到 2005 标准版的就地升级。
不使用命令行参数运行会导致先决条件检查页面上出现警告，指出要执行升级，我需要使用 SKUUPGRADE=1 从命令行启动。
当我执行此操作时，会出现警告，并且升级检查会通过，但我在任何阶段都不会看到实例选择屏幕（我希望是这样 - 它会询问我是否要创建新实例或升级）现有的），随后组件选择屏幕缺少服务器组件。
少量的谷歌搜索建议采用以下策略：
start /wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=SENSE UPGRADE=SQL_Engine SKUUPGRADE=1 /qb
这会产生错误“指定的功能对于此版本的 SQL Server 无效” - 我被困住了。先生们，有什么好主意吗？谢谢大家。
I have a straightforward installation of SQL Server 2005 Express with a named instance (SENSE), and a single database (sense), on which I wish to perform an in-place upgrade to 2005 Standard Edition.
Running without command line parameters results in a warning on the pre-requisites check page saying that to perform an upgrade I need to start from the command line using SKUUPGRADE=1.
When I do this, the warning goes, and the upgrade check passes, but at no stage am I presented with the instance selection screen (which I would expect to be - the one where it asks if I want to create a new instance or upgrade an existing one), and subsequently the component selection screen is missing server components.
A modicum of googling suggests the following tact:
start /wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=SENSE UPGRADE=SQL_Engine SKUUPGRADE=1 /qb
Which produces the error "The feature(s) specified are not valid for this edition of SQL Server" - and there I am stuck. Any great ideas, gentlemen? Thank you all.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
您是否将其安装在 Windows Web Server 版本上？我想我在尝试升级时遇到了这个问题。可能有一些技巧可以解决这个问题，但我通过重新安装服务器来艰难而漫长地完成了它。
Are you installing this on a Windows Web Server edition? I think I got that problem when I tried to upgrade it. Might be some trick to solve it, but I did it the hard and long way by reinstalling the server.
对于任何碰巧通过 google 搜索到此问题的人来说，解决方案是 SQL Server 2005 标准版的光盘 1 是客户端工具 - 这就是为什么我们没有看到任何安装服务器的选项元素。第二张光盘包含这些内容。问题解决了。
随后，我们发现 Server 2005（没有服务包）无法与处理器核心数量不是 2 的幂的系统很好地配合。服务就崩溃了。因此，在安装之前，必须使用 msconfig 中的引导选项将 CPU 关联性强制设置为 1，然后应用最新的服务包，然后恢复正确的 CPU 计数。
The solution, as it turns out for anyone who should happen to google across this, is that Disc 1 of the SQL Server 2005 Standard Edition is client tools - this is why we werent seeing any option to install server elements. Disc two contains these. Problem solved.
Subsequently, it transpires that server 2005 (without service packs) does not play nice with systems featuring a number of processor cores that is not a power of two. The service just crashes. Because of this, prior to the installation it is necessary to force the CPU affinity to 1 using the boot options in msconfig, then apply the newest service pack, then restore the correct CPU count.