Re: linkedServer fails from client when logged-in with NT-auth sql2k c
- From: "Russell Fields" <RussellFields@xxxxxxxxxxxxxxxx>
- Date: Mon, 28 Aug 2006 13:28:32 -0400
GA,
If you are using the setting where the current login on server A is supposed
to pass through to server B and if one of the servers is not properly set up
for Kerberos delegation, you will have a problem.
RLF
"DallasBlue" <DallasBlue@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7405A4DD-F0A5-478F-8569-6CC3F9BE120B@xxxxxxxxxxxxxxxx
delegation on linked server fails in our network when we use
nt-authenticated
logins. we have sql server 2000 nodes n1,n2 on win 2003 cluster. linked
server from n1 to n2 and n2 to n1 stop working when used in a query from
clinet xp pc.
we can query individually the servers(nodes/instances) from client and
from
server nodes to server instances without any error.
the error we get is " msg xxx err xx Reason: login failed for user (NULL)
......"
Any thots,hints,links,pointers appreciated
Thanks,
GA
.
- Prev by Date: Re: Delegation through Linked Server Stops working
- Next by Date: Re: how to decrypt an encrypted stored proc in 2005
- Previous by thread: RE: Login has all rigfhts but can login to sql
- Next by thread: [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error
- Index(es):
Relevant Pages
|
|
