SqlClient.SqlException: General network error.

  • Thread starter Thread starter Danny
  • Start date Start date
D

Danny

Hello there,

I've been reading up so many postings on this topic for days now and
have tried most suggestions to resolve my error without success - I
was hoping some fresh thoughts on the issue might help come up with a
solution.

The problem is this:

I have a long running sql query that, while quite complex, can be
summarised as performing a series of table creations, table drops,
table reads, updates, and inserts. I am executing this query from an
ASP.NET Windows Service using an SQLConnection object and an
SqlCommand object. The query is to be run on SQL Server 2000 that
resides on a Windows Server 2003 machine.

The query appears to run for an indeterminate period of time quite
happily until seemingly at random (well it may not be) I recieve the
following error:

:System.Data.SqlClient.SqlException: General network error. Check
your network documentation.

At that point, any other SqlConnections within the same application
that may have been open and running their own commands are also
severed with the same error.

I have also been able to reproduce this problem by running the query
manually using query analyser from a remote machine also.

Summary of architecture:

[Machine A: Windows Service] <------> [Machine B: Sql Server 2000]
or
[Machine A: Query Analyser] <------> [Machine B: Sql Server 2000]

Iwould be sincerely greatful for any ideas on this matter.

Regards,

Danny
 
A co-worker once gave me a chunk of SQL that did the same thing. It
was moving about 30 million records across two databases on the same
machine. I never pinpointed why this error would occur, but I know it
was putting a lot of stress on SQL server. Deadline was approaching.
I redid the functionality in a DTS package using bulk insert and
everything worked very smoothly from there.
 
Back
Top