I have a few web servers connection to MSSQL7 using odbc. I connect them with TCP/IP network library. Few days ago, some of the web servers fail to connect to the DB (TCP/IP, General Network Error).

When I switch those web servers to using Named pipes, they work ... I'm wondering what's causing the TCP/IP to suddenly fail, and is TCP/IP or Named pipe a better choice?