Linked Server error- Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

• steal

  SSC Eights!

  Points: 827

  More actions

  January 4, 2016 at 10:26 am

  #310584

  I have verified Kerberos authentication (SELECT auth_scheme FROM sys.dm_exec_connections WHERE session_id = @@spid;)

  -returns KERBEROS on both servers

  I have verified the SPNs on both servers

  C:\Program Files\Microsoft\Kerberos Configuration Manager for SQL Server>Kerbero

  sConfigMgr.exe -q -l

  Listing all the SPNs:

  Instance_Name Service_Account Required_SPN Status

  MSSQLSERVER DEV\DEV_SQL_SA MSSQLSvc/QA-S2-SQL.dev.rph.int Good

  MSSQLSERVER DEV\DEV_SQL_SA MSSQLSvc/QA-S2-SQL.dev.rph.int:1433 Good

  Does anyone have any other leads for me?

• steal

  SSC Eights!

  Points: 827

  More actions

  January 5, 2016 at 10:57 am

  #1849610

  This turned out to be a delegation setting in Active Directory.