Please help, SQL is failing on a cluster during setup!!!!

[4T86T7]

I have built a Two Node cluster on a Compaq server, all is well, the nodes are communicating and the shared drives are accessed by both nodes. THE PROBLEM is SQL 2000 entrprise; I go through the setup, all seems to work until the end when it finishes copying the files it comes back with this message <<Setup Failed to perform required operations on the cluster nodes>>.

I do not see anything in the Event log, except a DR Watson error ID 4097, <<an application exception occurred>> C0000005, address 01008554.

I created the MSDTC and it is listed, the IP's are all correct, I can ping the the Private and the public addresses just fine.

any help will be greatly appreciated..
Thanks.

 

[Guest_imported]

Need to start with the basics:
Before installing SQL, did you test failover?
Easiest way is in Cluster Administrator, left pane, right click on Cluster Group or Disk Group x and choose &quot;Move Group&quot;.
Watch the left pane where it shows the owner and see if ownership goes to the other node.

Did you match up drive letters on node1 and node2 so they see the same shared storage as the same drive letters?

W2K or NT4?
If NT4 are you running at least sp5 and reapply sp after installing cluster - both nodes.

If all that is OK then,
Did you follow the recommendations for installing SQL in a cluster?

I know you can find those intructions on Dell's site

good luck

 

[4T86T7]

Yes to all the above,
It is a w2k
Yes I did folow the instruction.
the SQL 2000 is the enteprise addition
the server is 2000 advance server.
Today I am redoing the servdr from Zero.
We'll see what happens.
Thanks