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 Server 2005.
I will try to be as descriptive as possible. In case something is not clear, please provide feedback.
You also have to download Microsoft Virtual Server (http://technet.microsoft.com/hi-in/bb738033(en-us).aspx)
You also need to download ISO image for SQL Server 2005 evaluation edition (http://www.microsoft.com/downloads/details.aspx?FamilyID=6931fa7f-c094-49a2-a050-2d07993566ec&DisplayLang=en)
You should also have virtual hard disk of operating system. (Download available http://www.microsoft.com/downloads/details.aspx?FamilyID=77f24c9d-b4b8-4f73-99e3-c66f80e415b6&DisplayLang=en)
Above link has three files to download. You have to download all files. Once you download content from above link, you need to extract to a folder in local machine using WIN2K3R2EESP2.part1.exe. I extracted in (E:\Virtual Server)
Above link has three files to download. You have to download all files. Once you download content from above link, you need to extract to a folder in local machine using
. I extracted in (E:\Virtual Server)
Please refer the readme file in above folder after you download.
NOTE: THIS SETUP WILL WORK ONLY FOR 30 days(depends on Read Me)
One you extracted the files, make three copies of virtual hard disk. One for Domain Controller, second for node1 and third for node2. I have created files as below:
Once you have downloaded and installed Virtual Server you should see new menu item in Programs.
Now, we will configure the Virtual Servers. First we need to Create Virtual Machine so that we have three separate virtual servers available. Make sure you set the Search Path at below screen.
On Left Side Menu choose Virtual Server > Server Properties > Search Path
below is the screen shot of "MyDC" setting. Information which I filled in is
Click on Create.
Now, Go to Master Status and try to "Turn ON" the domain controller (I know its not yet a DC but in next step we are going to make it)
One you log in to MyDC, rename the machine to MyDC (by right click on My Computer > Properties) You need to restart the computer after renaming.
Next step is to run "dcpromo" command to make this machine as domain controller. Start>Run>dcpromo
Accept all settings as default, below are few which you need to modify.
During setup if it asks for windows installation CD, please point it to C:\WindowsInstallationFiles\I386 folder. Also, when prompted, please provide IP address as 126.96.36.199. You will be prompted to restart the machine.
When you can logon screen after reboot, "Log on to" should have MyCluster selected.
Now we have one machine ready which will act as domain controller for our cluster setup.
You are now having one Domain Controller in your Virtual Network. Now, lets add two member servers in the domain. As we did earlier, we have to add rest two vhd to server. Below screen shot is for Node2.
After configuration on Virtual Servers, follow below steps
1. Rename the nodes to MyNode1 and MyNode2 (still in Workgroup).
My Computer > Right Click > Properties > Computer Name
Then Restart MyNode1 and MyNode2
2. Disable the Firewall on all three machines.
Control Panel > Windows Firewall
Select "Off" from the UI.
3. Change the IP address of machines.
MyNode1 - 188.8.131.52 (DNS Server 184.108.40.206)
MyNode2 - 220.127.116.11 (DNS Server 18.104.22.168)
4. Join the machine to domain (MyCluster.com) Below screen shot.
This finishes setup of one domain controller and two member servers.
Now we have to make MyNode1 and MyNode2 as single cluster.
lets move on to Part 2
PingBack from http://marcellotonarelli.wordpress.com/2008/06/30/how-to-create-sql-server-2005-clustering-with-virtual-server-2005/
In previous parts( Part 1 , Part 2 and Part 3 ), we have completed windows clustering. Now, before installing
In Part 1 and Part 2 , we configured till setting up Quorum drive on MyNode1. First we need to change
Is creating SQL Server cluster on virtual server 2005 similar, or reasonably similar or totally different to creating them on Window 2000 Advance Server or Windows
2000 Datacenter Edition.
I am not clear with the question. We are using Virtual Server 2005 to virtualize the OS. We are using 3 virtual machines of Windows 2003 to create cluster+DC. You can also use Windows 2000 vhd.
If you have physical machines (windows 2000) and SAN, you could follow
Microsoft Cluster Service Installation Resources
Server Clusters: Network Configuration Best Practices for Windows 2000 and Windows Server 2003
SQL Clustering White paper: . http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en
By this I mean, if I was to implement it on the physical machines, will the procedure you used also apply if I was to implement the cluster on physical machines rather than virtual machines, i.e. Setting network adapter, SCSI adapter, creating cluster groups, MSDTC configuration, installing SQL Server 2005, changing the IP Address, etc.
Yeah. you would perform almost same tasks. For physical machine below document is the best...
Let me know your MyDC,MyNode1 and MyNode2 woindow administrator password please..
Now I found.
ReadMe file should have password in it.
Now I installed SQL cluster group is IP 192.168.0.145. Cluster group is 192.168.0.140. But I want to use one IP only. So can I change SQL cluster IP to 192.168.0.140? Is it ok for SQL cluster?
Sorry to say but its not possible. You must have seperate IP for Cluster and SQL.
Thank for your quick reply.
After installing SQL fail over for default instance, if I need to install next other instance, how will I do?
Run the setup again and on screen where you have to choose instance name, choose named instance and provide new virtual server name and instance name.
step 10 and 11 would change in the below link..
Can I know how many computer that we need for this testing ?
If you need 3 computers , Can I know what is the OS of MyNode1 and MyNode2 ?