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!
MCITP: Business Intelligence Developer (2005)