Joy i believe that is a function of the application that is doing the connecting...for example SSMS will wait forever, whereas any application that is creating an instnace of a SQLConnection gets a default timeout of 30 seconds; there is a parameter ont he SQLCommand to change the timeout.
Since the application decides how long it will wait for SQL to respond, I don't think you'll find a server side setting for it.
Lowell