Thanks for response,

but getting same error as follows:

The object name '..." contains more than the maximum number of prefixes. The maximum is 2.

Any more ideas?

Thanks for quick response,

the server is added to linked servers list already, but giving the error.

any more ideas?