We have an application developed using ASP.NET and connects to SQL server 2000 using ADO.NET. We've been encountering a "general network error" sporadically. The problem appears to only happen when the application is running in a production enviroment and the web server where database server are on two different devices (same network).

I've seen others post this problem, but I haven't found any solution.

Can anyone please help?