Solved

Windows Server 2003 R2 Cluster and EqualLogic iSCSI SAN

Posted on 2009-05-05
1
1,079 Views
Last Modified: 2013-11-14
I'm building a SQL Server 2000 cluster on Server 2003 R2 Ent.

I'm pretty far into this build and I would hate to start from scratch if I don't need to.  The cluster works well with the basic cluster services and the cluster disk (Q:).  Everything fails over fine and all event logs and the cluster logs are clear of errors.  I start having problems when I add physical disk resources and new groups into the cluster service.  I've added three physical disks for SQL Server use to node 1.  I also added the same disks to node 2...just with node 1 disconnected from the SAN.  So both servers have access to all three volumes.  With node 2 disconnected ...I've opened cluster admin on node 1 and added the disks to the cluster in a new group called SQL Server.  I've also configured MSDTC on node 1 with an additional physical disk (M:).  Once created I brought all new disk resources on line.  So...from node 1 I have access to all disks required.  This includes the Q: drive, M: drive, and three for SQL server use.  The cluster groups are setup with the appropriate resources in each group.

The problem comes in when I turn on Node 2.  This node cannot access the Q: or M: drives...storage manager shows unreadable volumes but no drive letters in either storage manager or windows explorer.  This is expected since the cluster service is reserving the drives.  The three volumes created for SQL though do show up with drive letters on node 2...and they are labeled as online.  Even though Node 1 has these volumes mounted and the cluster server shows them as online.  I have 2 of the 5 drives working great.  Any ideas?  EqualLogic support suggests starting from scratch and ensuring the persistent drives registry key is added prior to setting up the cluster.  I really don't want to start from scratch...I'm close but can't seem to figure out why these three drives are not behaving.
0
Comment
Question by:Sagiman75
1 Comment
 
LVL 7

Accepted Solution

by:
dolomiti earned 500 total points
Comment Utility
hi,
discover the 3 disks from Node1, take notes of their LUNs, (from Disk Properties)
format them, assign a letter, a label, and create in each of them a little file:
Disk2-Lun1-PartitionI
Disk3-Lun2-PartitionJ
Disk4-Lun3-PartitionK

If you can, shutdown node1, if you are not still in production.
Discover disks from Node2: you have now not to format partition, but you have to assign
letters, or if it has done by itself, verify that the letters correpond with the little files:
verify filename and LUN.

Power On both servers, and create a Resource Group with just these 3 disks.
Bring on line, and verify failover. If all OK, destroy test Group, delete little files,
and start with the SQL Cluster Setup.

bye
vic
0

Featured Post

Scale it in WD Gold

With up to ten times the workload capacity of desktop drives, WD Gold hard drives employ advanced technology to deliver among the best in reliability, capacity, power efficiency and performance.

Join & Write a Comment

Suggested Solutions

In this article we have discussed the manual scenarios to recover data from Windows 10 through some backup and recovery tools which are offered by it.
How to update Firmware and Bios in Dell Equalogic PS6000 Arrays and Hard Disks firmware update.
In this Micro Tutorial viewers will learn how to use Windows Server Backup to create full image of their system. Tutorial shows how to install Windows Server Backup Feature on Windows 2012R2 and how to configure scheduled Bare Metal Recovery backup.…
In this Micro Tutorial viewers will learn how to restore their server from Bare Metal Backup image created with Windows Server Backup feature. As an example Windows 2012R2 is used.

763 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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now