Solved

Creating a second Virtual Machine on a windows server 2008 Cluster

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

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Want Win 10 Pro to search like Server 2010 or 2012 27 112
Windows 2008 set profile 9 49
AD Account lockout 11 68
Tips on reducing the size of AD (DIT) database 5 35
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.
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
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 process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

749 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