Linked server

  • atulyan.aries


    Points: 1998



    I have 2 servers A and B for which I need to setup a linked server.

    these are SQL servers.

    When I right click on server A and select the option create new linked server and I enter the new linked server name as B and in server B when I select the option create new linked server do I enter the server name as A or anything else




  • Mr. Brian Gale


    Points: 22932

    It depends.  Are you needing to change who it connects as?  Are you needing RPC?

    My advice, try it out.  Make the linked server and see if it works for you.  Then check if it works for someone with less permissions than you do.  If it works for you and them, pick a few more test users to try it out and fix any issues that come up.

    I'd also find a user who shouldn't have permissions and see if they cannot access it.  Basically, make it and make sure it is set up how you expect.

  • Chris Harshman


    Points: 42108

    Who will be using the linked servers?  If it is a session such as a SQL Agent job which is local to the server, then it should work.  For the case where the session originated on a client machine or some third server machine, then you will have what's called the "double hop issue".  Essentially the server A by default would not have permissions to pass the credentials on to server B over the link unless some extra setup is performed.  There are a number of articles online about it, such as this one here on SQL Server Central:


Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply