locked
Linked Server connection timeout RRS feed

  • Question

  • OLE DB provider "SQLNCLI10" for linked server "CHC-SQLREP01" returned message "Protocol error in TDS stream".
    OLE DB provider "SQLNCLI10" for linked server "CHC-SQLREP01" returned message "Communication link failure".
    Msg 65535, Level 16, State 1, Line 0
    Session Provider: Physical connection is not usable [xFFFFFFFF]. 
    OLE DB provider "SQLNCLI10" for linked server "CHC-SQLREP01" returned message "Communication link failure".
    Msg 65535, Level 16, State 1, Line 0
    Session Provider: Physical connection is not usable [xFFFFFFFF]. 
    OLE DB provider "SQLNCLI10" for linked server "CHC-SQLREP01" returned message "Communication link failure".
    Msg 1236, Level 16, State 1, Line 0
    TCP Provider: The network connection was aborted by the local system.

    I have a local server in and I connect to linked server but the query times out before completion.

    How can get this query completed without timing out?.

    Wednesday, February 12, 2014 10:58 PM

Answers

All replies