Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Timeout on Vista not XP

Author  Topic 

benander
Starting Member

1 Post

Posted - 2009-08-10 : 23:41:58
We are running a TPA tool that queries our SQL 2008 cluster. The problem is that it will error out with

System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

This is definately a Vista/server 2008 problem. The tool works on all XP and server 2003 machines. I looked at wireshark output from one time when it worked (it randomly works sometimes, maybe 1 in 100), and when it didn't work and I couldn't find any differences. Even when it didn't work there were correct Ack,Fin packets.

I found this on MSDN

http://msdn.microsoft.com/en-us/library/ms190181.aspx

and am just wondering if this is the correct assumption. If this is the case would the solution be code related or config (on the machines it does not work on)?

Thanks,

Ben
   

- Advertisement -