881223 - How to add a Share Disk resource to a cluster?

Question

Post reply

881223 - How to add a Share Disk resource to a cluster?

hamidi 97216

Ten Centuries

Points: 1217
More actions
March 14, 2010 at 12:18 am

#216666

hi
i've created a Windows Server Cluster with two nodes. the resources included in this cluster are of kind "Cluster IP Address", "Cluster Name" and "Majority Node Set". there're only these three resources in the cluster. the cluster is not erroneous. when installing SQL Server 2008 Enterprise Edition on the first node (New SQL Server failover cluster installation), i get the following error:
Rule "Cluster shared disk available check" failed.
The cluster on this computer does not have a shared disk available. To continue, at least one shared disk must be available.
i tried to add such a resource. but no "Share Disk" resource type available to create a new instance of. instead there's a "Share File" resource. does this error mean that i've to create a new resource of type "Share File" in the cluster?
what must i do?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic882515-1549-1.aspx

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

hamidi 97216 Ten Centuries Points: 1217 More actions · Answer 2

hi

i'm really sorry. i didn't meant cross-posting. i just found a more proper forum after posting and didn't know how to delete the post from General or move it.

apology...

d4d4u1 SSC Enthusiast Points: 101 More actions · Answer 3

ok, I have the same issue.

I have a shared drive setup on both nodes, in vmware, both are using the scsi1:6 channel and lun for the drive.

in cluster admin I have the drive as a resource and no dependencies with the drive.

so where am i getting this wrong, it is like it is not seeing the shared HDD, but it is there in the cluster group and setup as a resource physical drive.

d4d4u1 SSC Enthusiast Points: 101 More actions · Answer 4

ok, I added a third drive, put it on its ownscsi 1:8, and setup the drive in both vmware nodes, then setup the resource as a physical drive and SQL has no problems now with the install.

so you need 3 drives, 1-shared Quorum, 2-shared MSDTC and a 3-as shared drive.

Problem solved.