Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

So I have successfully set up a 2 node 2008 R2 cluster with SQL Server 2008.

There are basically 3 networks.

  • Public (client LAN)
  • Private (Heartbeat between the two machines)
  • iSCSI SAN (hosts witness disk and SQL storage)

I have had the cluster successfully failover by disconnecting the public network, by manually transferring the service, and by rebooting one of the machines.

What I cant get get to failover is when I pull the iSCSI network connection from the hosting machine. The service falls flat on its face and doesn't recover until I plug back in and manually bring the service online.

My quorum mode is Node and Disk Majority.

My understanding is that if Machine 1 loses its connection to either the public network or the iSCSI resource, that the whole cluster should failover to Machine 2 which still has an established connection to both networks.

share|improve this question
did this pass the cluster validation test? – tony roth Mar 26 '12 at 20:57
yes. and all services failover and failback properly if I do it manually through the management console – Brian Mar 26 '12 at 21:48
I had a similar issue with a cheap iscsi device it didn't really support persistent reservations wonder if thats an issue here. – tony roth Mar 27 '12 at 20:27
While we didnt go for a very expensive HP or Dell iSCSI solution, this isnt exactly a cheap unit either. Its made by QNAP. According to their site it supports SPC-3 Persistent Reservation QNAP Software Spec – Brian Mar 27 '12 at 20:36
qnap was the device that I used and it was not compliant with spc-3 at the time. But from what I've read that currently should be a non issue. When you did cluster validation test did you skip storage? – tony roth Mar 27 '12 at 21:11

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.