August 20, 2012 at 10:51 pm
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.
August 21, 2012 at 4:41 am
we did not change db settings and used separate service account with sysadmin rights.
August 21, 2012 at 5:11 am
This was removed by the editor as SPAM
August 21, 2012 at 7:43 am
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..
August 28, 2014 at 3:40 pm
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