stebennettsjb
asked on
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
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
ASKER
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
The article i quoted from isn't talking about Virtulization (Hyper-V, VMware etc). Just multiple instances of SQL on the same cluster.
S
ASKER
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I think you need to do a lot of reading and planning before you go anu further at all.