I have two w2k3 Servers on a SAN. I also have separate instances of SQL Server on the separate physical servers. I have have set up a cluster between the two. And I also have them in separate groups. I am trying to set up an active/active on SQL Server. However, when I try to set up the 2nd virtual server for the active/active cluster, I get an error that says,
'The path, x:\Program Files\Microsoft SQL Server, that you have chosen is either not on a cluster disk resource, or if it is, the resource may be unavailable for the following reasons:
-The disk resource is owned by another node.
-You are installing a virtual server, but selected a disk which is in a group with a virtual server already in it.

HELP!

Ok, so a 2 node cluster. 1 instance of SQL that fails over perfectly? Now
you want to add another instance and do A/A? You have two groups, but does
each group have a separate disk resource? Say X for Group 1, Y for Group 2?

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering

"DBA" <DBA (AT) discussions (DOT) microsoft.com> wrote

between the two. And I also have them in separate groups. I am trying to set
up an active/active on SQL Server. However, when I try to set up the 2nd
virtual server for the active/active cluster, I get an error that says,
unavailable for the following reasons:

Yes they are on separate physical win2k3 servers

"Rodney R. Fournier [MVP]" wrote:

Other question. Do I need to set up the sql server cluster prior to a w2k3 server cluster

"Rodney R. Fournier [MVP]" wrote:

Agreed two servers (nodes in clustering). They also need shared storage, SAN
or SCSI based. Can you tell us more about your clustering groups. Does
failover currently work?

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering

"DBA" <DBA (AT) discussions (DOT) microsoft.com> wrote

I am currently just setting them up. When I tell them to initiate failure, it seems to work fine

"Rodney R. Fournier [MVP]" wrote:

No. You need to first setup up Windows cluster server and then setup SQL Server 2000 failover clustering. SQL cluster runs on top of Windows cluster.

For additional information please review

Microsoft Whitepaper - SQL Server 2000 Failover Clustering
http://www.microsoft.com/SQL/techinf...vercluster.asp

Need more references, here you go :

Microsoft SQL Server 2000 High Availability Series
http://www.microsoft.com/technet/pro...y/sqlhalp.mspx

Microsoft Webcasts

Introduction to Microsoft SQL Server 2000 Clustering
http://support.microsoft.com/default...lurb051001.asp

Microsoft SQL Server 2000 Virtual Server: Things You Should Know
http://support.microsoft.com/default...lurb032602.asp


Microsoft SQL Server 2000 Virtual Server Basic Setup, Maintenance, and Service Pack http://support.microsoft.com/default.aspx?
scid=/servicedesks/webcasts/wcd061002/wcdblurb061002.asp

Microsoft SQL Server 2000 Failover Clustering Disaster Recovery Procedures
http://support.microsoft.com/default...lurb101802.asp

Troubleshooting SQL 2000 Virtual Server and Service Pack Setups for Failover Clustering

http://support.microsoft.com/default...lurb020703.asp


Microsoft Knowledge Base Articles

Q243218 INF: Installation Order for SQL 2000 Enterprise Edition
http://support.microsoft.com/?kbid=243218

Q260758 - INF: Frequently Asked Questions - SQL Server 2000 - Failover Clustering
http://support.microsoft.com/?kbid=260758

Best Regards,

Uttam Parui
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest
way to do this is to visit the following websites: http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

However,
When I do this I get an error saying that the system files
could not be found to complete setup. What does that mean?
Also when I look at the Cluster admin, the only thing that
does not start is the virtual SQL Server itself. The IP
add and net name are fine
cluster runs on top of Windows cluster.
http://support.microsoft.com/default.aspx?
Security Tool Kit, please visit
against viruses and security vulnerabilities. The easiest