SQL Server 2014 Setup is failing using #CSV #SQL14 #WFC #ws2012r2js

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 Winking smile 

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.

image

 

image_thumb[8]

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

image

image

 

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.

image

image As you can see now you can select both CSV volumes. and one normal disk for the Analysis Services Winking smile

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 !

image

 

and if we are looking to the ini files it should be OK

; The Database Engine root data directory.

INSTALLSQLDATADIR="C:\ClusterStorage\Volume1"

; Default directory for the Database Engine user database logs.

SQLUSERDBLOGDIR="C:\ClusterStorage\Volume2\MSSQL11.SQL002\MSSQL\Data"

; Directory for the Database Engine TempDB log files.

SQLTEMPDBLOGDIR="C:\ClusterStorage\Volume2\MSSQL11.SQL002\MSSQL\Data"

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.!

image

 

image image

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 Winking smile

image 

Follow me on twitter : https://twitter.com/clustermvp

Author: Robert Smit [MVP]

Robert Smit is Senior Technical Evangelist and is a current Microsoft MVP in Clustering as of 2009. Robert has over 20 years experience in IT with experience in the educational, health-care and finance industries. Robert’s past IT experience in the trenches of IT gives him the knowledge and insight that allows him to communicate effectively with IT professionals who are trying to address real concerns around business continuity, disaster recovery and regulatory compliance issues. Robert holds the following certifications: MCT - Microsoft Certified Trainer, MCTS - Windows Server Virtualization, MCSE, MCSA and MCPS. He is an active participant in the Microsoft newsgroup community and is currently focused on Hyper-V, Failover Clustering, SQL Server, Azure and all things related to Cloud Computing and Infrastructure Optimalization. Follow Robert on Twitter @ClusterMVP Or follow his blog https://robertsmit.wordpress.com Linkedin Profile Http://nl.linkedin.com/in/robertsmit Robert is also capable of transferring his knowledge to others which is a rare feature in the field of IT. He makes a point of not only solving issues but also of giving on the job training of his colleagues. A customer says " Robert has been a big influence on our technical staff and I have to come to know him as a brilliant specialist concerning Microsoft Products. He was Capable with his in-depth knowledge of Microsoft products to troubleshoot problems and develop our infrastructure to a higher level. I would certainly hire him again in the future. " Details of the Recommendation: "I have been coordinating with Robert implementing a very complex system. Although he was primarily a Microsoft infrastructure specialist; he was able to understand and debug .Net based complext Windows applications and websites. His input to improve performance of applications proved very helpful for the success of our project

12 thoughts on “SQL Server 2014 Setup is failing using #CSV #SQL14 #WFC #ws2012r2js”

  1. Regarding this statement: “and after the SQL Server setup you can do the Analysis Services setup” – How do you re-run setup to add AS to an existing clustered instance that you created on the first pass? None of the SkipRules switches will get me back to where I can add AS to the existing cluster.

  3. When I try this, it gives me the error: ‘The folder path ‘E:\MSAS12.INSTANCE\OLAP\Data’ is located on a shared disk’. Yes! – I want this on the shared disk and not the CSV. Just to be clear, I was adding AS to the existing clustered install of the database engine that is on a CSV volume. Do they need to be different instances? The disk does show as Available Storage in the cluster manager.

  5. Correct – I already have the database engine installed on a CSV volume and went back to add AS as you mentioned above but on the share disk that I have available (not a CSV). The interesting thing here is that when I come back in to add AS to the existing installed features, it does not ask me which available storage I want to install it in like it does on the first pass through with the storage engine – why is that? It is almost as if it doesn’t know that it is installing a clustered node anymore. I can’t figure out what I am missing here.

  6. I am facing the same issue. Let me know, if you guys have a fix for it. If yes, please share.

  8. Hi Robert, have you figured out a way to add tempdb files to SQL Server 2014 on a CSV? I can do it from the GUI, but using a SQL statement fails. It seems they didn’t do a very good job of integrating CSV support in 2014!

    Thanks

  9. Hi,
    I don’t understand your problem ? When installing the SQL server with the CSV I places all my DB on a CSV
    C:\ClusterStorage\Volume1\MSSQL12.MSSQL002\MSSQL\DATA
    as you could see in the screen shots
    but you could use this to move the DB
    SELECT name, physical_name
    FROM sys.master_files
    WHERE database_id = DB_ID(‘tempdb’);

    ALTER DATABASE tempdb MODIFY FILE ( NAME = tempdev , FILENAME = ‘F:\TempDB\tempdb.mdf‘ )
    ALTER DATABASE tempdb MODIFY FILE ( NAME = templog , FILENAME = ‘F:\TempDB\tempdb.ldf‘ )
    ALTER DATABASE tempdb MODIFY FILE ( NAME = tempdev2 , FILENAME = ‘F:\TempDB\tempdb2.ndf’ )

  10. Hi Robert. All my DB files are on the CSV, in a path like yours. But when I try to do this, it fails:

    USE [master]
    GO
    ALTER DATABASE [tempdb] ADD FILE ( NAME = ‘tempdev1’, FILENAME = ‘C:\ClusterStorage\sqlstore\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\tempdb1.mdf’ , SIZE = 100MB , FILEGROWTH = 10%)
    GO

  11. Hi Robert. I’m trying to follow your explanation but its giving me a headache, My bad sure. But could you please provide me a step by step full detailled with screens of how you deployed this SQL 2014 Cluster failover with SSAS on CSV? I’m really trying but nothing seems to work. Im doing the advanced install.
    Thanks

  12. CSV usage is depending on the storage you must use shared disk on your cluster nodes. with out this there is no CSV.
    I have a pending blog item on sql2016 this could be helpful.

    create a cluster and add the disk you have to the cluster but must be shared disks!! then add disk to the cluster and right click on the disk add to CSV and done. there are plenty of samples on my blog about this and there is also a little youtube movie

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.