MIS Systems Thread, FMS: Read Failures/General SQL Error/[Microsoft][SQL Native Client]Communication Link in Technical; On our 2 finance machines we are consistantly getting the following error when FMS is left open and not used ...
1st December 2011, 01:50 PM #1
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.
IDG Tech News
1st December 2011, 02:25 PM #2
Can't remember if this is either a problem with the network card on the server going to sleep and it's dropping network connections.
Or if it's the fact you shouldn't leave it open and not doing anything. I think it's the above, is it a HP server?
1st December 2011, 02:27 PM #3
Nope. A Dell server. In addition to SIMS/FMS the server also has our cashless catering software/db installed on it, would it really be going to sleep?
1st December 2011, 02:59 PM #4
1st December 2011, 03:06 PM #5
Yes, thats where the link in the SupportNet KB goes. It is a broadcom nic...
1st December 2011, 04:46 PM #6
Big discussion on SupportNet forum about this a while ago, I found swapping the NIC to be the best - assuming you've got a nice Intel server NIC lying around.
Found this topic on here = Help needed with FMS since Capita can't resolve an issue with there own software. - penfold posted about turning the power settings off.
1st December 2011, 04:49 PM #7
1st December 2011, 10:26 PM #8
Also seen that the issue was tracked down to a group policy refresh setting. I have that enabled and have now disabled it to see if it fixes the issue.
Originally Posted by matt40k
By adamf in forum MIS Systems
Last Post: 22nd December 2010, 12:24 PM
By neilault in forum Internet Related/Filtering/Firewall
Last Post: 16th October 2010, 01:50 PM
By UkDraxion in forum Wireless Networks
Last Post: 10th November 2009, 11:37 AM
By Rawns in forum Educational Software
Last Post: 13th August 2009, 05:37 PM
By thom in forum MIS Systems
Last Post: 30th August 2007, 05:50 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)