Post reply

linked server and remote server

  • December 16, 2003 at 9:34 am

    #107119

    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

    #486440

    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

    #486444

    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