[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 575
  • Last Modified:

Creating a second Virtual Machine on a windows server 2008 Cluster

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
stebennettsjb
Asked:
stebennettsjb
  • 3
  • 2
1 Solution
 
Neil RussellTechnical Development LeadCommented:
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
 
Neil RussellTechnical Development LeadCommented:
0
 
stebennettsjbAuthor Commented:
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
 
stebennettsjbAuthor Commented:
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
 
stebennettsjbAuthor Commented:
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now