Connection has been closed by peer.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Connection has been closed by peer.

Connection has been closed by peer.

Rate Topic

Display Mode

Topic Options

Author

Message

k.thanigaivel

Posted Monday, August 20, 2012 10:51 PM

SSC Rookie

Group: General Forum Members
Last Login: Friday, April 05, 2013 12:01 AM
Points: 45, Visits: 851

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

k.thanigaivel

Posted Tuesday, August 21, 2012 4:41 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, April 05, 2013 12:01 AM
Points: 45, Visits: 851

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

Post #1347693

Stewart "Arturius" Campbell

Posted Tuesday, August 21, 2012 5:11 AM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 3:48 AM
Points: 3,125, Visits: 4,311

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

k.thanigaivel

Posted Tuesday, August 21, 2012 7:43 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, April 05, 2013 12:01 AM
Points: 45, Visits: 851

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

« Prev Topic | Next Topic »

Permissions