Re: Linked Server Login Mapping - strange thing...

From: Mark (Post@here.please)
Date: 06/12/02


From: "Mark" <Post@here.please>
Date: Wed, 12 Jun 2002 13:46:55 -0700


Thanks,
I was actually looking for thoughts, not a bookmark to a
well-known article :-)

>-----Original Message-----
>You may consult this article:
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;Q299410
>Also verify that in both cases the systems have the same
configurations,
>service packs applied.
>
>Cheers
>
>"mark" <Please@post.here> wrote in message
>news:c23001c21174$6dfb75f0$36ef2ecf@tkmsftngxa12...
>> If anyone have thoughts on this. Kinda confused here.
>> Situation:
>>
>> ADSI linked server on SQL2k, Win2k native Domain.
>> User is member of Dom Admins.
>> Login to SQL has been granted (Domain\User), member of
>> SysAdmins role.
>>
>> Getting various errors 7330, 7350... when querying ADSI
>> using OpenQuery (syntax is correct)
>> Can Query using OpenRowset and providing User
credentials
>> in the form of UPN: user@domain.com
>>
>> Created a mapping on Linked server security: Local
Login
>> = Doman\user, remote = user@domain.com (same user,
>> basically, just different syntax)
>>
>> Now OpenQuery works.
>>
>> I tested on another natve mode domain, there is no
>> problem using legacy style logins: Domain\Login
>>
>> Any Ideas please ? Or this is more a question to the
>> systems folks than SQL?
>>
>>
>
>
>.
>