Installing cluster in Windows 2000 + 2003

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
>.
>

Installing Analysis Services

I installed anaylsis services 6 months after I installed
SQL 2000. Do I need to reinstall the SQL Service Packs?I probably would, also make sure to install the service packs for analysis
services
Ray Higdon MCSE, MCDBA, CCNA
--
"Greg" <anonymous@.discussions.microsoft.com> wrote in message
news:1b7601c3fbfe$5e44d4a0$a101280a@.phx.gbl...
> I installed anaylsis services 6 months after I installed
> SQL 2000. Do I need to reinstall the SQL Service Packs?

Installation hangs!

Hi!
I've tried to install and reinstall (after thourogh removal) MSDE 2000 A. It
always hangs!
I've followed this document, but nothing helps.
http://download.microsoft.com/downlo...eMSDE2000A.htm
It seems in the install log, that the execution of sqlredis.exe hangs.
Any advice/help would be very much appreciated!
regards
Karl
hi Karl,
Karl Zeift wrote:
> Hi!
> I've tried to install and reinstall (after thourogh removal) MSDE
> 2000 A. It always hangs!
> I've followed this document, but nothing helps.
>
http://download.microsoft.com/downlo...eMSDE2000A.htm
> It seems in the install log, that the execution of sqlredis.exe hangs.
> Any advice/help would be very much appreciated!
> regards
> Karl
if you think that sqlredis.exe hangs, try separately re-installing MDAC
stack before installing MSDE ... you can get the desired version or the MDAC
package from http://msdn.microsoft.com/data/Default.aspx
you can check your current MDAC level using Component Checker, you can
download at
http://www.microsoft.com/downloads/d...DisplayLang=en
please always add the
/L*v "c:\MsdeLog.txt"
parameter to your setup.exe bootstrap installer calls, in order to log the
installation process to a text file of about 2mb you can inspect for
RETURN VALUE 3
entries, that indicate errors, and, about 10/20 lines before or after each
entry you can fined some more (sometime cryptic) descriptive explanation of
the problem found...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:36rnmqF564rhoU1@.individual.net...
> hi Karl,
> Karl Zeift wrote:
> http://download.microsoft.com/downlo...eMSDE2000A.htm
> if you think that sqlredis.exe hangs, try separately re-installing MDAC
> stack before installing MSDE ... you can get the desired version or the
> MDAC
> package from http://msdn.microsoft.com/data/Default.aspx
> you can check your current MDAC level using Component Checker, you can
> download at
> http://www.microsoft.com/downloads/d...DisplayLang=en
> please always add the
> /L*v "c:\MsdeLog.txt"
> parameter to your setup.exe bootstrap installer calls, in order to log the
> installation process to a text file of about 2mb you can inspect for
> RETURN VALUE 3
> entries, that indicate errors, and, about 10/20 lines before or after each
> entry you can fined some more (sometime cryptic) descriptive explanation
> of
> the problem found...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
Thanks for your reply!
It did not seem to help. The Component Checker reports that I have version
2.8 SP 1 on Win XP SP 2. I downloaded the Mdac 2.8 from the link you
suggested to reinstall it, but it reports that it's not intended for my
version of Windows, since its already included.
I paste the last few log rows from the MsdeLog.txt here (if that contains
any clues...):
It seems that sqlredis.exe just hangs forever...
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\Kalle\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\Kalle\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action NoRebootReplace
TempFolder Property is C:\DOCUME~1\Kalle\LOCALS~1\Temp\
Source Dir Property is C:\DOCUME~1\Kalle\LOCALS~1\Temp\SqlSetup\Temp
NoRebootConnectRepl returned: 0
MSI (s) (64:D8) [14:37:09:421]: Executing op:
ActionStart(Name=InstallSqlRedis.2D02443E_7002_4C0 B_ABC9_EAB2C064397B,,)
MSI (s) (64:D8) [14:37:09:421]: Executing op:
CustomActionSchedule(Action=InstallSqlRedis.2D0244 3E_7002_4C0B_ABC9_EAB2C064397B,ActionType=1025,Sou rce=BinaryData,Target=InstallSqlRedis,)
MSI (s) (64:04) [14:37:09:437]: Invoking remote custom action. DLL:
C:\WINDOWS\Installer\MSIB4.tmp, Entrypoint: InstallSqlRedis
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\Kalle\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\Kalle\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action InstallSqlRedis
Executing "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlredis.exe
/q:a"

