Pull info from Active Directory into SQL Server 2000

[getseklets]

Hi,

I want to pull user info from Active Directroy into SQL Server 2000 table. I know that this is possible, but I don't know how. Can anyone help me.

Thnx Getseklets

[iburyak]

1. Execute line below on your SQL Server to link server and AD:

[PHP]EXEC sp_addlinkedserver 'ADSI', 'Active Directory Service Interfaces', 'ADSDSOObject', 'adsdatasource'[/PHP]

2. Change From in query below. It is just an example you have to write your own query.

[PHP] SELECT * FROM OPENQUERY( ADSI,

'SELECT name, adsPath

FROM ''LDAP://DC=....,DC=....,DC=...,DC=com''

WHERE objectCategory = ''Person'' AND objectClass= ''user''')[/PHP]




Also you have to be aware that SQL query has limitation with AD.

1. It has a limit of 1000 records returned at a time. I have a work around if you'll really need it.

2. There is no way to return multiple results like group memberships (if you know what it is). Whenever AD tries to return an object it can not be done through SQL.


Thank you.

[arshadsa]

1. Execute line below on your SQL Server to link server and AD:

[PHP]EXEC sp_addlinkedserver 'ADSI', 'Active Directory Service Interfaces', 'ADSDSOObject', 'adsdatasource'[/PHP]

2. Change From in query below. It is just an example you have to write your own query.

[PHP] SELECT * FROM OPENQUERY( ADSI,

'SELECT name, adsPath

FROM ''LDAP://DC=....,DC=....,DC=...,DC=com''

WHERE objectCategory = ''Person'' AND objectClass= ''user''')[/PHP]




Also you have to be aware that SQL query has limitation with AD.

1. It has a limit of 1000 records returned at a time. I have a work around if you'll really need it.

2. There is no way to return multiple results like group memberships (if you know what it is). Whenever AD tries to return an object it can not be done through SQL.


Thank you.

What is that work around?

[TorresI]

1. Execute line below on your SQL Server to link server and AD:

[PHP]EXEC sp_addlinkedserver 'ADSI', 'Active Directory Service Interfaces', 'ADSDSOObject', 'adsdatasource'[/PHP]

2. Change From in query below. It is just an example you have to write your own query.

[PHP] SELECT * FROM OPENQUERY( ADSI,

'SELECT name, adsPath

FROM ''LDAP://DC=....,DC=....,DC=...,DC=com''

WHERE objectCategory = ''Person'' AND objectClass= ''user''')[/PHP]




Also you have to be aware that SQL query has limitation with AD.

1. It has a limit of 1000 records returned at a time. I have a work around if you'll really need it.

2. There is no way to return multiple results like group memberships (if you know what it is). Whenever AD tries to return an object it can not be done through SQL.


Thank you.

What is your work around for this. I'm trying to pull over 25000 rows from AD if it's possible.
Thanks.

[krevell]

I have a similar script. Can you tell me how to pull more than 1000 records at a time?

[RaytheDBA]

I am also running into the 1000 row limitation. Can you please provide the workaround?