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@.clic.net> wrote in message
news:4dcr6016mhj94s2cvet4hqhjvblhgf72fp@.4ax.com...
> 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
|||Great! It works 8-).
Thanks!
Paul
On Fri, 2 Apr 2004 10:48:52 -0800, "Shon Shah [MSFT]" <shonsh@.online.microsoft.com> wrote:
>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.
|||You must evict the node from the cluster before joining it
back in.
HTH
Bjorn
>--Original Message--
>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
>.
>
Showing posts with label active. Show all posts
Showing posts with label active. Show all posts
Monday, March 26, 2012
Friday, March 23, 2012
Installing a local instance of SQL on a Cluster Node
Hi
I have an Active/Passive SQL 2000 Cluster - the OS is W3K Server.
I would like to install a local copy of SQL Server on the node that is
currently passive - if I start the SQL install process, it does give me
this option but I don't know what, if any, problems this might cause.
I appreciate if the currently active node fails, it will failover to
the node which also has a local version running as well.
Has anyone done this? I've tried searching groups and Microsoft without
success.
Thanks
Toby
It's OK to install local instances on cluster nodes. Just make sure the
instance name does not conflict with any instance on the cluster.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
<tjbeaumont@.gmail.com> wrote in message
news:1160036955.164570.322690@.i3g2000cwc.googlegro ups.com...
Hi
I have an Active/Passive SQL 2000 Cluster - the OS is W3K Server.
I would like to install a local copy of SQL Server on the node that is
currently passive - if I start the SQL install process, it does give me
this option but I don't know what, if any, problems this might cause.
I appreciate if the currently active node fails, it will failover to
the node which also has a local version running as well.
Has anyone done this? I've tried searching groups and Microsoft without
success.
Thanks
Toby
|||<tjbeaumont@.gmail.com> wrote in message
news:1160036955.164570.322690@.i3g2000cwc.googlegro ups.com...
> Hi
> I have an Active/Passive SQL 2000 Cluster - the OS is W3K Server.
> I would like to install a local copy of SQL Server on the node that is
> currently passive - if I start the SQL install process, it does give me
> this option but I don't know what, if any, problems this might cause.
Yes, you can do it, but it is a violation of the HA spirit. Meaning, why in
the world would you want to screw around and do that when the company has
obviously felt that the other SQL instances (in the cluster) require HA?
Don't mess with the HA environment!
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp
|||That's true for production clusters. But we install standalone SQL instances
on a clustered node all the time on our test clusters.
Linchi
"Russ Kaufmann" wrote:
> <tjbeaumont@.gmail.com> wrote in message
> news:1160036955.164570.322690@.i3g2000cwc.googlegro ups.com...
> Yes, you can do it, but it is a violation of the HA spirit. Meaning, why in
> the world would you want to screw around and do that when the company has
> obviously felt that the other SQL instances (in the cluster) require HA?
> Don't mess with the HA environment!
>
> --
> Russ Kaufmann
> MVP - Windows Server - Clustering
> ClusterHelp.com, a Microsoft Certified Gold Partner
> Web http://www.clusterhelp.com
> Blog http://msmvps.com/clusterhelp
>
>
|||"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:6B70403B-35CF-4773-9160-8FFC9DDC8638@.microsoft.com...
> That's true for production clusters. But we install standalone SQL
> instances
> on a clustered node all the time on our test clusters.
So, your test environment doesn't mirror production?
Actually, I can see doing that.
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp
I have an Active/Passive SQL 2000 Cluster - the OS is W3K Server.
I would like to install a local copy of SQL Server on the node that is
currently passive - if I start the SQL install process, it does give me
this option but I don't know what, if any, problems this might cause.
I appreciate if the currently active node fails, it will failover to
the node which also has a local version running as well.
Has anyone done this? I've tried searching groups and Microsoft without
success.
Thanks
Toby
It's OK to install local instances on cluster nodes. Just make sure the
instance name does not conflict with any instance on the cluster.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
<tjbeaumont@.gmail.com> wrote in message
news:1160036955.164570.322690@.i3g2000cwc.googlegro ups.com...
Hi
I have an Active/Passive SQL 2000 Cluster - the OS is W3K Server.
I would like to install a local copy of SQL Server on the node that is
currently passive - if I start the SQL install process, it does give me
this option but I don't know what, if any, problems this might cause.
I appreciate if the currently active node fails, it will failover to
the node which also has a local version running as well.
Has anyone done this? I've tried searching groups and Microsoft without
success.
Thanks
Toby
|||<tjbeaumont@.gmail.com> wrote in message
news:1160036955.164570.322690@.i3g2000cwc.googlegro ups.com...
> Hi
> I have an Active/Passive SQL 2000 Cluster - the OS is W3K Server.
> I would like to install a local copy of SQL Server on the node that is
> currently passive - if I start the SQL install process, it does give me
> this option but I don't know what, if any, problems this might cause.
Yes, you can do it, but it is a violation of the HA spirit. Meaning, why in
the world would you want to screw around and do that when the company has
obviously felt that the other SQL instances (in the cluster) require HA?
Don't mess with the HA environment!
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp
|||That's true for production clusters. But we install standalone SQL instances
on a clustered node all the time on our test clusters.
Linchi
"Russ Kaufmann" wrote:
> <tjbeaumont@.gmail.com> wrote in message
> news:1160036955.164570.322690@.i3g2000cwc.googlegro ups.com...
> Yes, you can do it, but it is a violation of the HA spirit. Meaning, why in
> the world would you want to screw around and do that when the company has
> obviously felt that the other SQL instances (in the cluster) require HA?
> Don't mess with the HA environment!
>
> --
> Russ Kaufmann
> MVP - Windows Server - Clustering
> ClusterHelp.com, a Microsoft Certified Gold Partner
> Web http://www.clusterhelp.com
> Blog http://msmvps.com/clusterhelp
>
>
|||"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:6B70403B-35CF-4773-9160-8FFC9DDC8638@.microsoft.com...
> That's true for production clusters. But we install standalone SQL
> instances
> on a clustered node all the time on our test clusters.
So, your test environment doesn't mirror production?
Actually, I can see doing that.
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp
Installing A Failover Cluster
I have two matched servers, one will be Active and one will be Passive.
The servers have Windows 2000 Advanced Server and I have SQL Server 2000
Enterprise Edition.
My question is, do I also need a box called a Shared Disk Array, or can I
use another server I currently have that has lots of disk space on it?
Correction: I have Windows 2000 Advanced Server
"Vincel2k2" wrote:
> I have two matched servers, one will be Active and one will be Passive.
> The servers have Windows 2000 Advanced Server and I have SQL Server 2000
> Enterprise Edition.
> My question is, do I also need a box called a Shared Disk Array, or can I
> use another server I currently have that has lots of disk space on it?
>
|||You will indeed need shared storage.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"Vincel2k2" <Vincel2k2@.discussions.microsoft.com> wrote in message
news:FF446D59-A73C-43EA-9EC2-4B9D03CFD51B@.microsoft.com...[vbcol=seagreen]
> Correction: I have Windows 2000 Advanced Server
> "Vincel2k2" wrote:
|||Hi
You need to get your self a Storage Area Network (SAN) to store your data
on.
For clustering, make sure that your hardware is on the Windows Hardware
Compatibility List (HCL)
Read the documentation on
http://www.microsoft.com/windowsserv...g/default.mspx
to get an understanding.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Vincel2k2" <Vincel2k2@.discussions.microsoft.com> wrote in message
news:FF446D59-A73C-43EA-9EC2-4B9D03CFD51B@.microsoft.com...[vbcol=seagreen]
> Correction: I have Windows 2000 Advanced Server
> "Vincel2k2" wrote:
I[vbcol=seagreen]
|||I also have two matched servers with Win2003EntSrv that I would like to
install an active/passive failover cluster of Yukon on. Since this is a lab
environment and I don't have the $$ for a SAN, will it work with a Network
Storage HD? I realize the performance won't be great, but I'm looking for
the experience in how to build/configure the environment.
Any tips?
An alternative question for the lab environment is ... how would you do this
in two VPC? Or would you steer clear?
Thanks
Al
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> You need to get your self a Storage Area Network (SAN) to store your data
> on.
> For clustering, make sure that your hardware is on the Windows Hardware
> Compatibility List (HCL)
> Read the documentation on
> http://www.microsoft.com/windowsserv...g/default.mspx
> to get an understanding.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Vincel2k2" <Vincel2k2@.discussions.microsoft.com> wrote in message
> news:FF446D59-A73C-43EA-9EC2-4B9D03CFD51B@.microsoft.com...
> I
>
>
|||Virtual Server 2005 will work nicely for this test. See
http://www.hands-on-labs.com/microsoft.asp?ID=4477 for the steps
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"al_stark_born" <al_stark_born@.discussions.microsoft.com> wrote in message
news:E579B181-45E6-4DF2-8BCA-E7F1D2DD44C7@.microsoft.com...[vbcol=seagreen]
>I also have two matched servers with Win2003EntSrv that I would like to
> install an active/passive failover cluster of Yukon on. Since this is a
> lab
> environment and I don't have the $$ for a SAN, will it work with a Network
> Storage HD? I realize the performance won't be great, but I'm looking for
> the experience in how to build/configure the environment.
> Any tips?
> An alternative question for the lab environment is ... how would you do
> this
> in two VPC? Or would you steer clear?
> Thanks
> Al
> "Mike Epprecht (SQL MVP)" wrote:
sql
The servers have Windows 2000 Advanced Server and I have SQL Server 2000
Enterprise Edition.
My question is, do I also need a box called a Shared Disk Array, or can I
use another server I currently have that has lots of disk space on it?
Correction: I have Windows 2000 Advanced Server
"Vincel2k2" wrote:
> I have two matched servers, one will be Active and one will be Passive.
> The servers have Windows 2000 Advanced Server and I have SQL Server 2000
> Enterprise Edition.
> My question is, do I also need a box called a Shared Disk Array, or can I
> use another server I currently have that has lots of disk space on it?
>
|||You will indeed need shared storage.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"Vincel2k2" <Vincel2k2@.discussions.microsoft.com> wrote in message
news:FF446D59-A73C-43EA-9EC2-4B9D03CFD51B@.microsoft.com...[vbcol=seagreen]
> Correction: I have Windows 2000 Advanced Server
> "Vincel2k2" wrote:
|||Hi
You need to get your self a Storage Area Network (SAN) to store your data
on.
For clustering, make sure that your hardware is on the Windows Hardware
Compatibility List (HCL)
Read the documentation on
http://www.microsoft.com/windowsserv...g/default.mspx
to get an understanding.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Vincel2k2" <Vincel2k2@.discussions.microsoft.com> wrote in message
news:FF446D59-A73C-43EA-9EC2-4B9D03CFD51B@.microsoft.com...[vbcol=seagreen]
> Correction: I have Windows 2000 Advanced Server
> "Vincel2k2" wrote:
I[vbcol=seagreen]
|||I also have two matched servers with Win2003EntSrv that I would like to
install an active/passive failover cluster of Yukon on. Since this is a lab
environment and I don't have the $$ for a SAN, will it work with a Network
Storage HD? I realize the performance won't be great, but I'm looking for
the experience in how to build/configure the environment.
Any tips?
An alternative question for the lab environment is ... how would you do this
in two VPC? Or would you steer clear?
Thanks
Al
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> You need to get your self a Storage Area Network (SAN) to store your data
> on.
> For clustering, make sure that your hardware is on the Windows Hardware
> Compatibility List (HCL)
> Read the documentation on
> http://www.microsoft.com/windowsserv...g/default.mspx
> to get an understanding.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Vincel2k2" <Vincel2k2@.discussions.microsoft.com> wrote in message
> news:FF446D59-A73C-43EA-9EC2-4B9D03CFD51B@.microsoft.com...
> I
>
>
|||Virtual Server 2005 will work nicely for this test. See
http://www.hands-on-labs.com/microsoft.asp?ID=4477 for the steps
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"al_stark_born" <al_stark_born@.discussions.microsoft.com> wrote in message
news:E579B181-45E6-4DF2-8BCA-E7F1D2DD44C7@.microsoft.com...[vbcol=seagreen]
>I also have two matched servers with Win2003EntSrv that I would like to
> install an active/passive failover cluster of Yukon on. Since this is a
> lab
> environment and I don't have the $$ for a SAN, will it work with a Network
> Storage HD? I realize the performance won't be great, but I'm looking for
> the experience in how to build/configure the environment.
> Any tips?
> An alternative question for the lab environment is ... how would you do
> this
> in two VPC? Or would you steer clear?
> Thanks
> Al
> "Mike Epprecht (SQL MVP)" wrote:
sql
Subscribe to:
Posts (Atom)