SQL server 2016 Analysis Services high availability

abhrfh 21 Reputation points
2021-08-31T14:47:52.747+00:00

hi. I need to HA my current sql server SSAS node. I am using multidimensional SSAS.
Is there any documentation on this?

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,312 questions
0 comments No comments
{count} votes

Accepted answer
  1. Darren Gosbell 2,376 Reputation points
    2021-08-31T22:26:14.157+00:00

    Yes, there is documentation on this here: https://learn.microsoft.com/en-us/analysis-services/instances/high-availability-and-scalability-in-analysis-services?view=asallproducts-allversions?WT.mc_id=DP-MVP-35889

    SSAS only supports Windows Server Failover Clusters (WSFC) for high availability.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. CarrinWu-MSFT 6,891 Reputation points
    2021-09-01T02:46:44.863+00:00

    Hi @abhrfh ,

    Welcome to Microsoft Q&A!

    Please refer to Analysis Services with Always On Availability Groups to get the steps:

    If you are using availability groups as your high availability solution, you can use a database in that group as a data source in an Analysis Services tabular or multidimensional solution. All of the following Analysis Services operations work as expected when using an availability database: processing or importing data, querying relational data directly (using ROLAP storage or DirectQuery mode), and writeback.

    And you could download SSAS Failover Cluster document from this link.

    Best regards,
    Carrin


    If the answer is helpful, please click "Accept Answer" and upvote it.
    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.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.