System.Data.SqlClient.SqlException: General network error.

[mb224]

Has anyone seen this error situation before?

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

i have setup 2 servers successfully ... now on a 3rd server at a different ISP that we are trying to migrate to..... I can read data from my database .. but when I try to update it fails! i get

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

1. The SQLAccount that the SQLService runs under has Full Control to the database folder ... so its not a permissions issue .....

2. running SQL Server 2000 standard edition ... on Windows 2000 Advanced Server .NET framework 1.0

i have researched articles which say .. increase the SQLCommand.CommandTimeout .. (did not work!) .. increase Max Connextion Pooling .. or even disable connection pooling.... still no good!

i have tried to change the Network library ..used , update MDAC ... still no good!

Has anyone faced a similar situation?

What else can I try

 

[stsuing]

Yes, and I never figured it out. Seemed to work after a reboot. Very frusterating.

 

[mb224]

i rebooted but it did not work! truely frustrating!

 

[AtomicChip]

Ain't M$ errors awesome? "General network error..." - tells you a bundle, don't it? Could be a number of things. I'd say try contacting Microsoft and getting their helpdesk to solve the problem (good luck ).

-----------------------------------------------

http://www.liquidfuzion.com

"The night sky over the planet Krikkit is the least interesting sight in the entire universe."
-Hitch Hiker's Guide To The Galaxy