« Previous Next »

• 10-17-2009, 11:29 AM

  Toby.Considine Joined on 10-15-2007, 6:47 PM Posts 7

  Vista IIS7 and connecting to external SQL Timeouts Reply Contact I do my ASP.NET development on my Vista 64 workstation with IIS 7. If the database is local, everything works well. If the database (MSSQL2k5 or MSSQL2k8) is remote, I get timeouts unless everyquery has 5 minutes or more to complete. This makes development / debugging well nigh impossible. The only error I ever get is timeouts on DB calls.  This does not appear to be a debugger issue (VS2k8) because the behavior is the same if I call up the same pages in IE. The same code runs fine on production servers against the same external DBs. The same conenction strings work fine in console applications (discount network issues). I am not using trusted connections, so I do not suspect any number of impersonation / Kerb issues. I can connect to all the databases from console apps using the same connection strings just fine. I assume it is some sort of over-arching IIS on Vista 64 config issue - but three days of searching have found many others reporting similar problems with nless details, and no answers.

  Tags: IIS 64 Vista SQL Perfromance

• 10-17-2009, 2:59 PM

  In reply to

  Toby.Considine Joined on 10-15-2007, 6:47 PM Posts 7

  Re: Vista IIS7 and connecting to external SQL Timeouts Reply Contact New detail: I seem to be timing out on the creation of recordsets. The problem stops if I turn on impersonation (which I shouldn't have to do). Impersonation does not affect the SQL server, as this is true even when hosting remote hosted SQL. I am guessing that it has to do with filelocking on some local temp file used by ADO.NET or something of that sort. Stillnot a clue as to why, or how to fix it other than the unacceptable work-around of turning on impersonation.

• 10-21-2009, 4:48 AM

  In reply to

  Leo Tang - MSFT Joined on 12-11-2008, 9:47 PM Posts 952

  Re: Vista IIS7 and connecting to external SQL Timeouts Reply Contact Hi, Since the problem stopped by turning on impersonation even when hosting remote SQL Server. I assume you use Windows Integrated Authentication connecting to SQL Server. Without the impersonation, your pages run in the security context of the application pool identity(If you are using Visual Studio built-in web server, pages running under the current windows log on account). If the account not have permissions connected to the remote SQL Server, you will encounter this issue. If this is your scenario, one option to resolve this issuer is using SQL Server Authentication. If your problem persists, you can run SQL Profiler to pinpoint the exacts cause of this issue. Also you can post this question at ASP.Net forum, the  engineers and community members can help you in a more efficient way. Leo Tang Microsoft Online Community Support Please remember to mark the replies as answers if they help and unmark them if they provide no help.

• 10-21-2009, 9:32 AM

  In reply to

  Toby.Considine Joined on 10-15-2007, 6:47 PM Posts 7	Re: Vista IIS7 and connecting to external SQL Timeouts Reply Contact Thanks for the suggestions, good all, but I am not using trusted connections, so I do not suspect any number of impersonation / Kerb issues. It is something that is preventing delaying establishment of connnections not requiring trust.