Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL 2000 linked server security

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-02-22 : 23:28:34
Robert writes "I have multiple SQL 2000 servers running on Windows 2000. My developers write code requiring the use of linked servers. I am trying to implement NT authentication security rather than mixed. However, I cannot set up linked servers using 'login's current security context'. Every time I try this I get 'login failed for user NT AUTORITY\ANONYMOUS USER'. How do I solve this problem? (I assume that there is some Windows user missing. Does Windows require an ANONYMOUS USER or will any anonymous user work?)"
   

- Advertisement -