linked servers and different windows users (domain - stand alone servers)

  • Hi.....

    First Of All.....Happy New Year.....

    That's the problem:

     

    I have 2 sql servers : srv1 (in windows domain) srv2 (stand alone):

    A main store proc run in srv2 and create linked servers between them (in srv1 ....srv2 is linked server, in srv2...srv1 is linked server) to call stored procs and sql statements between them.

    srv1 login users are users domain and local sql user

    srv2 login are local win domain and local sql user.

    The problem is that when the main stored proc (first store proc that runs under srv2) creates the linked server, but when the first sql statement from srv1 to srv2 is initiated I get the error:

    Login failed for user 'srv1\srv2sqluser'.

    The problem is that I have different user for the 2 sql servers and Windows account.

    I tried also with sa as impersonate, but the error is:

    'Access to the remote server is denied because no login-mapping exists.'

    How can I created a common user for both servers, also if are in different windws context (domain - stand alone).

  • The problem is definitley with the Login ..

    Try to recreate the Linked server with login as [sa] and try running the procedures.

    I guess it would work..

    Cheers ...

  • The problem is that to use impersonation with Windows authenticated logings "Account delegation" has to be in place at both servers. Have Look in BOL on how to setup Account delegation in AD.

    If you could use SQL logins only then go that route instead, you will need a lot of maitenance though 

    Cheers,

     

     


    * Noel

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

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