>Hi,
>
>I am two SQL 2000, both setup as Windows authentication based only. When I linked Server A to Server B using [Be made using the login's current security context], I keep on getting this error
>
>Error 18456: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
>
>
>Both server has been add to the AD, and user's right is identical on both server.
Tony,
The
Establishing Security for Linked Servers topic in BOL discusses in details what is required for Windows authentication to work for linked servers.
--sb--