Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

AD and SQL 2K Expand / Collapse
Author
Message
Posted Monday, October 19, 2009 2:04 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 5:48 AM
Points: 428, Visits: 927
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





Post #805267
Posted Thursday, February 23, 2012 10:06 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, March 6, 2014 11:47 PM
Points: 86, Visits: 214
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')
Post #1257090
Posted Thursday, February 23, 2012 10:07 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, March 6, 2014 11:47 PM
Points: 86, Visits: 214
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
Post #1257091
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse