Active Route removed on Windows Server Failover Cluster

I came across an issue today while failing over a SQL instance in a clustered 2 node setup. While failing over the resource group, I immediately lost connection to the active node prior to the failover. I was still able to access the now Active node and saw that the heartbeat between the two nodes was online which was an indication that the second node was still joined in the cluster.

I found an article from Microsoft which gave a good explanation as to this behavior and a fix. Unfortunately I am unable to replicate this issue in my lab to provide a visual explanation but will at some point. Please read the following articles for detailed information regarding this issue at your leisure time :):

Article1

Article2

 
comments powered by Disqus