troubleshooting Question

SQL Server Error 10054

Avatar of GreggPeele
GreggPeele asked on
Microsoft SQL ServerMicrosoft Dynamics
6 Comments3 Solutions2485 ViewsLast Modified:
We have SQL SERVER 2000 Enterprise Edition with Service Pack 2.  It is running on  Windows 2003 Server R2   Standard Edition with Service Pack 2.  
It runs several databases and   Microsoft Dynamics SL Application.  The main database is about 80 GB.   Recently , the application users have been getting "Sql server Error  10054 - Possible Network error : write to Sql Server Failed. General Network error." .   All users on the application get locked or disconnected from the server ; they have to terminate the task , and login again into the application.  This error occurs only  on those workstations which have logged on to the main database that is 80GB.  The users of  other databases on same server are not affected.   So far,  we have already verified that there is no problem with the switch, network card or server.  We have replace the network card on the server.  DBCC Checkdb returned 0 errors.  There is no particular process or  application screen that could be identified as a cause of this problem.  The error repeats several times in the day.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 3 Answers and 6 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros