Cluster issues on 2000

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ross Mistry - 11 Jul 2008 02:05 GMT

I need to install SQL Server 2000 on a Windows 2000 cluster - Yes I know how
sad is that...

Anyhow, I have following the installation based on the white paper below to
a T, however, I receive the following errors after I install Cluster
Services on the first first node - basically clustering service fails to
start.

http://technet.microsoft.com/en-us/library/bb727114.aspx

Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7031
Date: 7/10/2008
Time: 4:54:33 PM
User: N/A
Computer: POSPOLLPRD1
Description:
The Cluster Service service terminated unexpectedly. It has done this 1
time(s). The following corrective action will be taken in 60000
milliseconds: Restart the service.

Event Type: Error
Event Source: ClusSvc
Event Category: (128)
Event ID: 1009
Date: 7/10/2008
Time: 4:54:31 PM
User: N/A
Computer: POSPOLLPRD1
Description:
The Clustering Service could not join an existing cluster and could not form
a new cluster. The Clustering Service has terminated.
Data:
0000: a4 13 00 00 ¤...

Event Type: Error
Event Source: ClusSvc
Event Category: Services
Event ID: 1069
Date: 7/10/2008
Time: 4:54:31 PM
User: N/A
Computer: POSPOLLPRD1
Description:
Cluster resource 'Disk Q:' failed.

Reply to this Message

Geoff N. Hiten - 11 Jul 2008 02:30 GMT

One of the biggest weaknesses of Windows 2000 is that it let you build a
non-working cluster. Windows 2003 is better and 2008 is great.
Unfortunately without detailed access to the system and setup logs, I cant
help a lot. It looks like the Q drive is not accessable from all nodes and
did not correctly form a clustered resource.

Signature

Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP

>I need to install SQL Server 2000 on a Windows 2000 cluster - Yes I know
>how sad is that...
[quoted text clipped - 43 lines]
> Description:
> Cluster resource 'Disk Q:' failed.

Reply to this Message

Ross Mistry - 11 Jul 2008 03:28 GMT

I agree the lack of troubleshooting and diagnostics when building Windows
2000 clusters is horrendous. I have been spoiled for the past year as I
have only been building failover clusters with SQL Server 2008 on Windows
Server 2008.

Unfortunately, the customer I am working with needs to replace an old
cluster. They are forced to build the failover cluster with Windows 2000
and SQL Server 2000 as the 3rd party application running on top is only
certified to use this legacy platform.

Quorum and all the shared disks are available to all nodes within the
cluster. Everything appears to be fine, logs are clean.It has been ages
since I played with a 2000 cluster - I'll pluck away at it tomorrow and see
what I come up with.

Thanks Geoff!!!

Ross

> One of the biggest weaknesses of Windows 2000 is that it let you build a
> non-working cluster. Windows 2003 is better and 2008 is great.
[quoted text clipped - 49 lines]
>> Description:
>> Cluster resource 'Disk Q:' failed.

Reply to this Message

Edwin vMierlo [MVP] - 11 Jul 2008 14:06 GMT

logs are clean ?

and you have a "Cluster resource 'Disk Q:' failed" in the system event log ?

there must be something in the cluster.log file !

can you do the following:

- on node 2, disable cluster service
- on node 2, disable clusdisk.sys
- shutdown node 2
- on node 1, disable cluster service
- on node 1, disable clusdisk.sys
- reboot node 1
---> can you access your Q ?

- on node 1, enable cluster service
- on node 1, enable clusdisk.sys
- shutdown node 1
- powerup node 2
---> can you access your Q ?

- on node 2, enable cluster service
- on node 2, enable clusdisk.sys
- reboot node 2
---> does cluster service start ?
---> can you access Q ?

- powerup node 1
---> does cluster service start ?

- with cluster administrator: move the cluster group to node 1
---> does the group move to node 1 ?

- with cluster administrator: move the cluster group to node 2
---> does the group move to node 2 ?

and at each stage, if your answer is no to any of the questions, then stop,
and troubleshoot that first

HTH,
Edwin.

> I agree the lack of troubleshooting and diagnostics when building Windows
> 2000 clusters is horrendous. I have been spoiled for the past year as I
[quoted text clipped - 68 lines]
> >> Description:
> >> Cluster resource 'Disk Q:' failed.

Reply to this Message