SSAS , No connection could be made because the target machine actively refused it

[irfanhaleem hotmail com]

I am running a MDX query on a Cube. When I parse or run that query It gives me following error: A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient) No connection could be made because the target machine actively refused it 172.16.1.86:2383 (System) When I click OK button , I see the connection to the server is lost. Then I login to Analysis Service Server manchine, I come to know that the Analysis Service has been stoped. Then I start the service again and tried to parse the query , It behaved in the same way. But If I run any other MDX query , It works fine .... PLease help me in this regard, Irfan

[Wendelius]

So are you saying that when you start the analysis services, it stops when you run a query against it. If that's the case, try to find related error messages from Windows Event Log.

The need to optimize rises from a bad design.My articles[^]

[S Douglas]

Do all MDX queries cause SSAS to crash? Or just the one you are trying to run?

---

Common sense is admitting there is cause and effect and that you can exert some control over what you understand.