Solved

Creating a second Virtual Machine on a windows server 2008 Cluster

Posted on 2010-09-06
5
552 Views
Last Modified: 2012-06-21
Hi,

Im trying to create a SQL Cluster with multiple Instances. To install a second instance onto a Node i need to create a new Virtual Machine on the cluster.

Can anyone expain how this is done. I just spent several hours googling and come up short to say the least. finding only a few gloss over MS documents and no real explanations.

Im working from this Quote

[u]You can run only one instance of SQL Server on each virtual server of a SQL Server failover cluster, although you can install up to 16 virtual servers on a failover cluster.[/u]

So my question is

How do you install Multiple Virtual Servers on Windows Server 2008

Thanks for any help or links to decent reference material!

S
0
Comment
Question by:stebennettsjb
  • 3
  • 2
5 Comments
 
LVL 37

Expert Comment

by:Neil Russell
ID: 33613651
You need to be running a Hypervisor first and formost. Are you running Hyper-V on your 2008 server? Or VMWare?
I think you need to do a lot of reading and planning before you go anu further at all.
 
0
 
LVL 37

Expert Comment

by:Neil Russell
ID: 33613675
0
 

Author Comment

by:stebennettsjb
ID: 33613702
As i read it, the virtual server its talking about is the cluster instance.. ie when you cluster 2 servers you create a virtual server for clients to connect to. Am i reading this totally wrong? or just failed at explaining what i need?

The article i quoted from isn't talking about Virtulization (Hyper-V, VMware etc). Just multiple instances of SQL on the same cluster.

S

0
 

Author Comment

by:stebennettsjb
ID: 33613731
Reading my post again ive clearly not explained myself very well.

My question is:

In a windows server 2008 Cluster. How do you create 2 virtual machines for the clients to connect to.

Normal case:

2 servers with ip address 10.10.0.1 and 10.10.0.2 clustered =  clients connect to "virtual machine" 10.10.0.3

I believe (From a MS article below) to create multiple instance of SQL server 2008 on the cluster i need to create a new ip address for clients to connect to ie 10.10.0.4

http://msdn.microsoft.com/en-us/library/aa174516(SQL.80).aspx

Hope this helps clear it up and thanks for the quick replies!

s
0
 

Accepted Solution

by:
stebennettsjb earned 0 total points
ID: 33634570
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
A safe way to clean winsxs folder from your windows server 2008 R2 editions
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question