FMS: Read Failures/General SQL Error/[Microsoft][SQL Native Client]Communication Link
On our 2 finance machines we are consistantly getting the following error when FMS is left open and not used for somewhere between 10-20 minutes:
General SQL Error.
[Microsoft][SQL Native Client]Communication Link failure.
It causes a particular problem if in the middle of working on something like a bank rec for example.
There is an article on SupportNet but it simply directs you to a Microsoft KB. In this case it talks about disabling the TCP Chimney Offload, which I have done and it's made no difference.
I would raise a call with Captia but I suspect they will say goto Microsoft has the KB instructs. Has anybody else seen this problem and if so how did you resolved it?
We are using FMS Summer 2011 on Windows 7.