locked
TCP Provider: An existing connection was forcibly closed by the remote host. (Source: MSSQLServer, Error number: 10054) Get help: http://help/10054 RRS feed

  • Question

  • Hi Team,

    we have 1 replication setup on production server.Publisher and distribution are on same server and subscriber is at other end.

    We are getting above error lots of time. Data has been transfer from publisher to distribution but it is not transferring from distribution to subscriber.Replication monitor showing around 25262718 pending from distribution to subscriber.

    Error Messages :-

    TCP Provider: An existing connection was forcibly closed by the remote host. (Source: MSSQLServer, Error number: 10054)
    Get help: http://help/10054
    Communication link failure (Source: MSSQLServer, Error number: 10054)
    Get help: http://help/10054

    Thanks 

    Aniket N

    Friday, July 14, 2017 5:40 AM

All replies

  • Hi Anu321,

     

    This problem can be caused by a lot of network issues including but not limited to:

     

    • Workstations set to Stand By, Sleep or Hibernate when not used for a period of time.
    • Timeout settings on SQL Server, disconnecting idle sessions.
    • Faulty network infrastructure causing the connection to the server to be dropped. This includes bad Wireless quality.
    • Not installing critical updates, causing a faulty network driver to drop the connection.
    • The Database Property under Options "Auto Close" was set to True allowing the server to close "inactive" connections. This must be set to False.

     

    You can refer to this document to troubleshoot it: https://msdn.microsoft.com/en-us/library/ms187005.aspx

     

    Best Regards,

    Teige

     


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Proposed as answer by Teige Gao Tuesday, August 1, 2017 7:24 AM
    Friday, July 14, 2017 9:48 AM
  • In my experience this is most frequently caused by port 1433 or 1434 not open on the subscriber, the browser service not running on the subscriber, or the sql server not running on the subscriber.
    Friday, July 14, 2017 10:04 AM
    Answerer
  • I am getting this error frequently: TCP Provider: An existing connection was forcibly closed by the remote host.

    Seems like there is a network issue and Infra Team is looking into it. 


    Thanks Shiven:) If Answer is Helpful, Please Vote

    Friday, July 10, 2020 5:39 AM