I have a 2 node windows 2003 cluster with SQL Server 2005 running. The first node is the owner of SQL which has dependencies on the D: (Data), E: (index), F: (Log), H: (TempDB), and T: (Backup) drives. We have one database running with the files distributed across these volumes. We are trying to add another database but when I go to add it it gives me the following error:
Cannot use file 'D:\MSSQL.1\MSSQL\Data\test.mdf' for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used. Either the disk resource containing the file is not present in the cluster group or the cluster resource of the Sql Server does not have a dependency on it.
The database that runs on the cluster is located in the same location, so we know that it can see that resource and the SQL cluster group has the drive as a dependency. Any ideas?
Image of SQL dependencies: http://imgur.com/s1bf5