It is still necessary to add SSAS to an existing FCI to uninstall and install the instance

Vinicius Napoleão D. Ribeiro 0 Reputation points


Today I have a productive environment in SQL Server 2017 on FCI (node 1 & node 2). The need arose to install SSAS and also leave it in high availability. However, this environment has a DR (node 3) that is configured with several BAG (Basic Availability Group).

The reference documentation I found for SQL Server 2012 says the following:

If you want to add SSAS to an existing FCI, the only supported way to achieve this is to uninstall and reinstall the instance.

I would like to know if already in the 2017 version it would be possible to just add the SSAS service without the need to uninstall the current environment.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,811 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,102 questions
Windows Server Clustering
Windows Server Clustering
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Clustering: The grouping of multiple servers in a way that allows them to appear to be a single unit to client computers on a network. Clustering is a means of increasing network capacity, providing live backup in case one of the servers fails, and improving data security.
803 questions
{count} votes