October 19, 2009 at 2:04 pm
Hello,
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?
Thanks,
Paul
P
February 23, 2012 at 10:06 pm
I tried the same query on SQL Server 2008
But not working, it says in correct syntax near rowset
SELECT * FROM OpenRowset(NetGroupGetMembers, 'Domain\user')
February 23, 2012 at 10:07 pm
I tried the same query on SQL Server 2008
But not working, it says in correct syntax near rowset
SELECT * FROM OpenRowset(NetGroupGetMembers, 'Domain\user')
Please need help to tell me how this works
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply