uninstall of clustered SSAS instance may disable “olap redirection service”

  “OLAP redirection service” is the part of SQL browser service that supports SSAS connectivity. If you stick to our recommendation to only use “virtual server name” for connecting to clustered SSAS instances (see previous post: http://blogs.msdn.com/b/as_emea/archive/2014/01/08/connecting-to-clustered-ssas-instances.aspx), then you won’t need the “olap redirection service”. However, we are aware that there are some situations where…


"Analysis Services MOLAP Performance Guide for SQL Server 2012 and 2014" has been released

Thanks to the efforts of our US support colleagues Karan Gulati and Jon Burchel we now have an updated version of the SSAS performance guide available.  The “Analysis Services MOLAP Performance Guide for SQL Server 2012 and 2014” document can be downloaded from MSDN via the following link: http://msdn.microsoft.com/en-us/library/dn749781.aspx As the name suggests it contains advice…


New SSAS failover clustering white paper released

I’m glad to announce that we released an SSAS failover clustering whitepaper that fills in a large white spot in our documentation. It discusses many SSAS clustering aspects including setup + configuration, deployment modes, connectivity, and administration. Many thanks to MVP Alan Hirt and Heidi Steen from the MS content team for all the efforts…


How to connect to clustered Analysis Services instances

While clustered SSAS instances have been around for a while, we noted that there is still some confusion about the recommended way for connecting to clustered instances and our supportability policy. Let’s start with the hopefully well known behavior for non-clustered SSAS instances. Stand-alone Instances All default SSAS instances will listen on port tcp 2383….