LINKING USING LDAP TO ADSI

[Sammy145]

Hi i want to query the active directory on windows 2000
I dont mind what method but must be in SQL
and get all the group Names from teh DOMAIN [QC] and Populate a table with the Group names can Someone show me how to do this


Sam

 

[Sammy145]

anyone?

 

[topher0303]

I don't know of any way to do it directly from T-SQL. In VB I use the an ADSI interface using GetObject() to access the Active Directory but cannot find GetObject() in T-SQL. T-SQL appears to only support CreateObject() using a sproc. Read up on the OLEDB driver for active directory. This might give you what you need. You can use it in conjunction with ADO.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdrefadsprovspec.asp

Chris.

 

[Inwoner]

Why does it need to be in SQL?

Why can't you use a program that will connect to the database and populate the table with the information retrieved from LDAP?

 

[Sammy145]

i Just thought it would be a good way and faster way rather than writing an exe or dll to do it

Can you tell me why not to do it in SQL server
can it be done in SQL server
Its a microsoft product!


Sam

 

[MaffewW]

I tried recently to retrieve even just an NT/2000 user name before, and that cant even be done (unless they are logged on using Windows authentication). I just dont think this information is passed to SQL at any point

 

[Sammy145]

cant i use linked server?
if so can someone tell me how to set this up

sam

 

[barcoder]

Were using QSL 2K
I'm trying to get employee names out of ActiveDirectory and have not totally completed this task yet, but the following has extracted the basics. Maybe it will give you a start.

sp_addlinkedserver 'ADSI','Active Directory Services 2.5','ADSDSOObject','adsdatasource'


SELECT * FROM OpenQuery(ADSI,'<LDAP://??????? DC=QC >;(&(objectCategory=Person)(objectClass=user));name,userAccountControl,sAMAccountName,sn,givenname,DisplayName,WhenCreated,adspath;subtree')


?????? is the servername