因是安装SQL Server 2000的机器上的CPU数(核心数)必须是2的幂,即248163264 . . .
而双路6核服务器是12个核心,不是2的幂,因此报错。
 
SQL Server 2005也会面临同样的问题。
 
解决办法: –T3601 -T3603 参数来避免SMT检查,具体操作方法有两种,如下:
信息来源:blogs.msdn/sqlserverfaq/archive/2009/05/27/info-sql-2000-msde-installation-will-fail-if-you-have-number-of-cpus-on-a-box-which-is-not-in-power-of-2.aspx
决议
METHOD 1:
方法1:
Start the installation in debug mode from command prompt by browsing to the location and using the following command:
在开始安装调试模式从命令提示符浏览地点的和使用下列命令:
<Installation media path& k=dbg
安装媒体路径> < k = dbg
In case of SP4 installation :
SP4安装:
Start the installation of SP4 in debug mode from command prompt by browsing to the location and using the following command:
在开始安装调试模式从SP4命令提示符浏览地点的和使用下列命令:
<Installation media path& k=dbg
安装媒体路径> < k = dbg
sql server 2000是一种
Note: When you run setup in debug mode, the setup will prompt you for user action to proceed on each step. Only when you click “OK” will it continue. This is exactly what we want to do. We are pausing setup at the configuration step, while we add the following trace flags in the registry and then continuing.
注意:当你运行安装在调试模式,为用户安装将促使你行动继续每一个步骤。只有当你点击“OK”会继续下去。这正是我们想要做的事。我们暂停设定在配置步骤,而我们加入下面微量旗帜在注册表中,然后继续。
Before configuring the server go ahead and added the trace flag –T3601 & -T3603 in the registry by following the below steps:
配置服务器之前,先走一步,添加微量国旗在注册表中-T3601-T3603遵循下面的步骤:
1) Use trace flags 3601 and 3603 while the setup would be going on. Trace flags 3601 and 3603 can be tried to avoid SMT checks and bypass problematic code which checks the number of processors.
1)使用微量旗帜3601年和3603年将会在安装。3601年和3603年微量旗帜可以试图避免SMT检查代码,绕过问题检查处理器数目。
2) Open regedit. Browse to the following location (for named instance, refer method #2 for key location)
2)多谢开放。浏览下列位置(命名为实例,参考方法关键位置)2
x86 servers: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Parameters\
服务器:HKEY_LOCAL_MACHINE \软件x86 \ Microsoft MSSQLServer \ \ \ \参数MSSQLServer
X64 servers: HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432node\Microsoft\MSSQLServer\MSSQLServer\Parameters\
服务器:HKEY_LOCAL_MACHINE \软件看\ WOW6432node \ Microsoft MSSQLServer \ \ \ \参数MSSQLServer
3) Then add the following String Values (REG_SZ):
3),然后加入下面的字符串值(REG_SZ):
"SQLArg3". Set the value to "-T3601" (without the double-quotes)
“SQLArg3”。将此值设置为“-T3601”(没有double-quotes)
"SQLArg4". Set the value to "-T3603” (without the double-quotes)
“SQLArg4”。将此值设置为“-T3603”(没有double-quotes)
4) Then, go back to the setup screen and click OK to continue with the sp4 installation.
4)然后,回到设置屏幕,点击OK继续sp4安装。

版权声明:本站内容均来自互联网,仅供演示用,请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198,我们将在24小时内删除。