Microsoft KB Archive/318672

= BUG: Error message when you try to set up a SQL Server 2000 virtual server on multiple nodes: &quot;Setup failed to perform the required operation on the cluster nodes&quot; =

Article ID: 318672

Article Last Modified on 3/18/2006

-

APPLIES TO


 * Microsoft SQL Server 2000 Enterprise Edition

-



This article was previously published under Q318672



BUG #: 236113 (SHILOH_BUGS)



SYMPTOMS
A Microsoft SQL Server 2000 virtual server set up on multiple nodes may fail with this error message:

Setup failed to perform the required operation on the cluster nodes

The Sqlstp.log file will also contain the following error messages.

NOTE: The Sqlstp.log file is located in the %WINDIR% folder of the node from which you run the Virtual Server Setup program.

CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 0

CThreadPool::RunUntilCompleteHlpr signaled thread [0xa4]

Thread [0xa4] exit code: [0x0]

CRemoteProcess::RunUntilComplete [0xa8] exit code: 2

Remote process exit code was '2' (NODE2).

....

....

CThreadPool::RunUntilComplete returned 2

CThreadPool::RunUntilComplete execution level=1, need execution: 0

One or more errors occurred while running the remote/unattended setups.

In the preceding error message, identify the remote node that has a remote process exit code of 2. In the preceding example, the remote node is NODE2. On the remote node, open the Sqlstpn.log file located in the %WINDIR% folder, and look for this error message:

13:50:08 Begin Action: ShowDlgInstanceName

13:50:20 End Action: ShowDlgInstanceName

13:50:20 ShowDlgInstanceName returned : -1

13:50:20 ShowDlgInstanceName: GetLastError returned: 50044

13:50:20 End Action DialogShowSdInstanceName

13:50:20 End Action ShowDialogs

13:50:20 Action CleanUpInstall:

13:50:20 StatsGenerate returned: 2

13:50:20 StatsGenerate (0x0,0x1,0xf00000,0x200,1033,0,0x0,0x1000000a,0,0,0

13:50:20 StatsGenerate -1,cluster)

13:50:20 Installation Failed.

NOTE: You may receive the error message

Setup failed to perform the required operation on the cluster nodes

for causes other than the one described in this article. The only way to confirm if the error message is caused by the problem described in this article is to check the SQL Server setup logs and to compare the error footprint.



CAUSE
A race condition between the Setup program that is running on the first node (the node on which the Virtual Server set up is initiated) and the Setup programs that are running remotely on the other nodes.

The SQL Server 2000 Virtual Server set up involves a main set up process that starts one unattended installation for every node that is part of the virtual server. If the number of the unattended installations is two, or more, the race condition may occur.



WORKAROUND

 * 1) Install a single node virtual server by running the Setup program on any node of the cluster. For more information, see the &quot;How to install a one-node failover cluster (Setup)&quot; topic in SQL Server 2000 Books Online.
 * 2) Add the second node to the virtual server by running the Setup program again on the node you used in step 1. For more information, see the &quot;How to add nodes to an existing virtual server (Setup)&quot; topic in SQL Server 2000 Books Online.
 * 3) Repeat step 2 for any number of nodes that you want to add to the virtual server.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: cluster install fails 50044

Keywords: kberrmsg kbtshoot kbbug kbpending KB318672

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.