SQL Server Analysis Services Clustering

Leave a comment (0) Go to comments

Does Microsoft SQL Server Analysis Services (SSAS) Supports clustering ?

YES, Microsoft SQL Server Analysis Services (SSAS) supports windows clustering.

SQL Server Analysis Services is independent service and SSAS resource is not dependent on the SQL Server Database Engine resource.

Analysis Services on clustered environments listens on the default port – TCP 2383. Even if it is installed as a named instance.

Analysis Services will automatically detect that it is running on a cluster, and so it ignores the port server configuration property and listens on the default port.

Note:

  1. Rename of Analysis Services Instance name of clustered environment is not supported.
  2. SQL Server Analysis services shares SQL Server Installation Center and all those restrictions are applicable to SSAS also, which we has in SQL Server Database Services.
EOF - SQL Server Analysis Services Clustering, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.