AD and SQL 2K

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Security » AD and SQL 2K

AD and SQL 2K

Rate Topic

Display Mode

Topic Options

Author

Message

schleep

Posted Monday, October 19, 2009 2:04 PM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 12:35 PM
Points: 345, Visits: 605

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

sudhirnune

Posted Thursday, February 23, 2012 10:06 PM

SSC Journeyman

Group: General Forum Members
Last Login: Sunday, May 19, 2013 8:29 AM
Points: 79, Visits: 186

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

sudhirnune

Posted Thursday, February 23, 2012 10:07 PM

SSC Journeyman

Group: General Forum Members
Last Login: Sunday, May 19, 2013 8:29 AM
Points: 79, Visits: 186

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 »

Permissions