I have a Windows 2000 that crashed and was part of a active/active SQL cluster (SQL 2000).

Instead of reinstall the box with Windows 2000, I reinstalled it with Windows 2003 Advanced.

In Cluster Administrator (on the Windows 2003 box), I am trying to add the node, and I always get the following error:

- sql1: The list of nodes to configure is empty.
- Error 0x800713ac: A cluster node is not available for this operation.

here's the content of the log:

2004-04-02 13:34:10.084 [INFO] [CConnPointEnum::HrAddConnection] punk 0x0cd808 added to the connection point enumerator. (hr=00000000)
2004-04-02 13:34:10.214 [INFO] [CConnPointEnum::HrAddConnection] punk 0x0ce2f8 added to the connection point enumerator. (hr=00000000)
2004-04-02 13:34:25.195 [INFO] [WIZ] Setting analyze page active. Setting aborted to FALSE.
2004-04-02 13:34:25.336 [INFO] [MT] [CTaskAnalyzeClusterBase] Beginning task...
2004-04-02 13:34:25.446 [INFO] CLUSTER2: Checking for an existing cluster... (hr=00000000, {FDC75680-7DBB-42CA-8003-E4CDB01FF062},
{B8453B8F-92FD-4350-A6D9-551FD018B791}, 0, 90, 0), (null)
2004-04-02 13:34:25.556 [INFO] [CTaskAnalyzeClusterBase] Setting completion cookie 4 at array index 0 into the gather cluster information
task for node CLUSTER2.shop.clic.net
2004-04-02 13:34:25.656 [INFO] [MT] The name to connect to is 'CLUSTER2'.
2004-04-02 13:34:25.736 [INFO] [MT] Requesting a remote connection to 'CLUSTER2'.
2004-04-02 13:34:25.846 [INFO] CLUSTER2: The DNS record for "CLUSTER2.shop.clic.net" is "192.168.0.233". (hr=00000000,
{B8453B8F-92FD-4350-A6D9-551FD018B791}, {D86FAAD9-2514-451E-B359-435AF35E6038}, 1, 1, 1), (null)
2004-04-02 13:34:25.937 [INFO] sql1: Requesting a remote connection to "CLUSTER2" in domain "shop.clic.net" with binding string
"192.168.0.233" (hr=00000000, {B8453B8F-92FD-4350-A6D9-551FD018B791}, {26015CA7-EAE1-43F4-AC1E-718D80629E93}, 1, 1, 1), (null)
2004-04-02 13:34:26.067 [INFO] [MT] Connection to 'CLUSTER2' with binding string '192.168.0.233' failed because one or more classes are not
registered.
2004-04-02 13:34:26.187 [INFO] CLUSTER2: The DNS record for "CLUSTER2.shop.clic.net" is "192.168.0.233". (hr=00000000,
{B8453B8F-92FD-4350-A6D9-551FD018B791}, {D86FAAD9-2514-451E-B359-435AF35E6038}, 1, 1, 1), (null)
2004-04-02 13:34:26.427 [INFO] [MT:CTaskAnalyzeClusterBase] Looking for the completion cookie 1.
2004-04-02 13:34:26.537 [INFO] [MT:CTaskAnalyzeClusterBase] Looking for the completion cookie 4.
2004-04-02 13:34:26.628 [INFO] [CTaskAnalyzeClusterBase] Clearing completion cookie 4 at array index 0
2004-04-02 13:34:26.658 [INFO] CLUSTER2: (null) (hr=00000000, {FDC75680-7DBB-42CA-8003-E4CDB01FF062},
{B8453B8F-92FD-4350-A6D9-551FD018B791}, 0, 90, 1), (null)
2004-04-02 13:34:26.718 [INFO] [MT] [CTaskGatherClusterInfo] exiting task. The task was not cancelled.
2004-04-02 13:34:26.808 [INFO] CLUSTER2: (null) (hr=00000000, {FDC75680-7DBB-42CA-8003-E4CDB01FF062},
{B8453B8F-92FD-4350-A6D9-551FD018B791}, 0, 90, 2), (null)
2004-04-02 13:34:26.988 [INFO] [MT] Adding node 'SQL1.shop.clic.net' to the list of user-added nodes.
2004-04-02 13:34:27.128 [INFO] CLUSTER2: Collecting nodes currently in the cluster... (hr=00000000, {EBC8AEFF-10C3-4D5B-AC17-FC0F4C3871B7},
{72A04E74-2D14-4AD8-8E12-4AFBA56FD0E0}, 0, 1, 0), (null)
2004-04-02 13:34:27.389 [INFO] [MT] Connecting to cluster node 'SQL2.shop.clic.net'
2004-04-02 13:34:27.519 [INFO] CLUSTER2: Collecting nodes currently in the cluster... (hr=00000000, {EBC8AEFF-10C3-4D5B-AC17-FC0F4C3871B7},
{72A04E74-2D14-4AD8-8E12-4AFBA56FD0E0}, 0, 1, 1), (null)
2004-04-02 13:34:27.649 [INFO] CLUSTER2: (null) (hr=00000000, {FDC75680-7DBB-42CA-8003-E4CDB01FF062},
{B8453B8F-92FD-4350-A6D9-551FD018B791}, 0, 90, 90), (null)
2004-04-02 13:34:27.789 [INFO] sql1: (null) (hr=00000000, {FDC75680-7DBB-42CA-8003-E4CDB01FF062}, {93C32F99-39CA-4D38-9D7F-2707CA0EAF46}, 0,
90, 0), (null)
2004-04-02 13:34:27.919 [INFO] CLUSTER2: (null) (hr=00000000, {FDC75680-7DBB-42CA-8003-E4CDB01FF062},
{CC5E57B1-4520-4672-B4BA-A288EC42946E}, 0, 90, 0), (null)
2004-04-02 13:34:28.050 [INFO] [CTaskAnalyzeClusterBase] Setting completion cookie 6 at array index 0 into the gather node information task
for node SQL1.shop.clic.net
2004-04-02 13:34:28.190 [INFO] [CTaskAnalyzeClusterBase] Setting completion cookie 7 at array index 1 into the gather node information task
for node SQL2.shop.clic.net
2004-04-02 13:34:28.190 [INFO] SQL1: Connecting to server... (hr=00000000, {93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
{E88B08DD-2460-4DF1-B5C2-28587DD164EA}, 0, 1, 0), (null)
2004-04-02 13:34:28.320 [INFO] SQL2: Connecting to server... (hr=00000000, {93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
{E88B08DD-2460-4DF1-B5C2-28587DD164EA}, 0, 1, 0), (null)
2004-04-02 13:34:28.460 [INFO] [MT] The name to connect to is 'SQL1'.
2004-04-02 13:34:28.590 [INFO] [MT] The name to connect to is 'SQL2'.
2004-04-02 13:34:28.721 [INFO] [MT] Requesting a local connection to 'SQL1'.
2004-04-02 13:34:28.851 [INFO] [MT] Requesting a remote connection to 'SQL2'.
2004-04-02 13:34:29.061 [WARN] sql1: This node is already a member of a cluster, but the cluster service is not running. This node will not
be configured at this time. (hr=0x000001, {93C32F99-39CA-4D38-9D7F-2707CA0EAF46}, {8028BF97-2D57-4628-845D-C4BEFFEB531A}, 1, 1, 1), The
cluster service on this node is configured but is not currently running. This node will be skipped and no further tasks will be performed on
it. If this node is not supposed to be a member of any cluster, then clean it up using the "cluster node /forcecleanup" command and try
again.
2004-04-02 13:34:29.131 [INFO] SQL2: The DNS record for "SQL2.shop.clic.net" is "192.168.0.242". (hr=00000000,
{93C32F99-39CA-4D38-9D7F-2707CA0EAF46}, {D86FAAD9-2514-451E-B359-435AF35E6038}, 1, 1, 1), (null)
2004-04-02 13:34:29.271 [WARN] sql1: This node is already a member of a cluster, but the cluster service is not running. This node will not
be configured at this time. (hr=0x000001, {93C32F99-39CA-4D38-9D7F-2707CA0EAF46}, {8028BF97-2D57-4628-845D-C4BEFFEB531A}, 1, 1, 1), The
cluster service on this node is configured but is not currently running. This node will be skipped and no further tasks will be performed on
it. If this node is not supposed to be a member of any cluster, then clean it up using the "cluster node /forcecleanup" command and try
again.
2004-04-02 13:34:29.402 [INFO] sql1: Requesting remote connections... (hr=00000000, {93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
{1B606398-7193-4A48-AFBD-98AC8BACB690}, 1, 1, 1), (null)
2004-04-02 13:34:29.542 [INFO] [SRV] The cluster service is down on this node.
2004-04-02 13:34:29.672 [INFO] sql1: Requesting a remote connection to "SQL2" in domain "shop.clic.net" with binding string "192.168.0.242"
(hr=00000000, {1B606398-7193-4A48-AFBD-98AC8BACB690}, {7DCE2976-3E89-4683-8980-B41130CBABD9}, 1, 1, 1), (null)
2004-04-02 13:34:29.812 [INFO] [SRV] CClusCfgClusterInfo::Initialize() returning (hr=0x0713ba)
2004-04-02 13:34:29.962 [INFO] [MT] Connection to 'SQL2' with binding string '192.168.0.242' failed because one or more classes are not
registered.
2004-04-02 13:34:30.093 [WARN] sql1: GetClusterConfigInfo() completed. (hr=0x0713ba, {05AA0768-5F49-49CD-AFDC-96F9D51802D4},
{B460EA73-6223-44FA-84E0-DE7EC069DDD4}, 1, 1, 1), (null)
2004-04-02 13:34:30.253 [INFO] SQL2: The DNS record for "SQL2.shop.clic.net" is "192.168.0.242". (hr=00000000,
{93C32F99-39CA-4D38-9D7F-2707CA0EAF46}, {D86FAAD9-2514-451E-B359-435AF35E6038}, 1, 1, 1), (null)
2004-04-02 13:34:30.403 [WARN] sql1: The cluster configuration server has been started. (hr=0x0713ba,
{93C32F99-39CA-4D38-9D7F-2707CA0EAF46}, {39371CBA-A47B-4A4F-9042-6BECD321E9E2}, 1, 1, 1), (null)
2004-04-02 13:34:30.613 [INFO] [MT:CTaskAnalyzeClusterBase] Looking for the completion cookie 5.
2004-04-02 13:34:30.663 [WARN] sql1: The cluster configuration server has been started. (hr=0x0713ba,
{93C32F99-39CA-4D38-9D7F-2707CA0EAF46}, {39371CBA-A47B-4A4F-9042-6BECD321E9E2}, 1, 1, 1), (null)
2004-04-02 13:34:30.804 [INFO] SQL2: (null) (hr=00000000, {93C32F99-39CA-4D38-9D7F-2707CA0EAF46}, {E88B08DD-2460-4DF1-B5C2-28587DD164EA}, 0,
1, 1), (null)
2004-04-02 13:34:30.964 [INFO] [MT] The cluster service on node 'SQL1' is down.
2004-04-02 13:34:31.084 [INFO] [MT:CTaskAnalyzeClusterBase] Looking for the completion cookie 7.
2004-04-02 13:34:31.244 [WARN] SQL1: (null) (hr=0x0713ba, {93C32F99-39CA-4D38-9D7F-2707CA0EAF46}, {E88B08DD-2460-4DF1-B5C2-28587DD164EA}, 0,
1, 1), (null)
2004-04-02 13:34:31.414 [INFO] [CTaskAnalyzeClusterBase] Clearing completion cookie 7 at array index 1
2004-04-02 13:34:31.545 [INFO] [MT:CTaskAnalyzeClusterBase] Looking for the completion cookie 6.
2004-04-02 13:34:31.675 [INFO] [MT] [CTaskGatherNodeInfo] exiting task. The task was not cancelled.
2004-04-02 13:34:31.805 [INFO] [CTaskAnalyzeClusterBase] Clearing completion cookie 6 at array index 0
2004-04-02 13:34:32.075 [INFO] sql1: (null) (hr=00000000, {FDC75680-7DBB-42CA-8003-E4CDB01FF062}, {93C32F99-39CA-4D38-9D7F-2707CA0EAF46}, 0,
90, 1), (null)
2004-04-02 13:34:32.075 [INFO] [MT] [CTaskGatherNodeInfo] exiting task. The task was not cancelled.
2004-04-02 13:34:32.216 [ERR ] sql1: The list of nodes to configure is empty. (hr=0x800713ac, {93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
{A678963B-9173-4393-B21B-0B4337B28EE2}, 1, 1, 1), (null)
2004-04-02 13:34:32.486 [INFO] CLUSTER2: (null) (hr=00000000, {FDC75680-7DBB-42CA-8003-E4CDB01FF062},
{CC5E57B1-4520-4672-B4BA-A288EC42946E}, 0, 90, 90), (null)
2004-04-02 13:34:32.626 [INFO] [MT] [CTaskAnalyzeClusterBase] Exiting task. The task was not cancelled.

SQL1 is the Windows 2003 box newly installed and SQL2 is the old Windows 2000 box.

Can anyone see anything wrong?

Thanks in advance.

Paul

My Cluster Service does not want to start on SQL1. Event Viewer says:

Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7031
Date: 4/2/2004
Time: 1:39:12 PM
User: N/A
Computer: SQL1
Description:
The Cluster Service service terminated unexpectedly. It has done this 4 time(s). The following corrective action will be taken in 480000
milliseconds: Restart the service.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


What do you suggest?

Paul

Paul,

As the log indicates try adding the new node (SQL1) after cleaning it up
using the "cluster node /forcecleanup" command.

2004-04-02 13:34:29.061 [WARN] sql1: This node is already a member of a
cluster, but the cluster service is not running. This node will not
be configured at this time. (hr=0x000001,
{93C32F99-39CA-4D38-9D7F-2707CA0EAF46},
{8028BF97-2D57-4628-845D-C4BEFFEB531A}, 1, 1, 1), The
cluster service on this node is configured but is not currently running.
This node will be skipped and no further tasks will be performed on
it. If this node is not supposed to be a member of any cluster, then clean
it up using the "cluster node /forcecleanup" command and try
again.

Hope this helps.

--
Regards,
Shon Shah
Software Test Engineer
Microsoft Cluster Server

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples, if any, are subject to the terms specified
at http://www.microsoft.com/info/cpyright.htm

"Paul Dube" <pdube (AT) clic (DOT) net> wrote

{93C32F99-39CA-4D38-9D7F-2707CA0EAF46}, 0,
{8028BF97-2D57-4628-845D-C4BEFFEB531A}, 1, 1, 1), The
{8028BF97-2D57-4628-845D-C4BEFFEB531A}, 1, 1, 1), The
{E88B08DD-2460-4DF1-B5C2-28587DD164EA}, 0,
{E88B08DD-2460-4DF1-B5C2-28587DD164EA}, 0,
{93C32F99-39CA-4D38-9D7F-2707CA0EAF46}, 0,

Great! It works 8-).

Thanks!

Paul

On Fri, 2 Apr 2004 10:48:52 -0800, "Shon Shah [MSFT]" <shonsh (AT) online (DOT) microsoft.com> wrote:

You must evict the node from the cluster before joining it
back in.

HTH

Bjorn
will be taken in 480000