Ers: Connection Failed, Connection Read, Connection Write
Someone should get around to it soon but this is a connectivity issue.
Here are some basic things to do in the meantime:
- Check for any errors in the SQL errorlog at the times of the failures. If there are access violations, then make sure
you have the latest service pack.
- Check if you can use any SQL Server client utility to connect to the SQL Server from those clients with the problems.
If this is successful, you will need to use SQL Profiler to trace what was the last query your app was executing?
- Is the server PING'able from the client using the servername? If no, this is a network problem.
- Are the clients having the problem on a different subnet? If so, then more network problems
- Is SQL Server responding at all to any connection, including a local connection on the server itself? If responding, then
network or possible SQL errors in the errorlog.
-Keith
=================================================
* This posting is provided "AS IS" with no warranties, and confers no rights.
* Please do not send email directly to this alias.Respond to newsgroup
--------------------
|>Newsgroups: microsoft.public.sqlserver.programming
|>Subject: Re: Ers: Connection Failed, Connection Read, Connection Write
|>
|>Keith...
|> Have not gotten an answer from any of then, including .connect...
|>
|>
|>:-(
|>
|>-js
|>
|>> This is being cross-posted to multiple groups, including .Connect which is
|>a better place to get an answer.
|>>
|>> =================================================
|>> * This posting is provided "AS IS" with no warranties, and confers no
|>rights.
|>> * Please do not send email directly to this alias.Respond to newsgroup
|>>
|>> --------------------
|>> |>Newsgroups:
|>>
|>microsoft.public.sqlserver,microsoft.public.sqlserver.connect,microsoft.publ
|>ic.sqlserver.misc,microsoft.public.sqlserver.od
|>>
|>bc,microsoft.public.sqlserver.programming,microsoft.public.sqlserver.server
|>> |>Subject: Ers: Connection Failed, Connection Read, Connection Write
|>> |>Date: Mon, 12 Nov 2001 20:47:17 GMT
|>>
|>> |>
|>> |>I am suddenly getting lots of these errors from people in our remote
|>office
|>> |>connecting through a dedicated T-1 circuit(s) to our server.
|>> |>
|>> |>They use ADO, the connection string explicitly declares TCP/IP as the
|>> |>connection type (NTL=TCPIP).
|>> |>
|>> |>Everything else about our network is working fine.
|>> |>
|>> |>[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionWrite
|>(send())
|>> |>
|>> |>[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead
|>(rcvd))
|>> |>
|>> |>[Microsoft][ODBC SQL Server Driver]Communication link failure
|>> |>
|>> |>
|>> |>
|>> |>
|>>
|>>
|>
|>
|>
|>
