Cannot Start SQL Node in Cluster
I was unable to start SQL on one of the nodes of our 2008 R2 clusters. The resource status would show as Online Pending and then eventually fail.
It turns out that the SQL Browser service was disabled on the node. After enabling it, SQL started up immediately.