I am seeing some strange behaviour. We use AD to manage users, groups, and SQL Server access.
We have various levels of access, supervisor and administrator, among others.
(These are in-house privs, not OS/SQL).
We use the following
SELECT Name AS cName FROM OPENROWSET(NetGroupGetMembers, @cGroupNameArg)) to get the list of members for a given AD group.
Now, in each of the AD console, SQL QA xp_enumgroups, and a seperate app, I can see with my own eyes the groups CIPS\Imp_Prod_TCNW_Administrator_6, CIPS\Imp_Prod_TCNW_Supervisor_6, and the members of each group.
In SQL QA, NetGroupGetMembers returns the members of the Admin group, but none from the Sup group.
This is not a case of slow AD replication, it's been days since the groups were populated. Although if there's a way to force AD replication, can you let me know how?
Other suggestions? The SQL Servers are SP2. The DCs may be Win2K or Win2K3. However, if it works for 99% of the AD groups on our domain, it sholdn't be a SP thing, right?