HOW DO I CONNECT TO LDAP DB FROM SQL SERVER 2005

HOW DO I CONNECT TO LDAP DB FROM SQL SERVER 2005.  Does anyone know of a resource that would show me or walk me through the steps to connect to the LDAP directory in our company and the bring down data to my SQL 2005 Server Database?  A class or a book that may be available that explains this would be great.
kdschoolAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
WizillingConnect With a Mentor Commented:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=300083&SiteID=1

EXEC master.dbo.sp_addlinkedserver @server = N'ADSI',
@srvproduct=N'Active Directory Services', @provider=N'ADsDSOObject',
@datasrc=N'Servername.domain.com'  --AKA the full computer name of the AD server

Then execute the openquery like this:

select * from openquery
(
ADSI,'SELECT name
FROM ''LDAP://Servername.domain.com''
WHERE objectCategory = ''Person'' AND objectClass = ''user''
')
0
 
kdschoolAuthor Commented:
Will this work if I am not a member of AD and am not running active directory but a stand alone server in the network?
0
 
feesuCommented:
Hello there!

I tried that and got the following error:

Msg 7202, Level 11, State 2, Line 8
Could not find server 'ADSI' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.

What's wrong??
0
All Courses

From novice to tech pro — start learning today.