Linked server

  • atulyan.aries

    SSCommitted

    Points: 1998

     

    Hi

    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

    Thanks

     

     

  • Mr. Brian Gale

    SSC-Insane

    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

    SSC-Forever

    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:

    https://www.sqlservercentral.com/articles/a-brief-explanation-and-solution-for-the-double-hop-problem

     

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

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