I have configured SQL 2005 cluster in vmware workstation on windows 2003 R2 with SP2. First i have configured the windows cluster then installed sql 2005 on top of it. On node1 it showes all the resources online.
Now the problem is, when I move the resources from node1 to node2, it does not show anything on shared storage and sql server resources do not come up and showed "Failed" status in cluster administrator.
Now when I move back the resouces from node2 to node1, it deletes everything from the shared storage and both the nodes shows the failure status of sql resources.
Please guide what is the possible reason and how can I solve it?
Thanks in advance
View Complete Post