cluster ? on muliple data disks

Hi,
I have setup a 2 node a/p cluster. During install i picked the s drive as
the data drive, and the L drive as the log drive.
i was able to create a db on the S drive
now i want to create a database and use the z drive. but it won't show me
the Z drive as a option when i try to browse to a different drive as part of
the create new db steps.
both disks are disk resources managed by the cluster
in the past, i have been able to do it on a non clustered server
what is the trick with a cluster?The "trick" is twofold. First, you have to make the disks Cluster Resources
and put them in the resource group for the SQL virtual server. I am
guessing this is where you are at. Second, you have to make the SQL Service
dependent on the disk resource. You will have to take the service offline
to make the change. Look at the dependency relationship between the SQL
service and the existing disk resources.
Geoff N. Hiten
Microsoft SQL Server MVP
"jason" <jason@.discussions.microsoft.com> wrote in message
news:FA7F35A5-7EDE-4162-90CE-E6AAD7D43057@.microsoft.com...
> Hi,
> I have setup a 2 node a/p cluster. During install i picked the s drive as
> the data drive, and the L drive as the log drive.
> i was able to create a db on the S drive
> now i want to create a database and use the z drive. but it won't show me
> the Z drive as a option when i try to browse to a different drive as part
> of
> the create new db steps.
> both disks are disk resources managed by the cluster
> in the past, i have been able to do it on a non clustered server
> what is the trick with a cluster?|||Geoff, that did it thanks!
"Geoff N. Hiten" wrote:

> The "trick" is twofold. First, you have to make the disks Cluster Resourc
es
> and put them in the resource group for the SQL virtual server. I am
> guessing this is where you are at. Second, you have to make the SQL Servi
ce
> dependent on the disk resource. You will have to take the service offline
> to make the change. Look at the dependency relationship between the SQL
> service and the existing disk resources.
> Geoff N. Hiten
> Microsoft SQL Server MVP
> "jason" <jason@.discussions.microsoft.com> wrote in message
> news:FA7F35A5-7EDE-4162-90CE-E6AAD7D43057@.microsoft.com...
>
>