Tuesday 2 October 2012

SQL Server 2008 SSAS Deployment problem

A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. (Microsoft.AnalysisServices.AdomdClient)

well.... in my case, SQL Browser was running, and so were two named instances of SSAS.
I could connect to the named database engines with no problems.

In order to get SSAS to work, I found this article:
http://msdn.microsoft.com/en-us/library/cc917670.aspx

my instance of SQL Browser was running as 'LOCAL SERVICE' and it needed to run as 'LOCAL SYSTEM'