MSCS Active/Active Cluster problem

[Kevin Marefat]

Hi,

I am tryingto add ISCSI storage to an existing MSCS active/active cluster and am running into problems and am looking for community and vendor support.

There are 3 server s involved:

WINDB2 - windows 2003/StarWind Target offers 2 targets
P_OL1 - node1 of an MS cluster, Windows 2003/MS initiator
P_OL2 - node 2 of the cluster, similar to P_OL1

Current Shared Disk Aubsystem is an HP MSA2012

I did follow the instructions in the 3/2009 PDF exactly and still have the same problem:

1. LUNS are carved out using StarWind, and connected using MS initiator for Windows 2003 Server
2. Drives are created, partitioned and formatted
3. Resources are created into the cluster and assigned to cluster groups
4. Failover (move group) successfully tested
5. Drives are available to the OS and successfully tested for read/write
6. The SQL Server still does not see the new drives

I appreciate your assistance in advance.

Thanks,
Kevin

[Robert (staff)]

Hello Kevin,

Where is your SQL server located? Is on WINDB2?

Thanks

[Kevin Marefat]

Hi Robert,

The SQL resides on a clustered virtual server called VSDB1, which normally runs on the node 1 of the cluster and moved to node 2 when a fail over occurs. Not to complicate matters but that is half of an active/active cluster set up. a second virtual server called VSDB2 runs normally on node 2 of the cluster and moves to node 1 when a fail over occurs. I have logs available as well, and thank you for your response.

Kevin

[AccuMegalith]

Have you added the new drives as dependencies for SQL Server? In other words, the SQL Server resource needs to have these two new drives as dependencies for this resource. Clustered SQL Server 2000 (and later) won't even acknowledge disks on which it's not dependent, and won't let you create databases on them. This makes sense, as it would be bad for SQL Server to come online when one or more clustered disks containing databases didn't. It's more consistent, and protective of data, if the SQL Server process fails to come online at all.

[Robert (staff)]

Kevin,

If AccuMegalith's suggestion does not help, please send us the log files from the StarWind PC.

Thanks.