Marios Philippopoulos (2/27/2014)
No, the server itself is unusable; something happened and we are no longer able to even remote-desktop to it.It needs to be rebuilt and the SQL re-installed. Problem is this was initially the "active" node in the cluster configuration.
The SQL instance now resides in the "passive" node, B, but we have no HA for it; if something happens to server B, we have no failover option at the moment.
So you have all the databases live on the other node which was passive before active server went down. So failover happened to passive node before the active went down, right? If yes, the cluster can be on the single node. Try to work on the other node and fix it. Try to run the remove node from sql installation and then evict the node and start from scratch.