I have a quandry.
I have followed numerous articles for installing Windows 2008 R2 Enterprise with the SQL 2008 Enterprise without a hitch. The cluster validates perfectly. The only issue is, when I bring up the Server Manager > Failover Cluster Manager > My Cluster and failover the MSDTC to the other node, the SQL server doesn't fail over to the other node.
I am probably thick headed on this. I have searched numerous sites trying to find out what needs to be done and can't find the answer anywhere.
Any help would be much appreciated!
Thank you all for a great forum!