I have set up linked server sucessfully.. i can see all the tables and views.. however, when I try to run a query I keep getting below error:
OLE DB provider "SQLNCLI" for linked server "Application1" returned message "Communication link failure".
Msg 121, Level 16, State 1, Line 0
Named Pipes Provider: The semaphore timeout period has expired.
How can I resolve this issue?