Groups | Blog | Home
all groups > sql server clustering > october 2006 >

sql server clustering : Problems with Virtual Test Environment setup



Wayne
10/16/2006 4:21:36 PM
Has anyone successfully created a test setup with Virtual Server 2005 RC2
using two shared resources: Quorum and Shared Disk Array. I have followed
the "Using MicroSoft Virtual Server 2005 to Create and Configure a Two-Node
Microsoft Window Server 2003 Cluster" document and everything works fine but
I am at a loss as to how I am supposed to add the Shared Disk Array so it
can be used/included as a Cluster resourse. I can add it via Primary Channel
(1) to both; however, it is not a true shared resource and so I can only
have one node on at a time if I add it that way.
When I try to install the SQL 2005 ( failover cluster option) the only
resource that I see is the Quorum volume...

Am I missing something simple??


P.S. have read the following from a previous posting
If you want to create a cluster for evaluation and/or training purposes,
download Microsoft Virtual Server (a free product download).

Get these documents:

Using Microsoft Virtual Server 2005 to Create and Configure a Two-Node
Microsoft Windows Server 2003 Cluster
http://www.microsoft.com/technet/prodtechnol/virtualserver/deploy/cvs2005.mspx

Installing a Failover Cluster
http://msdn2.microsoft.com/en-us/library/ms179410.aspx

TechNet Support WebCast: How to cluster Microsoft SQL Server 2005 by using
Microsoft Virtual Server
http://support.microsoft.com/default.aspx?kbid=891798

How to Configure Virtual Server 2005 in Order to Setup a Test SQL Server
Cluster
http://www.sql-server-performance.com/installing_sql_clustering_virtual_server1.asp

Russ Kaufmann (MVP)
10/16/2006 6:43:02 PM
[quoted text, click to view]

What I always do is create the disks first. Make sure they are fixed in
size. Then add the adapters. Make sure you add the SCSI adapters. Make sure
that you check the box to enable it for clustering.

Part of the problem is likely that you are trying to do too much with each
adapter. The way that VS 2005 works, you can only have one disk per SCSI
adapter, so create more than one and then attach the disks. So, for example,
one disk will be connected to SCSI 0, a second disk would be connected to
SCSI 1.

Make sure that you also configure the scsi adapter on one node to be ID of 6
and the other node with an ID of 7.


--
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

The next ClusterHelp classes are:
Denver starting Nov 14th
NYC starting Dec 4th.

Wayne
10/17/2006 8:04:03 AM
Thanks for the tip: I was able to configure the diskarray in a couple of
minutes. I, as you said, was trying to do too much on one channel. I did try
the second adapter earlier, but I must have mixed up the numbers and it
through an error.Anyway, using both SCSI adapters I have been able to create
both a Quorum and a DiskArray which mirrors our physical setup!
Excellent!!
W.
[quoted text, click to view]

AddThis Social Bookmark Button