I connect to my sql server in my asp scipts. The connection sting is: application("connection")="Provider=SQLNCLI;Server=18.104.22.168\SQL2k5,1435;Database=database;Uid=user;Pwd=password;
Many times I get a timeout error with my queries. Apparenlty from the ms sql manager the connection has fewer problems.
The only thing I can thonk of is an ptimized connection string.