• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 944
  • Last Modified:

help solving: transport-level error has occurred ...

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.) (Microsoft SQL Server, Error: 10054)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=10054&LinkId=20476
0
Jagdish Devaku
Asked:
Jagdish Devaku
  • 2
2 Solutions
 
James MurrellProduct SpecialistCommented:
http://support.microsoft.com/kb/109787

says 10054 Connection reset by peer. [NT only]
This can happen if a sockets client (which includes SPX) is actively sending or receiving data to or from SQL Server, and the network connection is lost. This error is usually seen in conjunction with error 17824 when on sockets-based connections. For example, an Microsoft Windows NT client using the NWLink SPX transport could be selecting data from SQL Server, and if the network cable is unplugged from the SQL Server computer, you will see error 10054.
0
 
i2mentalCommented:
That's the error you get when you lose connection to the server. I happens if you unplug the cable, close your laptop, had a router fail, or any number of other network interferences.
0
 
James MurrellProduct SpecialistCommented:
any luck?
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now