Cannot see my drives in SSMS 2008 R2 when attaching or adding a database

Question

I have 2 servers in a cluster running 2008R2 and SQL2008 R2.  I was adding a disk to the cluster to put some databases on and was not able to see the disk in the management studio.  I was able to see the exising disks when I started.  I read online about the dependancies propery on the disk after adding it in the cluster manager.  After messing with that, I am now unable to see any of the disks when I attach or add a database.  I can type the full path after I get the error message that tells me that "Cannot access the specified path..."

There were 2 disks in the cluster from when it was put together.  They both did not have any dependancies listed in their properties.

Please let me know what I can do!!

Thank you

Tim

Answer 1

Hi Tim,

Assume the disk has been added successfully to the SQL Server clustered instance, you may have a try to input the file path directly to see if it works. Moreover, please check if the SQL Server service account has permissions to access the disk.

For your reference: How to add a new disk to a SQL Server Failover Cluster.

---

Stephanie Lv

TechNet Community Support

Answer 2

NOTE: These steps require a SQL Server outage.

1. With Failover Cluster Manager add/move the disks into the same "services and applications" cluster group as the SQL Server instance (I assume you have already done this).

2) In “Failover Cluster Manager”, on the left, expand “Services and applications”
3) Click on the first SQL Server instance. E.g. “SQL Server (SQL01)”
4) In the middle panel under “Other Resources”, right-click on “SQL Server  (SQL01)” and select “Properties”
5) Click on the “Dependencies” tab.
6) Click on “Click here to add a dependency”
7) In the “Resources” column drop down the list and select the disk
8) Add the other disks as required as dependencies
9) Click “OK”
10) Under "Other Resources", right-click on the SQL Server DB Engine resource e.g. SQL Server (SQL01), and click "take this resource offline"
11) If prompted to take offline click "OK"
12) Bring the whole group back online.

Answer 3

Thank you.  I was putting the dependency in the wrong place.

Got it seeing all the disks now.