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…


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….


SQL 2012 SP1 : Recommended udpate.

Hi, Sorry for bringing up something not strictly related to our ‘cube world’, but more coverage can’t hurt here : If you have installed SQL Server 2012 Service Pack 1, or if you plan to, it is highly recommended to apply a specific subsequent update as quickly as possible. This is announced on the official…


1 hour timeout for data imports in Powerpivot for Excel

This article describes an issue you may face when your data import in Powerpivot for Excel takes longer than 1 hour. Typically you should not run into this type of issue because Powerpivot for Excel was designed as an interactive tool with moderate amounts of data in mind. 1 hour should give you ample time to import all…


Project Server 2007 – Configure OLAP cube when SSAS instance is clustered

Project Server 2007 – Configure OLAP cube when SSAS instance is clustered   Project server 2007 has two very good articles to configure OLAP cube  SSAS 2005 and SSAS 2008 for Project Server 2007.   http://technet.microsoft.com/en-us/library/cc197552(office.12).aspx http://technet.microsoft.com/en-us/library/dd285466(office.12).aspx   But if the SSAS instance is clustered there are some points where extra information is needed.  …