I am having a problem creating a linked server between 2 sql2005 servers with windows authentication
I get the following error message:
Msg 18456, Level 14, State 1, Line 1
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
I have created Server principle names, using SETSPN -A. I have set the servers and my domain account to be trusted for delegation in AD. unfortunately I cannot see the delegation tab in AD, is this because the domain is set to windows 2000 native even though it's on a 2003 box?
But still no joy, sql server still shows my account connecting as NTLM.
I cannot use a sql server login...they wont allow it