SQL Server "General Network Error" 0x80004005

We have had some serious head scratching with a very unhelpful error given on a SSIS package failure.

An OLE DB error has occurred. Error code: 0x80004005.  An OLE DB record is available. 
Source: “Microsoft OLE DB Provider for SQL Server” 
Hresult: 0x80004005  Description: “[DBNETLIB][ConnectionRead (recv()).]
General network error. Check your network documentation.”

The SSIS suite was in the 10th hour of a 15 hour data load (on a test server – not a production server) and this occurred. The previous evening gave a similar error, but at a different point in the evening and a different package.

Some clever investigation by our system/network guy found these two entries from MS support http://support.microsoft.com/kb/942861/en-us and http://support.microsoft.com/kb/951037, which talks about the specific network card we have. After switching off the TCP Chimney Offload, the SSIS load ran successfully.

Latest from this author