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

From: jimmers (jimmers@yandex.ru)
Date: 06/12/02 

From: "jimmers" <jimmers@yandex.ru>
Date: Wed, 12 Jun 2002 00:08:36 -0700

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?
>
>

Relevant Pages

  • Re: Linked Server Login Mapping - strange thing...
    ... >> using OpenQuery (syntax is correct) ... >> problem using legacy style logins: ... >> systems folks than SQL? ...
    (microsoft.public.sqlserver.security)
  • Re: Permission question - another one
    ... If I add an Sql Login it does add the TRAVAC\ in front of the names, ... seems to be users that were setup to use SQL Server Authentication. ... RAPTOR is the Server that has SQL Server running on it. ... > " I could think I am taking permissions away from someone, ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL 2k5 SP2 Mirroring - SQL in Mixed mode.
    ... US\sqlservices (old SQLservice account) still member of built-in local admin ... Login: US\sqlservices ... How can I transfer the SQL logins to ... Here is SP_help_revlogin results from the Principal Server (NYSQL-3) ...
    (microsoft.public.sqlserver.clustering)
  • Re: Renamed Windows login not found in SQL Server 2000
    ... It's almost like SQL tuck some knowledge away in an area ... of memory that only gets released on Windows stop. ... > I am running SQL Server 2000 SP2 with Windows ... > login gets corrupted) I am unable to add the new login to ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server on XP Home Network
    ... The sa account is the system administrator "God" account witihin SQL ... This account is a SQL-Server login. ... You might be able to use Enterprise Manager to go in and create a new SQL ... Select the "SQL Server Authentication" ...
    (microsoft.public.sqlserver.setup)