Re: Cross Server Windows Authentication
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 11/18/03
- Next message: Sue Hoegemeier: "Re: access across domains"
- Previous message: Craig Roberts: "Account looses access to database"
- In reply to: Matto: "Cross Server Windows Authentication"
- Next in thread: Rand Boyd [MS]: "RE: Cross Server Windows Authentication"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 17 Nov 2003 20:19:12 -0700
It looks like a problem with how you have the security
mapping configured for your linked server. You need to check
the security mapping for the servers to make sure you
have this configured correctly. You can find more
information in books online under linked servers.
Additionally, you should also check the books online topic:
Security Account Delegation
-Sue
On Mon, 17 Nov 2003 17:21:29 -0600, "Matto"
<moconnell@investmentscorecard.com> wrote:
>I am switching from SQL to Windows Authentication. I have two servers A and
>B (remote servers because I have replication set up). I am a user on both
>(MyDomain\JohnSmith). In Query Analyzer when I try to query tables on B
>from A I get. I get the message "Login failed for user '(null)'. Reason:
>Not associated with a trusted SQL Server connection." What am I not doing?
>
>Thanks.
>
- Next message: Sue Hoegemeier: "Re: access across domains"
- Previous message: Craig Roberts: "Account looses access to database"
- In reply to: Matto: "Cross Server Windows Authentication"
- Next in thread: Rand Boyd [MS]: "RE: Cross Server Windows Authentication"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|