December 16, 2003 at 9:34 am
Hi I wanted to link tow servers a and b.After linking the server I could access the objects
of the server a from server b BUT could not access objects of server b from server a.
When I look at the linked servers on server a I could see the server b bur i could not see
server a on the server b,But its available under remote servers rather than linked server on server b.
PLease let me know what went wrong.
December 16, 2003 at 10:07 am
A remote server configuration allows a client connected to one SQL Server to execute a stored procedure on another SQL Server without establishing another connection. Remote servers are set up in pairs only between SQL Servers. To set up a pair of remote servers, configure both servers to recognize each other as remote servers. Local server is showed as remote server as its own.
A linked server configuration allows SQL Srver to execute commands against OLE DB data sources on different servers.
December 16, 2003 at 10:17 am
Thanks foor the info,But how can i make that remote server as linked server.
Thnaks once agian for ur help.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply