Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Connection has been closed by peer. Expand / Collapse
Author
Message
Posted Monday, August 20, 2012 10:51 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, May 30, 2013 1:44 AM
Points: 45, Visits: 852
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.
Post #1347564
Posted Tuesday, August 21, 2012 4:41 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, May 30, 2013 1:44 AM
Points: 45, Visits: 852
we did not change db settings and used separate service account with sysadmin rights.
Post #1347693
Posted Tuesday, August 21, 2012 5:11 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 8:07 AM
Points: 3,953, Visits: 5,184
Points to consider:
> was there a network issue during this time?
> did the remote server perhaps stop during that time?
> what did the remote server's logs show happened to the remote thread at that time?


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1347709
Posted Tuesday, August 21, 2012 7:43 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, May 30, 2013 1:44 AM
Points: 45, Visits: 852
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..
Post #1347795
Posted Thursday, August 28, 2014 3:40 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 28, 2014 4:00 PM
Points: 1, Visits: 1
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!
Post #1608430
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse