Unfortunately named pipes doesn't work through a firewall. Is there a method to make it work?

Did anyone figure this out? I am getting the same error intermittently in ASP since moving the SQL server behind a firewall.

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (recv()).

I figured it out - the new network driver setting was on half duplex, causing collisions which resulted in orphaned sessions

Thanks for the advice.

What do you make of this: I updated the antivirus defs on the sql server and after that the machine was so slow that people couldn't make...

Yes, it was restored by administrator mapped to sa and dbo. The only tables showing in that particular database (the others on the server are fine) are system tables. The...