SQL Server Error: 10060 SQL Server Error: 10061

Ok, new entry with connectivity problems and examples.   The scenario: You have a SQL Server 2005 that is up and running you also know that the SQL Browser service is up and running. So on the server side, all is well.   On a side note, if you do not know what the SQL…

5

TCP connections hanging in the CLOSE_WAIT and FIN_WAIT_2 state.

The other day I had an interesting case, and since there was very little information about this, I thought I’d share it.   The problem in short, a customer is running a web application that connects to SQL Server and very rapidly they were running out of TCP ports/sockets. Normally this type of problem occurs…

7