Set up the profiler to catch events(login, tsql, sp et al) created by the application user. Track each of the activity of the user & determine at what step the timeout occurs. It need not be at the database level, sometimes connection strings have a time limit & if your query runs longer, the timeout error occurs