| Author |
Topic |
|
nusolmc03
Starting Member
5 Posts |
 Posted - 2010-09-13 : 14:28:13
|
| I've got a working w2k3 2-node cluster with the following:C:Q:\Quorum (2GB)S:\SQL (1TB Presented from HP EVA SAN)During the SQL 2008 Cluster installation I get the following error: The cluster on this computer does not have a shared disk available. To continue, at least one shared disk must be available.In Cluster Administrator - Resources I see the following: Disk Q: Cluster IP AddressCluster NameI don't see my S:\SQL disk and when attempting to create a new Physical Disk resource called Shared Disk I don't see this disk listed as an available resource under Dependencies. Am I missing something obvious with the disk? Any responses appreciated. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-09-13 : 15:25:55
|
| are you installing SQL from the node that owns the shared disk(s)? |
 |
|
|
nusolmc03
Starting Member
5 Posts |
Posted - 2010-09-13 : 16:38:41
|
| Yes. The SQL installation is being performed on the first node which owns the resources. I can see the C, Q, and S drives fine.The questions for me is should I see my S:\1TB drive under Resources in Cluster Administrator?tia |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-09-13 : 17:03:00
|
| yes. you looked at this already? http://support.microsoft.com/kb/955780 |
|
|
|
nusolmc03
Starting Member
5 Posts |
Posted - 2010-09-13 : 17:19:52
|
| Yes I've viewed that article and I come away with the same question, should my S:\SQL drive be seen as a disk resource in cluster administrator? If so then this may be the cause of my SQL failures because my S:\ doesn't appear as a resource. When attempting to create the resource I'm not seeing the S:\ drive as an option.Am I right or wrong in this analysis?tia |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-09-13 : 17:22:34
|
| you're right. you need to be able to see S: in cluster administrator, else you can't use it.are you trying to make a share (s:\sql$) the shared resource? |
|
|
|
nusolmc03
Starting Member
5 Posts |
Posted - 2010-09-13 : 22:04:38
|
| Correct! I'm not sure why I'm unable to see the disk but if I'm reading the documentation right I should be able to create a new shared physical resource, resource type as Physical Disk, and use my S:\SQL drive. So I'm wondering if there's an issue with the disk. Is there anything else I can do to confirm this? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-09-14 : 00:18:37
|
| I could be wrong here, but I think you need to make it a drive, not a share. In other words, it needs to be S: not S:\SQL$ (again, I could be wrong on this point).Logged into the active node, can you see S: in My Computer?Can you add it as a new resource in the SQL Server Group? |
|
|
|
nusolmc03
Starting Member
5 Posts |
Posted - 2010-09-14 : 06:13:51
|
| I can see the drive as S:\ in My Computer and I'm unable to add it as a new Physical Disk Resource in SQL. I don't see it as an option. |
|
|
|
|
SQL 2k8 Install - Shared Disk Issue