If you want to create a SQL Server 2014 cluster and place the Databases on a Cluster shared volume just make sure that you have one disk left that is not a CSV volume else your SQL setup will fail. but why the requirements are SQL server 2014 is supported with CSV. And this is not a bug, this time it is your fault ! yes you are the problem
Read on I show you the problem !
The cluster disk ‘Cluster Disk 4’ can not be used as a cluster disk. Analysis Services on WFC cluster cannot have files on Clustered Shared Volume (CSV) locations.
the error in the setup will be “ cluster shared disk available check “ Failed.
just add a disk to the cluster iscsi or FC just as place holder. or do we need this disk, I did try a full install of the SQL Cluster
The CSV is only for the Database and not for a Analysis Services or any other SQL part!
The cluster disk ‘Cluster Disk 4’ can not be used as a cluster disk. Analysis Services on WFC cluster cannot have files on Clustered Shared Volume (CSV) locations.
Unselect the Analysis Services and restart the setup.
As you can see now you can select both CSV volumes. and one normal disk for the Analysis Services
I’m placing the Logfiles on the storage pool my storage pool is build up of less fast disk and will save costs here. unless you will see slow performance !
and if we are looking to the ini files it should be OK
; The Database Engine root data directory.
INSTALLSQLDATADIR="C:ClusterStorageVolume1"
; Default directory for the Database Engine user database logs.
SQLUSERDBLOGDIR="C:ClusterStorageVolume2MSSQL11.SQL002MSSQLData"
; Directory for the Database Engine TempDB log files.
SQLTEMPDBLOGDIR="C:ClusterStorageVolume2MSSQL11.SQL002MSSQLData"
and after the SQL Server setup you can do the Analysis Services setup
Now you will have the Databases and the Log files on a different CSV and the Analysis Services on a own clustered disk.!
So remember the CSV volumes are not showing in the Cluster Resource , as you know the CSV is connected to every Cluster node and is always there!
Keep this in mind when you do some troubleshooting and you can’t find the disks
Follow me on twitter : https://twitter.com/clustermvp