Trust relationship issue?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

My problem is related to SQL Server.

Many users are having access denied, even being members of a Windows group
which has access to the SQL Server 2000 SP4 instance.
They can access the instance only if I explicitly add a login for each user.
I'm sure that there is no group with Deny Access.

The SQL Server is member of domain A and the groups mentioned and their
membership are members of domain B.
I know there is an external trust relationship between A and B. Users from A
cannot access domain B, but domain B can access resources on domain A.
Logins created for groups from the same domain (A) as the server are working
correctly. Only groups from the other domain (B) are not working.
Can it be related to trust relationship?

Does anybody know why it's happening?


.

Relevant Pages

  • Re: sp_revoke login is not working as expected.
    ... when I use DROP LOGIN and subsequently try to connect i get the folloiwng ... Since sysadmin role members are mapped to the dbo user in all databases, ... SQL Server MVP ... All of them are also a part of a windows group which has required ...
    (microsoft.public.sqlserver.security)
  • Re: System Administrator Implied Permissions
    ... > sa login, it assigns it the System Administrator fixed ... > Now, given this, why does SQL Server ... in each database is always a member of the public and db_owner roles. ... Other sysadmin role members have the exact same ...
    (microsoft.public.sqlserver.security)
  • Trust relationship issue?
    ... My problem is related to SQL Server. ... Many users are having access denied, even being members of a Windows group ... They can access the instance only if I explicitly add a login for each user. ... Can it be related to trust relationship? ...
    (microsoft.public.security)
  • Re: Add Login to the Master Database
    ... Under which account is the SQL Agent service running? ... Can you give us a list of the members of the sysadmin ... I have also ensured that the login is in the ... they are for the SQL Server Agent. ...
    (microsoft.public.sqlserver.setup)
  • Re: Could not save on existing DTS
    ... >Make them members of dbo role in msdb. ... Adding dbo membership in msdb is not relevant as by default all users ... DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals ...
    (microsoft.public.sqlserver.dts)