Recently, I was tasked to set up SQL 2008 failover cluster on both Windows 2003 Server (Enterprise ed). Everything was set up perfectly, failover work on both cluster nodes.
Now the question is my boss asked me a very basic question on which I'm unable to give him a detailed explanation on why can't used only a single IP Address for both MSCS cluster and SQL failover cluster?
I replied back him (amateurish) its because of the requirement stated on SQL 2008 failover cluster. I can't even be allowed to install when I keyed in the already used IP Address for MSCS.
Can any folks enlighten me on these?
View Complete Post