This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 20%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Dear All,
We have a 4-nodes Windows cluster (2 HQ nodes, 2 DR nodes); the quorum is file share witness. Windows OS is 2016.
On this cluster, we have SQL Server 2016 & 2019 availability groups. Some AGs have HQ Nodes only, some have HQ & DR Nodes.
In our setup, we don't have shared disks.
We want to install SQL Server 2019 Analysis services in our setup (HQ Nodes only). How we can implement the SSAS with high availability option without the shared disks on the current nodes? Can we use UNC path? I am pretty much new to SSAS world so don't have any idea on how to proceed.
Regards,
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi @Riaz
You can install SSAS on a local disk.
You can refer to the official documentation.
Or you can check out this video, it is very helpful for newbies.
https://www.youtube.com/watch?v=RWtfutxe4zc
Best regards,
Percy Tang
If the answer is the right solution, please click "Accept Answer". If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Dear @Anonymous
Thank you for your feedback.
If we install SSAS on local disk on all involved nodes, how we can make it high available so that the unavailability of one node doesn't affect SSAS?
Regards,
Hi @Riaz
This is a fairly in-depth question. You can refer to these two links.
https://learn.microsoft.com/en-us/previous-versions/sql/sql-server-2012/dn736073(v=msdn.10)
Best regards,
Percy Tang
Hello @Anonymous
Thank you so much for your time in clarifying my doubts.
Actually, I already went through these documents.
Now in our scenario:
(1) We want to install SSAS on the DB Servers (where we already have a windows cluster configured)
(2) We don't have shared disks
(3) We want to configure SSAS as HA (Windows Failover Active/Passive Cluster)
Can we acheive HA for SSAS without using the shared disk and merely with a UNC path?
Regards,