Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to setup a SQL linked server?
Message
General information
Forum:
Microsoft SQL Server
Category:
Security
Miscellaneous
Thread ID:
00850898
Message ID:
00851213
Views:
15
>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--
Previous
Reply
Map
View

Click here to load this message in the networking platform