Install/Configure Analysis Services on SQL Server Always-on Nodes

Riaz 0 Reputation points
2023-03-09T06:20:13.15+00:00

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,

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,616 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,242 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. PercyTang-MSFT 12,426 Reputation points Microsoft Vendor
    2023-03-09T08:28:44.4466667+00:00

    Hi @Riaz

    You can install SSAS on a local disk.

    You can refer to the official documentation.

    https://learn.microsoft.com/en-us/analysis-services/instances/install-windows/install-analysis-services?view=asallproducts-allversions

    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.