Hi All
i did the same changes recommended here(changed MaxActiveReqForOneUser to 0). it worked for few days now again the same error had occured. Now the things i can see is even Analysis services becomes unavailable.(can't get accessed from management studio too.)The state of the service is abnormal (can't say it is running or stopped).
The server is quite OK around 300 GB free space availabe with 4 GB Ram.
The size of OLAP cube is around 5GB.
Can anybody help me out on this?