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.
| Author |
Topic |
|
mikebird
Aged Yak Warrior
529 Posts |
 Posted - 2009-09-18 : 05:04:57
|
| Msg 10054, Level 20, State 0, Line 0. A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)This is what I saw when running a query, using sp_who2 activeto monitor it's progress amongst other jobs, and when updating sp_who2 active I got this result. It's happened many times. As soon as the error happens, another query runs immediately. No need to reconnect. Other users are upset by interference to their data applications.Does it mean locks, lack of resource... memory, disk...? It's queries run in SSME or Crystal Reports - all SELECT - nothing else at all. |
|
|
|
|
|
Connection Lost