In a windows 2000 .NET service, we continuously process fact tables
into cubes. Typically every 15 minutes the service picks up available
fact tables, builds cubes and deletes the fact tables.
The processing part is done using DSO. However, on some occasions, the
DSO loses connection to the Analysis Services, and the processing
fails. On logging the error that we get, we found that the error given
by Analysis Services is one of:

System.Runtime.InteropServices.COMException (0x80040075): Connection
to
the server is lost
at DSO._Partition.Process(ProcessTypes ProcessOption)

or

System.Runtime.InteropServices.COMException (0x80040033): Cannot
connect to the repository.

or

System.Runtime.InteropServices.COMException (0x80010108): The object
invoked has disconnected from its clients.
at DSO.ServerClass.get_MDStores()

or

System.Runtime.InteropServices.COMException (0x80010108): The object
invoked has disconnected from its clients.
at DSO.ServerClass.get_State()

We found a link describing something similar, and a
workaround:http://support.microsoft.com/default.aspx?kbid=823357
But the above problems happen even after we changed the memory
settings as were suggested.
At all times the OLAP service is in the running state and is not found
to be dead when the error occurs.

Can you suggest any more solutions to this problem of intermittent
connection loss?

Thanks

I am using SQL server 2000 with Service pack3 for both SQL server and
Analysis services.