This post originated from an RSS feed registered with .NET Buzz by douglas reilly. Original Post: SQL Server CommandTimeout issue Feed Title: Doug Reilly's Weblog Feed URL: http://www.asp.net/err404.htm?aspxerrorpath=/dreilly/rss.aspx Feed Description: ASP.NET and More... Latest .NET Buzz Posts Latest .NET Buzz Posts by douglas reilly Latest Posts From Doug Reilly's Weblog

I have an application (originally a Windows Service, now testing with a Console mode application).

The program works perfectly on my home network.  On the site where it needs to be deployed, the problem is this: The connection works perfectly, yet when I do a DataAdapter.Fill() or Command.ExecuteReader(), it never returns, and timesout.  I initially thought it was a very slow query, but the same thing happens when the SQL is to return a single row based on a value of the primary key (which should return immediately).

The only thing unusual is that the program is accessing the SQL Server over a VPN.  I do not think this is the issue, as the connection connects just fine (meaning there is not port issue).  I have no real physical access to the live database server.