Query timed out if run from the application

Last Post 12 May 2009 11:42 AM by leohalim. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

12 May 2009 11:42 AM
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?


Acceptable Use Policy