Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Linked servers
Message
De
22/05/2003 16:24:08
John Deupree
Long Term Care Authority
Tulsa, Oklahoma, États-Unis
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Titre:
Linked servers
Divers
Thread ID:
00791905
Message ID:
00791905
Vues:
64
I am trying to query data across 2 sql servers. Both use NT authentication exclusively. I have set up a linked server on svrOne that points to svrTwo. Both servers have the NT group Developers with SQL Admin permissions. I have run sp_addlinkedsvrlogon, but when I try to query with something like
select * from svrTwo.database.dbo.table
I get the error 'Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

How do I get the logons mapped correctly?

TIA

John
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform