Add Node To Analysis Services Failover Cluster: In our previous article we have seen on how create SSAS cluster Instance, as a fresh installation and also saw how to create named instance multi-dimensional model but the same follow for tabular model as well.
In this article we will see how to add the SSAS cluster as part of cluster for other nodes as well, please follow the below steps to do so. Please check this article before following this doc.
Add Node To Analysis Services Failover Cluster
Step 1: Open the SQL Server installation media and click on New SQL Server Failover Cluster Installation.
Step 2: Skip the product update!
Step 3: I have also told you earlier that make sure everything is passed, if there is any error please fix it, as shown below.
Step 4: Select the addition which you want in my case, I will go with developer since it has all the features in it.
Step 5: Please agree the terms and conditions and hit next.
Step 6: Once done as you can see in the below screenshot that already the newly created SSAS instance is present, so what you have to do is just hit next because we can’t do any sort of changes here as the cluster has already recognize, which cluster should be part of this note.
THE CLUSTER NETWORK NAME IS SQLABFCIMULTI, BUT AS YOU REMEMBER IN OUR LAST VIDEO OR ARTICLE, WE HAVE CREATED A NAMED INSTANCE SSAS CLUSTER SO IT IS ASKING US TO JOIN TO THAT SEQUEL SERVER NAMED INSTANCE, WHICH IS OUR SSAS INSTANCE?
Step 7: You can also see the IP which we have configured earlier. We can’t make any changes so hit next.
Step 8: Now give the password for the account which we have used as a part of sql server analysis services, Service account.
Step 9: You will see all the summary listed below, but as I told there is no changes which we can make here as this article is regarding adding a note to the cluster so all the configuration has been done in our previous article, which is our installed, standalone sequel, fluster.
Step 10: As you can see in the below image that this particular note is part of our SSAS failover cluster, and now we are good to go to test this in SMSS.
If you see in the below image, I have connected successfully to my SSAS cluster using the network name which we have configured during the time of installation, now we can conclude that our failover cluster is running and up, so we manage to installed this node as a failover cluster.
This complete our article on SSAS cluster. If you have further more doubts or suggestions, please feel free to come down or you can also watch our video for further more assistance.
Hope you got the idea on how to install SSAS as part of WSFC, to make it work just add the others node this cluster and we are good to configure the things as a part of SQL/SSAS Failover Clustering. Check out this MS Doc
