Linked servers and active directory

• Luke79

  SSCrazy

  Points: 2571

  More actions

  October 22, 2008 at 10:15 am

  #131788

  I have to servers, both have linked servers pointing to each other. The problem is that if an active directory user tries to query either server the message returned is:

  Msg 18456, Level 14, State 1, Line 1

  Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

  The security for both remote servers is setup as "be made using the login's current security context".

  Any ideas how to fix it? The problem goes away when users connect with SQL logins, but I want them to start using windows authentication instead.

  Luke

• SQLBOT

  SSCrazy Eights

  Points: 8014

  More actions

  October 22, 2008 at 3:02 pm

  #888370

  I think this is a kerberos delegation problem.

  You'll need to set a SPN for the SQL Server in order to pass-through your credentials.

  ~BOT

  Craig Outcalt

  ---

  
  Tips for new DBAs: http://www.sqlservercentral.com/articles/Career/64632
  My other articles: http://www.sqlservercentral.com/Authors/Articles/Craig_Outcalt/560258