I cant find a solution for this.

My case is, I have many linkservers from Server A. Almost all are functioning. Only some are encountering the errors.

OLE DB provider "SQLNCLI" for linked server "RemoteServer" returned message "Unspecified error".

OLE DB provider "SQLNCLI" for linked server "RemoteServer" returned message "Communication link failure".

OLE DB provider "SQLNCLI" for linked server "RemoteServer" returned message "Communication link failure".

Msg 64, Level 16, State 1, Line 0

TCP Provider: The specified network name is no longer available.

The wierd thing is, I can directly connect to the RemoteServer from the Server A. The error only appears when I use the linkserver connection.

One of the Sysad of our company told me that it might be network related, but how come I am able to directly connect to the remote server?? Using the PCName, not even the IP address., By the way the datasource of my linkserver is the ipaddress of the remoteserver, so it should function properly and besides, this has been functional eversince and is used everyday. The error just appears this past few days.

Whew, hope someone could enlighted me.