Solved

Creating a second Virtual Machine on a windows server 2008 Cluster

Posted on 2010-09-06
5
562 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

OfficeMate Freezes on login or does not load after login credentials are input.
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…
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

734 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