Setting within SQL Server 2000 that I have over looked?Д«etter way to utilize Wireshark to find more answers? Setting in a router or switch the network team may have over looked? I HAVE SEARCHED HIGH AND LOW ON GOOGLE FOR A RESOLUTION FOR THIS ISSUE. Ran SQL Profiler at the same time and did not see anything out of the ordinary during the RST

Issue does not occur with SQL server Enterprise Manager. None of the switches have security ACLвЂ™s configured on them.ДЄlso they stated that NAT was not turned on. The traffic flows like this:Дesktop->Access Switch->Distro Switch->Core Switch->Datacenter Switch->SQL Server There are no firewalls or proxies in between SQL Server and your desktop. I consulted with network team and this is the response back: Issue does not occur if connecting to SQL on the server itself. Issue does not occur if I connect to any other SQL server 2000 server. I checked all settings within SQL Server 2000 against another server and they all seem to be the same. Attached below is the capture from the client Machine. I also ran a capture on the SQL Server and noticed the TCP RST reset command as well. Sure enough it was receiving a TCP RST reset every 5 min if the connection idled longer than 5 min. Next I went to wireshark and ran a capture on the client pc's nic card. I would have to right click on the instance and refresh for it to re-establish the connection. I would no longer be able to refresh my tables or any other object/node within the object browser in Query Analyzer. I discovered that if I connected to the database using Query Analyzer and let the connection idle for 5 minutes it would disconnect. So, I went through my normal trouble shooting steps to isolate or reproduce the issue. Recently I had a web developer come to me and ask why he was receiving connection errors in his app that was accessing a sql database.

Sql server client tcp reset connection