Home Forums SQL Server 2005 Administering Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. RE: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
Yelena Varshal
SSC-Dedicated
Points: 34286
More actions
August 11, 2008 at 9:45 am
#856190
On the Security tab of Linked Server properties you have to add your DOMAIN\sqlman login as Local Login and check Impersonate checkbox or add a remote server's valid login name and pw
Regards,Yelena Varsha