How to create SQL Server 2005 Clustering with Virtual Server 2005 (Part 5)

This is the last part of the series. Once you have configured windows cluster and MSDTC, installing SQL is piece of cake. I already mentioned in part 1 that you have to download ISO (SQLEVAL.ISO) which we would need to attached as CD drive which would have setup files. I have copied the image on…

66

How to create SQL Server 2005 Clustering with Virtual Server 2005 (Part 4)

In previous parts(Part 1, Part 2 and Part 3), we have completed windows clustering. Now, before installing SQL Cluster we have to configure MSDTC. We also need to make some shared drive which we would use to keep SQL Server databases and MSDTC. We are going to use Disk M for MSDTC and Disk X…

20

How to create SQL Server 2005 Clustering with Virtual Server 2005 (Part 3)

In Part 1 and Part 2, we configured till setting up Quorum drive on MyNode1. First we need to change the IP address of heartbeat network which we added to MyNode1 and MyNode2. Below is the screen shot of heartbeat IP on MyNode1. We need to give IP as 10.10.10.1 (once you hit tab, subnet…

13

How to create SQL Server 2005 Clustering with Virtual Server 2005 (Part 2)

In Part 1 we have made our Virtual network ready which is having a domain controller and two member servers (MyNode1 and MyNode2) Lets start making cluster… Create Quorum Disk For cluster we need a Quorum disk. Below are the steps to make a Quorum virtual disk. In the menu of Virtual Server, click on…

0

How to create SQL Server 2005 Clustering with Virtual Server 2005 (Part 1)

After delivering SQL Training, I realized that there is a need to write a blog which talks about Installing SQL Server 2005 cluster on Virtual Environment. Many DBA wants to see how Cluster looks like and they don’t have capability to buy/see actual cluster. There is an easy solution to the problem by using Virtual…

35