• Not sure my replies are going through. The column issue has been resolved.

    Getting the following errors:

    OLE DB provider "SQLNCLI10" for linked server "23.23.209.111" returned message "Protocol error in TDS stream".

    OLE DB provider "SQLNCLI10" for linked server "23.23.209.111" 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 "23.23.209.111" 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 "23.23.209.111" returned message "Communication link failure".

    Msg 10054, Level 16, State 1, Line 0

    TCP Provider: An existing connection was forcibly closed by the remote host.

    Might be a network connection either to or from the linked server. I can ping it fine though. Can't be permissions as I am using the sa account

    Busy investigating