I am running SQL2005 EE/Win2003 64bit. I have jobs that process data into the SSAS db/ cubes. Periodically the jobs just hang (without loading data) and I am unable to connect to SSAS using SS Mangement Studio & Profiler etc. I can find no errors or diagnostics or predict if/when it will happen again.
If I restart the SSAS service, everything works - till the next time.
Has anyone experienced / overcome a similar problem please ?