Re: SQL2K - Linked server - Mapping Windows group to a remote login

nntp
Date: 07/02/03 

Date: Wed, 2 Jul 2003 13:42:32 -0700

did you try typing in the domain\username?

"VUILLERMET Jacques" <jvuillermet@no-spam.fr> wrote in message
news:#9odfQMQDHA.2160@TK2MSFTNGP11.phx.gbl...
> My application uses an NT authentification login via a Windows group, as
> recommended by Microsoft.
> I've a linked server (Oracle), the link works fine.
>
> I want to map the Windows group with one Oracle login (in Linked server
> properties).
>
> But, the combo box shows only the windows users and the SQL Server logins.
>
> How to do ?
>
> Jacques.
>
>

Relevant Pages

  • Re: SQL Local Account Permission - Read Only on System Tables and
    ... Create a Windows group on the domain and have your developer logins added to ... VIEW SERVER STATE to that one login. ... can create your own server-level roles) and grant it VIEW SERVER STATE ...
    (microsoft.public.sqlserver.security)
  • SQL2K - Linked server - Mapping Windows group to a remote login
    ... My application uses an NT authentification login via a Windows group, ... I've a linked server (Oracle), ...
    (microsoft.public.sqlserver.security)
  • Re: Is_Member problem : Does user belong to custom Group
    ... In active directory: 1 - Created in Active directory a Windows group named ... 'MyDomainName/MyApplReadOnly' as Login Name and the same as User ... We can create a ROLE in the database and add the users. ...
    (microsoft.public.sqlserver.security)
  • Re: Is_Member problem : Does user belong to custom Group
    ... - Added in Security/Logins the windows Group 'MyDomainName/MyApplReadOnly' referred as type 'Windows Group' with Defaultdatabase 'Master' ... Then configured the database Role Membership of this user by setting db_datareader and db_denydatawriter to true. ... for the current user returns 0 although he is referred in active directory as someone belonging to the the windows group Mydomainname\MyapplReadOnly ... There is a login, there is a user that mapped to the Login ...
    (microsoft.public.sqlserver.security)
  • Re: Howto troubleshoot login failure - State 11?
    ... DOMAIN\BizTalk Server Administrators | EDIMgmtDb | EDI Administrators | MemberOf ... If I create a login named DOMAIN\BTS01$ with only the 'public' role, and tries to logon I get this error: ... The reason seems to be that if I create the actual account in SQL Server, any Windows group memberships are ignored and the account itself must be granted the same rights as the Windows group. ...
    (microsoft.public.sqlserver.security)