Hi hopefully someone can help me with this as well.

as above, I'm trying to query my LDAP server.

This is what I have setup:

I have access to our Active Directory and can view users and machines in active directory

> SQL Server 2005 Develper Edition installed on my machine.

> All services started.

SQL Server, SQL Server Agent, SSAS, SQL Server Browser, SQL Full Text Search & SQL Server VSS Writer all started as Local System

SSIS is started as Network Service

> OpenQuery is enabled

(I can run open query commands to other systems)

> I have defined a AD linked server as follows:

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

> Having configure the linked server I have run the following query:

select * from openquery

(ADSI,'SELECT cn, mail, co, distinguishedName, displayName

FROM "LDAP://DC=MyDOMAIN,DC=net" where objectClass = "User" ')