Solved

Creating a second Virtual Machine on a windows server 2008 Cluster

Posted on 2010-09-06
5
566 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
For anyone that has accidentally used newSID with Server 2008 R2 (like I did) and hasn't been able to get the server running again because you were unlucky (as I was) and had no backups - I was able to get things working by doing a Registry Hive rec…
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

626 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