I've been working on this problem for the last two weeks with no soltuion.
I have an application server on the DMZ running on Windows server 2008 64 bit and accessing a 64 bit cluster SQL 2005. The application is running on .NET Framewroks 1.1 SP 1. When I enter my credential on the UI of the application, the application runs a set of query and returns the result. In my case, the query times out all the time.
So I installed SQL Server Management studio and run the same query that the application runs. The query returns the result within one second.
I talked to both Networking people and the application people and basically they are pointing at each other.
Any opinion on this problem?