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" ')

where the domain is MyDOMAIN.NET.

I get the error:

Msg 7321, Level 16, State 2, Line 1

An error occurred while preparing the query "SELECT cn, mail, co, distinguishedName, displayName

FROM "LDAP://DC=MyDOMAIN,DC=net" where objectClass = "User" " for execution against OLE DB provider "ADSDSOObject" for linked server "ADSI".

What is: MSSQLServerADHelper - should this be started??

How do I know if SQL Server is operating in Kerboros mode - where do I change it?

Have I missed anything else??

Sorry - I know this has been covered several times, but I' struggling to see what the issue is!