Creating a 2 Node SQL Server 2008 Virtual Cluster Part 2

Question

Creating a 2 Node SQL Server 2008 Virtual Cluster Part 2

Viewing 7 posts - 31 through 36 (of 36 total)

You must be logged in to reply to this topic. Login to reply

M&M SSC-Insane Points: 21700 More actions · Answer 1

Perry Whittle (10/11/2011)
Try installing the VMWare tools in each of the windows virtual machines, this could be why you don't see the adapters.

Thank you Perry, that was a brilliant suggestion. Yes, I installed the VMWare tools on each of the VMs and now I can see the adapters.

But I have a question. Initially, as I couldn't see the adapters I had configured the Microsoft Loopback Adapter and assigned the static IP addresses. Please let me know how to proceed with this.

M&M

Perry Whittle SSC Guru Points: 234013 More actions · Answer 2

mohammed moinudheen (10/11/2011)
But I have a question. Initially, as I couldn't see the adapters I had configured the Microsoft Loopback Adapter and assigned the static IP addresses. Please let me know how to proceed with this.

un assign the IP from the loopback adapter and then remove the adapter itself. The VMWare VMNET virtual switches take care of the network functionality

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

M&M SSC-Insane Points: 21700 More actions · Answer 3

Perry Whittle (10/9/2011)
For this section create 3 new Windows virtual machines.
1 of them requires just 1 virtual NIC connected to the public network.
The other 2 require 3 virtual NICs each. One connected to public, one connected to iSCSI and the other connected to heartbeat\private. You could use the following
VMNet1 Public 172.168.10.0 255.255.255.0
VMNet2 ISCSI 192.168.93.0. 255.255.255.0
VMNet3 Private 10.10.10.0. 255.255.255.0
So the domain controller will have 1 NIC connected to VMNet1
Each cluster node will have one NIC connected to VMNet1, VMNet2 and VMNet3.
Get all 3 machines installed and networked and post back for details of how to create the domain controller.

Sorry, I have one doubt, please don't get mad. It is regarding the below IP addresses you suggested.

VMNet1 Public 172.168.10.0 255.255.255.0

VMNet2 ISCSI 192.168.93.0. 255.255.255.0

VMNet3 Private 10.10.10.0. 255.255.255.0

Does this mean that we need to provide the same IP address to the following. To be more clear.

For ClusterDC

VMNet1 Public 172.168.10.0 255.255.255.0

For Node1

VMNet1 Public 172.168.10.0 255.255.255.0

VMNet2 ISCSI 192.168.93.0. 255.255.255.0

VMNet3 Private 10.10.10.0. 255.255.255.0

For Node2

VMNet1 Public 172.168.10.0 255.255.255.0

VMNet2 ISCSI 192.168.93.0. 255.255.255.0

VMNet3 Private 10.10.10.0. 255.255.255.0

M&M

M&M SSC-Insane Points: 21700 More actions · Answer 4

Another doubt I have is. Do these IP addresses that needs to be configured on ClusterDC, Node1 and Node2 needs to match to what was configured on Part 1 of series, i.e. the ones that were configured in 'Virtual Network Editor' of VMWare.

Screenshot below.

M&M

Perry Whittle SSC Guru Points: 234013 More actions · Answer 5

mohammed moinudheen (10/11/2011)
Sorry, I have one doubt, please don't get mad. It is regarding the below IP addresses you suggested.
VMNet1 Public 172.168.10.0 255.255.255.0
VMNet2 ISCSI 192.168.93.0. 255.255.255.0
VMNet3 Private 10.10.10.0. 255.255.255.0
Does this mean that we need to provide the same IP address to the following. To be more clear.
For ClusterDC
VMNet1 Public 172.168.10.0 255.255.255.0
For Node1
VMNet1 Public 172.168.10.0 255.255.255.0
VMNet2 ISCSI 192.168.93.0. 255.255.255.0
VMNet3 Private 10.10.10.0. 255.255.255.0
For Node2
VMNet1 Public 172.168.10.0 255.255.255.0
VMNet2 ISCSI 192.168.93.0. 255.255.255.0
VMNet3 Private 10.10.10.0. 255.255.255.0

each machine must have a unique IP address in each of the ranges. For instance

DC public = 172.168.10.2

Node1 public = 172.168.10.3

Node1 iSCSI = 192.168.93.3

Node1 private = 10.10.10.3

Node2 public = 172.168.10.4

Node2 iSCSI = 192.168.93.4

Node2 private = 10.10.10.4

Incidentally what IP address did you assign to the NAS VM, you'll to take this into account to.

Remember IP addresses in the network have to be unique, just like computernames

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

Perry Whittle SSC Guru Points: 234013 More actions · Answer 6

mohammed moinudheen (10/11/2011)
Another doubt I have is. Do these IP addresses that needs to be configured on ClusterDC, Node1 and Node2 needs to match to what was configured on Part 1 of series

You can use the ranges in the tutorial or assign your own, it's up to you. Just remember which VMNet adapter belongs to which network

From memory the tutorial uses

VMNET1 public

VMNET2 private

VMNET3 iSCSI

If you don't mind me saying it seems that you have very little experience with Windows server systems and networks in general. Research TCP/IP and IP addressing. Practice these concepts on your virtual machines until you are confident of proceeding further.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

M&M SSC-Insane Points: 21700 More actions · Answer 7

If you don't mind me saying it seems that you have very little experience with Windows server systems and networks in general. Research TCP/IP and IP addressing. Practice these concepts on your virtual machines until you are confident of proceeding further.

Thanks for your help so far. I referred to Networking concepts from this book

"Pro SQL Server 2008 Failover Clustering" by Allan Hirt and found it be very useful.

Also, referred to these videos which helped me to configure networking between the VMs.

Link1

Link2

Link3

Now, Going to Part 3 of series.

M&M