Home Forums SQL Server 2005 Administering Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. RE: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

  • 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