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

I have linked MS SQL 2008 to MS SQL 2005 when try to execute the开发者_如何学运维 query, i have the following error:

OLE DB provider "SQLNCLI" for linked server "MY_DB"  returned message "Communication link failure".
Msg 64, Level 16, State 1, Line 0
TCP Provider: The specified network name is no longer available.

Any ideas?

---

What are you using for the IP configuration? Are you using the IP or the computer Name for the configuration?

This problem can occur if you are using a static IP in your configuration and your server has a dynamic IP, but this is assuming you have this configuration on the client and the server. It is better if you give the configuration that you used.