Donnerstag, 18. August 2011

Unable to connect to Analysis Services

If you are running multiple instances of Analysis Services on your machine (I am running MSSQLSERVER2008 - which is default instance - and MSSQLSERVER2008R2), you may get the following error when connecting to the non-default instance (via SQL Management Studio):

No connection could be made because the target machine actively refused it 127.0.0.1:2382 (System)


I solved the problem by running the Sql Server Browser as LOCAL SYSTEM instead of NETWORK SERVICE. Open Sql Server Configuration Manager -> Right click 'SQL Server Browser' and open the properties -> Chose 'Local System' as Built-In account in the 'Log on as' tab