I'm thinking that it might not be timing out waiting on the sql server, rather it might be odbc timing out from trying to get the network connection to work, and you might want to check that your networking between the front end and sql server is not flakey.