Interesting SQL 2012 Cluster Failover Question
Posted on 2014-03-21
Guys I need help here and if someone has a reasonable explanation about what happened, I need a proof.
I think I know the reason, but just wanted to see out if someone else has another interesting explanation.
Here's the case:
I have an SQL 2012 Cluster configured with two nodes. Unfortunately, the connection to the shared storage (SAN) was down due to a dhcp failure; everything else was statically configured.
So node A; which was the active node, failed over to node B; which was the passive node.
Node B became the active node, and I had connectivity back to the shared storage, but SQL traffic was not flowing through node B until I had to restart node A. Does anyone knows the reason behind that and why I had to restart node A to have SQL traffic flowing through node B.
Note: Before restarting node A, I was able to connect to node B; and it became the active node and everything seemed fine, but I couldn't telnet on port 1433 to node B until I restarted node A.