Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to setup a SQL linked server?
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Sécurité
Divers
Thread ID:
00850898
Message ID:
00851213
Vues:
14
>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--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform