SQL network connection error

Question Status

Rich Black asked a question on 2 Dec 2008 2:38 PM

I have a single user who occasionally encounters the error message below.  It appears to occur only when running large reports.  I have not found a connection limitation or error messages in the the event logs, and I have never encountered this error before, so I am at a loss.  The error is:

"Microsoft Dynamics GP
A SQL network connection error occurred and your connection was cleared.  This probably occured because all available connections to the server are in use.  Please try again later."

This occurs on GP10 SP1, SQL 2000 SP4, Windows Server 2003 SP2.  Does anyone have any suggestions?

Ron Draganowski responded on 7 Jan 2009 11:17 AM

Is this user either on a wireless connection or a VPN?  If any fluctuation happens in connectivity, then GP will do this.  Only LAN connections (10mbps or greater) are supported for GP.


Ron Draganowski
Solution Services Practice Manager
Olsen Thielen Technologies, Inc.
St Paul, Minnesota


Find me on LinkedIn: http://www.linkedin.com/in/rondraganowski 


Juan Rivero responded on 12 Jan 2009 8:48 AM

I have the same problem too, but for more than one user, and they are all working on the local network, not VPN, not Wireless.

Juan C. Rivero

Network Administrator

Diversified Clinical Services





Frank Diaz responded on 16 Jul 2009 3:58 PM

 Has anyone else found a solution to this error? Same issue here. Users are on a gigabit connection.

Juan Rivero responded on 16 Jul 2009 7:35 PM

It is a hotfixed update from microsoft for w2003 sp2



Apply this on your server and it will fixed the problem

Frank Diaz responded on 22 Jul 2009 2:02 PM

would this hot fix still apply to us if we don't use SNP?

joseg_Ve responded on 4 Apr 2011 7:18 AM

Hey Guys,

   I have been working since 2010 with Microsoft Dynamics GP 2010 and my clients are using terminal server to connect to Dynamics. One of them have the same issue for 6 weeks and I was applying some tips to solve this issue but any plan does not work.

 I don't know if the terminal is the cause of my errors. What do you think?.

Thanks a lot!