SQL SERVER 2008群集另个一个节点在安装到“正在运行 Windows Installer 之后的配置计算操作时”就卡在这里不动了

Question

操作系统是Window server 2008 Enterprise 64 位 & SQL SERVER 2008 Enterprise 64位，SQL SERVER 2008群集另个一个节点在安装到“正在运行 Windows Installer 之后的配置计算操作时”  & “SQL_DTS_VSTAConfiguration_install_Cpu64 ”就卡在这里不动了，如下图：

Answer 1

Did you check installation log files?

Answer 2

我应该看哪个文件夹下面的那个日志文件，安装现在一直卡在哪里，也没有抛出错误信息，谢谢！

Answer 3

如下是detail文件中最后的日志：

2012-08-14 10:17:49 Slp: SetSecurityDescriptor: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib, appending
2012-08-14 10:17:49 SSIS: Done setting permision on registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib.
2012-08-14 10:17:49 SSIS: Done processing Registry ACLs for SID 'S-1-5-21-1587408110-1480745695-4223875051-1003'
2012-08-14 10:17:49 SSIS: SetRegistryValues() start
2012-08-14 10:17:49 SSIS: Setting 'LogPackageExecutionToEventLog' to 1
2012-08-14 10:17:49 SSIS: Setting values for both 32bit and 64bit runtimes
2012-08-14 10:17:49 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
2012-08-14 10:17:49 Slp: Sco: Attempting to open registry subkey
2012-08-14 10:17:49 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\100\SSIS
2012-08-14 10:17:49 Slp: Sco: Attempting to set value LogPackageExecutionToEventLog
2012-08-14 10:17:49 Slp: SetValue: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\SSIS, Name = LogPackageExecutionToEventLog
2012-08-14 10:17:49 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
2012-08-14 10:17:49 Slp: Sco: Attempting to open registry subkey
2012-08-14 10:17:49 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\100\SSIS
2012-08-14 10:17:49 Slp: Sco: Attempting to set value LogPackageExecutionToEventLog
2012-08-14 10:17:49 Slp: SetValue: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\SSIS, Name = LogPackageExecutionToEventLog
2012-08-14 10:17:49 SSIS: SetRegistryValues() done
2012-08-14 10:17:49 SSIS: STATUS: Install_ConfigNonRC completed
2012-08-14 10:17:49 SSIS: SSIS_Config: Install Timing: ConfigNonRC completed
2012-08-14 10:17:49 Slp: SlpConfigAction.ExecuteAction(actionId: SSISConfigAction_install_postmsi_Cpu64) completed
2012-08-14 10:17:49 Slp: Checkpoint: INSTALL:CONFIGNONRC:SQL_DTS_FULL
2012-08-14 10:17:49 Slp: Completed Action: SSISConfigAction_install_postmsi_Cpu64, returned True
2012-08-14 10:17:49 Slp: ---- Flush datastore cache before calling configuration action 'SQL_DTS_VSTAConfiguration_install_Cpu64'
2012-08-14 10:17:49 Slp: ---- Flush datastore cache before calling configuration action 'SQL_DTS_VSTAConfiguration_install_Cpu64'
2012-08-14 10:17:49 Slp: ----------------------------------------------------------------------
2012-08-14 10:17:49 Slp: Running Action: SQL_DTS_VSTAConfiguration_install_Cpu64
2012-08-14 10:17:49 Slp: Action Data:
2012-08-14 10:17:49 Slp:   Feature = SQL_DTS_Full_sql_is_Cpu64
2012-08-14 10:17:49 Slp:   Scenario = install
2012-08-14 10:17:49 Slp:   Timing = ConfigNonRC
2012-08-14 10:17:49 Slp:   ConfigObjectType = Microsoft.SqlServer.Configuration.SSIS.VSTAConfigurationPrivate
2012-08-14 10:17:49 Slp:   FeatureName = SQL_DTS_Full
2012-08-14 10:17:49 Slp:   FeatureCpuType = Cpu64
2012-08-14 10:17:49 Slp:   FeaturePackageId = sql_is
2012-08-14 10:17:49 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
2012-08-14 10:17:49 Slp: Sco: Attempting to open registry subkey
2012-08-14 10:17:49 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\NET Framework Setup\NDP\v3.5
2012-08-14 10:17:49 Slp: Sco: Attempting to get registry value InstallPath
2012-08-14 10:17:49 SSIS: Running: c:\Windows\Microsoft.NET\Framework\v3.5\AddInUtil.exe -PipelineRoot:"C:\Program Files (x86)\Common Files\microsoft shared\VSTA\Pipeline" -Rebuild
2012-08-14 10:17:49 SSIS: Application succeded: c:\Windows\Microsoft.NET\Framework\v3.5\AddInUtil.exe -PipelineRoot:"C:\Program Files (x86)\Common Files\microsoft shared\VSTA\Pipeline" -Rebuild
2012-08-14 10:17:49 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
2012-08-14 10:17:49 Slp: Sco: Attempting to open registry subkey
2012-08-14 10:17:49 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\VSTA\9.0
2012-08-14 10:17:49 Slp: Sco: Attempting to get registry value InstallDir
2012-08-14 10:17:49 SSIS: Running: C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\vsta.exe /hostid SSIS_ScriptTask /setup

Answer 4

Did you see any failure in other log files under same folder?

Answer 5

在这个文件夹下面没有文件或文件名包含“Failed" 或者是”Error"的文件，在上一级的Log文件夹下面也没有，现在的安装程序还是卡在哪里没有动！

Answer 6

Does task manager show it in running status?

Answer 7

是的，在任务管理器中还是显示运行的：

如下图

Answer 8

Cpu time is always 0? Does memory usage change? If no change on both, may try kill it then retry.

Answer 9

两者都是0，我重装了也是卡在这里，然后又重装操作系统，还是卡在这里！

Answer 10

Are those VM machines? How did you setup cluster?

Answer 11

不是虚拟机，是IBM的服务器，我是做两个节点的SQL server 群集，第一个节点安装已经成功，在装第二个节点的时候出现上面的这个错误，找不到原因，没法解决！

Answer 12

是不是CPU 配置有关系。

先启用一个CPU 试试。http://support.microsoft.com/kb/954835/en-us

Good Luck

Answer 13

还是不行啊！

Answer 14

Hi, 是否可以提供一下你的服务器的CPU数量，如果总线程数超过32个，会有这个问题，这是.net 2.0本身存在的一个bug，在.net4.0才会被修复。
当安装停滞不动时，可以在进程中看到两个名称一样的安装进程，需要停掉一个，安装才可以继续。
如果确定是这个问题，再说其它解决方法。

Answer 15

I installed sql2k8 on win2k8 r2 cluster that has 128 processors on each node, no issue at all.

Answer 16

我也在相同的这两台服务器上安装过 sql2k8 r2 on win2k8 r2 ,也没有出错此错误问题，还有一点想说明一下，其中一台服务器安装是成功的，只是有一台有问题而已，

所以也觉得奇怪，但是通过禁用CPU数量确实是安装成功了，

多谢各位的帮助！