I presented a new lun to the sql server 2012 cluster and tried to restore a database to the new storage. I got the below error:
“System.Data.SqlClient.SqlError: Cannot use file ” 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. (Microsoft.SqlServer.SmoExtended)”
To resolve this I had to go to the Failover cluster manager –>services and applications–>SQLServer (MS SQLServer) (highlight it) and in the Other resources select the SQL Server services–> Right click –> Properties–>Dependencies–>Insert (select the drive that you needs to be added or the ones that you presented to the cluster).This fixed the error.
Hope this helps!