SQL Server can't see the new SAN storage | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL Server can’t see the new SAN storage

All, I have a 2-node 2000 cluster on Win 2003 Advanced server. The SE recently added new SAN storage (5 logical names as U, V,..Y). The new drives appear in the Cluster resource. The sql server can be failed over between the 2 nodes. I can also see the drives on the current node and am able to create new folders/files. But, the SQL Server can not see those new drives. What could be the problem? Thanks for any response.
OldTiger
http://www.sql-server-performance.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=1773 for reference. HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Yes, saw that link and found out that my new drives were not in the Dependant drives. But I am not able to add it to the SQL Server resource because it wanted the sql server to be offline. Could you please show the steps to ebale the new drives? thanks a lot,
OldTiger
Have you refreshed the SQL Server services after the addition on Cluster resouce? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
the new drives were on the cluster resource (but were not added to sql server resource depandency). both nodes were bounced and even the sql server was restarted. Now that we know the problem (new drives not added to sql server resource depandency), the remaining problem is on the steps to enable them for sql server. thanks,
OldTiger
– Move the disks into the sql server cluster group and bring them online
– Take the sql service offline in the group
– Add the drives as dependencies
– Take the sql service online in the group SQL Server should now be able to see the disks. Make sure that the SQL Server Service and Agent accounts have administrator permissions in any folders it will be using for databases. The accounts also need "List Folder Contents" permission on the root level of the new drives.
]]>