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

How to create SQL Server 2005 Clustering with Virtual Server 2005 « Marcello Tonarelli Blog

Mon, 30 Jun 2008 10:34:02 GMT

PingBack from http://marcellotonarelli.wordpress.com/2008/06/30/how-to-create-sql-server-2005-clustering-with-virtual-server-2005/

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

Balmukund — Sun, 11 Jan 2009 05:18:26 GMT

In previous parts( Part 1 , Part 2 and Part 3 ), we have completed windows clustering. Now, before installing

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

Balmukund — Sun, 11 Jan 2009 05:19:10 GMT

In Part 1 and Part 2 , we configured till setting up Quorum drive on MyNode1. First we need to change

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

Thai — Mon, 02 Mar 2009 10:45:16 GMT

Hi Balmukund,

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.

Thanks

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

blakhani — Mon, 02 Mar 2009 11:24:48 GMT

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

http://support.microsoft.com/?id=259267

Server Clusters: Network Configuration Best Practices for Windows 2000 and Windows Server 2003

http://www.microsoft.com/technet/prodtechnol/windowsserver2003/

technologies/clustering/clstntbp.mspx

SQL Clustering White paper: . http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en

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

Thai — Wed, 04 Mar 2009 03:06:35 GMT

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.

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

blakhani — Wed, 04 Mar 2009 05:53:51 GMT

Yeah. you would perform almost same tasks. For physical machine below document is the best...

SQL Clustering White paper: . http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en

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

hninwailwin — Wed, 06 May 2009 16:52:31 GMT

Dear Friend,

Let me know your MyDC,MyNode1 and MyNode2 woindow administrator password please..

Thanks

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

hninwailwin — Wed, 06 May 2009 16:55:26 GMT

Friend,

Now I found.

Thanks

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

blakhani — Wed, 06 May 2009 16:59:32 GMT

ReadMe file should have password in it.

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

hninwailwn — Fri, 15 May 2009 08:27:02 GMT

Hi Friend,

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?

Thanks.

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

blakhani — Fri, 15 May 2009 08:38:30 GMT

Sorry to say but its not possible. You must have seperate IP for Cluster and SQL.

http://blogs.msdn.com/blakhani/archive/2008/06/09/sql-2005-cluster-setup-checklist.aspx

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

hninwailwin — Fri, 15 May 2009 09:02:15 GMT

Hi Friend,

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?

Please....

Thanks

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

blakhani — Fri, 15 May 2009 09:16:48 GMT

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..

http://blogs.msdn.com/blakhani/archive/2008/01/19/how-to-create-sql-server-2005-clustering-with-virtual-server-2005-part-5.aspx

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

Pech Matine — Mon, 22 Jun 2009 09:18:57 GMT

Dear Sir,

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 ?

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

blakhani — Mon, 22 Jun 2009 09:24:30 GMT

Hi Pech Matine,

You just need one computer. We are using Virtual server to simulate three machines with in one machine.

Regards,

Balmukund

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

Pech Matine — Thu, 20 Aug 2009 11:23:15 GMT

Dear Sir,

If I need one computer , Do I need to use Virtual PC or not ? because If we don't need Virtual PC how can we setup windows server 2003 on other PC ?

Thanks

Create virtual hard disk of operating system

Seng Solong — Thu, 20 Aug 2009 11:49:00 GMT

Hi,

Can you tell me how to create virtual hard disk of operating system ? because I can't download from internet cause the speed of my internet so slow.

Best Regard,

Seng Solong.

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

blakhani — Thu, 20 Aug 2009 16:02:48 GMT

Hi Pech Matine,

You need to use Virtual Server software which is free download from Microsoft website

Regards,

Balmukund

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

blakhani — Thu, 20 Aug 2009 16:03:50 GMT

Hi Seng Solong,

Its available on internet. Not sure how can i help you in slow connection case.

Regards,

Balmukund

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

Pech Matine — Fri, 21 Aug 2009 06:15:39 GMT

Hi,

1- Does the virtual hard disk of operating system can run on Windows 2003 SP 2?

2- How can I Rename the nodes to MyNode1 and MyNode2 ? because I have only one OS and run one computer.

Thanks

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

blakhani — Fri, 21 Aug 2009 06:51:46 GMT

Hi Pech Matine,

Basically, we are using Virtualization technology here. This means that you can host multiple machines on just one hardware based operating system. MyNode1 and MyNode2 are two virtual machines hosted on your laptop/desktop. MyNode1 and MyNode2 would be used VHD (virtual hard disks) which are files located on your base machine.

In technical terms, "host" is the machine running virtual machines and "guest" is the machines which is running inside "host"

Hope this helps.

Balmukund

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

matineit — Tue, 25 Aug 2009 11:18:20 GMT

Dear Sir,

Can you show all IP address of all node (MyDC,MyNode1,MyNode2)?

Thanks

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

matineit — Tue, 25 Aug 2009 11:51:19 GMT

Dear Sir,

I don't under stand this step :

1. Rename the nodes to MyNode1 and MyNode2 (still in Workgroup).

How can I rename the my computer name to MyNode1 and MyNode2 ? because after I finish Create Member Servers (MyNode1 and MyNode2) then I go to right-click on my computer and see that :

My Computer Name : MyDC.MyCluster.com

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

blakhani — Tue, 25 Aug 2009 12:01:11 GMT

Not sure if I understood your question correctly... Below are IP Addresses...

MyDC - 192.1.1.1

MyNode1 - 192.1.1.2

MyNode2 - 192.1.1.3

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

blakhani — Tue, 25 Aug 2009 12:03:06 GMT

Hi matineit,

DCPromo need to be run on one of the virtual servers and 2nd virtual server and 3rd virtual server would join the domain.

Regards,

Balmukund

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

matineit — Tue, 25 Aug 2009 12:10:47 GMT

Dear Sir,

Can you detail the step when I take 2nd and 3rd Virtual Server join the domain ? Because you said we need only one computer it can create cluster sql.

Thanks

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

blakhani — Tue, 25 Aug 2009 16:21:39 GMT

you need to refer my earlier reply about virtual server. let me try to explain again.

you need to install virtual server 2005 on your machine and create three virtual machine. In my whole series I never suggested to make any change to physical OS. MyNode1, MyNode2 and MyDC are virtual machines hosted on physical hardware.

please feel free to reply back if you need more clarity.

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

matineit — Wed, 26 Aug 2009 03:42:48 GMT

Dear Sir,

Sorry, Now I need to clearly with you again. This is my step will build the first cluster sqlserver :

1- Is it I need 3 Computers ?

2- Do I need to install Virtual Server on each machine (3 computers) ?

3- What OS for MyNode1 and MyNode2 (Window 2003 server or it can Windows XP) ?

Much Thank for your support.

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

blakhani — Wed, 26 Aug 2009 08:16:45 GMT

Hi,

Please note that this whole blogs series is to help you in getting your hands dirty before playing with production.

Below are the answers

1. No, you need only one computer

2. No, only one computer needed for whole blog series.

3. Windows 2003 is used on virtual machines.

If you are creating a true cluster for production then you need real storage (SAN), real hardware computers.

Regards,

Balmukund

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

matineit — Wed, 26 Aug 2009 10:12:28 GMT

Hi,

If you said need only one computer for dong cluster sql server , How can I start MyNode1 and MyNode2 ?

I can follow your step until Create Virtual Machine but I can't re-name computer name to MyNode1 and MyNode2.

Can you detail this step ?

Thanks

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

matineit — Wed, 26 Aug 2009 11:36:51 GMT

Hi,

Can you tell me the password for login to MyDC ?

Thanks

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

blakhani — Sat, 29 Aug 2009 15:25:50 GMT

Hi matineit,

Sorry for delay in response.

It looks like are making your own machine as domain controller. I don't know password of your machine.

As exaplined earlier, you need to use Virtual Machines to play with.

For vhd's password, you should refer to ReadMe file which comes along with vhd.

Regards,

Balmukund