I have a Win 2003/SQL 2005 cluster. Now I am installing SSAS. The default path chosen by the installer is C:\Program Files\Microsoft SQL Server\MSSQL.3\ (there are 2 instances of SQL on the cluster).
It doesn't seem to make sense to install on the C: drive, which is a local drive, not shared by both nodes of the cluster.
I found this Microsoft article
Data root directory -- For failover cluster installations, ensure that data directories are placed on the shared disk.
But then under Notes it says -- Program files and data files cannot be installed in the following situations: On shared drives on a failover cluster instance.
So should I create a directory such as:
S:\Program Files\Microsoft SQL Server\MSSQL.3\OLAP
on the SAN and install there?
Finally, in the installer I have to choose 3 different directories:
The default for SSAS
Do these all go under the OLAP folder?
Thank you very much!
View Complete Post