Connection has been closed by peer.

  • Hi,

    I used linked server in a procedure which was working fine for two months, Now i am getting the below error..

    DB version : 2005 sql server

    Linkedserver DB Version : 2008 sql server.

    Error Message

    Executed as user: XXXX\SQL_Services. Session Provider: Connection has been closed by peer [xFFFFFFFF]. [SQLSTATE 42000] (Error 65535) Session Provider: Connection has been closed by peer [xFFFFFFFF]. [SQLSTATE 42000] (Error 65535) Session Provider: Connection has been closed by peer [xFFFFFFFF]. [SQLSTATE 42000] (Error 65535) OLE DB provider "SQLNCLI" for linked server "DBINST02" returned message "Protocol error in TDS stream". [SQLSTATE 01000] (Error 7412) OLE DB provider "SQLNCLI" for linked server "DBINST02" returned message "Communication link failure". [SQLSTATE 01000] (Error 7412) OLE DB provider "SQLNCLI" for linked server "DBINST02" returned message "Communication link failure". [SQLSTATE 01000] (Error 7412) OLE DB provider "SQLNCLI" for linked server "DBINST02" returned message "Communication link failure". [SQLSTATE 01000] (Error 7412). The step failed.

    Please share your ideas if you had the same issue.

  • we did not change db settings and used separate service account with sysadmin rights.

  • This was removed by the editor as SPAM

  • we fixed the issue.

    Problem is , we have snapshot database which recreated every 15 mins. So my procedure is getting this error

    Thanks for all..

  • k.thanigaivel (8/21/2012)


    we fixed the issue.

    Problem is , we have snapshot database which recreated every 15 mins. So my procedure is getting this error

    Thanks for all..

    Can I ask what cured this for you?

    We're seeing this intermittently as well and also make use of snapshots.

    With thanks!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply