Cannot See SAN Disk Drives

I've installed sql server 2005active/passive cluster on Win 2003 Ent Edition
boxes connected to 3 SAN drives L, M, S.
When setup asked me where to install datafiles i choose the S drive.
SP1 installed, everything looks good, failover succesfully both ways.
However in SQL Server Managment Studio i don't see L and M drives.
In cluster admin under resources I see all 3 drives which are owned by Sql
Server 2005 group.
But when i try to detach and move the tran log from S to M i don't see M.
When i go to attach db i only see the S drive.
How can i add the L and M drives to be visible to Sql Server?
Thank you
Stop the SQL Server service, add the M & L drives as dependencies to the
resource. Restart everything and use away!
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"Alex S" <alexsdba@.aol.com> wrote in message
news:OlJ46FZ6GHA.3288@.TK2MSFTNGP02.phx.gbl...
> I've installed sql server 2005active/passive cluster on Win 2003 Ent
> Edition boxes connected to 3 SAN drives L, M, S.
> When setup asked me where to install datafiles i choose the S drive.
> SP1 installed, everything looks good, failover succesfully both ways.
> However in SQL Server Managment Studio i don't see L and M drives.
> In cluster admin under resources I see all 3 drives which are owned by Sql
> Server 2005 group.
> But when i try to detach and move the tran log from S to M i don't see M.
> When i go to attach db i only see the S drive.
>
> How can i add the L and M drives to be visible to Sql Server?
>
> Thank you
>
>
|||Most likely your SQL Server resource does not depend on the drive L and M
disk resources. In Cluster Admin, bring the SQL Server resource offline, and
add those two disk resources as its dependencies. Bring the SQL Server
resource online, you should be ready to go.
Linchi
"Alex S" wrote:

> I've installed sql server 2005active/passive cluster on Win 2003 Ent Edition
> boxes connected to 3 SAN drives L, M, S.
> When setup asked me where to install datafiles i choose the S drive.
> SP1 installed, everything looks good, failover succesfully both ways.
> However in SQL Server Managment Studio i don't see L and M drives.
> In cluster admin under resources I see all 3 drives which are owned by Sql
> Server 2005 group.
> But when i try to detach and move the tran log from S to M i don't see M.
> When i go to attach db i only see the S drive.
>
> How can i add the L and M drives to be visible to Sql Server?
>
> Thank you
>
>
|||IT WORKED.
THANK YOU
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:%23JKiWNZ6GHA.4608@.TK2MSFTNGP05.phx.gbl...
> Stop the SQL Server service, add the M & L drives as dependencies to the
> resource. Restart everything and use away!
> Cheers,
> Rodney R. Fournier
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://www.msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
> ClusterHelp.com is a Microsoft Certified Gold Partner
>
> "Alex S" <alexsdba@.aol.com> wrote in message
> news:OlJ46FZ6GHA.3288@.TK2MSFTNGP02.phx.gbl...
>
|||IT WORKED.
THANK YOU
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:2E663D4D-3A0E-4F09-81D1-F348DA2F15AF@.microsoft.com...[vbcol=seagreen]
> Most likely your SQL Server resource does not depend on the drive L and M
> disk resources. In Cluster Admin, bring the SQL Server resource offline,
> and
> add those two disk resources as its dependencies. Bring the SQL Server
> resource online, you should be ready to go.
> Linchi
> "Alex S" wrote: