I'm having a problem with my asp.net application deployed over an SQL server back end. Actually it works fine but then at some point in time, for some reason, when retrieving data from any given table I get an error message of connection timeout expired.

Actually I have tried to empty syslogs, restart SQL server and it would eventually turn out to work again. But I dont have any concrete clue of why this would occur. I should be missing something here, anyone has ideas?

All help appreciated.

thanx.