A client could not bring the Analysis Service online in a cluster, and the logs only said Error 1067. Here is the systematic approach that found the cause.
Migrate SQL Server Cluster Storage to New Disks
To migrate cluster storage for a SQL Server failover cluster, add the new disks to the SQL Server role, take the instance offline, copy the files with their permissions, give the new disks the old drive letters and bring the instance back. This post lists every step, the checks to run first, the quorum and MSDTC disks, and the T-SQL alternative that changes file paths.
QL SERVER – Unable to Create Listener: Msg 41009 – The Windows Server Failover Clustering (WSFC) Resource Control API Returned Error Code 5057
Creating an AG listener failed with Msg 41009: the Windows Server Failover Clustering (WSFC) resource control API returned error 5057. Here is the fix.
SQL SERVER – Error 1324. The folder path ‘Program Files’ contains an invalid character.
Error 1324. The folder path ‘Program Files’ contains an invalid character. Let us fix the error with the help of the solution in the blog.
SQL SERVER – Empty Startup Parameter in SQL Cluster on One Node
Many problems lead to the same symptom. Here is another reason for an empty startup parameter in SQL Cluster, when it was not a registry permission issue.
SQL SERVER – Install Error: Standalone SQL Server on WFC Cluster Cannot Have Files on Shared Disk Locations
SQL Server 2014 setup failed with an Install Error: standalone SQL Server on a WSFC cluster cannot have files on shared disk. Here is why and what to do.
SQL SERVER – Patch Rule Failure: Not Clustered or the Cluster Service is Up and Online
A SQL Server 2016 service pack failed the rule “Not clustered or the cluster service is up and online”. Here is what Detail.txt showed and how we fixed it.