Installation Error: Error performing inpage operation

Hi All,
I un-installed existing SQL Server 2000 on my PC (Windows XP Pro), and when
I try to reinstall I am getting the following error
Setup Initialization Error - Error performing inpage operation
I tried to remove all instances of SQL Server from my PC, and still the
installation did not work.
Could anybody help me identifying the cause.
Awaiting your expertise.
Thanks
Hi
Try copying the CD to your local drive and running setup from there. This
error is usually caused when a read error occurs on transferring data
between a drive and RAM.
If it occurs during the file copy, you have either a bad CD or a CD faulty
drive.
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/
"Reilly" <Reilly@.discussions.microsoft.com> wrote in message
news:1840BBF3-EBAF-4F3E-8B00-8CFF47B87BDB@.microsoft.com...
> Hi All,
> I un-installed existing SQL Server 2000 on my PC (Windows XP Pro), and
when
> I try to reinstall I am getting the following error
> Setup Initialization Error - Error performing inpage operation
> I tried to remove all instances of SQL Server from my PC, and still the
> installation did not work.
> Could anybody help me identifying the cause.
> Awaiting your expertise.
> Thanks
>

Installation Error: Error performing inpage operation

Hi All,
I un-installed existing SQL Server 2000 on my PC (Windows XP Pro), and when
I try to reinstall I am getting the following error
Setup Initialization Error - Error performing inpage operation
I tried to remove all instances of SQL Server from my PC, and still the
installation did not work.
Could anybody help me identifying the cause.
Awaiting your expertise.
ThanksHi
Try copying the CD to your local drive and running setup from there. This
error is usually caused when a read error occurs on transferring data
between a drive and RAM.
If it occurs during the file copy, you have either a bad CD or a CD faulty
drive.
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/
"Reilly" <Reilly@.discussions.microsoft.com> wrote in message
news:1840BBF3-EBAF-4F3E-8B00-8CFF47B87BDB@.microsoft.com...
> Hi All,
> I un-installed existing SQL Server 2000 on my PC (Windows XP Pro), and
when
> I try to reinstall I am getting the following error
> Setup Initialization Error - Error performing inpage operation
> I tried to remove all instances of SQL Server from my PC, and still the
> installation did not work.
> Could anybody help me identifying the cause.
> Awaiting your expertise.
> Thanks
>

Installation Error

After I uninstalled Reporting Services (which it was working just fine) and
to reinstall it, the setup screen for installing SQL Server Reporting
Services Setup Support Files completes successfully. When I click the Next
button nothing happens.
If I go to the event viewer, I get this:
Faulting application SETUP.EXE, version 2000.80.743.0, faulting module
sqlspars.dll, version 2000.80.743.0, fault address 0x00059cf8.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Any ideas? I turned on logging by doing this:
setup.exe /l*v setupmsi.log
and no log file was generated. Does anyone know what else I can try to get
this thing installed? I hope to god I don't have to rebuild my server. So
far, I have 3 servers that I cannot get reporting services installed on
since I have "screwed the pooch" on this by uninstalling RS - and now I
cannot put them back on. The development team is breathing down my neck on
this.
=-ChrisI apologize for the duplicate postings. I couldn't see this post and thought
that it didn't go through.
"Christopher Conner" wrote:
> After I uninstalled Reporting Services (which it was working just fine) and
> to reinstall it, the setup screen for installing SQL Server Reporting
> Services Setup Support Files completes successfully. When I click the Next
> button nothing happens.
> If I go to the event viewer, I get this:
> Faulting application SETUP.EXE, version 2000.80.743.0, faulting module
> sqlspars.dll, version 2000.80.743.0, fault address 0x00059cf8.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Any ideas? I turned on logging by doing this:
> setup.exe /l*v setupmsi.log
> and no log file was generated. Does anyone know what else I can try to get
> this thing installed? I hope to god I don't have to rebuild my server. So
> far, I have 3 servers that I cannot get reporting services installed on
> since I have "screwed the pooch" on this by uninstalling RS - and now I
> cannot put them back on. The development team is breathing down my neck on
> this.
> =-Chris
>
>